details: /erp/devel/pi/rev/f90ffc74fb0a
changeset: 8020:f90ffc74fb0a
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Thu Aug 05 11:42:54 2010 +0530
summary: Fixes issue 13685: volume discount wrongly calculated even for
products which is not included while defining volume discount.
diffstat:
src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml | 6 ------
1 files changed, 0 insertions(+), 6 deletions(-)
diffs (16 lines):
diff -r eb7b40bb1ecb -r f90ffc74fb0a
src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml
--- a/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml Wed Aug
04 13:13:08 2010 +0200
+++ b/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml Thu Aug
05 11:42:54 2010 +0530
@@ -273,12 +273,6 @@
(SELECT M_PRODUCT_CATEGORY_ID
FROM M_RAPPEL_PRODUCTCATEGORY RC
WHERE RC.M_RAPPEL_ID=R.M_RAPPEL_ID
- ))
- OR(COALESCE(R.INCLUDE_PRODUCT_CATEGORY, 'Y')='Y'
- AND P.M_PRODUCT_CATEGORY_ID NOT IN
- (SELECT M_PRODUCT_CATEGORY_ID
- FROM M_RAPPEL_PRODUCTCATEGORY RC
- WHERE RC.M_RAPPEL_ID=R.M_RAPPEL_ID
)))
UNION
SELECT M_PRODUCT_ID
------------------------------------------------------------------------------
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://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits