details: /erp/devel/main/rev/877040d09dc4
changeset: 6488:877040d09dc4
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Wed Feb 24 12:08:38 2010 +0100
summary: fixes issue 12366
trigger was affecting the Create Sales Orders from Expenses window
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diffs (30 lines):
diff -r 2ce2b4a5bd16 -r 877040d09dc4
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
Tue Feb 23 17:50:44 2010 +0100
+++ b/src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
Wed Feb 24 12:08:38 2010 +0100
@@ -157,7 +157,7 @@
C_UOM_ID, QTYORDERED, C_CURRENCY_ID,
PRICELIST, PRICEACTUAL, PRICELIMIT,
C_TAX_ID, S_RESOURCEASSIGNMENT_ID, DISCOUNT,
- PRICESTD)
+ PRICESTD, LINENETAMT)
VALUES
(?,?,?,
now(),?,now(),?,
@@ -167,7 +167,7 @@
?,TO_NUMBER(?),?,
TO_NUMBER(?),
M_GET_OFFERS_PRICE(to_date(?),?,?,TO_NUMBER(?),TO_NUMBER(?),?),TO_NUMBER(?),
?, ?,TO_NUMBER(?),
- TO_NUMBER(?))
+ TO_NUMBER(?), (to_number(?) * to_number(?)))
]]>
</Sql>
<Parameter name="cOrderlineId"/>
@@ -199,6 +199,8 @@
<Parameter name="sResourceassignmentId"/>
<Parameter name="discount"/>
<Parameter name="priceactual"/>
+ <Parameter name="qtyordered"/>
+ <Parameter name="priceactual"/>
</SqlMethod>
<SqlMethod name="cDoctypeTarget" type="preparedStatement" connection="true"
return="string" default="">
<SqlMethodComment></SqlMethodComment>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
