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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Deletion of records from Configuration Package of On Premises Business Central

(0) ShareShare
ReportReport
Posted on by 100
I have around 85000 records in the configuration package of the table which I want to delete I have tried deleting the records altogether but it's not working I was trying through export import excel but it would delete the database records which I don't want to do, So for now I am deleting line by line but since it's a lot of records it would take many days to accomplish this, I want a quick and authentic solution since I am doing this in a live company.
I have the same question (0)
  • Suggested answer
    PRao Profile Picture
    252 on at
    Deletion of records from Configuration Package of On Premises Business Central
    I agree with the solution provided by Pallavi Phade.
    Could you please confirm whether this is customized table data or base table data?
    When inserting data into any table where a primary key is defined, there is a possibility that the table is related to other tables through relationships.
    A better approach would be to consult with a developer and create an extension report using AL to delete the data. Always ensure a backup is taken before performing any deletions or modifications.
     
     
    Thanks, 
    PRao

     
  • Verified answer
    Pallavi Phade Profile Picture
    129 on at
    Deletion of records from Configuration Package of On Premises Business Central
    Namaste ,
     
    It is not possible to delete records directly from the Configuration Package. Before proceeding with any deletion, please ensure that you take a backup of the data.
     
    Below two options i can suggest
     
    Option 1
    Create a List Page for the table from which you want to delete records (assuming it is a custom table).
    Once the List Page is available, you can select the records directly from the page and delete them.
    Since the original problem statement does not mention any reference table, it is assumed that there are no dependencies on these tables.
     
    Deletion from custom list page should work .
     
    Option 2
    Create a Custom Report for the specific table.
    Add custom AL code within the report to handle deletion of the selected records
    This allows you to trigger the deletion process directly from the front end in a controlled manner
     
     
    Both options will be always useful . Ensure above activity is done by admin and not with all users 
     
    IF you feel this answer helps , Please mark as verified 
     
    Regards 
    Pallavi Phade

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,669 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,668

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans