Our company ages a Receivable on a MONTHLY basis. IE: Any purchase in August and prior is 90 days; September = 60 days; October = 30 days and ANY November purchase will be Current.
How do I get this to work in GP.
TY
Mary
*This post is locked for comments
In addition to the above setup information, the ageing process includes an age as of date. If, for example, you are running the ageing today but want to see the accounts as of 11/1/2013, just enter that date in the age as of field.
If you want to group all over 60 day invoices into one bucket, simply enter four tiers (current, 30, 60, and 90 and over). All of the tiers in the above window do not need to be completed. Make the last tier from 90 to 999.
Note that if you have any accounts over 999 days old, you have to write them off, they will fall out of the last bucket. GP does not support an ending of 9999 days.
In Dynamics GP, the aging periods are calculated based on either "Document Date" or "Due Date" as shown below;
I think you can get this by creating a "customized report". You could consider Ms. Victoria's Receivables Aging views as a starting point, which are;
SQL view for current Receivables aging detail in Dynamics GP
SQL view for current Receivables aging in Dynamics GP (Summary)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (