BeyondERP.Newsletter
Menu

Setup step on the Imported statistical measures page · Cost accounting

Import measured quantities from a file

Load statistical measures from another system through the Imported transactions data connector.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Process statistical measures for cost accounting in Dynamics 365 Finance
Menu item
CAMImportedStatisticalMeasure
Main table
CAMDataImportedStatisticalMeasure
Data entity
CAMImportedStatisticalMeasureEntity
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 staging page that shows the statistical measures (source identifier, accounting date, magnitude and up to five dimension member names) loaded through Data management with the Imported statistical measures data entity, ready for the Imported statistical measures data connector.
What you do hereUse this page to review nonmonetary measures loaded from a file, such as metered electricity consumption per cost center, before a data provider processes them into statistical entries for a cost accounting ledger.
ExampleFor example, electricity consumption recorded in Excel as 2,450.00 for CC001, 4,100.00 for CC002 and 15,000.00 for CC003 with source identifier Electricity is imported here and then matched to the Electricity statistical dimension member.
Imported 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

Import measured quantities from a file

Load statistical measures from another system through the Imported transactions data connector.

Steps from Microsoft

  1. Go to System administration > Workspaces > Data management and create an import project.
  2. Add the Imported statistical measures entity with your file, map the columns and import.
  3. Go to Cost accounting > Imported data > Data entity > Imported statistical measures and check the rows, filtering on the source identifier.
  4. On the cost accounting ledger, open Actual versions > Manage > Statistical measures and add a data source with the Imported statistical measures connector and the statistical dimension member.
  5. In the data provider configuration enter the import source identifier, the function Sum and the cost object dimensions to match, then process the period and check Statistical entries.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Source identifierIdentifier of the measure in the source (for example Electricity); the data provider configuration matches it to a statistical dimension member.Microsoft Learn
Accounting dateThe date the measure is accounted for.Microsoft Learn AccountingDate
MagnitudeThe nonmonetary quantity, such as kWh consumed.Microsoft Learn Magnitude
Dimension member name1The first cost object dimension member value the measure belongs to (for example a cost center).Microsoft Learn
Dimension member name2A second cost object dimension member value, when used.Microsoft Learn
Dimension member name5Up to five dimension member values are allowed per entry.Microsoft Learn

Common errors and fixes

MessageWhat to do
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
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

Test checklist

  1. Load Electricity kWh per cost center with source identifier Electricity.
  2. Set up the Statistical measures data source with the Imported statistical measures connector, function Sum and the Cost centers dimension.
  3. Process the period and open Statistical entries.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Import measured quantities from a fileLoad measures per period with the source identifier used in the data provider configuration and the cost object dimension member names in Dimension member name1 to name5.The data provider configuration names which cost object dimensions to match; rows are matched to cost objects by those member names.Should statistical measures be loaded from files or come from a connector?Leaving the cost object dimensions out of the data provider configuration, so the rows aren't matched and no statistical entries are created.Test: Import measured quantities from a file end to end

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 load and check imported data. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: Data management lists the entity as shared by all companies, so the rows aren't tied to one legal entity. Checked in Dynamics 365
Can it be undoneReversible: A corrected file can be imported again; process the source data again to replace the entries.
If you change it laterImported measures are kept in a Cost accounting staging table that all cost accounting ledgers can use, so a reload affects every ledger that reads from it; the data provider must name which cost object dimensions to match against the imported rows. Microsoft Learn
Technical architect

6Technical

Menu itemCAMImportedStatisticalMeasure Checked in Dynamics 365
FormCAMImportedStatisticalMeasure Checked in Dynamics 365
TableCAMDataImportedStatisticalMeasureShown as “IMPORTED STATISTICAL MEASURES” in Record infoChecked in Dynamics 365
Data entitiesCAMImportedStatisticalMeasureEntityImported statistical measures Microsoft data model
Who can open it

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

  • RoleCost accountantCAMCostAccountant
    • DutyInquire into imported source entriesCAMImportedSourceEntriesInquire
      • PrivilegeView the imported statistical measuresCAMImportedStatisticalMeasureEntityView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyImport imported source entriesCAMImportedSourceEntriesImport
      • PrivilegeImport the imported statistical measuresCAMImportedStatisticalMeasureEntityImport
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into imported source entriesCAMImportedSourceEntriesInquire
      • PrivilegeView the imported statistical measuresCAMImportedStatisticalMeasureEntityView
Checked in Dynamics 365
Roles to set it up and use itTo use itInquire into imported source entries CAMImportedSourceEntriesInquireGive people a role that holds these duties. On this system, 3 roles give access to this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMImportedStatisticalMeasure
Integrate withCAMImportedStatisticalMeasureEntity data entity Microsoft data model
Data migrationCAMImportedStatisticalMeasureEntity (Imported statistical measures): shared by all companies; Data management lists it as enabled in the Cost accounting module.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 matching Imported dimension members, loaded firstMicrosoft Learn
Everyone

8Sources

To cite this step: CA-IMP-060, Import measured quantities from a file. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CA-IMP-060