BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Imported general ledger entries

A staging page that shows general ledger entries (amount, accounting date, dimension member names, main account name, debit/credit and source identifier) loaded through Data management with the Imported general ledger entries data entity for the Imported transactions data connector.

Used by
Cost accountant, Cost accountant clerk, Cost accounting manager
Business process
Process general ledger data for cost accounting in Dynamics 365 Finance
Menu item
CAMImportedGeneralLedgerEntry
Main table
CAMDataImportedTransactionEntry
Data entity
CAMImportedGeneralLedgerEntryEntity
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 staging page that shows general ledger entries (amount, accounting date, dimension member names, main account name, debit/credit and source identifier) loaded through Data management with the Imported general ledger entries data entity for the Imported transactions data connector.
What you do hereUse this page to review ledger transactions loaded from an external system before the Imported transactions data connector processes them into cost entries in a cost accounting ledger.
ExampleFor example, a subsidiary that runs a different ERP system can export its monthly expense postings to a file, import them here, and have them processed into the group cost accounting ledger.
Imported general ledger 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

Import ledger entries from a file

Load general ledger entries 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 general ledger entries entity with your file, map the columns and import.
  3. Go to Cost accounting > Imported data > Data entity > Imported general ledger entries and check the rows, filtering on the source identifier.
  4. On the cost accounting ledger, open Actual versions > Manage > General ledger and add a data source with the Imported transactions connector and the same source identifier.
  5. Run Source data processing > General ledger for the period and check the totals on Cost entries.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
AmountThe transaction amount to be transferred as a cost entry.Microsoft Learn
Accounting date (AccountingDate)The date the entry is accounted for; it determines the fiscal period in the cost accounting ledger.Microsoft Learn
Dimension member names (DimensionMemberNames)The cost object dimension member values (for example cost center codes) the entry carries.Microsoft Learn
Main account name (MainAccountName)The main account, which is matched to a cost element dimension member.Microsoft Learn
Debit/credit (DebitCredit)Whether the amount is a debit or a credit.Microsoft Learn
Source identifier (SourceIdentifier)Identifier of the external source that the data provider configuration matches on.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

Test checklist

  1. Load one period of expense postings with source identifier EXT-GL.
  2. Set up a general ledger data source on the ledger's actual version with the Imported transactions connector and EXT-GL.
  3. Run Source data processing > General ledger for the period and open Cost entries.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Import ledger entries from a fileLoad one file per period and source, with main account and dimension member names that match the imported members.Rows are matched to cost elements and cost objects by name when the source data is processed; unmatched rows give no cost entries.Should general ledger entries be loaded from files or come from a connector?Loading a period twice and processing it again, which doubles the costs unless the earlier rows are removed first.Test: Import ledger entries 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: 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 laterIf the source figures change, the file must be imported again and the source data processed again before the cost accounting ledger reflects the change; the staging data is shared by all cost accounting ledgers. Microsoft Learn
Technical architect

6Technical

Menu itemCAMImportedGeneralLedgerEntry Checked in Dynamics 365
FormCAMImportedTransactionEntry Checked in Dynamics 365
TableCAMDataImportedTransactionEntryShown as “IMPORTED TRANSACTION ENTRIES” in Record infoChecked in Dynamics 365
Data entitiesCAMImportedGeneralLedgerEntryEntityImported general ledger entries 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 general ledger entriesCAMImportedGeneralLedgerEntryEntityView
  • RoleCost accountant clerkCAMCostAccountantClerk
    • DutyImport imported source entriesCAMImportedSourceEntriesImport
      • PrivilegeImport the imported general ledger entriesCAMImportedGeneralLedgerEntryEntityImport
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyInquire into imported source entriesCAMImportedSourceEntriesInquire
      • PrivilegeView the imported general ledger entriesCAMImportedGeneralLedgerEntryEntityView
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=CAMImportedGeneralLedgerEntry
Integrate withCAMImportedGeneralLedgerEntryEntity data entity Microsoft data model
Data migrationCAMImportedGeneralLedgerEntryEntity (Imported general ledger entries): 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