How to delete all the transactions

chrispaul
chrispaul Member Posts: 174
edited 2006-08-21 in NAV/Navision Classic Client
Hi All
Please suggest me a way to delete all the transactions in a database

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Hi Chrispaul

    You could use the Go Live tool in the download section
  • chrispaul
    chrispaul Member Posts: 174
    Hi Aleb
    Well i can't find Go Live tool in Download section, Please help
  • kine
    kine Member Posts: 12,562
    There is standard function for "clearing" standard DB in the 4.00SPx - check this - Administration - IT Administration - General Setup - Setup Checklist - Functions - Implementations - Data cleaning - Clean
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    Here is the go-live tool: http://www.mibuso.com/dlinfo.asp?FileID=580

    You should review all tables that contain data by Ctrl+L and tick the ones you need to delete. Generally, *Entry*, *Document Dimension*, *Header*, *Line* is a good start but it's hard to define it 100%, so it's best to decide it in a 1-by-1 way. For example, maybe you want to keep Fixed Asset Ledger Entry if the book values are already posted in the master data migration phase.

    Also, if you started by a demo database, be sure to delete all data related to granules you don't use, because you can get licence problems. For example, if you don't have Service granules but there are Service Ledger Entries in the demo database, and you keep it, and open the Item Card with the customer's licence, Nav will likely complain about rights.

Categories