jdewees
Member
Hi,
When I create a Sales Order through xmlinterop, the line items get created properly, and work orders are created for the line items of type W. However, the work order field "Related PO/SO (RORN)" is always zero, instead of having the sales order #.
Do you have any ideas what might cause this?
If I manually enter the Sales Order, the work orders get created and the RORN field on the work order is properly populated with the SO number; JDE does all this behind the scenes automatically without me having to update any of the WO fields.
Here is a small example of the xml requests I send:
<jdeRequest type="callMethod" user="USERID " pwd="PASSWORD" environment="ENV">
<callMethod name="GetLocalComputerId" app="TestApp" runOnError="no">
<params>
<param name="szMachineKey" id="2" />
</params>
<onError abort="yes" />
</callMethod>
<callMethod name="F4211FSBeginDoc" app="TestApp" runOnError="no">
<params>
<param name="mnCMJobNumber" id="1" />
<param name="cCMDocAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name='cCMErrorConditions'>2</param>
<param name="szCMComputerID" idref="2" />
<param name="cCMUpdateWriteToWF">2</param>
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="szOrderType">SO</param>
<param name="szBusinessUnit"> 2000</param>
<param name="mnAddressNumber">11742</param>
<param name="jdRequestedDate">2012/02/24</param>
<param name="szReference">WO TEST-JON-2</param>
<param name="szOrderedBy">1413308</param>
<param name="szDeliveryInstructions1">Manual </param>
<param name="szOrderTakenBy">USERID</param>
<param name="mnTradeDiscount">52.5</param>
<param name="szPricingGroup">US-99</param>
<param name="cApplyFreightYN">Y</param>
<param name="szCurrencyCode" />
<param name="cWKSourceOfData" />
<param name="cWKProcMode" />
<param name="mnWKSuppressProcess">0</param>
</params>
<onError abort="yes">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</callMethod>
<callMethod name="F4211FSEditLine" app="TestApp" runOnError="yes">
<params>
<param name="mnCMJobNo" idref="1" />
<param name="cCMLineAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name='cCMErrorConditions'>2</param>
<param name="cCMWriteToWFFlag">2</param>
<param name="szCMComputerID" idref="2" />
<param name="szItemNo">X10026-S11</param>
<param name="mnQtyOrdered">1</param>
<param name="szLineType">W</param>
<param name="szDescription1">SP Door 26" x 55" Custom Door Width: 25.875 " (25.375" fin.)</param>
<param name="szPriceCode1" />
<param name="szBusinessUnit"> 2000</param>
<param name="mnShipToNo">11742</param>
<param name="jdPromisedDate">2012/02/24</param>
<param name="szLastStatus">520</param>
<param name="szNextStatus">522</param>
<param name="cSalesTaxableYN">N</param>
<param name="szTransactionUOM">EA</param>
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="cWKSourceOfData" />
</params>
<onError abort="no" />
</callMethod>
<callMethod name="F4211FSEndDoc" app="TestApp" runOnError="no">
<params>
<param name="mnCMJobNo" idref="1" />
<param name="szCMComputerID" idref="2" />
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="cCMUseWorkFiles">2</param>
</params>
<onError abort="no">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</callMethod>
<returnParams failureDestination="ERROR.Q" successDestination="SUCCESS.Q" runOnError="yes" />
<onError abort="no">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</jdeRequest>
When I create a Sales Order through xmlinterop, the line items get created properly, and work orders are created for the line items of type W. However, the work order field "Related PO/SO (RORN)" is always zero, instead of having the sales order #.
Do you have any ideas what might cause this?
If I manually enter the Sales Order, the work orders get created and the RORN field on the work order is properly populated with the SO number; JDE does all this behind the scenes automatically without me having to update any of the WO fields.
Here is a small example of the xml requests I send:
<jdeRequest type="callMethod" user="USERID " pwd="PASSWORD" environment="ENV">
<callMethod name="GetLocalComputerId" app="TestApp" runOnError="no">
<params>
<param name="szMachineKey" id="2" />
</params>
<onError abort="yes" />
</callMethod>
<callMethod name="F4211FSBeginDoc" app="TestApp" runOnError="no">
<params>
<param name="mnCMJobNumber" id="1" />
<param name="cCMDocAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name='cCMErrorConditions'>2</param>
<param name="szCMComputerID" idref="2" />
<param name="cCMUpdateWriteToWF">2</param>
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="szOrderType">SO</param>
<param name="szBusinessUnit"> 2000</param>
<param name="mnAddressNumber">11742</param>
<param name="jdRequestedDate">2012/02/24</param>
<param name="szReference">WO TEST-JON-2</param>
<param name="szOrderedBy">1413308</param>
<param name="szDeliveryInstructions1">Manual </param>
<param name="szOrderTakenBy">USERID</param>
<param name="mnTradeDiscount">52.5</param>
<param name="szPricingGroup">US-99</param>
<param name="cApplyFreightYN">Y</param>
<param name="szCurrencyCode" />
<param name="cWKSourceOfData" />
<param name="cWKProcMode" />
<param name="mnWKSuppressProcess">0</param>
</params>
<onError abort="yes">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</callMethod>
<callMethod name="F4211FSEditLine" app="TestApp" runOnError="yes">
<params>
<param name="mnCMJobNo" idref="1" />
<param name="cCMLineAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name='cCMErrorConditions'>2</param>
<param name="cCMWriteToWFFlag">2</param>
<param name="szCMComputerID" idref="2" />
<param name="szItemNo">X10026-S11</param>
<param name="mnQtyOrdered">1</param>
<param name="szLineType">W</param>
<param name="szDescription1">SP Door 26" x 55" Custom Door Width: 25.875 " (25.375" fin.)</param>
<param name="szPriceCode1" />
<param name="szBusinessUnit"> 2000</param>
<param name="mnShipToNo">11742</param>
<param name="jdPromisedDate">2012/02/24</param>
<param name="szLastStatus">520</param>
<param name="szNextStatus">522</param>
<param name="cSalesTaxableYN">N</param>
<param name="szTransactionUOM">EA</param>
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="cWKSourceOfData" />
</params>
<onError abort="no" />
</callMethod>
<callMethod name="F4211FSEndDoc" app="TestApp" runOnError="no">
<params>
<param name="mnCMJobNo" idref="1" />
<param name="szCMComputerID" idref="2" />
<param name="szCMProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
<param name="cCMUseWorkFiles">2</param>
</params>
<onError abort="no">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</callMethod>
<returnParams failureDestination="ERROR.Q" successDestination="SUCCESS.Q" runOnError="yes" />
<onError abort="no">
<callMethod name="F4211ClearWorkFile" app="TestApp" runOnError="yes">
<params>
<param name="mnJobNo" idref="1" />
<param name="szComputerID" idref="2" />
<param name="mnFromLineNo">0</param>
<param name="mnThruLineNo">0</param>
<param name="cClearHeaderWF">2</param>
<param name="cClearDetailWF">2</param>
<param name="szProgramID">P4210</param>
<param name="szCMVersion">HAD0004BA</param>
</params>
</callMethod>
</onError>
</jdeRequest>