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

Hi,

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.

Comment List
Anonymous
Related
Recommended