Autosplitkey Problem

roshanthapa

In the account schedules, when I try to enter a new entry, error is triggered and says "The autosplitkey facility cannot find a key between the current and the previous record".

What is the reason?
What is split key?
How can this problem be solved??

-Roshan Thapa

Waldo

See that you're sorting on the right key (where the integer (Line No.?) is the last column).

The AutoSplitKey is a mechanism in NAV to generate a number between a previous and next record. It is used in Sales Line table for example. If you add a line between two lines, it generates a Line No. with a value between those lines. That way, the record is unique, and the records are automatically ordered in the right way.

roshanthapa

Waldo,

can u please make it a bit more clearer so that I can figure out the problem and the solution.

jm

please lokk here: http://www.mibuso.com/forum/viewtopic.php?t=12759&highlight=autosplitkey+cannot

Waldo

These threads handle about the same problem:

http://www.mibuso.com/forum/viewtopic.php?t=11904&highlight=
http://www.mibuso.com/forum/viewtopic.php?t=15795&highlight=

David_Cox

The first line you enter will have a Line No. of 10000 and lets say the row number is A20, you cannot insert a record in front of this line.

If you press F3 the system tries to insert a line in front so the AutoSplitKey cannot find a Value in the Range 10000..0

Go to the first empty line and create the record Line No. 20000, after which you can Insert records between Line No. 15000 etc:.