You delete items by selecting the Delete operation in the Import Export PowerTool, specifying the Item table, applying a filter that targets only the records you intend to remove, previewing the affected records, and confirming the deletion. This is a completely free app from Insight Works for Business Central. The tool deletes directly from the table, so careful filtering and a preview step are essential before you run it.
Setting up the deletion
Open the tool and choose the Delete operation. Enter the Item table, either by its name or by its table identifier. Then build a filter that scopes the deletion to exactly the items you want gone, for example a range of item numbers or items that share a particular attribute. You can combine multiple filters in the same way you would filter any list in Microsoft Dynamics 365 Business Central. Filtering is the most important safeguard, because without it you would target every record in the table.
Previewing before you delete
The tool lets you preview which records your filter will affect before anything is removed. You can display the data filtered exactly as your criteria specify, which confirms that only the intended items are in scope. For tables that have no corresponding page in Business Central, the tool can also show the raw table data, but for items you will normally see them in a familiar list. Always use this preview to verify the count and the specific records, since the deletion itself is immediate once confirmed.
Confirmation safeguards
Depending on the set up, the tool can require an enhanced confirmation in which you type a confirmation value before the deletion proceeds. It then reports how many records will be deleted and gives you a final chance to stop. Reading that count and comparing it to your preview is a simple but effective check against an overly broad filter.
The on delete trigger and related records
The delete options include an on delete trigger setting that runs the same logic Business Central would run if you deleted the record manually. Leaving this enabled is usually what you want, because deleting an item often needs to remove or update related information, such as item references or units of measure, and the trigger handles that cleanup. With the trigger disabled you may leave related records behind. Keep in mind that Business Central will still prevent deletion where its own rules require it, so an item that has ledger entries or other dependencies may not be removable until those dependencies are addressed, and the tool respects those rules.
Related Tools
Import Export PowerTool is the Insight Works app for fast import, export, update, and delete operations in Business Central. Its Delete operation, filters, preview, and confirmation features are what you use to remove items safely.
Deleting items is straightforward with the tool, but it is also irreversible, so treat it with care. Filter precisely, preview the affected records, keep the on delete trigger enabled to clean up related data, and confirm the reported count before you proceed. Items with existing dependencies may be blocked by Business Central until those are resolved.