In this post I will be discussing the issue which I faced after a couple of upgrades while upgrading from previous versions of AX to Newer version i.e. from AX 4.0 or 2009 to AX 2012 R3. The issue we face issue was while querying from the Trial Balance window i.e. Posted transactions can not be seen for the main account when user select an amount with a link and try to drill down, the grid is empty.
– Navigation – General Ledger >> Common >> Trial Balance.
After investigating the issue we found that the MainAccount was not properly updated in the GeneralJournalAcountEntry Table in AX2012, which was a part of a standard upgrade script in Class ReleaseUpdateDB63_LedgerMinor method updateGeneralJournalLinesMainAccount().
Below is the Code which executes in this Update script:
This is one of the Post Sync Update script which was already executed but due to some reason the MainAccount was not updated properly therefore to fix this issue I executed this script through my custom Job which is as follow:
After executing this JOB the Main Account was updated properly and the issue was resolved and on drill down on trail balance the grid was populated with its corresponding records. That’s all for this post, hope this post is helpful in such similar scenarios which normally occur after the Upgrade.
Keep tuned to www.axpulse.com for more posts related to Data upgrade, issues and their solution and much more…