Record Insert

lally

Hi experts,
In every sales, purchase , Gen.jnl…….. U have a Line no field. It is assigned by 10000 internally.. And autosplit keyProperty key for this line is yes. Up to now this is ok.
AutoSplitKey
Use this property to have the system automatically create a key for a new record placed between the current record and the previous record.I am not understanding the use of autosplitkey property.
At what condition we use this property.
For example I created 3 sales lines. If I want create one more line I wil create 4 th line.What is the need to create 4th line between above 3 lines.
And I know In all these cases the line no. ist part of the primary key (the last field in these keys). So if you have two lines, the first get the number 10000 and the second the number 20000 automatically. If you insert an new line, this line get the number 15000 automatically; if you insert a new line between the first (= 10000) and the second line (= 15000), this new line gets the number 12500 and so on.
What is purpose to create a new record between current, previous record.
Could throw some example. Why we want to insert a record.
Why don’t we create another line as a record .

.Thanks and regards

DenSter

lally wrote:

What is purpose to create a new record between current, previous record.
Could throw some example. Why we want to insert a record.
Why don’t we create another line as a record .

I don't know what you mean by 'throw some example', because you just gave a few yourself.

Why you want to insert a record? Because you want to record another transaction.

Why you want to put it in between two other lines instead of at the end? That's user preference, either way will work.

The line number makes the record uniquely identifiable. The other fields in the primary key are foreign keys into other tables, and because of the 1-to-many relationship, there has to be an additional field to uniquely identify the records in the line table. The way that the system was designed is to do this with the cunning use of an integer field. The AutoSplpitKey property is nothing more than a mechanism to create the values of the line number without user intervention. The number 10000 was chosen so that there is room for additional lines in between existing records. There is no hidden meaning to this value, the system just splits the difference in half when it inserts a line.

Dries

Hi,

Why don't you use a simple code to find the last line within that line tables using of course (Document No and Line No) as currentkey then you have the last line No and then insert the new record.

Please provide us with the way you're inserting the new lines.

Cheers,
Dries.

hawwa

This is to give your user flexibility to insert a new record between 2 records.

From your example, after you created 3 lines and you want to create a new line, you will create it at the 4th line position. That's your choice. It is fine for you but your user may not want to create the new line as the 4th line. You user may like to insert the new record in the 2nd line position because he/she feels that putting the new record in the 2nd line position can make the printout looks better (or any other reason).

To make it simple, not everyone want to insert new record at the last position. That's why Navision give you the flexibility to insert a new record between 2 lines. If navision don't provide this flexibility, I am sure a lot of people will complain Navision is not user friendly. This is a must have feature.