Aged Overdue Payables

Hi,

I tried both version of AP 9.3A (171027) & 9.3A (180201)
Aged Overdue Payables

I have AP Invoices in December 2018 that are fully paid and cleared in January 2019.
I run Age Overdue Payables using Calculate as of December 31, 2018.
For some reason, all of the December 2018 invoices that are paid in January 2019 are not showing up. I tried running is again but using November 30, 2018 and it give me a good result for November 2018.

I tried all three reports and have the same issue:
Open Payables
Aged Open Payables
Aged Overdue Payables

What am I doing wrong?

Marlon Asuncion

Marlon:

I doubt you are doing anything wrong, more likely there is some anomaly with the December invoices. I'd need eye on the data to figure that out.

I found the issue.

Our AP closed the month (Dec 2018) and year (2018). After closing, all of the invoices / credit notes that are December 2018 and prior that were paid/adjusted in Jan 2019 went to History table. So when I run the Age Overdue Payable using Calculate as of Dec 31, 2018. for some reason it does not see the invoices / credit note from History table.

Can someone please look into this if this is actually the issue?

On another subject, is there an option for the Age Overdue Payables (calculated as of) to not show vendor that are have zero balance?

Marlon Asuncion

Hi Marlon,

I recall that we made a change in the past that if the Report Date for the Aged Overdue Payables report is older than the Last Period End date, history is no longer checked - otherwise the report was painfully slow.

The Aged Overdue Payables report does not have an option to suppress or show zero balance vendors - this is what the Aged Open Payables report is for.

I will forward your comments to R&D.

Thank you for looking into it.

RE: Zero Balance Vendor; I might have mis-stated, but I DO NOT want the zero balance vendor to show in the Aged Overdue Payables report.

Marlon Asuncion

Hi Marlon,

Do these zero-balance vendors have outstanding transactions that are not matching together yet net to zero? If so, then the Aged Overdue Payables report will continue to show the outstanding invoices and other transaction until such time that they are matched and all have 0.00 Current balances. Suppressing the zero balance vendors is for the Aged Open Payables report.

You're sort of right.

There is an invoice with credit note and the other is a manual with reverse check. Both are a match for their respective documents.

In Aged Overdue Payables detailed, it is fine because you can see the transaction on why it is zero, but in Age Overdue Payables summary, it just zero which makes people question it.

Marlon Asuncion

Hello Marlon,

The Payables 93B (20.02.17) Upgrade has been updated so that Aging reports that 'Calculate as of' a Report date that is equal to the Last Period End date will include documents that are in History.

The Company Profile, Report Options tab, 'Days to Read History for Backdating' option should not be set to 0 days.