Is there any way to add a button that we can click that allows us to run the AP AgedInvoice using the same data that is in the AP TrialBalance if we run this after the "as of" date we require. This would be extremely helpful with auditors who want to not only see an AP TB, but an Aging as well. The issue is that we can have invoices or credits come in after we close. As I understand it, the AP TrialBalance is based on Transaction Effective Date - that's what I want to be able to run the AP AgedInvoice on as well.

Comments

  • You are correct that the AP Trial Balance uses the Transaction/Posting Date and the Aged Invoice report uses either the Invoice Date or Invoice Due Date.

    I've created an AP Aging report using Sage Intelligence that ages using the Transaction/Posting date. Let me know if