Learn how data management works in Microsoft Dynamics 365 for Finance and Operations by following the below guidelines for importing and exporting data, batching large files and troubleshooting error messages. Also read some helpful tips for loading data through LCS (lifecycle services) configuration and data manager.
How does Data Management work in Dynamics 365 for Finance & Operations?
Data Management Workspace
- Use file format created by exporting an entity or group of entities
- Check which fields are mandatory by checking the mapping of the entity
- Remove non-essential columns from import file to reduce potential for errors during upload
- Recommended for creating the blank or sample data packages/files for import
- Exports can be filtered to include specific data
- Create Templates to group together dependent import forms
- Select an Entity to see which other entities it is dependent upon
Configure Data Source
- Several standard data sources are set up – excel, CSV, xml, etc.
- Additional data sources can be set up if required (useful for linking to external databases for recurring imports/exports)
Configure Entity Export to Database
- Used for publishing data to an external database for things like BI tools
- List of available entities:
- Entities contain fields that can be filled in for importing information
- There are hundreds of entities but they don’t cover 100% of all tables of all modules. Some may need to be created.
- What happens when an entity doesn’t exist out-of-the-box? Developers can create a custom entity or combination of entities using Visual Studios.
- Includes Staging table and Target entity information
- Data management settings
- Clean up job history
Set up Roles for Data Projects
- Security to allow/deny access to certain data projects
Batching Large File Imports and Exports
- Very Large Imports can be set to Import or Export in a Batch
- The order of loading data packages is important due to dependencies within the file.
Parameter, reference, master, document, transaction
- Data packages will fail if setup information is missing.
- Templates section enables you to easily check an entity to see which information it is dependent upon. For example, bank accounts require a currency. Currencies need to be set up before bank accounts can be fully set up.
- After importing an Excel file, make sure that data management is closed before reopening the Excel file or it may become corrupted and unusable.
- Recommend ‘save-as’ new file name before importing to preserve the import file.
- When importing open customer invoices, we previously ran into an issue where extra ‘remit-to’ addresses were created for each customer. Hundreds of extra addresses were created.
- To find which entity belongs to a form, right click on the form to get the form name
Troubleshooting Error Messages
- Most errors will be due to invalid data in the import file or missing setup information
- View staging data
- Some errors can be corrected in here and uploaded
- View execution log
- Staging log details
- View error file
Loading Data Through LCS Configuration & Data Manager
Microsoft recommends, but does not require, that users load data through LCS
- If data is loaded through LCS, and there are issues, it is easier for Microsoft to support.
- It makes it easier to deploy the same packages to multiple environments.
- It’s useful if there is more than one person loading packages.
- Complete upload history is in one place for easy review.
How Much Does Dynamics AX Cost?
And more importantly, what is the ROI on an implementation? Forrester research just completed a study outlining the Total Economic Impact of Microsoft Dynamics AX 2012!Get The Dynamics AX ROI Report Now