BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Cost rollup policies

A setup page where you create cost rollup policies and rules that map each cost object (such as a cost center) and cost element node to a secondary cost element, so that allocated balances are transferred under that secondary element instead of the original primary cost elements.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Define costing policies
Menu item
CAMCostRollupRule
Main table
CAMDataCostRollupPolicy
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create cost rollup policies and rules that map each cost object (such as a cost center) and cost element node to a secondary cost element, so that allocated balances are transferred under that secondary element instead of the original primary cost elements.
What you do hereUse this page to decide at which level costs are aggregated before allocation, so that the primary cost per cost object is preserved for reporting and the flow of cost between cost objects can be traced. Without a rollup policy, every primary cost element is allocated separately and auxiliary cost objects end with zero balances.
ExampleFor example, you create secondary cost elements SC-CC001 to SC-CC004 and map each cost center to its own secondary element, so the HR cost center's 10,100.00 is passed to Finance, Assembly and Packaging as cost element SC-CC001.
Cost rollup policies 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 Cost rollup policies

Use this page to decide at which level costs are aggregated before allocation, so that the primary cost per cost object is preserved for reporting and the flow of cost between cost objects can be traced. Without a rollup policy, every primary cost element is allocated separately and auxiliary cost objects end with zero balances.

Steps from Microsoft

  1. Go to Cost accounting > Policies > Cost rollup policies.
  2. Select New, type a Policy name and a Description.
  3. Select the Cost object dimension hierarchy and the Cost element dimension hierarchy, then select Save.
  4. Select New in the rules list and pick the Cost object dimension hierarchy node (for example a cost center).
  5. Select the Cost element dimension hierarchy node and the Secondary cost element to map the cost center to.
  6. Repeat until all cost centers are mapped to their secondary cost elements.
  7. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Policy nameThe name of the cost rollup policy.Microsoft Learn PolicyName
DescriptionA free-text description of the policy.Microsoft Learn PolicyDescription
Cost object dimension hierarchyThe cost object hierarchy whose nodes the rules refer to.Microsoft Learn CostRollupPolicyCostObjectDimensionHierarchy
Cost element dimension hierarchyThe cost element hierarchy whose nodes the rules refer to.Microsoft Learn CostRollupPolicyCostElementDimensionHierarchy
Cost object dimension hierarchy nodeIn a rule, the cost object (for example cost center 007) whose balance is rolled up.Microsoft Learn
Cost element dimension hierarchy nodeIn a rule, the cost element node whose primary costs are aggregated.Microsoft Learn
Secondary cost elementIn a rule, the secondary cost element that carries the aggregated balance during allocation.Microsoft Learn

Common errors and fixes

MessageWhat to do
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
A validation message says a dimension member is missing from a classification hierarchyAdd the member to a node of the hierarchy. A classification hierarchy must hold every member of its dimension. Microsoft Learn

Test checklist

  1. Create secondary cost elements SC-CC001 to SC-CC004 and add them to a Secondary cost node in the Profit & Loss statement hierarchy.
  2. Create a rollup policy with the Organization and Profit & Loss statement hierarchies, and map each cost center node to its secondary cost element.
  3. Run the overhead calculation with the cost allocation policy assigned.
  4. Open the Cost object balance journal entries and check that each cost center's balance appears under its secondary cost element.
  5. In the Excel or Cost control report, check that the primary cost stays on each cost center and that the secondary cost lines net to zero in total.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cost rollup policiesOne secondary cost element per auxiliary cost center (for example SC-CC001 for HR), mapped to that cost center in the rollup rulesWith a rollup policy and secondary cost elements, each cost object keeps its primary cost for reporting, and you can trace how cost flows between cost centers. Without one, auxiliary cost objects end at zero for every primary cost element and the flow can't be traced.Should cost allocation use a cost rollup policy with secondary cost elements?Create the secondary cost elements and add them to the cost element hierarchy used for reporting and policies (for example a Secondary cost node). If you don't, the rollup amounts don't appear where you expect them in reports.Test: Rollup keeps primary cost visible

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 policies. 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: Learn states that you can change the configuration if reporting requirements change. Rollup rules change only how allocated balances are labelled and traced, not the allocation, and the change appears in the next overhead calculation. Microsoft Learn
If you change it laterRollup rules change only how allocated balances are labelled and traced, not the allocation amounts, and they can be revised independently of the allocation policies when reporting needs change. Microsoft Learn
Technical architect

6Technical

Menu itemCAMCostRollupRule Checked in Dynamics 365
FormCAMCostRollupRule Checked in Dynamics 365
TableCAMDataCostRollupPolicyShown as “COST ROLLUP POLICIES” in Record infoChecked in Dynamics 365
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyMaintain cost accounting policiesCAMCostAccountingPoliciesMaintain
      • PrivilegeMaintain cost rollup policiesCAMCostRollupPolicyMaintain
    • DutyMaintain cost accounting rulesCAMCostAccountingRulesMaintain
      • PrivilegeMaintain cost rollup rule detailsCAMCostRollupRuleMaintain
      • PrivilegeView cost rollup rule detailsCAMCostRollupRuleView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyInquire into cost accounting policiesCAMCostAccountingPoliciesInquire
      • PrivilegeView cost rollup rule detailsCAMCostRollupRuleView
    • DutyMaintain cost accounting rulesCAMCostAccountingRulesMaintain
      • PrivilegeMaintain cost rollup rule detailsCAMCostRollupRuleMaintain
      • PrivilegeView cost rollup rule detailsCAMCostRollupRuleView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into cost accounting policiesCAMCostAccountingPoliciesInquire
      • PrivilegeView cost rollup rule detailsCAMCostRollupRuleView
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain cost accounting policies CAMCostAccountingPoliciesMaintainMaintain cost accounting rules CAMCostAccountingRulesMaintainTo use itInquire into cost accounting policies CAMCostAccountingPoliciesInquireGive people a role that holds these duties. On this system, 3 roles give access to this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Policy assignments for cost control unitChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMCostRollupRule
Data migrationLoad order: A cost rollup policy has no data entity in Data management, so it can't be loaded from a file or a configuration template. Re-create the policy and its rules by hand in each environment after the hierarchies and allocation bases exist, and assign it to the cost control unit.Microsoft Learn
Everyone

8Sources