Finance | Project Operations, Human Resources, ...

AR Historical Aged Trial Balance

(1) Share

Report

Posted on by Community Member

The AR Historical Aged Trial Balance is not picking up an invoice that it should.

Customer is setup to maintain history

The invoice has:

Posting Date 11/20/2020

Invoice Date 11/20/2020

Due Date 1/19/2021

When I run the AR Historical Aged Trial Balance with the following:

Print Age as of 11/29/2020

Select Transactions for Reporting using - GL Posting Date

Exclude Fully Paid Documents, Zero Balance, No Activity, Unposted Applied Credit Memos

The invoice does not appear on the report.

I have done the following:

Reconciled Current Customer Information , Outstanding Document Amounts

Ran aging

Delete RM Keys file - ran checklinks

Created the same invoice in Sandbox company - the report in the Sandbox company does pick up the document

Ran SQL query on RM20101 for the invoice in question against the Live Company and the Sandbox company and compared the columns, everything looks the same

How do I get the invoice in the Live Company to appear on the report?

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: AR Historical Aged Trial Balance

Hi Dean,

Thanks for your suggestion I have checked all of the dates and they are the same. I even had co-worker look at what I have dumped out of SQL just for a second set of eyes. Everything looks the same. This one is really stumping me.
Suggested answer

Dean Marty on at

Like (0)

Report

RE: AR Historical Aged Trial Balance

Good Day

When there is an issue with a transaction not being picked up, it's typically something with a Date

I would suggest to check all the RM tables for your Live and Test documents - it seems like there must a date field somewhere that is different and is the cause.

Thanks!

Dean