Skip to main content

Notifications

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

Cant insert a new line on sales order

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 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 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.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans