Skip to content
Import Export PowerTool app iconImport Export PowerToolImport

Import Field Validation for Microsoft Dynamics 365 Business Central

When an import writes raw values straight into a table, the defaults and related fields that Business Central fills in during manual entry never appear. Import Export PowerTool lets you mark selected fields in the import file with an asterisk, and it runs Business Central's own validation for those fields during the import. This is a completely free app from Insight Works for Business Central.

How Import field validation works in Import Export PowerTool

  1. Build the import file with the field names in the header row.
  2. Add an asterisk in front of each field that should be validated, for example *Item No. and *Quantity.
  3. In Import Export PowerTool, set the Operation to Import and choose the validation option that validates only the marked fields.
  4. Run the import; Business Central logic runs for the marked fields and fills in the related values.

Key capabilities

Validate the fields a person would type

A practical rule: validate the fields someone would normally enter by hand in Business Central, and let Business Central default the rest.

Fewer columns in the file

Validating an item number on a journal line pulls in fields such as the description and unit of measure, so those columns do not need to be in the file.

Marked in the file itself

The asterisk sits on the field name in the header row, so the validation choice travels with the file and is repeatable.

Errors stop bad data

If a value fails Business Central validation, the import reports the error instead of writing a record that breaks business rules.

See Import field validation on screen

Real screens from Import Export PowerTool, shown with demo data.

Details that matter on the floor

Order of fields matters

Validation runs the same logic as manual entry, so a field that depends on another, such as a quantity that depends on the item, should come after it in the file.

Choose validation deliberately

Validating every field can trigger logic you do not want, such as recalculations that overwrite values in the file. Marking only the fields a person would type keeps the result predictable.

Who uses Import field validation

Business Central consultants

Load journals and documents that behave as if they were entered by hand.

Data migration specialists

Keep import files short by letting Business Central default the dependent fields.

Questions about Import field validation

How do I validate a field during import?

Prefix the field name with an asterisk in the header row of the import file, and choose the option to validate the marked fields when you run the import.

Which fields should I validate?

Validate the fields a person would normally type in Business Central, such as an item number and quantity on a journal line, and let Business Central fill in the rest.

What happens if a validated value is wrong?

Business Central validation raises an error and the import stops, rather than writing a record that breaks business rules.

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 Import field validation?

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