web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Accounts Payable Aging
Microsoft Dynamics GP (Archived)

Accounts Payable Aging

(1) ShareShare
ReportReport
Posted on by Community Member

Is there a report that will alow me to get the Aging Balances of vendors for an as of date even if it is months later that I am running it?  I need to be able to get to the details also.

Example:  It is Jun 15th of a year, I wish to find out what a vendor aging balance details as of Dec 31.

If there is not a canned report, is this something I could build as a SmartList?

Any assistance is greatly appreciated.

Kristin

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Accounts Payable Aging

    Hi Matt,

    This report can be downloaded as a CSV file, but a needs a lot of tidying up. Is there a way we can get the same report on Smart List or is there a quicker way of tidying up Aged Creditors report in Excel. Your advise will be highly appreciated.

    Regards

    JAM3S

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at
    RE: Accounts Payable Aging

    There is the Historical Aged Trial Balance that's run from Purchasing >> Reports >> Trial Balance.  Choose Historical Aged Trial Balance from the dropdown.  This will allow you to run the report on a historical basis like you are describing.  In the report option screen there will be a detailed checkbox to check since you want the detail.

  • Community Member Profile Picture
    Community Member on at
    RE: Accounts Payable Aging

    Hello, SmartList does not run the report as of like SSRS. So, you have to apply a date range in SmartList. To answer your question, yes it is possible to create such a report. The only thing you would need to modify is the aging buckets and define rule for the buckets to age appropriately and total it for each vendor. if you need further details, please let me know.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans