BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Cost distribution policies

A setup page where you create cost distribution policies and rules that move costs recorded on a collective cost object to other cost objects, at the level of the original primary cost element, using an allocation base.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Define costing policies
Menu item
CAMCostDistributionRule
Main table
CAMDataCostDistributionPolicy
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 distribution policies and rules that move costs recorded on a collective cost object to other cost objects, at the level of the original primary cost element, using an allocation base.
What you do hereUse this page to define, per cost object node, cost element node and cost behavior, which allocation base distributes a lump-sum cost to the cost objects that actually consumed it, and to assign the policy to a cost control unit from a given date. The rules run in step 2 of the overhead calculation.
ExampleFor example, electricity posted as one amount on a default cost center is distributed to HR, Finance and Assembly in proportion to the kWh each consumed.
Cost distribution 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 distribution policies

Use this page to define, per cost object node, cost element node and cost behavior, which allocation base distributes a lump-sum cost to the cost objects that actually consumed it, and to assign the policy to a cost control unit from a given date. The rules run in step 2 of the overhead calculation.

Steps from Microsoft

  1. Go to Cost accounting > Policies > Cost distribution policies.
  2. Select New, type a Policy name and a Description.
  3. Select the Cost object dimension hierarchy, the Cost element dimension hierarchy and the Statistical dimension, then select Save.
  4. Select New in the rules list; pick the Cost object dimension hierarchy node and the Cost element dimension hierarchy node (for example 605150 Rent).
  5. Select the Cost behavior (for example Fixed cost) and the Allocation base, and repeat for each rule.
  6. Select Policy assignments for cost control unit, then select New.
  7. Enter the Valid from accounting date and select the Cost control unit.
  8. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Policy nameThe name of the cost distribution 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, for example Organization.Microsoft Learn DistributionCostObjectDimensionHierarchy
Cost element dimension hierarchyThe cost element hierarchy whose nodes the rules refer to.Microsoft Learn DistributionCostElementDimensionHierarchy
Statistical dimensionThe statistical dimension whose members may be used as allocation bases in the rules.Microsoft Learn DistributionStatisticalDimension
Cost object dimension hierarchy nodeIn a rule, the cost object (typically the collective cost center) whose cost is distributed.Microsoft Learn
Cost behaviorIn a rule, whether the Fixed cost, Variable cost or other classification of the cost is distributed.Microsoft Learn
Allocation baseIn a rule, the predefined, hierarchy or formula allocation base that sets the distribution ratio.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 a policy with the Organization cost object hierarchy, a cost element hierarchy and the statistical dimension.
  2. Add a rule for the collective cost center and the electricity cost element with Cost behavior Variable cost and allocation base Electricity.
  3. Assign the policy to the cost control unit with a Valid from accounting date.
  4. Run the overhead calculation and open the Cost distribution calculation journal.
  5. Check that the collective cost center is credited and that the receiving cost centers are charged in proportion to their kWh, on the same primary cost element.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cost distribution policiesDistribute lump-sum costs posted to a collective cost object with the measure that reflects consumption: for example the Electricity statistical member (kWh) for Variable cost, and a formula base for the Fixed cost portionCost distribution moves cost from one cost object to others by a relevant allocation base, keeping the original primary cost element. Learn's electricity example splits variable cost by kWh and the fixed fee evenly among consumers.Should a lump-sum cost be distributed, and on which base?Distribution always stays at the primary cost element and involves no reciprocal processing. Don't use it to pass a service cost center's whole balance to other cost centers. That's what cost allocation policies are for.Test: Electricity distributed by kWh

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: Change or expire rules at any time and rerun the overhead calculation for the period. Earlier calculation versions are kept, so you can compare them. Microsoft Learn
If you change it laterChanging a policy or its rules does not alter past results; you rerun the overhead calculation for the period, and each run is stored under its own version ID so results can be compared. Microsoft Learn
Technical architect

6Technical

Menu itemCAMCostDistributionRule Checked in Dynamics 365
FormCAMCostDistributionRule Checked in Dynamics 365
TableCAMDataCostDistributionPolicyShown as “COST DISTRIBUTION 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 distribution policiesCAMCostDistributionPolicyMaintain
    • DutyMaintain cost accounting rulesCAMCostAccountingRulesMaintain
      • PrivilegeMaintain cost distribution rule detailsCAMCostDistributionRuleMaintain
      • PrivilegeView cost distribution rule detailsCAMCostDistributionRuleView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyInquire into cost accounting policiesCAMCostAccountingPoliciesInquire
      • PrivilegeView cost distribution rule detailsCAMCostDistributionRuleView
    • DutyMaintain cost accounting rulesCAMCostAccountingRulesMaintain
      • PrivilegeMaintain cost distribution rule detailsCAMCostDistributionRuleMaintain
      • PrivilegeView cost distribution rule detailsCAMCostDistributionRuleView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into cost accounting policiesCAMCostAccountingPoliciesInquire
      • PrivilegeView cost distribution rule detailsCAMCostDistributionRuleView
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=CAMCostDistributionRule
Data migrationLoad order: A cost distribution 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