Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

create sales order using configuration package issue

Posted on by 167
Hi Experts, 
 
I want to create sales order using configuration package. I select the fields for sales order header and sales order lines and populated the exported excel file. 
I get an error when applying data. It says /If you change Customer, the existing sales lines will be deleted and new sales lines based on the new information on the header will be created.

Do you want to continue?/ /Yes/ and /No/ 

The sell to customer in the header table is the same as the one in sales line table. It looks like a validation error. I tested by uncheck all validations and able to import both tables, but some values on the sales line were not brought in.

Could you advise what would be the processes to for this?

Many thanks! 

Categories:
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,816 Super User 2024 Season 2 on at
    create sales order using configuration package issue
    In your sales line table don't include the Sell-to Customer field, there's no need for it and that's why you have your issue. As long as your sales line table has the Document No. field, that's all that's required to make the connection between the lines and the header. 
     
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,181 Most Valuable Professional on at
    create sales order using configuration package issue

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans