fixes issue 12366
authorDavid Alsasua <david.alsasua@openbravo.com>
Wed, 24 Feb 2010 12:08:38 +0100
changeset 6522 032a222bb905
parent 6521 f1b39044e9e9
child 6523 b7f2cd7f9e22
fixes issue 12366
trigger was affecting the Create Sales Orders from Expenses window
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql	Wed Feb 24 10:52: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>