We have a custom Transactions report where the component is active account by account type. These show GL Impacts across periods based on the filters. Why would invoices not show the correct Amount (Gross) on this report? ie. the invoice is for 40000 for account 123, but on the report it shows 280000 for account 123

AI generated answer (using internal Slack threads):

The discrepancy in the amounts shown in your custom Transactions report could be due to several reasons: 1. GL Impact Calculation: The GL impact of a transaction is not always equal to the gross amount of the invoice. It depends on the accounting entries generated by the transaction. For example, if you have an invoice of 40000, but there are discounts, returns, or allowances associated with it, the GL impact might be less than the gross amount. 2. Multi-Currency Transactions: If your transactions are in multiple currencies, the GL impact is recorded in your base currency. If there are fluctuations in the exchange rate, the GL impact in your base currency might not match the gross amount of the invoice in the transaction currency. 3. Posting vs Non-Posting Transactions: Not all transactions in NetSuite are posting transactions. Non-posting transactions do not have a GL impact. If your report includes non-posting transactions, their GL impact would be zero. 4. Accounting Periods: The GL impact of a transaction is recorded in the accounting period when the transaction is posted. If your report filters transactions by accounting period, it might not include all transactions for an account. 5. Inter-Company Transactions: If you have inter-company transactions, the GL impact might be recorded in different accounts in the different subsidiaries, which might not be included in your report. 6. Customization: If you have customized your NetSuite account, for example, by using SuiteScript or SuiteTalk to modify the standard behavior of transactions, it might affect the GL impact of transactions. To resolve the issue, you might need to review the setup of your custom Transactions report and the accounting entries of the transactions. You might also need to check the exchange rates for multi-currency transactions, the posting status of transactions, the accounting periods, and any customization in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******