501
I want to create a new sales order through DIXF in dynamics 365. I am using Sales order Composite entity for this. My XML file contains 1 header and 2 lines. When i import sales order, it gives error on sales order line and gives error "Sales order number does not allow editing", so kindly tell me how to create sales order through composite data entity.
*This post is locked for comments
Could you please mark it as the answer
1) do not that include sales order number node in xml on Header or Lines
2) Do not include InventoryLotId and LineCreationLineNumber XML Nodes on the Lines;
When performing the Entity mapping, ADD The fields InventoryLotId, LineCreateionLineNumber to staging node and set to auto generate
3) Remember to look at PK on entity and staging tables to see what is Required for insert and auto-generated. As A Rule, do not include empty <NodeName/> when using auto generated nodes in your xml
Share
Report
All responses (
Answers (
<?xml version="1.0" encoding="utf-8"?>
<Document>
<SALESORDERHEADERV2ENTITY>
<SALESORDERNUMBER></SALESORDERNUMBER>
<CURRENCYCODE>AUD</CURRENCYCODE>
<INVOICECUSTOMERACCOUNTNUMBER>CA00000005</INVOICECUSTOMERACCOUNTNUMBER>
<ORDERINGCUSTOMERACCOUNTNUMBER>CA00000005</ORDERINGCUSTOMERACCOUNTNUMBER>
<REQUESTEDRECEIPTDATE>2018-11-15T00:00:00</REQUESTEDRECEIPTDATE>
<REQUESTEDSHIPPINGDATE>2018-11-15T00:00:00</REQUESTEDSHIPPINGDATE>
<SALESORDERLINEV2ENTITY>
<DEFAULTLEDGERDIMENSIONDISPLAYVALUE>1004-1002-1004-403-0005</DEFAULTLEDGERDIMENSIONDISPLAYVALUE>
<INVENTORYLOTID></INVENTORYLOTID>
<ITEMNUMBER>A0001</ITEMNUMBER>
<LINECREATIONSEQUENCENUMBER>1</LINECREATIONSEQUENCENUMBER>
<LINEDESCRIPTION>Monitor 19</LINEDESCRIPTION>
<ORDEREDSALESQUANTITY>3.000000</ORDEREDSALESQUANTITY>
<SALESPRICE>150.000000</SALESPRICE>
<SALESPRICEQUANTITY>1.000000000000</SALESPRICEQUANTITY>
<SALESPRODUCTCATEGORYNAME></SALESPRODUCTCATEGORYNAME>
<SALESTAXGROUPCODE>GST</SALESTAXGROUPCODE>
<SALESTAXITEMGROUPCODE>GST</SALESTAXITEMGROUPCODE>
<SALESUNITSYMBOL>ea</SALESUNITSYMBOL>
<SHIPPINGSITEID>AUS</SHIPPINGSITEID>
<SHIPPINGWAREHOUSEID>QLD</SHIPPINGWAREHOUSEID>
<SKIPCREATEAUTOCHARGES>1</SKIPCREATEAUTOCHARGES>
</SALESORDERLINEV2ENTITY>
</SALESORDERHEADERV2ENTITY>
</Document>
Hi,
It is quite straightforward, I'm working on Update 8.0 (not sure if any of the issues discussed here is already fixed in 8.0). Here is how I have it configured:
<?xml version="1.0" encoding="utf-8"?>
<Document>
<SALESORDERHEADERV2ENTITY>
<SALESORDERNUMBER></SALESORDERNUMBER>
<CURRENCYCODE>AUD</CURRENCYCODE>
<INVOICECUSTOMERACCOUNTNUMBER>CA00000005</INVOICECUSTOMERACCOUNTNUMBER>
<ORDERINGCUSTOMERACCOUNTNUMBER>CA00000005</ORDERINGCUSTOMERACCOUNTNUMBER>
<REQUESTEDRECEIPTDATE>2018-11-15T00:00:00</REQUESTEDRECEIPTDATE>
<REQUESTEDSHIPPINGDATE>2018-11-15T00:00:00</REQUESTEDSHIPPINGDATE>
<SALESORDERLINEV2ENTITY>
<DEFAULTLEDGERDIMENSIONDISPLAYVALUE>1004-1002-1004-403-0005</DEFAULTLEDGERDIMENSIONDISPLAYVALUE>
<INVENTORYLOTID></INVENTORYLOTID>
<ITEMNUMBER>A0001</ITEMNUMBER>
<LINECREATIONSEQUENCENUMBER>1</LINECREATIONSEQUENCENUMBER>
<LINEDESCRIPTION>Monitor 19</LINEDESCRIPTION>
<ORDEREDSALESQUANTITY>3.000000</ORDEREDSALESQUANTITY>
<SALESPRICE>150.000000</SALESPRICE>
<SALESPRICEQUANTITY>1.000000000000</SALESPRICEQUANTITY>
<SALESPRODUCTCATEGORYNAME></SALESPRODUCTCATEGORYNAME>
<SALESTAXGROUPCODE>GST</SALESTAXGROUPCODE>
<SALESTAXITEMGROUPCODE>GST</SALESTAXITEMGROUPCODE>
<SALESUNITSYMBOL>ea</SALESUNITSYMBOL>
<SHIPPINGSITEID>AUS</SHIPPINGSITEID>
<SHIPPINGWAREHOUSEID>QLD</SHIPPINGWAREHOUSEID>
<SKIPCREATEAUTOCHARGES>1</SKIPCREATEAUTOCHARGES>
</SALESORDERLINEV2ENTITY>
</SALESORDERHEADERV2ENTITY>
</Document>
in the Data Project >> click View map >> for the SalesOrderHeaderV2Entity >> Mark SALESORDERNUMBER as "Auto-Generated"
in the Data Project >> click View map >> for the SalesOrderLineV2Entity >> Mark INVENTORYLOTID as "Auto-Generated"
feel free to write to me if you are unable to fix it. Happy to help.
thanks,
Manish
Did anyone ever figure this out? I'm having the same issue.
Hi Shahrukh, Did you manage to solve the problem? I am asking you due i am having the same error but when I upload Sales Orders as Excel type. I am suspecting that it might be some config at the entity, mapping or similar. Can I get a feedback from you? Thanks so much.
This is the error: Results. update not allowed for field 'Sales order(SalesOrderNumber)' Results. Validations failed
Kind regards,
Sebastian
make sure you have Allow Blank data in SalesOrderNumber field checked. Also having SalesOrderNumber set to auto-generate on SalesOrdersHeaderV2Entity will allow this to be created on entry to Staging.
On lines, make sure LineNumbersequence number is set to AutoGenerate as well
Hi!
I have Update 3,
Goog Luck,
Regards Jarmo
Hi!
I think I have update 4 maybe 3.
How can I check it from my virtual box?
You can find the file below:
<?xml version="1.0" encoding="utf-8"?><Document><SalesOrderHeaderEntity>
<SALESORDERNUMBER></SALESORDERNUMBER>
<CURRENCYCODE>USD</CURRENCYCODE><INVOICECUSTOMERACCOUNTNUMBER>US-027</INVOICECUSTOMERACCOUNTNUMBER>
<ORDERINGCUSTOMERACCOUNTNUMBER>US-027</ORDERINGCUSTOMERACCOUNTNUMBER>
<SalesOrderLineEntity>
<DELIVERYADDRESSLOCATIONID>000001266</DELIVERYADDRESSLOCATIONID>
<ITEMNUMBER>A0001</ITEMNUMBER><LINEAMOUNT>777.000000</LINEAMOUNT>
<SALESORDERNUMBER></SALESORDERNUMBER>
<SALESPRICE>18.000000</SALESPRICE>
<SALESPRICEQUANTITY>2.000000</SALESPRICEQUANTITY>
<SHIPPINGSITEID>6</SHIPPINGSITEID>
</SalesOrderLineEntity></SalesOrderHeaderEntity></Document>
Regards Jarmo
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
