web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Variable Allocation with Statistical Account returns 0.00 when using Shortcut Dimension 3 filter

(3) ShareShare
ReportReport
Posted on by 14

I am testing a Variable Allocation Account using a Statistical Account as the breakdown account.

Dimension setup:

  • Global Dimension 1 = DEPARTMENT
  • Global Dimension 2 = STATE
  • Shortcut Dimension 3 = ENTITY

I posted valid Statistical Account entries against ENTITY values COMP A, COMP B, and COMP C. In the Variable Allocation setup, I applied these ENTITY values under Breakdown Account Balance Filters.

However, the Allocation Preview returns Breakdown Account Balance = 0.00 for all lines. I tested both Period and Balance at Date with the same result.

As a control test, using DEPARTMENT (Global Dimension 1) works correctly and retrieves the statistical balances.

Question:
Is this expected behavior for Statistical Account-based Variable Allocation when using Shortcut Dimension 3, or should Shortcut Dimensions 3–8 work in Breakdown Account Balance Filters? Is any additional setup required?

  • Suggested answer
    YUN ZHU Profile Picture
    103,704 Super User 2026 Season 2 on at

    Hi, As far as I know, this requires you to split and maintain the configuration by Dimension in advance. For example, the three lines below represent three different dimensions.

    PS: Business Central 2023 wave 2 (BC23): Use General Ledger Allocations to distribute costs and revenue more efficiently (Allocation Account)

    https://yzhums.com/42632/

     

  • Verified answer
    OussamaSabbouh Profile Picture
    20,172 Super User 2026 Season 2 on at

    Hello,

    Yes, based on Microsoft’s current documentation, this is expected standard behavior. For a Variable Allocation Account using a Statistical Account as the breakdown account, Microsoft specifically documents Breakdown Account Balance Filters as supporting filters on global dimension values. In other words, Global Dimension 1 and Global Dimension 2 are supported for calculating the breakdown balance; Shortcut Dimensions 3–8 aren't documented as supported for this calculation. That matches your test exactly: DEPARTMENT as Global Dimension 1 returns the statistical balance, while ENTITY as Shortcut Dimension 3 returns 0.00. There isn't an additional setup that will make Shortcut Dimension 3 participate in the standard calculation. If ENTITY is fundamental to your allocation logic, the standard options are to make it one of the two global dimensions (only if that makes sense for your overall dimension design), redesign the statistical accounts/allocation structure, or customize the variable-allocation calculation to evaluate the Dimension Set Entries for dimensions 3–8. I would not change global dimensions purely as a workaround without considering the impact, because Microsoft notes that changing global dimensions updates existing entries and can be a significant operation.

    Regards,
    Oussama Sabbouh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 765 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 571 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 299 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans