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