I have seen some questions regarding historical aging reports - they seem to point to Accounts Payable report but indicate a possible bug.
Is there a way to run historical aging reports for both Customers and Vendors?
I have seen some questions regarding historical aging reports - they seem to point to Accounts Payable report but indicate a possible bug.
Is there a way to run historical aging reports for both Customers and Vendors?
Stephen,
Yes, you are right. It provide the results based on date. But once the entries are closed they will not appear in this report.
e.g. suppose Vendor A has balance $400 on 03/11/21 and you post a payment on 03/15/21. Vendor A has a balance 0 now (But you have not applied payment entry IMPORTANT) .
If you run this report with date 03/14/21 you'll see the entries that make this $400. Now if you run this report on 03/16/21 you'll see entries before that make $400 and also the payment entry of $400.
Now comes the main part. If you close Vendor A entries by Apply entries and Post Application from Vendor Ledger Entry page. When you run this report now you'll not see even a single entry for this vendor. So we can say that this report shows transactions for vendors based on date but only those that are Open.
You might consider running the Vendor - Balance to Date report. And yes, this applies to AR and AP.
Hope this helps.
Thanks,
Steve
André Arnaud de Cal... 291,735 Super User 2024 Season 2
Martin Dráb 230,466 Most Valuable Professional
nmaenpaa 101,156