Supply chain | Supply Chain Management, Commerce

How to delete all transaction in Legal entity in D365FO

(0) Share

Report

Posted on by Udit

567

How to delete all transaction in Legal entity in D365FO?

Can we make copy of sysdatabasetransdelete?

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Sumit Loya 2,230 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
huijij 19,811 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Udit 567 on at

Like (0)

Report

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

Also posted data deletion will throw error.

Was this reply helpful? Yes No
Suggested answer

Joris dG 17,775 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,095 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rogerio da Costa 26 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,095 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Ravi Kumar Desu 80 on at

Like (0)

Report

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?

Was this reply helpful? Yes No