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:
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. |