Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Not showing proper Pay...
Microsoft Dynamics GP (Archived)

Not showing proper Payables Aging

(0) ShareShare
ReportReport
Posted on by GovindDevda 615

Hi All,
I am very confused about the aging report, When I had created payables trx and post with this date are

Trx date : 21-07-2016 and Due date is 20-08-2016 now I had changed the GP date as well as system date with 31-08-2016 and Print/Age as of also 31-08-2016 and generate a report but the trx amount goes to the 31-60 days but it should be go into the Current trx am I right because the age of trx is 11 days ?


Means that each time It is calculating the age on trx date not Due date.
Please help me out how to resolve this issue.

Thanks & Regards,

Govind Devda

*This post is locked for comments

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Not showing proper Payables Aging

    Govind,

    In the snapshot, you can see Aging Periods option set to Document Date,

    please try to change that to Due Date and see if you can get the Ageing based on Due Date.

    Thanks,

    Praveen

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: Not showing proper Payables Aging

    Thanks Praveen for response, Yes I understand but I want to take from due date and my setup in gp are :

    so according to my setup aging is 11 days old I am right so in that case why it goes into 31-60 Days It should be go into Current Period as I guess.

    99.PNG

    Thanks & Regards,

    Govind Devda

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Not showing proper Payables Aging

    Hi Govind,

    When you setup GP Date to 31/Aug/2016, the application will check for transactions between 1st Aug 2016 to 30 Aug 2016 for first bucket that is 0 to 30 Any transaction which falls before 1st Aug 2016 will be considered as above 30 days that is 31 to 60 Bucket, so ideally the application behaves proper.

    Hope this will helps you to understand the Ageing.

    Thanks,

    Praveen

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: Not showing proper Payables Aging

    Thanks Sagi for reply, Yes I had checked it, But facing same problem.

    Regards,

    Govind

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not showing proper Payables Aging

    Hi Govind

    Can you validate your aging option in Setup - Payables

    You will see an option for Transaction Date or Due Date.

  • Michelle Bruehler Profile Picture
    Michelle Bruehler 275 on at
    RE: Not showing proper Payables Aging

    Hi Govind,


    This is an open payables report. I would run it and see what you think - there are options in the report where you can

    exclude fully paid documents.

    Nothing wrong with  going in there and testing the report.... It should get you what you need.

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: Not showing proper Payables Aging

    Hello Michelle  Thanks for guide, But I am looking for open trx aging report, not historical.So is that any way to resove my issue?

    Thanks & Regards,

    Govind Devda

  • Michelle Bruehler Profile Picture
    Michelle Bruehler 275 on at
    RE: Not showing proper Payables Aging

    I would use the Historical report, that will get you your aging by document date.

  • GovindDevda Profile Picture
    GovindDevda 615 on at
    RE: Payables Aging report Issue

    Hello Michelle  thanks for quick response, No I am not looking a historical aging report I am looking a open trx aging report, FYI I am using  "Aged Trial Balance with Options" for generating a report of PM aging report.

    So in that case I am facing above mention issue.

    Thanks & Regards,

    Govind Devda

  • Michelle Bruehler Profile Picture
    Michelle Bruehler 275 on at
    RE: Payables Aging report Issue

    Hi Govind,

    Which report are you printing? I would make sure you are using the Historical Aged Trial Balance so that you have the option to print by GL posting Date or Document Date.  Looks like most reports pull by GL posting date

    Thank you,

    Michelle Bruehler

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