Dimension Import and Export for Microsoft Dynamics 365 Business Central
Dimensions are easy to lose in a migration, because they live in separate tables from the documents and master records they describe. Import Export PowerTool imports and exports shortcut dimensions, non-shortcut dimensions, and default dimensions. This is a completely free app from Insight Works for Business Central.
How Dimension import and export works in Import Export PowerTool
- Export the records and their dimensions from the source company or environment.
- Review or adjust the dimension values in the text file.
- Import the file into the target with Import Export PowerTool.
- Check the dimensions on the imported records in Business Central.
Key capabilities
Shortcut and non-shortcut
Dimension values carry across whether or not they are set up as shortcut dimensions, so the full dimension picture moves with the data.
Default dimensions
Default dimensions on records such as customers, vendors, and items can be exported from one environment and imported into another.
With the rest of the load
Dimensions travel with the other tables in a bulk export and bulk import.
Text you can review
Dimension data exports to the same plain text format as other tables, so it can be checked or corrected in a text editor before import.
Details that matter on the floor
Set up the dimensions first
Dimension codes and values need to exist in the target before records that use them are imported.
Who uses Dimension import and export
Business Central consultants
Carry default dimensions across during an implementation.
Finance and data teams
Keep dimension coding consistent when data moves between companies.
Questions about Dimension import and export
Can I import dimensions into Business Central?
Yes. Import Export PowerTool imports and exports shortcut dimensions, non-shortcut dimensions, and default dimensions.
Do default dimensions on customers and items carry across?
Yes. Default dimensions can be exported and imported with Import Export PowerTool.
Can dimensions move in the same export as other tables?
Yes. Dimensions export to the same text file format as other tables, so they can move in the same export and import.
Related Import Export PowerTool features
All Import Export PowerTool features →Part of Import Export PowerTool
Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.
Have a question about Dimension import and export?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.