MQ ADAPTER using XML with BSFN F4074MaintainPricehistory

[jejelb]

Hi,

I'm trying to post some discounts into F4074 table using xml file which include JDE BSFN in order to replicate what P4210 does. I've succeeded to enter the order itself but not sure how to handle the discount section to populate F4074 accordingly, I was playing with F4074MaitainPriceHistory as it looks to be the one called while entering discount but it does not work (or i'm badly using it). i'm joining the xml code below, if anyone could help, I'd really appreciate. Thx

<?xml version="1.0" encoding="utf-8" ?>
- <jdeRequest pwd="xxxxx" type="callmethod" user="xxxxxx" environment="DV7333">
- <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">28</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 28</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="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>

 

[Scott Meyer]

Did you ever achieve your goal? If so could you post details? If not, are you still needing help, or did you seek another path? I'll add to this post if I succeed.

Also, I'm interested in the method or product you are using to talk to the jdenet XML jdeRequest service. I have a roll-my-own Java adapter, but slightly concerned about production viability. Guessing you have Websphere MQ? Does that get you jdenet connectivity out-of-the box, or is there separate product for jde integration. Our deployment uses WebLogic, so don't know if Websphere is excluded.

Thanks.