AR Aging

(0) Share

Report

Posted on by Community Member

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.

Mary

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: AR Aging

Hi,

Make sure you are using the Historical Aged Trial Balance Report if you want to see what the AR trial balance looked like as of a specific date in the past.

Kind regards,

Leslie

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

RE: AR Aging

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.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: AR Aging

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)

Was this reply helpful? Yes No