Navision Attain 3.60, Sales Orders window, alot of lines, half of which are comments. At one point, when the end-user adds a new line, the following error appears: The autosplitter facilty cannot find a key between the current and the previous record. Any idea what it meas and how to fix it? Can’t find any information in documentation about this error.
When you enter sales lines, the systems gives numbers to each line. The first normally starts with 10.000, the next ones will get a number incremented by 10.000. If you place lines in between two existing lines, the system will assign a line number which lies in between the neigboring line numbers (the first insert between the 1. and 2. line gets no. 15.000). Obviously, if you keep inserting lines, at one time the system cannot find a number that lies in between any more. So the solution is quite easy: Recreate the lines from top to bottom.
Hi I believe you get 13 splits. 10000 - 20000 = 15000 10000 - 15000 = 12500 10000 - 12500 = 11250 10000 - 11250 = 10625 10000 - 10625 = 10313 10000 - 10313 = 10156 10000 - 10156 = 10078 10000 - 10078 = 10039 10000 - 10039 = 10020 10000 - 10020 = 10010 10000 - 10010 = 10005 10000 - 10005 = 10002 10000 - 10002 = 10001
If paste is allowed in that form, a cut and paste of all the lines will do the trick.
I’ve also seen this issue when the sorting of the table is changed (by user or by customization of the form). The AutoSplitKey functionality can generate a wrong line number if the sorting is not: Document Type, Document No., Line No.