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
- Open Import Export PowerTool and set the Operation to Update.
- Enter the table ID, the field, and the new field value.
- Build the update filter that selects the records.
- Choose whether to run the OnModify trigger and validate the field.
- 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.
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 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.
