Maximum number of Line numbers

jimmyf

Does anyone know what is the maximum number of line numbers allowed for Sales Order Lines or Purchase Order Lines?

einsTeIn.NET

Basically it's an integer field, so it should be something around 2,147,483,647 (positive values). But in standard forms this field is filled by Property AutoSplitKey and it uses steps of 10,000. That means if you put all your lines below the current last line, then it's maybe around 214,748 lines. But it's also possible to insert a new line between two existing lines and that would lead to steps of 5,000. If you then insert another line between you would get 2,500 and so on and so on...

jimmyf

Thank you for that. Clarifies exactly what i need to know.

kine

I hope that you will never hit this limit... or even go near it. Because one thing is theoretical limit and one thing is time limit/performance limits/usability limits.

einsTeIn.NET

Thanks Kamil for pointing that out. That's absolutely true. I think you would get massive performance issues if you would have Orders/Invoices/Credit Memos/... with such an amount of lines. Especially when you consider that what I mentioned above applies to every single document (header).

kapamarou

We have a periodic procedure that once a year generates some hundreds of thousands of lines in a Journal Batch. Not only the posting but even the deletion of the batch takes forever if we need to re-run the procedure. I can't imagine a Sales Order having so many lines.

gvolkov

Whats the official rule? Do you have to go in 10000s for each line? what would happen if you increment by 1s? Is there a valid reason to increment by 10000s? as it seem like it always increases by 10000s

DenSter

The "Line No." field is an integer type field, so it will accept any valid integer field. The 10000 increment is used by Autosplitkey, so that you can actually insert lines between existing lines. Where lines are created by C/AL code standard code mimics this increment, to keep things consistent.

If you are developing a process that creates new lines though, you can use any valid integer value. There are no reasons not to use any valid value.

David_Singleton

gvolkov wrote:

Whats the official rule? Do you have to go in 10000s for each line? what would happen if you increment by 1s? Is there a valid reason to increment by 10000s? as it seem like it always increases by 10000s

The reason that 10,000 was chosen was to that you could insert 10 lines between any other two lines in an order and still have a line number easily divisible.

In this case between 10,000 and 20,000 it is possible to insert 13 new lines between any other two. (try it)

gvolkov

might be a stupid question, why

divisible

?

David_Singleton

gvolkov wrote:

might be a stupid question, why

divisible

?

Well in an ideal world we wouldn't have thumbs, so instead of decimal we would all use octal. But because we have 8 fingers and two thumbs the Romans decided that 10 was a nice number to use.

I think that if the line numbers were

8192
16384
24576
32768
40960
49152
57344
65536
73728
81920


It just wouldn't look nice. 8)

Numbers have no real meaning, e.g. why is 01/01/2000 treated differently to 10/03/1926 they are just numbers, but since we have 10 fingers we just like to see multiples of 10.