Why do quantities and amounts pulled from the analytics data source show as reversed versus what a saved search produces? Is there any way to fix this without doing a formula for each field? For example item quantities show as negative on an invoice in the suiteanalytics data source but show as positive when pulled from a saved search.

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The discrepancy you're seeing between the SuiteAnalytics data source and saved searches in NetSuite is likely due to the way NetSuite handles certain account types. For some account types, if you enter a positive amount, rate, or quantity, they show as negative in the saved search and vice versa. This is particularly common with liabilities. The logic behind this is that positive values increase the balance of an account, while negative values decrease it. Depending on the account type, the positive value in the amount field goes to debit or credit. For example, for an expense account, a positive value goes to debit, while for an income account, a positive value goes to credit. Unfortunately, there isn't a straightforward way to fix this discrepancy without using a formula for each field. You might need to use a condition based on the GL account type or use the Amount (debit) or Amount (credit) columns instead of the standard Amount column. As for the issue with item quantities showing as negative on an invoice in the SuiteAnalytics data source, it might be worth checking the item account type. The account type could potentially affect how quantities are displayed in saved searches and the SuiteAnalytics data source. Remember, these are just possible explanations based on the information available. You might need to experiment with different settings and formulas to find a solution that works for your specific situation.