Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Delete Some tables data after class sysdatabasetransdelete

Posted on by 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 

Categories:
  • 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,812 Super User 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans