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
- Open Import Export PowerTool and set the Operation to Delete.
- Enter the table ID and build the filter.
- Preview the records the filter selects.
- 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.
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 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.