How can I automatically close all open bills, or non-mapped journals, in an accounts payable subledger against all unmapped vendor payments, or other journals, such that the impact is zero.

AI generated answer (using internal Slack threads):

Based on the conversations, to automatically close all open bills or non-mapped journals in an accounts payable subledger against all unmapped vendor payments or other journals, you can follow these steps: 1. Create a saved search to identify all open bills or non-mapped journals. This search should include the Internal ID and Line ID of the J/E lines where Account = A/P. 2. Export the results of this saved search to a CSV file. 3. Prepare a CSV file for bill payment records. This file should include the necessary information to apply payments to the identified bills or journals. This includes the vendor, the amount to be paid, and the bill or journal to which the payment should be applied. 4. Import the CSV file into NetSuite using the CSV import tool. This will create bill payment records and apply payments to the identified bills or journals, effectively closing them. Please note that this process will not eliminate the balances associated with these bills or journals. If you need to eliminate these balances, you will need to post a journal entry to offset them. This could involve reclassifying the balances to a dummy vendor or another account of your choice. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******