Record Deletion Tool

Record Deletion Tool

Recently I was faced with the challenge of deleting a lot of data from different tables in NAV. I thought I was not the only person who had faced such a challenge and so I went searching. On Olof Simren’s blog I quickly found what I was looking for. His Record Deletion Tool allows to delete transactional data from tables. Unfortunately he programmed this functionality for NAV 2015 and I needed it for Business Central as an extension.

For this reason I have upgraded the Record Deletion Tool to AL and the latest Business Central version. You can find and download it on GitHub.

The general functionality hasn’t changed, for more detailed explanations you can have a look at Olof’s post. A few screenshots:

ExtensionPage.png
TellMe.png

Have a nice week!

11 thoughts on “Record Deletion Tool

    1. Thanks for your comment. I am glad that the tool can help people. 🙂

  1. Hi Waldemar, do you have an updated version of this for the latest version? or the next one 25.0.23364.24593.

    I’m also getting this error:

    If requesting support, please provide the following details to help troubleshooting:

    Error message:
    Sorry, the current permissions prevented the action. (TableData 46 Item Register Delete: Record-Deletion-Tool)

    To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: ‘131480’.

    Internal session ID:
    71335475-d8f4-49a0-ac17-2cc04a15accd

    Application Insights session ID:
    e024bb8b-8544-48bc-806d-9d1dea60e24c

    Client activity id:
    0918600c-f06c-4dea-87f1-ad787df1c233

    Time stamp on error:
    2024-09-24T07:36:21.4519799Z

    User telemetry id:
    eef1ec99-d4c6-4fff-85b4-4b1ab155acc1

    AL call stack:
    “Record Deletion Mgt.”(CodeUnit 50000).DeleteRecords line 27 – Record-Deletion-Tool by Waldemar Brakowski
    “Record Deletion”(Page 50000).”DeleteRecords – OnAction”(Trigger) line 2 – Record-Deletion-Tool by Waldemar Brakowski

    1. Hey Vee,
      sorry to hear that. Are you still facing this problem?
      Please report issues on github, this way I can track them better.

      Thank you and have a nice day. 🙂
      Kind regards

      1. Hey Waldemar,

        Do you plan on updating this tool to work for BC25? If so, what is the expected timeline?

        Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *