the Main account list page can take ages. When you have a very high number of ledger accounting transactions, opening of e.g. Very large number of accounting transactions If you read the preface, theoretically everything looks to be a perfect world, however there are some scenarios where you can encounter system slowness or even database blocks. This has been removed as of R2 and in a cumulative update for the initial version of AX 2012. Note that earlier versions of AX 2012 did have an option to keep the balances updated automatically. Also when you open the Main account list page, Trial balance list page, Detailed trial balance or Summary trial balance report the update of balances is executed prior to show the data. The update of balances is performed using a batch job. Here there is a performance gain as during posting there will be no blocks to update the balances. When a new accounting transaction is created, a record will be inserted in a table, stating the balance should be updated apart from the posting itself. After this initialization the balances are maintained by updates. When you create a Dimension set, you need to initialize balances. A field Ledger has the reference for the legal entity. Main account – Department – Cost centerĪ table Dimension set balance (DimensionFocusBalance) is a global table and stores all balances for all Dimension sets in all legal entities.Further you can create set to have reporting options based on e.g.: There is one mandatory Dimension set consisting of only the main account. The Dimension sets in Microsoft Dynamics AX are sets which can be setup to hold balances for a combination of several dimensions. Also if you want to create all kinds of Dimension sets, there are more balances which needs to be maintained. 20 active dimensions the data entry will be unwieldy. Yes you can define anything you like, but with e.g. Setting up Main accounts and related dimensions are now flexible and unlimited. In AX 2012 a new Financial dimension framework has been introduced. This post will inform you about the possible problems and how you could prevent them.
However some scenarios will still cause wait times on the rebuild or update of the balances or even… database blocks. Updating the balances is working correct in many scenarios. Compared to previous versions of Microsoft Dynamics AX, the implementation of balances has been redesigned in AX 2012 to improve performance.
0 kommentar(er)
