Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AR Aging
Microsoft Dynamics GP (Archived)

AR Aging

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

 

Recently i came across this criteria on AR Aging of which like below.

1. Aging Buckets are referred / measured in Months (Jan, Feb, March ... ), instead of Days (0-30, 31-60, 61-90 ... )

2. All sales shall be due by the next month, regardless of the day of the current month the sales is commited

 

Example, the 3 sales (invoice) was done on 1st June, 15th June, 30th June, and all 3 invoices will be due in July

 

With such criteria, how should the aging periods be like? i couldn't set a fixed amount of days for each bucket because number of days differs crossing each month. Anyone has a better idea on this?

 

The ultimate intention is to get all invoices due by the following month, and should appear in the correct aging bucket when aged at the end of every month.

 

Thanks very much.

 

ivan

*This post is locked for comments

  • Ritesh Maharaj Profile Picture
    Ritesh Maharaj 945 on at
    Re: Re: Re: Re: AR Aging

    You can force GP to age by calendar month by changing the AR aging every month. Although this is not ideal, I've had a few clients who really didn't mind the extra effort at month end.

     How to do it? Assuming the current month is April, then the aging buckets in AR setup will be setup as

    current : 0-29 (April)

    30days : 31-60 (March)

    90days : 61-88 (February)

    120+ : 88-9999 (January and prior)

    You will of course have to setup a schedule like this for every month and give to your client to input at month end. Don't forget the leap year!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: AR Aging

    Aging periods in GP cannot be based on calendar months, only based on number of days.  So you would either have to create a modified report in report writer (which would require a number of calculated fields and am not sure it would be possible) or in SQL reporting services (and even then, it would be fairly complex due to the varying months.

     Take care,
    Christina

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: AR Aging

     Hi Christina,

     

    thanks for the info. i've tried using payment term to set the due on the 1st of each month, and it all turned out right. but when i start aging by due date, the invoices still won't fit into the correct aging buckets (with fixed amount of days).

     

    apart from SQL Reporting Services, is there any other way that can be done within GP itself? we're trying to minimize SQL Reporting Services due to the client environment.

     

    Thanks again.

     ivan

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AR Aging

    Hi--

     If the goal is to get all invoices due by the following month, I would use a payment term, and make them due on the 1st/15th/etc of the next month. Then I would age by due date, so anything not current would be in a subsequent period.  Unfortunately, the aging periods cannot be based on calendar months, but you could design a report in SQL Reporting Services to accomplish the same goal if it was necessary.


    Take care,

    Christina

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans