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

Announcements

News and Announcements icon
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 81

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
    235 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
    668 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
    102,811 Super User 2026 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,043 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,812 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
    81 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 548 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 417 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 377 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans