web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Cant insert a new line on sales order

(0) ShareShare
ReportReport
Posted on by 5

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 

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,045 Moderator on at
    RE: Cant insert a new line on sales order

    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.  

  • Suggested answer
    YUN ZHU Profile Picture
    92,886 Super User 2025 Season 2 on at
    RE: Cant insert a new line on sales order

    Hi, Inge is right. In the system, Line No. will have the following processing when you insert a new line from the middle.

    pastedimage1679017413499v1.png

    pastedimage1679017432180v2.png

    pastedimage1679017443674v3.png

    pastedimage1679017459838v4.png

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans