NetSuite Search Error with Once Export

Integrator.io
, , , ,
1

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!!

2

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

3

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