RM Historical Aged Trial Balance (HATB) doesn't match ATB with Options

(0) Share

Report

Posted on by Kirk Alexander

410

We've compared the settings such as Document Date versus Posted Date, and the As Of date. But the 0-30 days column is about $3000 more on the HATB than on the ATB... and the "120+ column" is the same $3000 less. The other columns match to the penny.

Thoughts on why this discrepancy would occur?

*This post is locked for comments

All responses (2)

Answers (0)

Kirk Alexander 410 on at

Like (0)

Report

RE: RM Historical Aged Trial Balance (HATB) doesn't match ATB with Options

Thanks for your reply... Yes, we had run aging... and the TOTALS matched, but the buckets did not - so we're still wondering.
Marlena A. Stark 21 on at

Like (0)

Report

RE: RM Historical Aged Trial Balance (HATB) doesn't match ATB with Options

Brian,

You need to run aging process in GP in order for AR TB reports to update the aging buckets. Historical Trial balance report does it out of box.

Also, if you ever have differences between the 2 reports in totals (not buckets), this may mean that you have some data corruption and some transactions may have not got properly to all of the tables. AR TB and HTB are build on different using different tables but they should match.

Thanks.

Marlena

dexprodynamics.com