MQ ADAPTER using XML with BSFN F4074MaintainPricehistory

[jejelb]

Hi,

I'm using MQ adapter to import into JDE (XE) sales orders. I've already succeeded to do that but now I'd like to add a record in F4074 table to manage discount. I had a look to debuglog to see the BSFN to use and it seems that F4074MaintainPriceHistory is the one to use but I'm not able to do that. Below is the current xml I'm working on, if anyone could help i'd really appreciate.

<?xml version="1.0" encoding="utf-8" ?>
- <jdeRequest pwd="xxxxxx" type="callmethod" user="xxxxxx" environment="Pxx7333">
- <callMethod name="GetLocalComputerId" app="LSM" trans="order" runOnError="no">
- <params>
<param name="szMachineKey" id="computerId" />
</params>
</callMethod>
- <callMethod name="F4211FSBeginDoc" app="LSM" trans="order">
- <params>
<param name="mnCMJobNumber" id="jobNum" />
<param name="cCMDocAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name="szCMComputerID" idref="computerId" />
<param name="cCMUpdateWriteToWF">1</param>
<param name="szCMProgramID">LSM</param>
<param name="szCMVersion">HRC0005</param>
<param name="szOriginalOrderNo" id="origOrdNum">29</param>
<param name="szOriginalOrderType" id="origOrdType">Y1</param>
<param name="szBusinessUnit" id="busUnit">99640</param>
<param name="mnAddressNumber" id="billTo">2852031</param>
<param name="mnShipToNo" id="shipTo">2852031</param>
<param name="szReference">Cust PO 29</param>
<param name="szDeliveryInstructions1">Test 1</param>
<param name="szDeliveryInstructions2">Test 2</param>
<param name="jdOrderDate" id="orderDate">20091124</param>
<param name="jdRequestedDate">20091224</param>
<param name="szOrderType" id="orderType">SO</param>
<param name="cApplyFreightYN">Y</param>
<param name="szCurrencyCode" id="curCode">EUR</param>
<param name="szTaxExplanationCode" id="taxExplan" />
<param name="szTaxArea" id="taxArea" />
<param name="szOrderBy">Christian</param>
<param name="szOrderTakenBy">llachej</param>
<param name="mnWKSuppressProcess">0</param>
</params>
- <onError abort="yes">
<endTransaction trans="order" action="rollback" />
</onError>
</callMethod>
- <callMethod name="F4211FSEditLine" app="LSM" trans="order">
- <params>
<param name="mnCMJobNo" idref="jobNum" />
<param name="cCMLineAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name="cCMWriteToWFFlag">1</param>
<param name="szCMComputerID" idref="computerId" />
<param name="szOrderType" idref="orderType" />
<param name="mnLineNo" id="lineNum1">1</param>
<param name="szItemNo">20090022</param>
<param name="cWKCheckAvailability">1</param>
<param name="szOriginalOrderNo" idref="origOrdNum" />
<param name="szOriginalOrderType" idref="origOrdType" />
<param name="mnShortItemNo" id="itemNum1" />
<param name="mnUnitPrice" id="unitPrice1">2000</param>
<param name="mnQtyOrdered" id="qtyNum1">1</param>
<param name="szLineType" id="lineType1" />
<param name="mnExtendedPrice" id="extPrice1" />
<param name="szBusinessUnit" id="busUnit1" />
<param name="cSalesTaxableYN" id="taxable1" />
<param name="cOverridePrice">1</param>
<param name="mnOriginalOrderLineNo">1</param>
<param name="szCMProgramID">LSM</param>
<param name="szCMVersion">HRC0005</param>
</params>
- <onError abort="yes">
<endTransaction trans="order" action="rollback" />
</onError>
</callMethod>
- <callMethod name="F4211FSEditLine" app="LSM" trans="order">
- <params>
<param name="mnCMJobNo" idref="jobNum" />
<param name="cCMLineAction">A</param>
<param name="cCMProcessEdits">1</param>
<param name="cCMWriteToWFFlag">1</param>
<param name="szCMComputerID" idref="computerId" />
<param name="szOrderType" idref="orderType" />
<param name="mnLineNo" id="lineNum1">2</param>
<param name="szItemNo">20091224</param>
<param name="cWKCheckAvailability">1</param>
<param name="szOriginalOrderNo" idref="origOrdNum" />
<param name="szOriginalOrderType" idref="origOrdType" />
<param name="mnShortItemNo" id="itemNum2" />
<param name="mnUnitPrice" id="unitPrice1">2000</param>
<param name="mnQtyOrdered" id="qtyNum1">1</param>
<param name="szLineType" id="lineType1" />
<param name="mnExtendedPrice" id="extPrice1" />
<param name="szBusinessUnit" id="busUnit1" />
<param name="cSalesTaxableYN" id="taxable1" />
<param name="cOverridePrice">1</param>
<param name="mnOriginalOrderLineNo">1</param>
<param name="szCMProgramID">LSM</param>
<param name="szCMVersion">HRC0005</param>
</params>
- <onError abort="yes">
<endTransaction trans="order" action="rollback" />
</onError>
</callMethod>
- <callMethod name="F4211FSEndDoc" app="LSM" trans="order">
- <params>
<param name="mnCMJobNo" idref="jobNum" />
<param name="szCMComputerID" idref="computerId" />
<param name="mnSalesOrderNo" id="orderNumber" />
<param name="szKeyCompany" id="orderCo" />
<param name="mnOrderTotal" id="orderTotal" />
<param name="szCMProgramID">LSM</param>
<param name="szCMVersion">HRC0005</param>
<param name="cCMUseWorkFiles">1</param>
</params>
- <onError abort="yes">
<endTransaction trans="order" action="rollback" />
</onError>
</callMethod>
- <callMethod name="F4074MaintainPriceHistory" app="NetCommerce">
- <params>
<param name="mnOrderNumber" idref="orderNumber" />
<param name="szOrderType" idref="orderType" />
<param name="szOrderCompany" idref="KeyorderCo" />
<param name="mnShortItemNumber">1257212</param>
<param name="mnLineNumber" idref="lineNum1" />
<param name="mnSequenceNumber">20</param>
<param name="szAdjSchedule">20000</param>
<param name="szAdjName">MANUALD</param>
<param name="mnAddressNumber" idref="billTo" />
<param name="szCurrencyCode" idref="curCode" />
<param name="szUnitOfMeasure" idref="TransactionUOM" />
<param name="mnUnitPrice">70</param>
<param name="mnForeignUnitPrice">0</param>
<param name="szGLClass">AD05</param>
<param name="szReasonCode">ND</param>
<param name="cAdjControlCode">1</param>
<param name="cManualAddChange">Y</param>
<param name="cPriceOverrideCode">1</param>
<param name="szProgramID">LSM</param>
<param name="cBasisCode">5</param>
<param name="mnFactorValue">70</param>
<param name="cOverridePriceYN">Y</param>
<param name="cActionCode">A</param>
<param name="cSuppressErrorMsg">1</param>
<param name="cFile">2</param>
<param name="szComputerID" idref="computerId" />
<param name="mnJobNumber" idref="jobNum" />
<param name="mnRevisionLevel">1</param>
<param name="cAdjustmentLevel">1</param>
</params>
- <onError abort="yes">
<endTransaction trans="order" action="rollback" />
</onError>
</callMethod>
<endTransaction trans="order" action="commit" />
<returnParams failureDestination="ERR.Q" successDestination="PC.Q" />
- <onError abort="no">
<endTransaction trans="order" action="rollback" />
</onError>
</jdeRequest>

Thanks in advance.
Jérôme