Reading Time: 3 minutes

There are several times that we need to do a bulk delete of records, most of the time when we test migration data integrity, storage consumption, etc. For that reason, in this post, we read how we can do it this in Dynamics 365 Business Central.

Bulk Delete Customer Table Records Procedure

At the next steps, we can see how easy bulk delete the records from the Customer table.

Step 1. Search For “Configuration Packages”

Type Configuration and select the first result “Configuration Packages”.

Step 2. Create New Configuration Package

In the second step, we have to create a new configuration package, click New and select  +New.

Step 2.1 Config Package Card

In the Config. Package Card we have to fill up some fields. These are CodePackage Name

Click the ellipse button, select the Customer table (ID. 18 | Name Customer) and click OK.

Next, we select DELETE TABLE RECORDS BEFORE PROCESSING and click OK. 

Step 3. Export To Excel

On the 3rd step, we will export an excel file with the Customer table columns and data. To do this we just select Edit from the Application Package we earlier created.

Select PackageExport to Excel.

In the informative message select Yes.

Save the file, by selecting the Save button.

Step 4. Import From Excel

Select Import from Excel to begin the importing procedure.

Select Choose… and select the excel file we edit earlier.

Earlier we saved and edit the excel file in the Windows desktop. The next we should do is to select and open it, by clicking the button Open.

Step 4.1 Proceed To Import

To proceed with the import action we have to select Import.

Step 5. Apply The Package

In the next step select Actions – Functions and click Apply Package

In the next informative message, we select Yes.

When the package is being applied we can that in one table (Customer), 10 records inserted. In this informative message, we just click OK.

Conclusion

In this article, we read about how can we bulk delete records from the Customer table in a Dynamics 365 BC instance. By following the same steps and just change the table in step 2.1, we can proceed for bulk to delete to other tables.

See Also

 

Share This