Why Navision init line with number 10000¿?

cpina · 2007-03-19

A lot of table init number line with 10000 and add from 10000 each time
10000 20000 30000

Why?

Init line 1,2,3,4...
Metaphisic question...

Saint-Sage · 2007-03-19

It's Navision standard...as to why it's the standard...uh..no idea!

nunomaia · 2007-03-19

For example in sales order form:

Line 1: 10 000
Line 2: 20 000

If you want to insert a line in middle it has to be 15 000

If Navision didn’t inserted that way, it hasn't possible to insert a new line between existing lines.

cunny · 2007-03-20

Yes it is, It's a basic rule of Navision just like why we should use the Menusuite to control the display of Navision. You can not change it currently:). It's controlled by the prperty "AutoSplitKey" of the form. You can check the properties of subforms just like from 46 "Sales order subfrom" and form 47 "Sales Invoice subform".

cpina · 2007-03-22

Thanks for reply.
It is a Metaphisic question...
Why 10000+10000 and not 1+1 :roll:

Marije_Brummel · 2007-03-22

If the purpose of your solution does not need inserting lines in between later then you can make a manual lineindent function.

Otherwise just use the out-of the box functionality.

Cem_Karaer · 2007-03-29

The reason why line numbers increases by 10000 is that you may want to add a new line between, say 10000 and 20000 by getting the number 15000. Because lines are sorted by line numbers, that insertion will not impose any problem because 10000 < 15000 < 20000 not changing the sorting order of insertion.

cunny · 2007-09-12

Hi guys,

I think I was wrong. In fact, you can change the rule by selecting "AutoSplitKey" = No on the list form property. This property defined you want to increase line by 10000 in the list form or not. And it's only avaliable for list form and card form. Anyway, you can increase the line no. by whatever you want if you want assign the line no. by code directly in the table and the list form will show the real line no. like 11000,12000.....

Good Luck,

cunny

Waldo · 2007-09-12

May be in other words ...

The reason why it's initiated by 10000, and added by 10000, is to make AutoSplitkey to work.

If AutoSplitKey = yes, and you're inserting a line between 1 and 2 ... you'll get an error. So, making it so that it's 10000 by default, you're creating some extra levels to insert lines.

DenSter · 2007-09-12

cpina wrote:

Thanks for reply.
It is a Metaphisic question...
Why 10000+10000 and not 1+1 :roll:

Nothing meta abot this, it's a purely practical reason

Miklos_Hollender · 2007-09-12

And actually this enables a trick. What if you need to write code to generate and post item journals? You can't just call the posting routine on the record variable as you need to attach some dimensions to it, usually. Well maybe with a lot of magic you could but it's just easier to insert it and post it aftewards. Solution - use a magic line number that can never automatically be created by autosplitkey. F.e. 108.

David_Singleton · 2007-09-12

cpina wrote:

A lot of table init number line with 10000 and add from 10000 each time
10000 20000 30000

Why?

Init line 1,2,3,4...
Metaphisic question...

The reason for 10,000 was simply so that you can insert at least 10 new lines between any line. In fact using 10,000 allows a maximum of 13 lines to be inserted...:

0..10,000

5,000
2,500
1,250
625
312
156
78
39
19
9
4
2
1

powerstu · 2017-08-22

Hi I know this is an old posting. However, I am curious as to whether it is possible to change the standard Numbering from 10000 to say 1000. The reason I ask is that when exporting SO's to an external WMS - the external WMS cannot handle lines >1000000 which limits the number of lines to 100.

thomasbarbut · 2017-09-05

Hello,

I haven't checked how to change the "Line No.", but you could renumber it when exporting. This would be a better solution because it does not change the core functionality.

best regards,
Thomas Barbut

David_Singleton · 2017-10-12

powerstu wrote: »

Hi I know this is an old posting. However, I am curious as to whether it is possible to change the standard Numbering from 10000 to say 1000. The reason I ask is that when exporting SO's to an external WMS - the external WMS cannot handle lines >1000000 which limits the number of lines to 100.

I would recommend that you create a new field "Line No. Export" then when you export the order, increment this field by 1 for each line, that way you will have a link in your existing system to connect back to later.

Howdy, Stranger!

Quick Links

Categories

Why Navision init line with number 10000¿?

Comments