how to create vendor statement

AI generated answer (using internal Slack threads):

To create a vendor statement in NetSuite, there are a few methods you can use: 1. AP Aging Detail Report: You can modify the AP Aging Detail report to fit your needs. This report can be stripped down to the specific vendor you're looking for, cleaned up to fit your needs, and then printed or sent as a PDF. 2. Saved Search and Advanced PDF: Create a transaction saved search for AR aging with the vendor as a filter. You can then port the results to a custom advanced PDF template, which offers more flexible formatting and design options than reports. You can reuse the search for any vendor just by using the filter. Formulas for AR aging can be found in SuiteAnswers. 3. Dashboard Link: Use the Dashboard link to find all your reports prefiltered for aging etc on the dashboard page for that vendor. If you need to automate the process, you can create a Saved Search of all Open Vendor Bills, add the columns you want to have, customize the email you want, use Send to Recipient, tick SUMMARIZE SCHEDULED EMAILS, schedule a send. This method will give the vendor a list to accept but won't get a total onto the summary. Another solution is to use a map/reduce script that identifies vendors with open balances, then for each of those run another search to include the open Bills. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******