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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Config Package - Sales Orders

(1) ShareShare
ReportReport
Posted on by 44
Hi All,
 
I'm bringing data to BC via config packages for Sales Orders ( Tables 36 & 37)
 
The order has 8 lines - all or the same item, same quantity , but different prices.
 
BC only imports the very last line.
 
Is there any way to get around this and have a ll the lines come in ?

Here's a snapshot of the data.
 
 
 
 
Thanks!
 
Rajiv
  • Verified answer
    Valentin Castravet Profile Picture
    32,808 Super User 2026 Season 2 on at
    That's because you left the Line No. column empty, so all the lines are being imported into the 1st line of the sales order lines. If you manually create a sales order and export it to a configuration package you will see that the line no. field will be populated i.e. line 1 will be 10,000, line 2 will be 20,000 and so on. You need to do the same. 
     
     
    Valentin Castravet
    Zander ERP Services
  • rajivsewsarran Profile Picture
    44 on at
    Well i feel like an idiot!
     
    Thanks for pointing that out!
     
    much appreciated!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 743 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 546 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 332 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans