i want to build customer statement show the customer transactions and customer forward balance

AI generated answer (using internal Slack threads):

To build a customer statement that shows the customer transactions and customer forward balance, you can use a combination of SuiteScript and Saved Searches in NetSuite. Here's a general approach: 1. Customer Transactions: You can create a saved search that targets the customer transactions. This can be done by selecting the 'Transaction' record type and filtering by the 'Name' field to target a specific customer. You can then add the necessary columns to display the transaction details. 2. Customer Forward Balance: The forward balance is the summarized balance of Accounts Receivable (A/R) for that customer prior to the start date of your statement. To calculate this, you would need to get the start date the user selects when generating the statement, then find all transactions hitting A/R that have a due date BEFORE that date and sum up the total amount remaining in A/R for those transactions. This might be a bit tricky to achieve with a saved search alone, so you might need to use SuiteScript to perform this calculation. Please note that the running balance might be tricky to achieve with a saved search, and the saved search will be based on To and From dates unlike a statement that runs as of date. Also, if you set the start date of your Statement to be NULL then the forward balance won't show up. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******