Microsoft Dynamics GP (Archived)

AP aging report not showing properly??

(0) Share

Report

Posted on by Rajamoahmmed

200

i need a report print from due date to cutoff date?.

i was setup a AP setup window :

1. Current 0 to 30 days

2. 31 - 60 Days

3.61 - 90 Days

4.Over 90 Days.

my invoice date is: 09/30/2016.

my due date is 30/10/2016,

Print/Age as of is 12/31/2016

now i will print a report with option, the printing report is document date (09/30/2016.) to Print/Age as of date (12/31/2016),but i need a report is due date(30/10/2016) to Print/Age as of(12/31/2016) can you help me.how to do this?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

L Vail 65,271 on at

Like (0)

Report

Hi,

I don't think I exactly understand. The due date of an AP voucher is based on the payment terms assigned to the invoice. You can set up default payment terms against the vendor and then the default due date will calculate based on those payment terms. I don't understand what you mean by due date to as of till date. Could you give an example using some representative dates?

Kind regards,

Leslie

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

Thanks for your reply Leslie,

i was setup a AP setup window :

1. Current 0 to 30 days

2. 31 - 60 Days

3.61 - 90 Days

4.Over 90 Days.

my invoice date is: 09/30/2016.

my due date is 30/10/2016,

my Print/Age as of date is 12/31/2016

now i will print a report with option, the printing reporting is document date (09/30/2016.) to Print/Age as of date (12/31/2016) ,but i need a report is due date(30/10/2016) to Print/Age as of date(12/31/2016) can you help me.how to do this?

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

please help me anyone!

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (0)

Report

Hi Rajamoahmmed,

I think the question you are asking has no answer and it's likely due to a miss understanding of how the historical aging report works.

There is no relationship between due date and 'as of date' as far as what records will pull onto the report. Document Date or GL Post Date on the Invoice is measured against 'Print as of/ Aging date' factoring Date Paid Off to decide what records are on the report. Due Date is then evaluated to decide what bucket the amount should sit in.

Using your parameters:

my invoice date is: 09/30/2016.

my due date is 30/10/2016,

my Print/Age as of date is 12/31/2016

Assuming you did not pay this invoice on or before 12/31/2016 you would have that value in bucket 3 (61 - 90) when you run the report as the Due Date of 10/30 is 61 days over due when measured on 12/31/2016.

If you ran the same report with a as of date of 10/31/2016 then that amount would bucket in Current as it would be 1 day overdue.

Aged TB allows you to do a 'what it was then' look at your AP open balance as if you were running the report that day. It's a look at all open invoices 'as of' that date and the start date is the oldest unpaid invoice you have. It's a moment in time look, not a range related report.

Due Date is only used to determine the bucket. Aging Date vs. Invoice Date/GL Post Date factoring Date Paid Off determine what's on the report, Due Date just sets the bucket amount.

Maybe a simple SmartList adding date paid off as a column and ranging Due Date need is an easier way to get what you want. The ask though seems incorrect, I'm not envisioning the value of a partial as of aging and I think that's why responses to your ask are minimal.

Best

Tim

Was this reply helpful? Yes No
Verified answer

Heather Roggeveen 9,146 on at

Like (0)

Report

Hi

It sounds like you are trying to do the Aging based on Due Date rather than document date. But you have your Aging Method as set to Document Date in your setup window.

So based on Document Date, it should be sitting in around about 90 days old.

If you are aging based on Due Date, then it would sit in about 60 days overdue.

So you just need to reset your aging options in Receivables Setup as below. Note: This changes it for the system overall - so all aging - statements, trial balance reports etc for receivables will all be based on Due Date.

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

please share a same setup window in AP module, i think this is a AR setup window

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

Hi Tim,

Thanks for your reply,and i have some questions? can you clarify me please!

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

In payable module setup window (AP):

Document date :

current period showing

0 to 30 days,

30 to 60 days,

60 to 90 days.

over 90 days.

but

Due date:

current period was showing :

0 to 0 days,

1 to 30 days,

30 to 60 days,

61 and over

my question is:

my invoice date is 09/30/2016

my due date is 10/30/2016

my cutoff date is 12/31/2016

if am print a report with due date then it will show in which aging bucket?, 1 to 30 days aging column or

current period aging column ? and why ? please tell me.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

Can you do a screen shot of the report option you are printing with the data filled in? Then we can comment fully on what you should be getting.

Cheers

Heather

Was this reply helpful? Yes No
Rajamoahmmed 200 on at

Like (0)

Report

thanks for your reply. please check a screen shot

Was this reply helpful? Yes No