When you migrate NAV database from native to SQL you might get an error similar to following:
You have entered an illegal value or a nonexistent row number.The error occurred when the program tried to calculate:Acc. Sched. Line: Row No. = xxx, Line No. = A number, Totaling =Some FormulaAcc. Sched. Column: Column No. = yyy, Line No. = zzz, Formula =
What is the solution: Change the SQL data type of Row No. field in Acc. Schedule Line table to Integer. Thanks to Archard (a user on DUG) for this solution.