Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor aging Report

Posted on by Microsoft Employee

Can someone please help to create SQL query for vendor aging report with due date buckets?

I am using VendorTable and VendorTrans Table AX 2009.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Vendor aging Report

    Hi AXdynamics1,

    There is a vendor aging report in the standard application where you can configure your aging buckets. For what reason do you need a SQL query?

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: Vendor aging Report

    Hi AXdynamics1,

    Is there any specific business requirement to create custom Vendor Aging report instead of using Out of the box Vendor Aging report from system? You can generate report with Dates, Aging buckets along with other parameters from Accounts Payable > Reports > Status > Vendor Aging Report.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans