Error: illegal value or a nonexistent row number in Account Schedule.


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 Formula
Acc. 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.