jejelb
Active Member
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>
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>