Not showing proper Payables Aging

(0) Share

Report

Posted on by GovindDevda

617

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

I have the same question (0)

All responses (10)

Answers (0)

Michelle Bruehler 275 on at

Like (0)

Report

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

Was this reply helpful? Yes No
GovindDevda 617 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Michelle Bruehler 275 on at

Like (0)

Report

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

Was this reply helpful? Yes No
GovindDevda 617 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Michelle Bruehler 275 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Govind

Can you validate your aging option in Setup - Payables

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

Was this reply helpful? Yes No
GovindDevda 617 on at

Like (0)

Report

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

Regards,

Govind

Was this reply helpful? Yes No
Suggested answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

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

Was this reply helpful? Yes No
GovindDevda 617 on at

Like (0)

Report

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.

Thanks & Regards,

Govind Devda

Was this reply helpful? Yes No
Suggested answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

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

Was this reply helpful? Yes No