KTL SOLUTIONS

Dynamics-GP Historical Aged Trial Balance shows wrong information

Share this post

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

Tags
365 2013 2015 2016 accounting BI blog Business Business Intelligence Cloud CMMC CRM Data Development Dynamics Dynamics 365 Dynamics CRM Dynamics GP ERP Excel Government Contractor GP How To ISV KTL KTL Blog KTL Solutions Management Microsoft Microsoft Dynamics Microsoft Dynamics CRM Microsoft Dynamics GP Office 365 Power BI Project Project Management Reports Sales Security Solutions Technology tools User User Conference Webinar

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 »
April 10, 2024