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

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. ****** To create a report that shows the customer opening balance, customer invoices, and customer payments in separate columns, you can use NetSuite's Saved Search functionality. Here's a general guideline on how you can do it: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the "Transaction" record type. 3. On the Criteria subtab, you can set the following filters: - Type: Any of Invoice, Payment - Main Line: True - Customer: select the specific customer(s) you want to include in the report. 4. On the Results subtab, you can define the columns you want to show in the report. For your case, you might want to include: - Name (this will show the customer name) - Type (this will show whether the transaction is an invoice or a payment) - Amount (this will show the amount of the invoice or payment) 5. Save the search. Please note that this will give you a list of all invoices and payments for the selected customer(s). If you want to calculate the opening balance, you might need to create a separate saved search or use a SuiteScript to calculate the opening balance based on the customer's transactions before a certain date. As for the code provided in the thread, it seems to be related to customizing a PDF layout for a statement, which includes columns for date, due date, description, PO#, charge, payment, and balance. This might not directly help with your requirement, but it shows how you can customize the layout of a statement in NetSuite. Remember, this is a general guideline and might need to be adjusted based on your specific requirements and NetSuite setup.