Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Historical Aged Receiveables and Payables Reports

(0) ShareShare
ReportReport
Posted on by 23

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?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Historical Aged Receiveables and Payables Reports

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans