Record Deletion Tool in Business Central

Introduction:

After a successful Go-Live in Business Central, we somehow need to delete a record from Backend.
There is no way of doing this until you write a code to delete the specific record.
I also had a word with Microsoft Support Team who recommend taking this approach.

Thus I have created a Generic Record Deletion Tool where you have to put your Table Number and Primary Keys to delete the specific record.

Record Deletion Tool : https://github.com/olisterr/Data-Deletion-Tool/blob/master/Report%2050199%20DataDeletionReport.al

Pre-requisites:

Microsoft Dynamics Business Central

Books & References:

https://forum.mibuso.com/discussion/6922/how-to-setrange-and-find-a-record-with-recordref-datatype

Demonstration:

NOTE: This tool is available for free without any warranties. Use it at you own risk.

1. Global Search for the Tool:

Searching for the Record Deletion Tool

2. Filter records by Table No. and Primary Keys:

Filling in the Table No. and Primary Keys

3. During Record Deletion:

Shows the Record Deletion Confirmation

4. After Record Deletion:

After the Record is Deleted.

Conclusion:

This Record Deletion Tool I have added as an extension to Olof Simren's Data Deletion Toolkit (https://github.com/olisterr/Data-Deletion-Tool).

This tool can be used after Post Go-Live to delete a record in Business Central Production Environment.

Also, it can help you browse through the Table Data inorder to find a record.

Hope this is useful to you. Let me know in comments.