how to calculate the age for open payments

AI generated answer (using internal Slack threads):

To calculate the age for open payments, you can use a formula that subtracts the invoice date from the bill payment date. This can be achieved in NetSuite using the following formula:

round({closedate} - {trandate})

. This formula will give you the number of days between the bill payment date and the invoice date. For the Customer AR Ageing report, it does take into consideration customer payments which might not be allocated yet. If you have vendors appearing on the A/P aging detail report which you want to remove, and these vendors are all linked to the same Vendor, you can apply them against each other on the Bill Payments page or Bill Payment transaction. Make sure that the total is 0 when you mark the transactions so that you won't accidentally create a new transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******