web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / OlisterR's NAV/BC blog / Record Deletion Tool in Bus...

Record Deletion Tool in Business Central

Olister Rumao Profile Picture Olister Rumao 3,957

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.

Comments

*This post is locked for comments