Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

How to delete all transaction in Legal entity in D365FO

Posted on by 567

How to delete all transaction in Legal entity in D365FO?

Can we make copy of sysdatabasetransdelete?

  • Ravi Kumar Desu Profile Picture
    Ravi Kumar Desu 80 on at
    RE: How to delete all transaction in Legal entity in D365FO

    I agree with others on this thread not to take short cuts with this. But why you would like to delete all the transactions first place?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: How to delete all transaction in Legal entity in D365FO

    Hi Rogerio,

    There is no replacement for the class. You can indeed consider creating a new legal entity. Can you tell your reason for this requirement?

  • Rogerio da Costa Profile Picture
    Rogerio da Costa 26 on at
    RE: How to delete all transaction in Legal entity in D365FO

    Is there any replacement for this class in D365 or would the guidance be to setup a new empty legal entity if clearing transactions is ever needed?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: How to delete all transaction in Legal entity in D365FO

    I'm with Joris here. At least do not use it in a production environment or golden configuration environment which will be used at go-live.

  • Suggested answer
    Joris dG Profile Picture
    Joris dG 17,775 on at
    RE: How to delete all transaction in Legal entity in D365FO

    SysDatabaseTransDelete is marked as obsolete in Dynamics365.

    This class was NEVER maintained for Dynamics365 so does not result in a valid database. Do NOT use it.

  • Udit Profile Picture
    Udit 567 on at
    RE: How to delete all transaction in Legal entity in D365FO

    Deleting records table wise will be too risky and data flows to multiple tables.

    Also posted data deletion will throw error.

  • huijij Profile Picture
    huijij 19,811 on at
    RE: How to delete all transaction in Legal entity in D365FO

    Hi Udit Kumar

    Similar questions at the forum link 

    https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/289859/is-there-a-routine-to-delete-all-transactions-in-d365/831150

    The  SysDatabaseTransDelete can be extended

    https://www.axperience.ch/en/deleting-one-single-company-legal-entity-in-d365fo/

    regards

  • Suggested answer
    Sumit Loya Profile Picture
    Sumit Loya 2,230 on at
    RE: How to delete all transaction in Legal entity in D365FO

    There is a standard class and it also has delegates for both global and and company specific trans tables. You can make use of those to add your own custom transaction tables.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans