Salesline Num Error

Hi Everbody,

We have a problem in salesline table. LineNum field may not aligned orderly.

For Example;

SalesId LineNum ItemId Tax Group QTY…

1000_054 1,00000 ABC 18 1

1000_054 2,00000 BCD 18 2

1000_054 2,25000 DEF 18 2

1000_054 2,50000 FGO 18 1

1000_054 2,75000 GLM 18 2

1000_054 3,00000 GSM 18 1

As you see above, the linenum increase with 0,25. Sometimes, the lines order is change

For example; 1,2,3,5,6,4,7,9,8…

I tested in development however, I didn’t find any mistake but our user can face to face with this problem.

Can you help me please?

See the “system line number increment” field in system parameters form of System administration module. System increments the line number with the number entered in above field.

If you insert a new line between 2.0 and 3.0, its number will be 2.5. If it got 4.0, it wouldn’t be between 2.0 and 3.0 anymore. If you insert another line between 2.0 and 2.5, it will get 2.25. And so on.