BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Data connector statistical measures

An inquiry page that shows the statistical measures an external system instance has sent through the Dynamics AX data connector, per statistical measure configuration and period.

Used by
Cost accountant, Cost accounting manager
Business process
Process statistical measures for cost accounting in Dynamics 365 Finance
Menu item
CAMDataConnectorStatisticalMeasure
Main table
CAMDataDataConnectorStatisticalMeasure
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 shows the statistical measures an external system instance has sent through the Dynamics AX data connector, per statistical measure configuration and period.
What you do hereUse this page to check the nonmonetary measures from a Dynamics AX system, such as headcount per cost center, before they become statistical entries.
ExampleFor example, you check that the subsidiary's headcount configuration sent a magnitude for every cost center for October before the overhead calculation uses it to allocate HR cost.
Data connector statistical measures 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

Transferred measures cover every cost object

Check statistical measures that an external system instance sent through the Dynamics AX data connector.

Steps from Microsoft

  1. Go to Cost accounting > Imported data > Data connector > Data connector statistical measures.
  2. Filter on the System instance and the period start date.
  3. Check the Magnitude per configuration and cost object.
  4. Select a row to see its cost object dimensions in the lower grid.
  5. Process the statistical measures for the period on the cost accounting ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Statistical measure configurationThe configuration on the system instance that defines the measure.Checked in Dynamics 365
Period start date / Period end dateThe fiscal period the measure belongs to.Checked in Dynamics 365
Start date / End dateThe dates the measured activity covers.Checked in Dynamics 365
MagnitudeThe measured quantity, such as a count or a sum.Microsoft Learn
System instanceThe external system instance that sent the measure.Microsoft Learn
Cost object dimensions (lower grid)The cost object the selected measure belongs to.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The page is emptyOnly the Dynamics AX data connector fills this page. Data from this Dynamics 365 Finance system goes straight into the cost accounting ledger when you process the source data, and is checked in Journals. 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

Test checklist

  1. Run a transfer from the system instance.
  2. Check the transfer on Data connector data transfers.
  3. Filter this page on the system instance and the period.
  4. Process the source data and compare with the resulting entries.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Transferred measures cover every cost objectFilter on the System instance and the period, and compare the totals with the source system before you process the period.These rows become cost or statistical entries only when processed, so this is the last place to catch missing or doubled data from the external system.Is the external measures data checked before processing?Expecting this page to show data from this Dynamics 365 Finance system: the built-in connector doesn't stage data here.Test: Transferred measures cover every cost object

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 transferred data. 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 page changes no data; transfer and process again to replace the figures. Microsoft Learn
If you change it laterThese rows are a copy of what the external system sent. They reach cost or statistical entries only when the source data is processed, and changes in the external system need a new transfer. Microsoft Learn
Technical architect

6Technical

Menu itemCAMDataConnectorStatisticalMeasure Checked in Dynamics 365
FormCAMDataConnectorStatisticalMeasure Checked in Dynamics 365
TableCAMDataDataConnectorStatisticalMeasureShown as “DATA CONNECTOR STATISTICAL MEASURES” in Record infoKey field: DataConnectorSystemInstance_Name, DataConnectorStatisticalMeasureConfiguration_CAMDataDataConnectorSystemInstance_Name, DataConnectorStatisticalMeasureConfiguration_NameChecked in Dynamics 365
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyView data connector source entriesCAMDataConnectorSourceEntriesInquire
      • PrivilegeView data connector statistical measuresCAMDataConnectorStatisticalMeasureView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyView data connector source entriesCAMDataConnectorSourceEntriesInquire
      • PrivilegeView data connector statistical measuresCAMDataConnectorStatisticalMeasureView
Checked in Dynamics 365
Roles to set it up and use itTo use itView data connector source entries CAMDataConnectorSourceEntriesInquireGive people a role that holds these duties. On this system, 2 roles give access to this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMDataConnectorStatisticalMeasure
Data migrationLoad order: Transferred statistical measures has no data entity in Data management, so it can't be loaded from a file or a configuration template. The rows come from the connector; run the transfer again in the new environment.Microsoft Learn
Everyone

8Sources