# NetSuite Search Error with Once Export

**URL:** <https://connective.celigo.com/t/netsuite-search-error-with-once-export/3208>\
**Category:** Integrator.io\
**Tags:** filter, error-handling, export, flow-builder, netsuite\
**Created:** [February 19, 2025, 2:21am UTC](https://connective.celigo.com/t/netsuite-search-error-with-once-export/3208 "2025-02-19T02:21:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [February 19, 2025, 2:21am UTC](https://connective.celigo.com/t/netsuite-search-error-with-once-export/3208/1 "2025-02-19T02:21:46Z")

</div>

Hey Guys,  
I haven't seen this error in a long time. I thought this bug had been fixed.  
I'm running a Once export of sales orders. The NetSuite search has a summary criteria on it. The search runs perfectly in NetSuite but when running the flow there's the following error:  
"Search error: Parentheses are unbalanced."  
Here's the request with the search.  
search.filterExpression: [[["location","anyof","23"],"AND",["status","anyof","SalesOrd:B"],"AND",["tobefulfilled","is","T"],"AND",["type","anyof","SalesOrd"],"AND",["sum(formulanumeric: {quantity}-nvl({quantitycommitted},0))","equalto","0"]],"AND",["custbody\_sentto3pl","is","F"]]

I used to see these error and could work around it.

Any ideas? This needs to be live in a few days and I don't think I can wait on support.

thanks!!

---

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [February 19, 2025, 2:24am UTC](https://connective.celigo.com/t/netsuite-search-error-with-once-export/3208/2 "2025-02-19T02:24:03Z")

</div>

Obviously, I can update the field in a subsequent import bubble. I just don't like doing that.

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [February 19, 2025, 2:34am UTC](https://connective.celigo.com/t/netsuite-search-error-with-once-export/3208/3 "2025-02-19T02:34:04Z")

</div>

Does SuiteApp 1.0 vs 2.0 make a difference? Are you working in sandbox with an updated SuiteApp and updated bundle?