I ended up using the Foreign Currency fields, which resolved most of the discrepancy between the Search and the Customer. Netsuite seems to love not being clear sometimes, about what currency a particular value is in.

case when trunc({today})-{duedate} between 1 and 30 then {fxamount} - {fxamountpaid} end

I still have an issue with the Criteria, it seems other than Account and Status, there is something else that Netsuite uses for the Over 91 range.

I pulled all the relevant transactions, but I could not see any combination that would come up with the result I needed.

Thanks for the quick response 🙂

Yeah I’ve already put in around a dozen hours playing around. My attempts with N/encode were mostly a last ditched effort to see if it worked. I’ll try js-base64 when I get a chance.

Does N/https screw around with the data you send it?

Install the below Chrome Extension, then build your search in the UI and save it, then edit the search and use the Chrome Extension to view the code.
https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp

Also, I’d advise you use an array of search.createFilter entries, unless you are doing complicated joins.