Hi I would like to import sales orders by specifying customer and items, and the import will create new sales order headers and lines. I am wondering what entities to use and what excel template should look like,.
Great, thank you very much!!
You have to do it as two steps process. First headers with sales order number auto create and then lines. You can also use salesorderV3Entity which is composite entity , uses above two entities but in that case you have to use xml as format. You can not use xml. Take a look at below links to see how you can use it
mukesh-ax.blogspot.com/.../dynamics-365-operations-composite-data.html
Thank you Sukrut! I looked at the exported template for SalesOrderLineV2Entity, is has Sales order number. Assuming the import is to create header and lines, how would I specify sales order number on the sales order line template as it's unknown at that point?
You can use SalesOrderHeaderV2Entity for SO header and SalesOrderLineV2Entity entity for lines. To get the excel template put these entities in data project and do export for single sales order (You can use filter to put single order)and download the template.
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
