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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / is there a routine to ...
Finance forum

is there a routine to delete all transactions in D365?

(0) ShareShare
ReportReport
Posted on by Abdo Khoury 14,855

Dear 

is there a routine to delete all transactions in D365 while keeping all setup and configuration as is ? and is it recommended by Microsoft ? 

Regards

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    You can delete all transactions of a legal entity: community.dynamics.com/.../delete-all-transaction-data-for-legal-entity-in-dynamics-365-fo

    However a lot of the data in D365FO is in global tables, I don't know if that functionality removes them. But you could try to run this in all companies. I haven't used this functionality.

    Do not use it in production environment!

    I would also say that the recommended way to start from a clean slate would be to deploy a new empty environment, and use data packages to input the parameter and master data. But that requires that you have created such packages.

    You could also copy database from a golden configuration environment, if you have such environment in place.

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,855 on at

    Hello Nikolaos

    i actually agree with you , because that functionality was not recommended by Microsoft in AX 2012 so i assume it is not recommended either in D365

    thank you for the above, i am struggling with the data packages, as i am looking for the correct sequence for export and import the setup and configuration ,

    i am following this link and using the default data templates in the data management but not everything gets imported

    docs.microsoft.com/.../data-entities-data-packages

    do u have a straight forward document that i can use to copy the setup from one environment to another ? appreciate it

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Unfortunately I don't have anything to show, but you can study the MS data packages in any dev/demo machine where Contoso data is used. You can find them in the file system of the machine.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,741 Moderator on at

    If it's non prod environment you can use sysdatabadetransDelete . make sure you have database back up taken.

    Just for your information global tables are not impacted by this utility.

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans