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