Difference in Historical Aging & AP Aging

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I have a year end aging report that the balance matches to the control AP account. When I ran the Historical Aging Report for the same year end I got a report with a different balance amount. I can see the transaction in the Historical Aging Report that is causing the AP Aging & control AP accounts to be off. My question is, is there a way to remove this transaction from the Historical Aging Report so it matches the Year End Aging report and AP control account?

Any help would be greatly appreciated!

Thanks,

Bob.

*This post is locked for comments

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Difference in Historical Aging & AP Aging

Yes. The Document causing the issue is included in the Historical Trial Balance in both cases.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Difference in Historical Aging & AP Aging

Bob,

So the document causing the issue is included in Historical Trial Balance in both cases when you generate by GL posting date or by document date. Right?

Thanks,

Tina
Community Member Microsoft Employee on at

Like (0)

Report

RE: Difference in Historical Aging & AP Aging

I ran the historical report by GL date and also by document date.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Difference in Historical Aging & AP Aging

I ran the report by GL Posting date and Document date.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Difference in Historical Aging & AP Aging

Bob,

Can you please confirm if you generated the historical report by posting date and not document date?

Thanks,

Tina