Fixes issue 13605: Wrong behaviour in production with products with 'stocked' unchecked
authorSivaraman Rajagopal <sivaraman.rajagopal@openbravo.com>
Wed, 16 Jun 2010 16:59:31 +0530
changeset 7675 1cd1fa208bcc
parent 7674 2d363b75144f
child 7676 e6a6e9dcefab
child 7763 9e7ab50c3fa7
Fixes issue 13605: Wrong behaviour in production with products with 'stocked' unchecked

Change is added in MA_WORKEFFORT_VALIDATE.xml that restricts M_Transaction not to be inserted when we validate work effort for Not-Stocked products.
src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
--- a/src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml	Wed Jun 16 16:26:13 2010 +0530
+++ b/src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml	Wed Jun 16 16:59:31 2010 +0530
@@ -263,6 +263,7 @@
           AND pp.M_ProductionPlan_ID=pl.M_ProductionPlan_ID
           AND pp.M_Production_ID=v_Record_ID
           AND pl.M_PRODUCT_ID=pr.M_PRODUCT_ID
+          AND pr.ISSTOCKED='Y'
         ORDER BY pp.Line, pl.Line)
       LOOP
         -- M_ProductionLine_ID, AD_Client_ID, AD_Org_ID, MovementDate, M_Product_ID, MovementQty, M_Locator_ID