BeyondERP.Newsletter
Menu

Inquiry page · Cost accounting

Data connector data transfers

An inquiry page that lists each data transfer an external system instance has made into Cost accounting through the Dynamics AX data connector, with the expected and transferred number of records and the status.

Used by
Cost accountant, Cost accounting manager
Business process
Record cost accounting transactions
Menu item
CAMDataConnectorDataTransfer
Main table
CAMDataDataConnectorDataTransfer
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 each data transfer an external system instance has made into Cost accounting through the Dynamics AX data connector, with the expected and transferred number of records and the status.
What you do hereUse this page to check that a transfer from a registered system instance has finished and brought in every record before you process the source data for the period.
ExampleFor example, a transfer from the subsidiary's Dynamics AX system shows 1,200 expected and 1,180 transferred records, so you rerun it before processing the period instead of reporting incomplete costs.
Data connector data transfers 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

Confirm an external transfer is complete

Check a Dynamics AX data connector transfer before its data is processed.

Steps from Microsoft

  1. Go to Cost accounting > Inquiries and reports > Data connector data transfers.
  2. Filter on the System instance and sort by Created date and time.
  3. Compare Expected number of records with Number of transferred records.
  4. Check the Status of the latest transfer.
  5. Select Transferred records to see the records of the selected transfer.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Created date and timeWhen the transfer ran.Checked in Dynamics 365
System instanceThe external system instance the data came from, as registered on Data connector system instances.Microsoft Learn
DescriptionWhat the transfer carried.Checked in Dynamics 365
Expected number of recordsHow many records the system instance reported for the transfer.Checked in Dynamics 365
Number of transferred recordsHow many records arrived. A lower number than expected means the transfer is incomplete.Checked in Dynamics 365
StatusWhether the transfer has finished.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The page is emptyTransfers are listed only for the Dynamics AX data connector. Data from this system comes through the built-in Dynamics 365 Finance connector and is checked in Journals instead. Checked in Dynamics 365

Test checklist

  1. Run a transfer from the system instance.
  2. Open this page and find the transfer.
  3. Check that the expected and transferred counts match before processing the period.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Confirm an external transfer is completeBefore each period's processing, filter on the system instance and confirm the latest transfer has finished with the expected number of records.Processing an incomplete transfer leaves costs out of the period, and the gap only shows later in the Cost control workspace.When is an external transfer accepted for processing?Looking here for transfers from this Dynamics 365 Finance system: the built-in connector doesn't record transfers on this page.Test: Transfer counts match

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 check transfers. 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. Microsoft Learn
If you change it laterThe page only lists transfers. Data from a transfer reaches cost entries only when the source data is processed on the cost accounting ledger. Microsoft Learn
Technical architect

6Technical

Menu itemCAMDataConnectorDataTransfer Checked in Dynamics 365
FormCAMDataConnectorDataTransfer Checked in Dynamics 365
TableCAMDataDataConnectorDataTransferShown as “DATA CONNECTOR DATA TRANFERS” in Record infoKey field: DataConnectorSystemInstance_Name, SurrogateKeyChecked 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 data transfersCAMDataConnectorDataTransferView
  • RoleCost accounting managerCAMCostAccountingManager
    • DutyView data connector source entriesCAMDataConnectorSourceEntriesInquire
      • PrivilegeView data connector data transfersCAMDataConnectorDataTransferView
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
Actions on the page(Action Pane without tabs): Transferred recordsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CAMDataConnectorDataTransfer
Data migrationLoad order: A data transfer record has no data entity in Data management, so it can't be loaded from a file or a configuration template. Transfers are created by the connector; run the transfer again in the new environment.Microsoft Learn
Everyone

8Sources