Notifications
Announcements
No record found.
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.
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.
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?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 384 Most Valuable Professional