Trial balance transactions are missing in AX 2012 R2 CU9 when you upgrade AX 2012 R2 to AX 2012 R2 CU9 or if you install KB3024254 (which is a part of CU9 package).
Navigation: General Ledger >Common > Trial balance > Double click any record
When you select any record, the window containing transactions should open, however the grid is empty.
The issue occurs when you view the transactions of already existing data before upgrade in the trial balance form.
When transactions are populated in the grid, the Main account column in the GeneralJournalAccountEntry table is populated. However, in this case the value is ‘0’ for Main account column as the transactions are not displayed.
In order to fix missing transactions in the main account column in the GeneralJournalAccountEntry table, you need to install hotfix KB3093861.
While applying KB3024254 or AX 2012 R2 CU9 you also need to apply KB3093861 before running the software update checklist so the appropriate data upgrade script runs to populate the MainAccount column in the GeneralJournalAccountEntry table.
If you have already applied KB3024254 or AX 2012 R2 CU9, then you can run the data upgrade script manually using this X++ job:
static void Job3(Args _args)
{
ReleaseUpdateDB63_LedgerMinor r = new ReleaseUpdateDB63_LedgerMinor();
;
r.updateGeneralJournalLinesMainAccount();
}
DISCLAIMER:
Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that. You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code
– Written by: Malaika Mulla & Nikita Gavandi
– Contributor: James Wang