Hello,

I'm running AP - Aged Overdue Payables, using "Calculate as of" and it is not picking up paid invoices that are in history.

Please advice.

Marlon

Marlon:

Fully paid invoices in history don't meet the definition of "Overdue". Please explain what you are trying to accomplish and why. Someone may then be able to offer a suggestion.

Perhaps you are really looking to print an Aged Open Payables calculated as at a specific date?

Douglas,

What I'm looking for is AP - Aged Overdue Payable calculated as of 02/28/2015. I want the report to show me the Overdue Payables that was not paid on or before 02/28/2015 even though they were paid in full and cleared in March. Please note that I want the "Calculated as of" not "Aged as of".

I was able to do this on previous version of AP8.1F(130826).

Andrew,

Aged Open Payables calculated as of a specific date do not allow running earlier dates than the last clearing date.

Marlon

Hi Marlon,

I don't believe that restriction exists in Payables 9.2A.

Hi Marlon,

The Aged Overdue Payables report has an option at the very top to either 'Calculate as of' or 'Aged as of'. Make sure to choose to Calculate, as this is the correct way to print the report as it was as of the report date. When an invoice meets the report selection criteria, and the payment/credit applied to the invoice comes after the report date, you should see either a C (completed) or P (partial) print in the right-margin next to the invoice.

I believe that Doug is indicating the Open Payables report will go back into History to determine the transactions current as of the report date. I do not believe this is true for the new Aged Open Payables (currently) for the reason you indicated.

When I print the Aged Overdue Payables with a report date earlier than the clearing date and Calculate as of, I don't see historical transactions on the report. I do not recall off the top of my head whether this was a limitation of Calculate as of in version 8.1F.

Hello Support,

Yes, in Aged Overdue Payables, I selected "Calculate as of" and some transaction do not show on 9.2A but shows in 8.1F using the same data set.

Do you want to look at my dataset?

Marlon

Hello Andrew,

My last clearing date was 03/31/2015. I'm running a report (Aged Open Payables) Calculated as of 02/28/2015 and I get a restriction. Please see screenshot.

Is there a check box I need to marked to get this restriction off?

Marlon

Support,

As I mentioned before, version 8.1F picks up the information even if the invoice is in history as long as it meets the criteria Calculated as of.

Is there anything that can be done? Do you need more information? Do you need me to replicate the issue. If nothing can be done let me know as well.

Marlon

Hi Marlon,

As indicated in the last paragraph of my initial response, I was able to replicate what you reported in the Payables 9.2A upgrade, and indeed I could see those same transactions appear not only in the same report from version 8.1F, but also the Open Payables report in the current version.

No further information is required and this is currently being investigated by the development team. I would tend to agree with you that a fix is required for both of the Aged reports.

Thank you Warren.

Marlon

Hello Marlon,

The Payables 92A (150609) Service Pack has these updates to the Aging reports:
- The Aged Open Payables report can be printed if the ‘Calculate as of’ date used is earlier than the last clearing date
- The Aged Overdue Payables report will report transactions that were in history.

Thank you for the update.

I've been waiting for the service pack because I need to reverse some checks.

Marlon