The autosplitkey facility cannot find a key between the current and the previous record.

Hi all !

There's an error message that can appear when you're inserting lines between two existing lines. 
Although it seems you can repeat this action over and over, the system finally generates the following error message:

Classic version says like this:

“The autosplitkey facility cannot find a key between the current and the previous record.”

And Role Tailored version says like this:

“The line cannot be split.”

Look at the previous image: In the document lines, there's a field called "Line No". This field is used to give a number for every line. The system assigns this value automatically and sequentially  in increments of 10.000.

What happens when you insert a line between line #10.000 and line #20.000? The new one will be line #15.000. That is, halfway between the two existing lines.

So,

A new line between line #10.000 and line #15.000 will be line #12.500 

A new line between line #10.000 and line #12.500 will be line #11.250

If you continue like this, there comes a time when you try to insert a new line between line #10.000 and line #10.001 and the system generates the error.

You have to add the new line in another position.

AND REMEMBER:

If you are in the classic version of Dynamics NAV, you can select all the lines in a journal, Cut the lines, and immediately Copy the lines. When the system copies all the lines, the "Line No." field is recalculated, and all the lines appear again in increments of 10.000. So, you can continue inserting new lines in the desired position.

Be careful! If you are in the lines of a document, you can Copy the lines, but you can't  Paste them, as this action is not available in this kind of forms.

See you soon!