Testing field relationship between tables

Hi,

when Testing field relationship between tables, i come across lots of data mismatch. is this going to trouble me when am doing upgradation(data migration). Pls advice us.

Thanks,

Shyam Kumar N

how do you do the testing? please describe more details?

It depends on which tables/fields have the issues, and whether those are validated during the upgrade process. These situations are often the results of “cleaning up” supplemental tables by removing records for values no longer used. While it makes those tables more “manageable” for the users, it also often ends up where historical data will not pass these test.

Hi,

using File > Database > Test > Test field relationship between tables, i found that some customer, payment terms, UOM are not found in masters, so during the process i come across issues in G/L Entry, Cust. ledger entry, vendor ledger entry tables, now am going to start upgrading from NAV 4.0 to NAV 2009 SP1 is this going to cause any issues in data upgradation.

Thanks,

Shyam Kumar N