details: http://code.openbravo.com/erp/devel/main/rev/7ddd0f166bf0
changeset: 3526:7ddd0f166bf0
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Apr 03 12:13:43 2009 +0200
summary: Fixed bug 8105. Added a filter by ad_client_id in the cursors so
only costs of current client are calculated.
diffstat:
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diffs (29 lines):
diff -r 76bd2a58e42d -r 7ddd0f166bf0
src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
--- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Thu Apr
02 15:05:34 2009 +0200
+++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Fri Apr
03 12:13:43 2009 +0200
@@ -87,7 +87,8 @@
WHERE ISPERMANENT='N'
AND ISMANUAL='N'
AND COSTTYPE='AV'
- AND ISPRODUCTION = 'N';
+ AND ISPRODUCTION = 'N'
+ AND AD_CLIENT_ID = v_Client;
v_rowcount:=SQL%ROWCOUNT;
v_Deleted:=v_Deleted + v_rowcount;
v_rowcount:=SQL%ROWCOUNT;
@@ -96,6 +97,7 @@
FOR Cur_ManualCost IN
(SELECT M_COSTING_ID, M_PRODUCT_ID, DATEFROM
FROM M_COSTING
+ WHERE AD_CLIENT_ID = v_Client
ORDER BY M_PRODUCT_ID, DATEFROM DESC) LOOP
IF (v_ProductOld <> Cur_ManualCost.M_PRODUCT_ID) THEN
v_Date := TO_DATE('31-12-9999', 'DD-MM-YYYY');
@@ -119,6 +121,7 @@
AND M_INOUT.PROCESSED='Y'
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 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
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
