Options

HOW TO DELETE TRANSACTION Record.

kiLLkiLL Member Posts: 53
Hi,
Im finished testing my database,and want to delete all transaction in all table.Is there's away to delete,all transaction? All transaction only.Hope you can help me.TY
DEV.Trainee

Answers

  • Options
    AlbertvhAlbertvh Member Posts: 516
    Hi

    For NAV 4 there is a codeunit 8604 data cleaning that you could use.
    This deletes most of the entries you want.


    Albert
  • Options
    j.marseloj.marselo Member Posts: 102
    Most entries, but not all. Moreover if you are using Manufacturing functionalities, the codeunit is not deleting Production Order related tables, Reservation Tables, and so on.

    You will need to check what tables you want to delete, then add lines in the codeunit to run the deletion to the tables.
    Kind regards, Joe Marselo | see my NAV blog joemarselo.wordpress.com | twitter @joemarselo
  • Options
    vikram7_dabasvikram7_dabas Member Posts: 611
    hi
    J.Marselo gave u the right suggestion but u can make 1 report called batch job there u can delte the records of any table whatever u wants.ok
    Vikram Dabas
    Navision Technical Consultant
Sign In or Register to comment.