Skip to content
Import Export PowerTool app iconImport Export PowerToolImport

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

  1. Export the records and their dimensions from the source company or environment.
  2. Review or adjust the dimension values in the text file.
  3. Import the file into the target with Import Export PowerTool.
  4. 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.

Import Export PowerTool app icon

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.

Ask a product question

Product Questions