Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Delete Some tables dat...
Finance | Project Operations, Human Resources, ...
Suggested answer

Delete Some tables data after class sysdatabasetransdelete

(0) ShareShare
ReportReport
Posted on by MEROMUCH 565

Dear All

We are using ax2012 r3 and we need to clear all transactions in our company and keep only master
data so I used class sysdatabasetransdelete and after process finished I found some tables still
have huge data so my question can I delete data from them manually without problem?

tables still contain data:

INVENTSETTLEMENT,SOURCEDOCUMENTHEADER,SOURCEDOCUMENTLINE,INVENTTRANSORIGINJOURNALTRANS,INVENTTRANSORIGINJOURNALTRANSRECEIPT,

INVENTTRANSORIGINSALESLINE,INVENTTRANSORIGINTRANSFER,INVENTCLOSINGNONFINANCIALINVENTTRANS,GENERALJOURNALACCOUNTENTRYDIMENSION,DI

MENSIONFOCUSUNPROCESSEDTRANSACTIONS

Thanks 

  • MEROMUCH Profile Picture
    MEROMUCH 565 on at
    RE: Delete Some tables data after class sysdatabasetransdelete

    thanks for your replay I will check this link

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,816 Moderator on at
    RE: Delete Some tables data after class sysdatabasetransdelete

    I've seen it before but never tried it. Check the link, It may give an idea. (at least it felt like a better approach than deleting tables one by one)

    rahulmsdax.blogspot.com/.../delete-transactions-in-dynamics-ax-2012.html

    Do not just go through this link, you can see similar solutions on many web pages.

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 New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans