I am running a saved search via SuiteScript. In the saved search is a filter for amount greater than $100. The NetSuite UI shows only transactions with amounts greater than positive $100, but the SuiteScript results return transactions with absolute value greater than $100, which includes negative amounts. What’s happening, and is there a way to make the SuiteScript results match the NetSuite UI results?

AI generated answer (using internal Slack threads):

The discrepancy you're seeing between the NetSuite UI and SuiteScript results is due to how NetSuite handles the 'Amount' field in saved searches. In the NetSuite UI, the 'Amount' field respects the accounting "natural balance". This means that positive does not necessarily mean a debit and negative does not necessarily mean a credit. Positive means an increase in the balance of the account and negative means a decrease in the balance of the account. For example, for a liability account, an increase is a credit. If you put a negative "expense" on the bill, that amount would become a credit to the account, which is an increase to a liability, hence it showing positive on the saved search. However, when you run a saved search via SuiteScript, it seems that the 'Amount' field is returning the absolute value of the transaction amount, which includes both positive and negative amounts. To make the SuiteScript results match the NetSuite UI results, you could add 'Amount (Debit)' and 'Amount (Credit)' to your search instead of 'Amount'. This should give you a more accurate representation of how amounts are represented in relation to GL accounts. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******