BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Cost accounting ledgers

A setup page where you create cost accounting ledgers, each defined by a cost element dimension, a statistical dimension, a fiscal calendar, an accounting currency and an exchange rate type, and from which you manage the ledger's versions, control units and data sources.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Define costing policies
Menu item
CAMCostAccountingLedger
Main table
CAMDataCostAccountingLedger
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 accounting ledgers, each defined by a cost element dimension, a statistical dimension, a fiscal calendar, an accounting currency and an exchange rate type, and from which you manage the ledger's versions, control units and data sources.
What you do hereUse this page to create the ledger that collects cost and statistical entries from one or more legal entities, then define its control units, set up data sources (general ledger entries, budgets, statistical measures) on the actual and budget versions, and run source data processing.
ExampleFor example, data from legal entities with different local currencies is converted into the ledger's accounting currency using the exchange rate type chosen on the ledger.
Cost accounting ledgers 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 accounting ledgers

Use this page to create the ledger that collects cost and statistical entries from one or more legal entities, then define its control units, set up data sources (general ledger entries, budgets, statistical measures) on the actual and budget versions, and run source data processing.

Steps from Microsoft

  1. Go to Cost accounting > Ledger setup > Cost accounting ledgers.
  2. Click New.
  3. In the Name field, type a value.
  4. In the Cost element dimension field, enter or select a value.
  5. In the Fiscal calendar field, enter or select a value.
  6. In the Accounting currency field and the Exchange rate type field, enter or select values.
  7. In the Statistical dimension field, enter or select a value.
  8. Click Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
NameThe name of the cost accounting ledger.Microsoft Learn LedgerName
Cost element dimensionThe dimension whose members (for example main accounts) are the cost elements the ledger records costs against.Microsoft Learn CostElementDimension
Fiscal calendarThe calendar whose years and periods the ledger uses; its periods appear in the Cost control workspace configuration.Microsoft Learn FiscalCalendar
Accounting currencyThe currency in which all entries in the ledger are stated.Microsoft Learn AccountingCurrencyCode
Exchange rate typeThe exchange rate type used to convert each legal entity's currency to the ledger's accounting currency.Microsoft Learn ExchangeRateType
Statistical dimensionThe dimension whose members hold nonmonetary measures for the ledger; a statistical dimension can serve more than one ledger.Microsoft Learn StatisticalDimension
Control units (button)Opens the cost control units of the ledger, where you pick the cost object dimension whose members become cost objects.Microsoft Learn
Actual versions (button)Opens the ledger's actual version, where Manage sets up data sources and Source data processing runs the import jobs.Microsoft Learn

Common errors and fixes

MessageWhat to do
A number sequence has not been set up for the reference JournalGo to Cost accounting > Setup > Parameters > Number sequences and set a number sequence for the Journal reference, then run the processing again. Checked in Dynamics 365
Corrected source figures don't show in Cost accountingCost accounting keeps its own copy of the source data. Import the data again and process the source data for the period. 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 ledger with Name, Cost element dimension, Fiscal calendar, Accounting currency, Exchange rate type and Statistical dimension, then save it.
  2. Open Actual versions > Manage > General ledger and add a data source with the Dynamics 365 Finance - General ledger entries provider. Configure the legal entity with Posting layer Current.
  3. Run Source data processing > General ledger for one fiscal calendar period.
  4. Open the General ledger entry transfer journal, select a line, and use Cost entries > Source entry to trace the cost entry back to its ledger transaction.
  5. Check that the cost entry amounts are in the ledger's accounting currency.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cost accounting ledgersOne ledger per management reporting unit, with the fiscal calendar, accounting currency and exchange rate type chosen for management reporting, and a shared cost element dimension and statistical dimensionA cost accounting ledger is the overall reporting unit and isn't tied to a legal entity. One legal entity's data can feed several ledgers. Data from each legal entity is converted into the ledger's accounting currency with the ledger's exchange rate type.Should the business use one cost accounting ledger or several?A ledger collects nothing until you add data sources on its versions. For example, on Actual versions > Manage > General ledger, add the Dynamics 365 Finance - General ledger entries provider and configure the legal entity and posting layer. Then run source data processing.Test: General ledger entries flow into the cost accounting ledger

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 set up ledgers. 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: The fiscal calendar, accounting currency and exchange rate type define how every cost and statistical entry in the ledger is dated and converted, and which fiscal periods reports and overhead calculations use. Learn doesn't describe a way to change them once data is processed. Plan them before the first source data processing run. Microsoft Learn
If you change it laterThe ledger's fiscal calendar, accounting currency, exchange rate type and cost element dimension decide how every entry is dated and converted. Policies, versions and reports are built on the ledger, so settle these values before the first processing run. Microsoft Learn
Technical architect

6Technical

Menu itemCAMCostAccountingLedger Checked in Dynamics 365
FormCAMCostAccountingLedger Checked in Dynamics 365
TableCAMDataCostAccountingLedgerShown as “COST ACCOUNTING LEDGERS” in Record infoKey field: LedgerNameChecked in Dynamics 365
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyInquire into all cost object entries in excelCAMAllCostObjectEntriesInExcelInquire
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyInquire into cost accounting ledgersCAMCostAccountingLedgersInquire
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyCalculations performCAMPerformCalculations
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyRefresh entriesCAMRefreshEntries
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyInquire into cost accounting ledgersCAMCostAccountingLedgersInquire
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyRefresh entriesCAMRefreshEntries
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into all cost object entries in excelCAMAllCostObjectEntriesInExcelInquire
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyInquire into cost accounting ledgersCAMCostAccountingLedgersInquire
      • PrivilegeView cost accounting ledger detailsCAMCostAccountingLedgerView
    • DutyMaintain cost accounting ledgersCAMCostAccountingLedgersMaintain
      • PrivilegeMaintain cost accounting ledger detailsCAMCostAccountingLedgerMaintain
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain cost accounting ledgers CAMCostAccountingLedgersMaintainCalculations perform CAMPerformCalculationsRefresh entries CAMRefreshEntriesTo use itInquire into cost accounting ledgers CAMCostAccountingLedgersInquireGive people a role that holds these duties. On this system, 3 roles give access to this page.Checked in Dynamics 365
Actions on the pageView(Action Pane without tabs): Control units, Actual versions, Budget versionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMCostAccountingLedger
Data migrationLoad order: A cost accounting ledger has no data entity in Data management, so it can't be loaded from a file or a configuration template. Set it up by hand or with the Get started wizard in each environment, then process the source data there.Microsoft Learn
Everyone

8Sources