Views:

Applies to Product - Dynamics 365 Finance
 

What’s happening?
There are instances where budget register entry line amounts are duplicated in the Budget control statistics by period form.
 

Reason:
Wrong data that occurs only for a specific budget register entry and not for others. For the visibility issue, it may relate to budget control activation or configuration settings.
 

Resolution:
For Duplicate Budget Register Entry Line Amounts:
 

  1. Refresh the database from the production environment to the sandbox environment to test for issues.
  2. Run the following SQL script to check for duplicates: sql SELECT BUDGETDIMENSIONFOCUSDIMENSIONREFERENCE FROM BUDGETDIMENSIONFOCUSDIMENSIONREFERENCE BDFDR JOIN BUDGETTRANSACTIONLINE BTL ON BDFDR.BUDGETLEDGERDIMENSION = BTL.LEDGERDIMENSION JOIN BUDGETTRANSACTIONHEADER BTH ON BTL.BUDGETTRANSACTIONHEADER = BTH.RECID JOIN DimensionAttributeValueCombination DAVC ON DAVC.RECID = BDFDR.FocusDimension WHERE davc.hashversion = {ALPHANUMERICPII}
  3. If the result is greater than 0, the issue likely exists.
  4. Ensure that Performance enhancement for general ledger dimension set balance calculation feature is enabled from Feature management workspace.
  5. Rebuild balances for the financial dimension set used by Budget Analysis by going to General ledger> Chart of accounts> Dimensions> Financial dimension sets. Then click on Balance status option, select the legal entity and then Rebuild balances option.
  6. Clear balances and then create balances in the financial dimension sets. Here you can find more details: Financial dimension sets - Finance | Dynamics 365 | Microsoft Learn