Skip to main content

Notifications

Community site session details

Community site session details

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

ad a new line on a sales price list (new experiance)

(1) ShareShare
ReportReport
Posted on by 145
Hi, 
 
I am trying to ad a new line on a sales price list, but when I do I get the error /the line cannot be split/.
What does this mean? Have I done something wrong?
 
  • Verified answer
    Judy Profile Picture
    Microsoft Employee on at
    ad a new line on a sales price list (new experiance)
    As mentioned, that is a by design feature, in order to achieve a change in the long term, you could send the feedback into the idea forum, add a new idea or vote for existing ideas. Then ask you your colleagues to raise up the votes. Microsoft has direct visibility of these ideas, and they will implement it on the basis of the highest number of votes received.
     
    Best Regards,
    Judy
  • Verified answer
    YUN ZHU Profile Picture
    81,286 Super User 2025 Season 1 on at
    ad a new line on a sales price list (new experiance)
    Hi, I've discussed this before and hope it can give you some tips.
    Business Central Standard Error: The line cannot be split & There is not enough space to insert correction lines (AutoSplitKey Property)
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    27,517 Super User 2025 Season 1 on at
    ad a new line on a sales price list (new experiance)
    Try adding a new line anywhere else, other than before the first row and it will work. The reason is because in the background Business Central assigns all lines a line number and you have reached that limit. If you keep adding new lines in the same spot you will always get that error message eventually. For example lets say you have the following two lines only:
     
    • Line 1 - Line No. assigned by Business Central is 10,000
    • Line 2 - Line No. assigned by Business Central is 20,000
     
    When you insert a new line before line 1, Business Central will assign it a line number that is half of that existing line. In this case the new line number will be 5,000. If you then insert another line number before the 5,000 line, the line number will be 2,500. You can keep going like this until you get line numbers 1,250, 625, 312, 156, 78, 39, 19, 9, 4, 2, 1. At this point if you try to insert another new line you will get an error message that the line cannot be split, for the reason being that the system can't assign it a line number that's half of 1. 
     
     
    Valentin Castravet
    Zander ERP Services

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,060 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,858 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans