Skip to content
Import Export PowerTool app iconImport Export PowerToolImport

Missing Fields and Tables for Microsoft Dynamics 365 Business Central

A file from an older system or another Business Central environment often includes custom fields and tables that the target does not have, and a strict import fails on the first one it cannot find. Import Export PowerTool can prompt you about fields and tables that do not exist in the target environment, or skip them silently. This is a completely free app from Insight Works for Business Central.

How Missing fields and tables works in Import Export PowerTool

  1. Export or prepare the file from the source system or environment.
  2. In Import Export PowerTool, set the Operation to Import and choose whether missing fields and tables are prompted for or ignored.
  3. Run the import.
  4. Review any prompts, or check afterward that the expected core fields loaded.

Key capabilities

Prompt

With prompting on, Import Export PowerTool asks about each field or table it cannot find, so you see exactly what will be left out.

Skip silently

With ignoring on, unrecognized fields and tables are skipped without a question, which suits a file you already know carries extra columns.

Legacy imports

A table full of custom fields from an older system can be imported straight in. The fields that exist in the target land correctly and the rest are skipped.

Moves between environments

The same setting helps when exporting from one environment and importing into another whose extensions differ, such as a sandbox with extra fields.

Details that matter on the floor

No need to trim the file first

Because missing fields can be skipped, a legacy export can be imported without first deleting columns the target does not have.

Prompt the first time

Prompting on a first run shows which fields are being dropped; ignoring them suits later runs of the same file.

Who uses Missing fields and tables

Data migration specialists

Import legacy data that carries custom fields the new environment does not have.

Developers

Move data between environments with different extensions installed.

Questions about Missing fields and tables

What happens if my import file has fields Business Central does not have?

Import Export PowerTool can prompt you about each missing field or skip it silently, depending on the option you choose, and the fields that exist still import.

Does this also apply to whole tables?

Yes. Tables that do not exist in the target environment can be prompted for or ignored the same way.

Can I import data from an older system that has custom fields?

Yes. Choose to ignore missing fields, and the columns the target lacks are skipped while the core data loads.

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 Missing fields and tables?

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