BeyondERP.Newsletter
Menu

Setup step on the Cost element dimensions page · Cost accounting

Set up Cost element dimensions

Use this page to create a cost element dimension, configure its dimension member provider (for example a range of main accounts from the shared chart of accounts), import the members, and view the imported cost elements.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Define costing policies
Menu item
CAMCostElementDimension
Main table
CAMDataDimension
Data entity
CAMImportedCostElementDimensionMemberEntity
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 create cost element dimensions, each with a data connector that imports its members (typically main accounts from a chart of accounts) as the cost elements that costs flow to.
What you do hereUse this page to create a cost element dimension, configure its dimension member provider (for example a range of main accounts from the shared chart of accounts), import the members, and view the imported cost elements.
ExampleFor example, you use the US chart of accounts as the cost element dimension so that its profit and loss accounts become the cost element dimension members.
Cost element dimensions 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 element dimensions

Use this page to create a cost element dimension, configure its dimension member provider (for example a range of main accounts from the shared chart of accounts), import the members, and view the imported cost elements.

Steps from Microsoft

  1. Go to Cost accounting > Dimensions > Cost element dimensions.
  2. Select New.
  3. Enter a name in the Name field.
  4. Enter or select a value in the Data connector for dimension members field, enter a Description, and select Save.
  5. Select Configure dimension member provider, select the Chart of accounts (Shared for the shared chart of accounts), select New and enter the From main account and To main account range, then select OK.
  6. Select Import dimension members and then OK.
  7. Select View dimension members to see the imported accounts as cost elements.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameThe name of the cost element dimension.Microsoft Learn Name
Data connector for dimension membersThe connector that supplies the dimension members, for example main accounts from Dynamics 365 Finance.Microsoft Learn
DescriptionA description of the dimension.Microsoft Learn Description
Chart of accounts (Configure dimension member provider)The chart of accounts the main accounts are read from; Shared uses the shared chart of accounts.Microsoft Learn
From main account / To main accountThe range of main accounts to import as cost elements; filters can be applied to the accounts.Microsoft Learn
Import dimension members (button)Imports the main accounts into Cost accounting as cost elements.Microsoft Learn
View dimension members (button)Shows the imported ledger accounts as cost elements.Microsoft Learn

Common errors and fixes

MessageWhat to do
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
Costs from some main accounts don't reach Cost accountingMain accounts outside the dimension member provider's range aren't cost elements. Widen the range and import the dimension members again. Microsoft Learn

Test checklist

  1. Create a cost element dimension with a data connector for dimension members.
  2. Select Configure dimension member provider, choose the Shared chart of accounts and a From main account / To main account range.
  3. Select Import dimension members.
  4. Select View dimension members and check every expected main account is listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cost element dimensionsUse the chart of accounts as the cost element dimension, importing the main accounts needed for managerial reporting through the Dynamics 365 Finance data connector; manage cost control on grouped elements rather than thousands of single onesPrimary cost elements correspond to main accounts, and cost elements are the lowest level of cost detail. Microsoft notes that thousands of cost elements are hard to control and suggests grouping them.Which main accounts should become cost elements?Leaving out accounts needed for managerial reporting: cost elements set the lowest level of detail available, so missing accounts can't be reported or used in policies.Test: Profit and loss accounts become cost elements

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 dimensions. 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 undoneHard to reverse: Policies, hierarchies and processed entries refer to the cost elements, so settle the account range before you build them. More members can be added by importing again.
If you change it laterThe cost elements you import set the lowest level of cost detail available for reporting and policies, so leaving accounts out limits managerial reporting, while importing thousands makes individual control hard and calls for grouping. Microsoft Learn
Technical architect

6Technical

Menu itemCAMCostElementDimension Checked in Dynamics 365
FormCAMDimension Checked in Dynamics 365
TableCAMDataDimensionShown as “DIMENSIONS” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesCAMImportedCostElementDimensionMemberEntityImported cost element dimension members Microsoft data model
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyMaintain dimension membersCAMDimensionMembersMaintain
      • PrivilegeView dimension detailsCAMDimensionView
    • DutyMaintain dimensionsCAMDimensionsMaintain
      • PrivilegeMaintain dimension detailsCAMDimensionMaintain
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyMaintain dimension membersCAMDimensionMembersMaintain
      • PrivilegeView dimension detailsCAMDimensionView
    • DutyInquire into dimensionsCAMDimensionsInquire
      • PrivilegeView dimension detailsCAMDimensionView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into dimensionsCAMDimensionsInquire
      • PrivilegeView dimension detailsCAMDimensionView
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain dimension members CAMDimensionMembersMaintainMaintain dimensions CAMDimensionsMaintainTo use itInquire into dimensions CAMDimensionsInquireGive 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): Import dimension members, View dimension members, Configure data source, Configure data provider, Dimension mappingsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMCostElementDimension
Integrate withCAMImportedCostElementDimensionMemberEntity data entity Microsoft data model
Data migrationCAMImportedCostElementDimensionMemberEntity (Imported cost element dimension members): loads cost element members for a dimension whose data connector is Imported transactions; shared by all companies.Load order: Not part of Microsoft's default configuration templates. Load the dimension members first (cost element, cost object, statistical), then the general ledger entries, budget entries and statistical measures that refer to them, and then process the source data on the cost accounting ledger.Load first: the cost element dimension, created on this pageMicrosoft Learn
Everyone

8Sources