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

Delete Records for Microsoft Dynamics 365 Business Central

Clearing out test data, duplicate records, or leftover entries one page at a time is slow, and some tables have no page to delete from at all. Import Export PowerTool removes a filtered set of records from a table in one operation. This is a completely free app from Insight Works for Business Central.

How Delete records works in Import Export PowerTool

  1. Open Import Export PowerTool and set the Operation to Delete.
  2. Enter the table ID and build the filter.
  3. Preview the records the filter selects.
  4. Run the delete and complete the confirmation.

Key capabilities

Filter, then delete

Set the Operation to Delete, enter the table ID, and build a filter that selects exactly the records to remove.

Preview first

Preview shows the records the filter selects before anything is deleted.

Controlled access

The setup page sets Delete Access, including an enhanced confirmation the user must type before a delete runs.

Reaches tables without a page

With protected table access, deletes can reach system-protected tables. A documented case is clearing leftover data from a system table that would otherwise block a Business Central upgrade.

Details that matter on the floor

Deletes are permanent

Deleted records are gone. Export the records first if you may need them again.

Mind the dependencies

Deleting records that other records depend on, such as ledger entries with related value or general ledger entries, leaves data in a bad state.

Permissions still apply

A delete can only remove records the user could already delete in Business Central.

Who uses Delete records

Business Central consultants

Clear test data and duplicates during an implementation.

Business Central administrators

Remove leftover data that blocks a task, under controlled access.

Questions about Delete records

How do I delete many records at once in Business Central?

With Import Export PowerTool, set the Operation to Delete, enter the table ID, and filter the records. Preview them, then run the delete.

Can end users delete records with Import Export PowerTool?

Only if a manager allows it. Delete access is set on the setup page, and the app never goes beyond a user's existing Business Central permissions. Import Export PowerTool is built for consultants and administrators rather than everyday users.

Can I undo a delete?

No. Export the records first if you might need them.

Can Import Export PowerTool help with an upgrade blocked by leftover data?

Yes, in a documented case where leftover data in a system table blocks an upgrade, the Delete operation is one of the documented fixes.

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 Delete 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