BeyondERP.Newsletter
Menu

Setup step on the Formula allocation bases page · Cost accounting

Set up Formula allocation bases

Use this page to define an advanced allocation basis when a single statistical or cost element measure is not enough. You pick the statistical and cost element dimensions whose bases may be used, give each base or constant an alias, write the formula, and preview the resulting magnitudes per cost object.

Used by
Cost accountant, Cost accounting manager
Business process
Define costing policies
Menu item
CAMFormulaAllocationBase
Main table
CAMDataFormulaAllocationBase
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you build an allocation base from a formula that combines existing allocation bases and constants through aliases, using arithmetic and comparison operators.
What you do hereUse this page to define an advanced allocation basis when a single statistical or cost element measure is not enough. You pick the statistical and cost element dimensions whose bases may be used, give each base or constant an alias, write the formula, and preview the resulting magnitudes per cost object.
ExampleFor example, a formula allocation base Electricity fixed with the formula a > b (where a is the Electricity base and b is 0.01) gives each cost object that consumed electricity a magnitude of 1, so a fixed grid fee is spread evenly.
Formula allocation bases page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Formula allocation bases

Use this page to define an advanced allocation basis when a single statistical or cost element measure is not enough. You pick the statistical and cost element dimensions whose bases may be used, give each base or constant an alias, write the formula, and preview the resulting magnitudes per cost object.

Steps from Microsoft

  1. Go to Cost accounting > Allocation bases > Formula allocation bases.
  2. Select New and enter a Name.
  3. Select the Statistical dimension and, if needed, the Cost element dimension whose allocation bases the formula may use.
  4. In the formula allocation base factors, add an Alias for each Allocation base or Constant the formula needs (zero is not allowed as a constant).
  5. In the Formula field, write the formula using the aliases and the supported operators.
  6. Select Preview to check the calculated magnitude per cost object.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameThe name of the formula allocation base, for example Electricity fixed.Microsoft Learn Name
Cost element dimensionThe cost element dimension whose predefined bases may be referenced in the formula.Microsoft Learn CostElementDimension
Statistical dimensionThe statistical dimension whose predefined bases may be referenced in the formula.Microsoft Learn Dimension
FormulaThe expression built from aliases and operators (parentheses, <, >, +, -, *); IF statements are not supported but comparisons evaluate to 1 or 0.Microsoft Learn Formula
AliasA short name used in the formula for one allocation base or constant.Microsoft Learn Alias
ConstantA fixed numeric value assigned to an alias; 0 is not supported.Microsoft Learn Constant
Allocation baseAn existing allocation base (predefined, hierarchy or another formula base) assigned to an alias.Microsoft Learn Name

Common errors and fixes

MessageWhat to do
A formula with an IF statement isn't acceptedFormula allocation bases don't support IF statements. Use a comparison such as a > b, which gives 1 when true and 0 when false. Microsoft Learn
A changed policy doesn't change the figures in the Cost control workspacePolicies take effect when you run the overhead calculation again. Run it for the period and point the report at the new calculation version. Microsoft Learn

Test checklist

  1. Create a formula base named Electricity fixed and select the Statistical dimension.
  2. Add factors: alias a = allocation base Electricity, and alias b = constant 0.01.
  3. Enter the formula a > b and select Preview.
  4. Check that every cost object with consumption shows magnitude 1.00 and that any cost object with none shows 0.
  5. Try 0 as a constant and check that the system doesn't accept it.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Formula allocation basesBuild formula bases on top of an existing predefined base instead of loading a second measure. For example, Electricity > 0.01 gives an even split of the fixed fee among the cost objects that used electricity.Learn shows that a formula base can reuse the Electricity base, so you only load data for one statistical member. The comparison returns 1 when true and 0 when false.Is a formula needed, or does a predefined base give a fair split?Traditional IF statements aren't supported, and 0 (zero) isn't supported as a constant. Use comparisons with a small constant such as 0.01. Check the result with Preview before you use the base in a rule.Test: Formula spreads a fixed fee evenly

Feature management and licence

Licence or add-inCost accounting has four roles: Cost accounting manager (Activity licence), Cost accountant and Cost accountant clerk (Operations licence), and Cost object controller (Team members licence). Cost accountants and cost accounting managers maintain allocation bases. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: Cost accounting setup isn't kept per legal entity. It is the same from every company, and one cost accounting ledger can collect data from several legal entities. Checked in Dynamics 365
Can it be undoneReversible: You can change the formula or its factors at any time. A formula base can be reused in other formula bases and in policy rules, so rerun the overhead calculation for the period. Each run is stored under its own version ID.
If you change it laterA formula base can be reused inside other formula bases and in policy rules, so changing it changes every allocation built on it; rerun the overhead calculation after a change. Microsoft Learn
Technical architect

6Technical

Menu itemCAMFormulaAllocationBase Checked in Dynamics 365
FormCAMFormulaAllocationBase Checked in Dynamics 365
TableCAMDataFormulaAllocationBaseShown as “FORMULA ALLOCATION BASES” in Record infoChecked in Dynamics 365
Who can open it

2 security roles. Select a role to see its duties and privileges.

  • RoleCost accountantCAMCostAccountant
    • DutyInquire into allocation basesCAMAllocationBasesInquire
      • PrivilegeView formula allocation basesCAMFormulaAllocationBaseView
    • DutyMaintain allocation basesCAMAllocationBasesMaintain
      • PrivilegeMaintain formula allocation basesCAMFormulaAllocationBaseMaintain
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into allocation basesCAMAllocationBasesInquire
      • PrivilegeView formula allocation basesCAMFormulaAllocationBaseView
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain allocation bases CAMAllocationBasesMaintainTo use itInquire into allocation bases CAMAllocationBasesInquireGive people a role that holds these duties. On this system, 2 roles give access to this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): PreviewChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMFormulaAllocationBase
Data migrationLoad order: A formula allocation base has no data entity in Data management, so it can't be loaded from a file or a configuration template. Re-create it by hand in each environment after the bases it uses exist.Microsoft Learn
Everyone

8Sources

To cite this step: CA-ALLOC-020, Set up Formula allocation bases. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CA-ALLOC-020