BeyondERP.Newsletter
Menu

Inquiry page · Cost accounting

Statistical entries

An inquiry page that lists the nonmonetary statistical entries in a cost accounting ledger, showing for each cost object and statistical dimension member the accounting date and the magnitude (for example a head count or kilowatt hours).

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Process statistical measures for cost accounting in Dynamics 365 Finance
Menu item
CAMCostObjectStatisticalEntry
Main table
CAMDataCostObjectStatisticalEntry
Data entity
CAMAggregatedStatisticalEntryWithHierarchiesEntity
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 isAn inquiry page that lists the nonmonetary statistical entries in a cost accounting ledger, showing for each cost object and statistical dimension member the accounting date and the magnitude (for example a head count or kilowatt hours).
What you do hereUse this page to review the nonmonetary measures that source data processing has registered per cost object, which policies use as allocation bases and which can be reported as consumption.
ExampleFor example, after electricity consumption is imported and processed, the page shows 2,450.00 kWh on cost center CC001, 4,100.00 on CC002 and 15,000.00 on CC003 for the Electricity statistical dimension member.
Statistical entries 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

Check statistical magnitudes before allocation

Confirm the magnitudes per cost object that allocation bases will use.

Steps from Microsoft

  1. Go to Cost accounting > Inquiries and reports > Statistical entries.
  2. Select the Version to show.
  3. Use the Filter box to find an entry.
  4. Review the Cost object, Accounting date, Magnitude, Statistical dimension member and Version columns.
  5. Select Trace rule or Journal entry on the Action Pane to see where a selected entry came from.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Cost objectThe cost object (for example a cost center or product group) the measure is registered on.Microsoft Learn CostObject
Accounting dateThe date the measure is accounted for in the cost accounting ledger.Microsoft Learn AccountingDate
Statistical dimension memberThe statistical element being measured, such as FTEs or Electricity.Microsoft Learn StatisticalDimensionMember
MagnitudeThe nonmonetary quantity registered (a count or a sum).Microsoft Learn Magnitude

Common errors and fixes

MessageWhat to do
Imported statistical measures create no statistical entriesIn the data provider configuration, enter the import source identifier and name the cost object dimensions to match against the imported rows, then process the source data again. Microsoft Learn
Statistical dimension members can't be brought in through the Dynamics 365 Finance data connectorStatistical dimension members can only come from the Imported transactions data connector. Enter them by hand or load them with the Imported statistical dimension members entity. Microsoft Learn

Test checklist

  1. Process the statistical measures for one period.
  2. Filter on the member, for example Electricity, and the period.
  3. Compare the magnitude per cost object with the source file or table.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check statistical magnitudes before allocationFilter on the statistical dimension member and the period, and check the magnitudes before you run the overhead calculation.Distribution and allocation rules divide cost in proportion to these magnitudes, so a missing or doubled measure moves cost to the wrong cost objects.Who checks statistical magnitudes before each overhead calculation?Reading a missing cost object as zero consumption when its measure wasn't matched: imported measures need the cost object dimensions named in the data provider configuration.Test: Imported kWh appear per cost center

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 accountant clerks read statistical entries. 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: The inquiry changes no data. Correct a measure at its source and process it again. Microsoft Learn
If you change it laterStatistical entries are the magnitudes that allocation bases use. Processing new measures changes the allocation factors of every rule that uses the member at the next overhead calculation. Microsoft Learn
Technical architect

6Technical

Menu itemCAMCostObjectStatisticalEntry Checked in Dynamics 365
FormCAMCostObjectStatisticalEntry Checked in Dynamics 365
TableCAMDataCostObjectStatisticalEntryShown as “STATISTICAL ENTRIES” in Record infoChecked in Dynamics 365
Data entitiesCAMAggregatedStatisticalEntryWithHierarchiesEntityAggregated statistical entries with dimension hierarchies Microsoft data model CAMAggregatedStatisticalEntryWithDefaultCostObjectHierarchyEntityAggregated statistical entries with the default cost object hierarchy Microsoft data model
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyInquire into cost object entriesCAMCostObjectEntriesInquire
      • PrivilegeView cost object entry detailsCAMCostObjectEntryView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyInquire into cost object entriesCAMCostObjectEntriesInquire
      • PrivilegeView cost object entry detailsCAMCostObjectEntryView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into cost object entriesCAMCostObjectEntriesInquire
      • PrivilegeView cost object entry detailsCAMCostObjectEntryView
Checked in Dynamics 365
Roles to set it up and use itTo use itInquire into cost object entries CAMCostObjectEntriesInquireGive 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): Trace rule, Journal entryChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMCostObjectStatisticalEntry
Integrate withCAMAggregatedStatisticalEntryWithHierarchiesEntity data entity Microsoft data model
Data migrationLoad order: A statistical entry has no data entity in Data management, so it can't be loaded from a file or a configuration template. Statistical entries are created by processing, so process the measures again in the new environment.Microsoft Learn
Everyone

8Sources