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 :
Small and medium business | Business Central, N...
Suggested Answer

How to delete all data from Business Central?

(0) ShareShare
ReportReport
Posted on by 75

We are currently setting up Business Central in a production environment. We have been testing profusely the functionality of the software, but we have realized we have too many transactions (Sales orders, sales invoices, purchase orders/invoices, G/L entries etc...) and we want to delete it all and start from scratch. Is there a way to do this without coding? We have been using to mainly learn the software and we are to the point where we will soon start testing with actual customers, but would like to have fresh environment to start from. 

I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    You can setup a new company and import your master data and associated data. But no way to remove transactions.

  • AD-22040756-1 Profile Picture
    642 on at

    As Kim mentioned its not possible out of the box, but you can try using the following extension which will allow you to delete data from all tables including transactional ones

    navinsights.net/.../

  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at

    Hi, I recommend re-creating the environment directly to be more thorough.

    pastedimage1662702645329v1.png

    pastedimage1662702657728v2.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Amit Baru Profile Picture
    3,037 on at

    Hi,

    Delete the existing Prod. Environment a and setup new one.

    For more info:

    https://erpconsultors.com/how-to-delete-environment-in-d365-bc-saas/

    Regards

    Amit Sharma

    www.erpconsultors.com

    linkedin.com/in/amit-sharma-94542440/

  • Suggested answer
    Nitin Verma Profile Picture
    21,698 Moderator on at

    Hi,

    Adding more information

    You can use the Retention Policy but it will help you delete all your logs.

    pastedimage1662707014546v1.png

    You can choose below objects to be removed or schedule them.

    pastedimage1662707045766v2.png

  • FJR Profile Picture
    75 on at

    I see, ok thank you for your help, actually tried that and it didn't move over transactions, which is good enough.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans