This message was deleted.

AI generated answer (using internal Slack threads):

To build a report showing customer opening balance, transactions, and closing balance using Suite Analytics, you can follow these steps: 1. Opening Balance: To get the opening balance, you can use the 'Balance Sheet' report. This report will show you the opening balance for a specific period. If you want to exclude transactions made on a specific date, you could use the closing amounts from the previous day as your opening balance. If you have migrated from another system and do not have data for the previous day, you might need to import the closing balance from your previous system to the last day of the previous period. 2. Transactions: To get the transactions, you can use the 'Account Detail Report'. This report will show you all the transactions that have occurred within a specific period. You can filter this report by customer to get the transactions for a specific customer. 3. Closing Balance: The closing balance can be calculated by adding the transactions to the opening balance. Alternatively, you can use the 'Balance Sheet' report for the next day as your closing balance. Please note that these steps might need to be adjusted based on your specific requirements and the data available 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. ******