i want to create report show the customer opening balance in separate column and the customer invoices in separate column and customer payment in separate column as totals

AI generated answer (using internal Slack threads):

To create a report that shows the customer opening balance, customer invoices, and customer payments in separate columns as totals, you can use NetSuite's Saved Search functionality. Here's a general guideline on how you can do it: 1. Navigate to Reports > New Search. 2. Select the 'Transaction' record type. 3. In the Criteria tab, set the following filters: - Type: Any of Invoice, Payment - Main Line: True - Date: set the date range you want to report on 4. In the Results tab, set the following columns: - Customer: Group - Type: Group - Amount (Sum): This will give you the total amount for each transaction type (Invoice or Payment) for each customer. 5. Save and run the search. This will give you a report with each customer's total invoices and payments. However, to get the opening balance, you would need to create a separate saved search with a date range that ends the day before your current report starts, and sum the invoice and payment amounts. Please note that this is a simplified example and you might need to adjust it according to your specific needs. For example, you might need to add more filters or columns, or use formulas to calculate the opening balance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******