Skip to content
Import Export PowerTool app iconImport Export PowerToolUpdate and delete

Update Records for Microsoft Dynamics 365 Business Central

A bad value on hundreds of records, or a single broken record a page will not let you edit, usually means exporting, editing, and reimporting, or asking a developer for a fix. Import Export PowerTool applies a value to one field across a filtered set of records in a single operation. This is a completely free app from Insight Works for Business Central.

How Update records works in Import Export PowerTool

  1. Open Import Export PowerTool and set the Operation to Update.
  2. Enter the table ID, the field, and the new field value.
  3. Build the update filter that selects the records.
  4. Choose whether to run the OnModify trigger and validate the field.
  5. Preview the affected records, then run the update and confirm it.

Key capabilities

Table, field, value, filter

Set the Operation to Update, enter the table ID and field, type the new value, and build the filter that selects the records to change.

Business logic on or off

Run OnModify Trigger and Validate Field Data are switches, so the update can run Business Central logic or write the value directly.

Fix data without an extension

Updates can reach fields Business Central marks non-editable and tables with no page of their own, which is a practical route to fixing a bad entry without writing an extension. See Protected Tables.

Check first

Preview the records the filter selects before the update runs.

Confirmation and access

The setup page decides who can run updates and whether an enhanced confirmation is required.

Change log option

A Disable Change Log switch keeps a bulk update from writing an entry for every record.

See Update records on screen

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

Details that matter on the floor

A search and replace for data

The update is a filtered search and replace on one field, for example setting the quantity to ship to zero on a set of sales lines.

Your permissions still apply

An update can only change tables the user is already allowed to change in Business Central.

Think about dependent data

Changing a value that other records depend on can leave data inconsistent. Preview the records and understand the dependencies first.

Who uses Update records

Business Central consultants

Fix bad values and broken records directly, without an export and reimport.

Business Central administrators

Correct a field across many records after a setup change.

Questions about Update records

How do I update a field on many records at once in Business Central?

With Import Export PowerTool, set the Operation to Update, choose the table and field, enter the new value, and filter the records. The value is applied to every record the filter selects.

Can I update a field that Business Central does not let me edit?

Yes, when protected table access is granted on the setup page. Updates can reach non-editable fields and tables with no page.

Can the update run Business Central validation?

Yes. Turn on Validate Field Data and, if needed, Run OnModify Trigger.

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 Update records?

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