details: /erp/devel/pi/rev/a97e0286a716
changeset: 8023:a97e0286a716
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Aug 06 13:23:42 2010 +0200
summary: Fixed issue 14132.The process also sets in the order the
po_paymentmethod_id.
diffstat:
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java | 2 +-
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql | 11
++++++---
2 files changed, 8 insertions(+), 5 deletions(-)
diffs (54 lines):
diff -r 4a38878937ad -r a97e0286a716
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
--- a/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java Fri Aug
06 10:43:25 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java Fri Aug
06 13:23:42 2010 +0200
@@ -472,7 +472,7 @@
data1[0].invoicerule.equals("") ? "I" : data1[0].invoicerule,
data1[0].deliveryrule
.equals("") ? "A" : data1[0].deliveryrule, "I",
data1[0].deliveryviarule.equals("") ? "D" :
data1[0].deliveryviarule, strWarehouse,
- strPriceListId, "", "", "");
+ strPriceListId, "", "", "", data1[0].poPaymentmethodId);
} catch (ServletException ex) {
myMessage = Utility.translateError(this, vars, vars.getLanguage(),
ex.getMessage());
releaseRollbackConnection(conn);
diff -r 4a38878937ad -r a97e0286a716
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql Fri Aug
06 10:43:25 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql Fri Aug
06 13:23:42 2010 +0200
@@ -32,7 +32,7 @@
'' AS InvoiceRule, '' AS DeliveryRule, '' AS FreightCostRule, '' AS
DeliveryViaRule,
'' AS PaymentRulePO, '' AS PO_PaymentTerm_ID, '' AS DESCRIPTION, ''
AS C_UOM_ID, '' AS QUANTITYORDER, '' AS M_PRODUCT_UOM_ID,
'' AS PRICELIMIT, '' AS PRICEACTUAL, '' AS DISCOUNT, '' AS TAX, ''
AS C_ORDERLINE_ID,
- '' AS PADRE, '' AS ID, '' AS NAME, '' AS PRICESTD, '' AS TO_CLOSE,
'' AS UOMNAME, '' AS SECUOMNAME
+ '' AS PADRE, '' AS ID, '' AS NAME, '' AS PRICESTD, '' AS TO_CLOSE,
'' AS UOMNAME, '' AS SECUOMNAME, '' AS PO_PAYMENTMETHOD_ID
FROM DUAL
]]></Sql>
<Field name="rownum" value="count"/>
@@ -231,7 +231,7 @@
<Sql>
<![CDATA[
SELECT p.InvoiceRule, p.DeliveryRule, DeliveryViaRule,
- p.PaymentRulePO, p.PO_PaymentTerm_ID
+ p.PaymentRulePO, p.PO_PaymentTerm_ID, p.PO_PaymentMethod_ID
FROM C_BPartner p
WHERE p.C_BPartner_ID = ?
]]>
@@ -375,8 +375,10 @@
DATEORDERED, DATEPROMISED, DATEACCT, C_BPARTNER_ID,
C_BPARTNER_LOCATION_ID, BILLTO_ID, C_CURRENCY_ID,
PAYMENTRULE, C_PAYMENTTERM_ID, INVOICERULE, DELIVERYRULE,
FREIGHTCOSTRULE,
DELIVERYVIARULE, M_WAREHOUSE_ID, M_PRICELIST_ID,
- C_PROJECT_ID, C_ACTIVITY_ID, C_CAMPAIGN_ID, PRIORITYRULE, ISSOTRX)
- VALUES
(?,?,?,now(),?,now(),?,?,?,?,?,?,TO_DATE(?),TO_DATE(?),TO_DATE(?),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'5',
'N')
+ C_PROJECT_ID, C_ACTIVITY_ID, C_CAMPAIGN_ID, PRIORITYRULE, ISSOTRX,
+ FIN_PAYMENTMETHOD_ID)
+ VALUES
(?,?,?,now(),?,now(),?,?,?,?,?,?,TO_DATE(?),TO_DATE(?),TO_DATE(?),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,'5',
'N',
+ ?)
]]>
</Sql>
<Parameter name="cOrderId"/>
@@ -407,6 +409,7 @@
<Parameter name="cProjectId"/>
<Parameter name="cActivityId"/>
<Parameter name="cCampaignId"/>
+ <Parameter name="finPaymentMethodId"/>
</SqlMethod>
<SqlMethod name="insertCOrderline" type="preparedStatement"
connection="true" return="rowCount">
<SqlMethodComment></SqlMethodComment>
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
