details: /erp/devel/pi/rev/ff9d8e6fe070
changeset: 7923:ff9d8e6fe070
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Tue Jul 27 17:11:31 2010 +0530
summary: Fixes Issue 14016: It is not possible save a line with a price
adjustment.
diffstat:
src-db/database/model/triggers/C_ORDERLINE_TRG2.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 6834c4694499 -r ff9d8e6fe070
src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
--- a/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml Tue Jul 27
10:12:49 2010 +0200
+++ b/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml Tue Jul 27
17:11:31 2010 +0530
@@ -184,7 +184,7 @@
VALUES
(v_OrderLine_Offer_ID, :NEW.AD_Client_ID, :NEW.AD_Org_ID,
:NEW.IsActive,
now(),:NEW.CreatedBy, now(),:NEW.UpdatedBy,
- :NEW.C_OrderLine_ID, v_lineno, Cur_Offer.M_Offer_Id,
ROUND(v_Price,v_Precision), ROUND(v_Amt,v_Precision));
+ :NEW.C_OrderLine_ID, v_lineno, Cur_Offer.M_Offer_Id,
COALESCE(ROUND(v_Price,v_Precision),0), COALESCE(ROUND(v_Amt,v_Precision),0));
v_Price := v_PriceNew;
END IF;
END LOOP;
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://ad.doubleclick.net/clk;226879339;13503038;l?
http://clk.atdmt.com/CRS/go/247765532/direct/01/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
