Navision Data Cleaning

Developer101
Developer101 Member Posts: 569
edited 2014-09-18 in NAV/Navision Classic Client
How to come up with the data cleansing strategy to make sure the data is

reliable and accurate and free of errors. Did anyone work on it before?
United Kingdom

Comments

  • tinoruijs
    tinoruijs Member Posts: 1,226
    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
  • Developer101
    Developer101 Member Posts: 569
    Thanks I didnt think of testing it. I will do now :)
    Master data mostly and some ledgers data as well.
    United Kingdom
  • bbrown
    bbrown Member Posts: 3,268
    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.

Categories