I am trying to insert a new item on sales order in the middle of multiple lines and it doesn't allow me to do this, forces me to add to the bottom
Hi, Inge is right. In the system, Line No. will have the following processing when you insert a new line from the middle.
When it cannot be allocated, an error will be prompted. But as far as I know, this generally rarely happens. . . . . .
Hope this helps as well.
Thanks.
ZHU
Then you have probably inserted some lines in between there already.
There is a limit in the system on how many lines you can insert between two already existing lines.
Once you have reached that limit you need to add new lines to the bottom.
It is because the line number is part of the primary keys for the order lines. And they are usually inserted in steps of 10000 and when you insert a line the the new line will get a line number that is the split between the line above and the line below.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156