SALES LINE
Abdul asked 7 years ago
Hi,
I’m trying to update the data into SOP lines using the Add Line Item Node. The Issue is that it updates the first line in the Sales order leaving the 2nd line unchanged.
The samples XML
<?xml version=”1.0″ encoding=”UTF-8″?>
<pwPICKSfromWMS>
<headerLine>
<fileDirection>FROM.WMS</fileDirection>
<fileType>PICKS</fileType>
<itemId>103940</itemId>
<itemCount>2</itemCount>
<orderTypeCode>SO</orderTypeCode>
<toHostDate>13/04/2016</toHostDate>
<toHostTime>20:05:15</toHostTime>
<customerNumber>002263</customerNumber>
<customerName>XXXXXXXXXX</customerName>
<customerOrderNumber>4464</customerOrderNumber>
<referenceNumber>2</referenceNumber>
<orderCompStatus></orderCompStatus>
</headerLine>
<detailLine>
<itemId>103940</itemId>
<itemCount>1</itemCount>
<productCode>OS89</productCode>
<warehouseCode>2</warehouseCode>
<qtyPicked>4</qtyPicked>
<commentLine1>16384</commentLine1>
</detailLine>
<detailLine>
<itemId>103940</itemId>
<itemCount>2</itemCount>
<productCode>OSFORMNXT</productCode>
<warehouseCode>2</warehouseCode>
<qtyPicked>1</qtyPicked>
<commentLine1>32768</commentLine1>
</detailLine>
</pwPICKSfromWMS>
Any ideas, I have tried using the groupings on ITEMID which is equal to SOPNUMBE in GP and setting the Key fields as ITEMDID = SOPNUBE and commentLine1 = LINETEMSQ
I’m trying to update the data into SOP lines using the Add Line Item Node. The Issue is that it updates the first line in the Sales order leaving the 2nd line unchanged.
The samples XML
<?xml version=”1.0″ encoding=”UTF-8″?>
<pwPICKSfromWMS>
<headerLine>
<fileDirection>FROM.WMS</fileDirection>
<fileType>PICKS</fileType>
<itemId>103940</itemId>
<itemCount>2</itemCount>
<orderTypeCode>SO</orderTypeCode>
<toHostDate>13/04/2016</toHostDate>
<toHostTime>20:05:15</toHostTime>
<customerNumber>002263</customerNumber>
<customerName>XXXXXXXXXX</customerName>
<customerOrderNumber>4464</customerOrderNumber>
<referenceNumber>2</referenceNumber>
<orderCompStatus></orderCompStatus>
</headerLine>
<detailLine>
<itemId>103940</itemId>
<itemCount>1</itemCount>
<productCode>OS89</productCode>
<warehouseCode>2</warehouseCode>
<qtyPicked>4</qtyPicked>
<commentLine1>16384</commentLine1>
</detailLine>
<detailLine>
<itemId>103940</itemId>
<itemCount>2</itemCount>
<productCode>OSFORMNXT</productCode>
<warehouseCode>2</warehouseCode>
<qtyPicked>1</qtyPicked>
<commentLine1>32768</commentLine1>
</detailLine>
</pwPICKSfromWMS>
Any ideas, I have tried using the groupings on ITEMID which is equal to SOPNUMBE in GP and setting the Key fields as ITEMDID = SOPNUBE and commentLine1 = LINETEMSQ
Answers
Lorren Zemke Staff answered 7 years ago
Abdul,
I assume that when you preview the data you see two lines, correct? If we are not seeing two lines then the XML source would need to change. As I look at it there should be an XML node around the detailLine nodes. I think the format should be as below.
<pwPICKSfromWMS>
<headerLine>
<detailLines>
<detailLine>
….data….
</detailLine>
<detailLine>
….data…
</detailLine>
</detailLines>
</headerLine>
</pwPICKfromWMS>
The Key Field should be just ITEMID since you want to create 1 SOP document with two lines.
You would Group on the SOP Header node on the ITEMID. On the SOP Line node, you would not have any grouping.
Lorren
I assume that when you preview the data you see two lines, correct? If we are not seeing two lines then the XML source would need to change. As I look at it there should be an XML node around the detailLine nodes. I think the format should be as below.
<pwPICKSfromWMS>
<headerLine>
<detailLines>
<detailLine>
….data….
</detailLine>
<detailLine>
….data…
</detailLine>
</detailLines>
</headerLine>
</pwPICKfromWMS>
The Key Field should be just ITEMID since you want to create 1 SOP document with two lines.
You would Group on the SOP Header node on the ITEMID. On the SOP Line node, you would not have any grouping.
Lorren
Alwani replied 3 years ago Hi, I have a scenario where items are in repeating order and come in any sequence. We come up with a line sequence number so I can use also restriction limit, but for some reason, it is not working.
I have xml so what would be my direction on this, how to go on this?