Navision Data Cleaning

Comments

• Options

  tinoruijs Member Posts: 1,226

  2014-09-17

  In classic client it is possible to test the database. File, Database, Test.
  

  reliable and accurate and free of errors.
  

  This mostly depends on the users that have put in the data.
  What kind of data do you mean?

  ---

  Tino Ruijs
  Microsoft Dynamics NAV specialist

  0
• Options

  Developer101 Member Posts: 528

  2014-09-17

  Thanks I didnt think of testing it. I will do now
  Master data mostly and some ledgers data as well.

  United Kingdom

  0
• Options

  bbrown Member Posts: 3,268

  2014-09-18

  That's only going to check a few things such as the physical integrity of database records and keys. Plus foreign key relations that are defined. It's not going to do any for of financial validation. So if you deleted open records or something, it won't find those.
  
  Use the various financial reports to reconcile. Run them before and after your process. They should still balance. Better yet, don't delete to begin with.

  There are no bugs - only undocumented features.

  0