details: /erp/devel/pi/rev/cfa473aebc99
changeset: 8263:cfa473aebc99
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Wed Sep 01 19:24:34 2010 +0200
summary: Fixed issue 14393.Fixed clause to consider only products that are
used and not other produced products.
details: /erp/devel/pi/rev/9e696678cdb0
changeset: 8264:9e696678cdb0
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Wed Sep 01 19:41:17 2010 +0200
summary: Fixed issue 14392.Do not allow negative values con quantity columns
of ma_workrequirement and ma_wrphase tables.
details: /erp/devel/pi/rev/59b8fae9af7e
changeset: 8265:59b8fae9af7e
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Wed Sep 01 19:42:34 2010 +0200
summary: Fixed issue 14394.Do not consider work requirements with more done
quantity than expected.
diffstat:
src-db/database/model/functions/MRP_PROCESSPLAN.xml | 4 +++-
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml | 1 +
src-db/database/sourcedata/AD_COLUMN.xml | 2 ++
3 files changed, 6 insertions(+), 1 deletions(-)
diffs (44 lines):
diff -r 5ae34f00e40f -r 59b8fae9af7e
src-db/database/model/functions/MRP_PROCESSPLAN.xml
--- a/src-db/database/model/functions/MRP_PROCESSPLAN.xml Thu Sep 02
09:22:45 2010 +0200
+++ b/src-db/database/model/functions/MRP_PROCESSPLAN.xml Wed Sep 01
19:42:34 2010 +0200
@@ -118,7 +118,9 @@
AND pl.MRP_RUN_PRODUCTION_ID = p_Run_ID
AND pl.M_PRODUCT_ID =
MRP_RUN_PRODUCTIONLINE.M_PRODUCT_ID
AND parent.isplanned = 'N'
- AND pl.qty < 0 )
+ AND pl.isfixed = 'Y'
+ AND ((pl.qty < 0 and parent.qty > 0 ) OR (pl.qty
> 0 AND parent.qty < 0)))
+
ORDER BY planneddate
) LOOP
v_Planned := 'Y';
diff -r 5ae34f00e40f -r 59b8fae9af7e
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
--- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Thu Sep 02
09:22:45 2010 +0200
+++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Wed Sep 01
19:42:34 2010 +0200
@@ -212,6 +212,7 @@
WHERE WR.MA_WORKREQUIREMENT_ID =
WP.MA_WORKREQUIREMENT_ID
AND WP.MA_WRPHASE_ID = WPP.MA_WRPHASE_ID
AND WR.CLOSED = 'N'
+ AND WP.donequantity < WP.quantity
AND WPP.M_PRODUCT_ID =
Cur_Product.M_Product_ID
AND TO_NUMBER(WR.ENDDATE - p_PlanningDate) <
p_TimeHorizon
AND
Mrp_Check_Planningmethod(Cur_Product.MRP_PlanningMethod_ID, 'WR',
diff -r 5ae34f00e40f -r 59b8fae9af7e src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Sep 02 09:22:45 2010 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Sep 01 19:42:34 2010 +0200
@@ -197600,6 +197600,7 @@
<!--801559--> <SEQNO><![CDATA[110]]></SEQNO>
<!--801559--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
<!--801559--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--801559--> <VALUEMIN><![CDATA[0]]></VALUEMIN>
<!--801559--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
<!--801559--> <AD_ELEMENT_ID><![CDATA[800315]]></AD_ELEMENT_ID>
<!--801559--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
@@ -198105,6 +198106,7 @@
<!--801575--> <SEQNO><![CDATA[120]]></SEQNO>
<!--801575--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
<!--801575--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--801575--> <VALUEMIN><![CDATA[0]]></VALUEMIN>
<!--801575--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
<!--801575--> <AD_ELEMENT_ID><![CDATA[800315]]></AD_ELEMENT_ID>
<!--801575--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
