i need a report on accrued purchases account that shows debit and credit amount but shows the transaction in one line

AI generated answer (using internal Slack threads):

To create a report on the Accrued Purchases account that shows both debit and credit amounts in one line, you can use a Saved Search in NetSuite. Here's a general guideline on how you can do it: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. On the Criteria subtab, set the following filters: - Type: Purchase Order - Status: Purchase Order: Open - Main Line: True 4. On the Results subtab, add the following fields: - Name (this will give you the vendor name) - Document Number (this will give you the PO number) - Amount (this will give you the PO amount) - Account (this will give you the account associated with the PO) 5. You can also add Debit Amount and Credit Amount fields to the Results subtab to show these amounts in the report. 6. Save and Run the search. This will give you a report showing all open Purchase Orders with their associated accounts, and the debit and credit amounts in one line. Please note that this is a general guideline and you might need to adjust the search criteria and results fields based on your specific business requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******