The AP aging detail report is showing the open balance of a bill as the total of the bill and not taking in consideration the bill credit that was applied

AI generated answer (using internal Slack threads):

The AP Aging Detail report in NetSuite shows the unpaid bills in Accounts Payable. It does not include closed transactions, i.e., paid bills. If you want to see all transactions including paid bills, you might need to use a different report. If you are looking for a report that shows all suppliers balances as of a specific date, you can start with the AP Aging Summary report. However, please note that "Bill Credits" do not have a due date, so they do not get aged the same way as Bills. If your report is not including any of the bill credits that you know are unpaid at that time, you can try changing the Aging Options to "Transaction Date". If you have vendors appearing on the A/P aging detail report which you want to remove, 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. ******

how do i get it to reflect the amount remaining on the report