details: https://code.openbravo.com/erp/devel/pi/rev/441f08ff52d8
changeset: 17586:441f08ff52d8
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Aug 01 13:07:52 2012 +0200
summary: fixes issue 20926: Generate Average Cost process
should not consider elements in closed periods to be unposted
diffstat:
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diffs (11 lines):
diff -r dfffc79d0876 -r 441f08ff52d8
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
--- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Wed Aug
01 12:11:25 2012 +0200
+++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Wed Aug
01 13:07:52 2012 +0200
@@ -362,6 +362,7 @@
AND M_INOUTLINE.MOVEMENTQTY>0
AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND
M_INOUT.DOCSTATUS <> 'VO'
AND M_INOUT.AD_CLIENT_ID = v_Client
+ AND M_INOUT.MOVEMENTDATE >= v_MinDateCosting
AND NOT EXISTS
(SELECT 1 FROM M_COSTING WHERE
M_INOUTLINE_ID=M_INOUTLINE.M_INOUTLINE_ID)
ORDER BY M_PRODUCT.M_PRODUCT_ID, M_INOUT.MOVEMENTDATE,
M_INOUTLINE.MOVEMENTQTY DESC
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
