A staging page that shows the cost object dimension member records (source identifier, member name, member description) loaded through Data management with the Imported cost object dimension members data entity, ready for a dimension that uses the Imported dimension members data connector.
Define cost accounting reporting structure in Dynamics 365 Finance
Menu item
CAMImportedCostObjectDimensionMember
Main table
CAMDataImportedDimensionMember
Data entity
CAMImportedCostObjectDimensionMemberEntity
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 is
A staging page that shows the cost object dimension member records (source identifier, member name, member description) loaded through Data management with the Imported cost object dimension members data entity, ready for a dimension that uses the Imported dimension members data connector.
What you do here
Use this page to review the cost object dimension members imported from a file before you import them into a cost object dimension, and to see which source identifier each member belongs to.
Example
For example, cost centers maintained in an external HR or ERP system can be loaded from a file and imported as cost objects without re-keying them.
The page in Dynamics 365. page title tab to open what to set or check
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 cost objects from a file
Load cost object dimension members from another system through the Imported transactions data connector.
Steps from Microsoft
Go to System administration > Workspaces > Data management and create an import project.
Add the Imported cost object dimension members entity with your file, map the columns and import.
Go to Cost accounting > Imported data > Data entity > Imported cost object dimension members and check the rows, filtering on the source identifier.
Open the cost object dimension, set its data connector to Imported transactions with the same source identifier, and select Import dimension members.
Add the new cost objects to the classification hierarchies, then refresh the setup validation messages.
Identifier of the external source the member came from; the data provider configuration uses it to match imported rows to the dimension.Microsoft Learn
Member name (MemberName)
The dimension member value, such as a main account number or a cost center code.Microsoft Learn
Corrected source figures don't show in Cost accounting
Cost accounting keeps its own copy of the source data. Import the data again and process the source data for the period. Microsoft Learn
Imported members don't appear on the dimension
Set the dimension's data connector to Imported transactions, configure the provider with the same source identifier, and select Import dimension members. Microsoft Learn
Test checklist
Load a file of cost centers with source identifier EXT-CC.
Set the cost object dimension's provider to Imported transactions with EXT-CC.
Select Import dimension members and add the members to the hierarchy.
One source identifier per external system, and member names that match the dimension values in the imported ledger and measure rows.Imported entries and measures are matched to cost objects by these names, so a different spelling leaves an entry without its cost object.
Cost 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.
Shared: 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 undone
Reversible: Rows can be loaded again from a corrected file. Entries already processed stay in the ledger until the data is processed again. Microsoft Learn
If you change it later
Imported rows sit in a Cost accounting staging table shared by every cost accounting ledger, so a change here affects every dimension and ledger that imports members from it. Microsoft Learn
Technical architect
6Technical
Menu item
CAMImportedCostObjectDimensionMemberChecked in Dynamics 365
Form
CAMImportedDimensionMemberChecked in Dynamics 365
Table
CAMDataImportedDimensionMemberShown as “IMPORTED DIMENSION MEMBERS” in Record infoKey field: Name, SourceIdentifierChecked in Dynamics 365
Data entities
CAMImportedCostObjectDimensionMemberEntityImported cost object dimension members Microsoft data model
Who can open it
2 security roles. Select a role to see its duties and privileges.
RoleCost accountantCAMCostAccountant
DutyInquire into imported dimension membersCAMImportedDimensionMembersInquire
PrivilegeView the imported dimension membersCAMImportedDimensionMemberEntityView
DutyInquire into imported dimension membersCAMImportedDimensionMembersInquire
PrivilegeView the imported dimension membersCAMImportedDimensionMemberEntityView
Checked in Dynamics 365
Roles to set it up and use it
To use itInquire into imported dimension members CAMImportedDimensionMembersInquireGive people a role that holds these duties. On this system, 2 roles give access to this page.Checked in Dynamics 365
CAMImportedCostObjectDimensionMemberEntity (Imported cost object dimension members): 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.Microsoft Learn