Users who want to change from Navision Native database to SQL discovers some timesa problem related to wrong (read: "Very old") date fields in the Native database.
This problem makes it impossible to restore a Navision-backup in to SQL-database because SQL isn't able to handle or store date value in the database beforeJanuary 1.st 1753.
This codeunit make the program code for codeunit 70823 that afterward can updateall invalid date fields to a date that is supported in SQL-database.
How to use this codeunit:1. Often it will be necessary to use a developers licens when using this functionality because several customers have data in table that their license not allow access to.2. Import this codeunit in the appropriate database3. When running this coduinit from design, it will create a file "C:\70823.txt" that is source code for codeunit 70823 in txt-format.4. Import the new created file from point 3 in the database5. Compile this codeunit6. Run this codeunit i all companies (Can take very long time depending of the size of database and amount of records stored in difrent tables).
Exceptions:This functionality isn't able to handle date-field included in the primary-key.Example: Salary-rate, pricelist lines, ect. Such tables have to handled manuallybefore using this codeunit.