Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
The Performance enhancement for general ledger dimension set balance calculation feature starts the process of creating new balances. This process might take several hours if the amount of transactional data is large. Reports and inquiries that use dimension sets aren't available until the processing finishes. You can view the status on the Dimension set page.
This feature makes the Trial balance inquiry page and reports that use financial dimension sets run more efficiently. The financial dimension sets store data more efficiently and use less space. Therefore, the trial balance can show current balance data more quickly. The feature uses process automation to keep the balance amounts up to date. The background process automation named General ledger balance process runs every 5 minutes by default. The process automation background task creates a new, single occurrence batch every 5 minutes. When you view the individual batch task, the occurrence displays 10 minutes because that's the default for any batch. The background task creates a new balance process batch every 5 minutes. You can change this time on the Background process tab in Process automation.
Important
In Dynamics 365 Finance version 10.0.45 and earlier
Before enabling this feature in a production environment, review any customizations that rely on the previous balance data. Also, complete full functional and performance testing in a sandbox or UAT environment to validate expected behavior. Prior balance data is immediately queued for deletion to help reduce storage usage. In Dynamics 365 Finance version 10.0.46 and later Before enabling this feature in a production environment, review any customizations that rely on the previous balance data. Also, complete full functional and performance testing in a sandbox or UAT environment to validate expected behavior. Prior balance data is retained for 30 days before being queued for deletion, allowing additional time for validation or transition. This deletion process can't be reversed once it begins, and must be allowed to fully complete before switching back from the enhancement feature, if reverting is needed.View balance status
Use the Balance status button to view the current calculation state of the financial dimension set. The page that appears shows the status of the dimension set balance for each legal entity. It also shows the date and time when the dimension set was last updated by the automatic background process.
Enable balances
Use the Enable balances button to initialize and start to track balances for a dimension set that doesn't currently have balances.
Note
Limit the number of dimension sets that have balances, because balance updates affect all General ledger posting activities.
Disable balances
Use the Disable balances button to turn off balance tracking for a given dimension set.
Rebuild balances
Use the Rebuild balances button on the balance status page to recreate balances from the General ledger transactional data. This functionality helps ensure that the balances match the data in General ledger. A rebuild of balances requires lots of processing and should rarely be required.
Delete a dimension set
If you no longer need a dimension set, use the Delete button to remove it. Don't delete and recreate dimension sets as a workaround for potential problems with the balance data for a specific dimension set. Recreation of a dimension set is costly. For help with problems, contact support.
Trial balance and reporting
After you turn on the feature, you notice small changes to the trial balance page and reports such as the Dimension statement report that utilize dimension sets to display ledger balance data. Each of these reports notifies the user how current the balance data is. By default, this value is a number between 0 and 5 minutes since the background process ran.
Technical information
The following table describes the old data model and the new data model used for this feature. The outcome is less data to store resulting in faster performance for some queries such as ones used for the trial balance inquiry page.
Important
Any customizations that depend on the old data model stop working as soon as you enable the performance feature. Test in a UAT environment first. It's not possible to switch between the new and old models efficiently.
| New table | Old table | Description |
|---|---|---|
| GeneralLedgerBalance, GeneralLedgerMainAccountBalance | DimensionFocusBalance | FocusDimensionHierarchy and FocusLedgerDimension are removed from the balance tables. The data is now aggregated by the original GeneralJournalAccountEntry.LedgerDimension value (no new DimensionAttributeValueCombination records created for balances any longer). The GeneralLedgerMainAccountBalance stores balances at the main account level only as a performance optimization as the primary use case scenario. |
| GeneralLedgerBalanceReportingDimension | DimensionAttributeValueCombination, DimensionAttributeValueGroupCombination, DimensionAttributeValueGroup, DimensionAttributeValue, DimensionAttributeLevelValue, and others. | New tables store segment values of the dimension attribute value natural key values in hierarchical order based on the dimension set. NOTE: The change to no longer use the DimensionAttributeValueCombination and other Dim* tables is only in the context of dimensions set storage. These tables are still used and linked to for transaction entry and all voucher data found in the general ledger (LedgerJournalTrans, GeneralJournalAccountEntry). |
| GeneralLedgerBalanceReportingDimensionReference | DimensionFocusLedgerDimensionReference | The new table is the link between the original ledger account and reporting account structure per dimension set. |
| GeneralLedgerBalanceUnprocessedTransactions | DimensionFocusUnprocessedTransactions | Records to perform incremental update of balances are no longer created per dimension set. |
For more information, see Financial dimensions.