Dynamics-GP Historical Aged Trial Balance shows wrong information

Problem – The historical aged trial balance is showing records that should not appear. If you check the box exclude unposted applied credits you get one number. If you uncheck exclude unposted applied credits you get the wrong number. You have no unposted applied credits.

Resolution – The problem is in the RM20201 table. There is a column called POSTED. For some reason this field is still set to zero. If all of your batches are posted this value should be a 1. Follow these steps:

Backup the company database
Execute the following script “update RM20201 set POSTED = 1” against the company database
Run your historical trial balance

You should have the correct totals now

Share this post

Related Posts

Checking Your CMMC Progress

Written by Alec Toloczko With Cybersecurity Maturity Model Certification (CMMC) requirements on the horizon, it’s crucial for organizations handling Controlled Unclassified Information (CUI) to adhere

Read More »