details: https://code.openbravo.com/erp/devel/pi/rev/cbfed8a6d9a0
changeset: 21412:cbfed8a6d9a0
user: Victor Villar <victor.villar <at> openbravo.com>
date: Mon Nov 04 17:57:05 2013 +0100
summary: Fixed issue 25074:the standard cost is taking
into account the wrong price list for consumed products
diffstat:
src-db/database/model/functions/M_GET_PRODUCT_PRICE_DATE.xml | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diffs (19 lines):
diff -r 829c47df5f1c -r cbfed8a6d9a0
src-db/database/model/functions/M_GET_PRODUCT_PRICE_DATE.xml
--- a/src-db/database/model/functions/M_GET_PRODUCT_PRICE_DATE.xml Fri Nov
01 01:07:00 2013 +0100
+++ b/src-db/database/model/functions/M_GET_PRODUCT_PRICE_DATE.xml Mon Nov
04 17:57:05 2013 +0100
@@ -43,6 +43,7 @@
WHERE ISDEFAULT = 'Y'
AND AD_CLIENT_ID = p_AD_Client_ID
AND ISACTIVE = 'Y'
+ AND ISSOPRICELIST='N'
)
AND VALIDFROM =
(SELECT max(VALIDFROM)
@@ -53,6 +54,7 @@
WHERE ISDEFAULT = 'Y'
AND AD_CLIENT_ID = p_AD_Client_ID
AND ISACTIVE = 'Y'
+ AND ISSOPRICELIST='N'
)
AND TO_DATE(VALIDFROM) <= TO_DATE(COALESCE(p_Date, now()))
AND EXISTS(SELECT 1
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
