We have a Financial dimension set for the main account that is set to Update balances during the posting process. Despite this users are reporting that when they run a trial balance with the primary financial dimension set of main account in summary level and detail level they are getting different results.
We identified that we were getting deadlock errors when posting transactions from a separate point of sale system into AX. The error was :
Cannot edit a record in Dimension set unprocessed transactions (DimensionFocusUnprocessedTransactions). Financial dimension set: 0.
Deadlock, where one or more users have simultaneously locked the whole table or part of it.
We found a hotfix (2708448 : When you enable “Update balance during the posting process” on Financial Dimension Set, we see the system getting deadlocks.) which we installed. This stopped the deadlocking problem but we are still getting inconsistencies between the Summary and Detailed trial balance. Upon investigating this it appears that some transactions are missing from the summarised data despite the Update balances during the posting process flag being selected. Even more bizarrely the missing transactions were not newly created transactions but were several days old and had been posted prior to the Financial Dimension Set values being rebulit and the summary and detailed trial balances being reconciled.
Has anyone else come across this problem? This is a serious issue for our users as they cannot rely upon the summary trial balance witrhout rebuilding the Financial dimension set balance each time they run the trial balance (Even updating the balance does not apprear to solve the issue)
Listed on the hotfixes for Ax 2012 is 2717490 : Financial dimension set balance rebuild. I am unable to find any additional information on this. Has anyone got any additional information as to the exact problem this reoilves.
Our system information is :
Kernal version : 6.0.947.862
Application version : 6.0.947.280
Thanks and regards
Steve Roberts