details: /erp/devel/pi/rev/c358c1e82f10
changeset: 7873:c358c1e82f10
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Tue Jul 13 15:58:25 2010 +0530
summary: Fixes issue 13816: error when processing purchasing plan indicating
Business Partner and Product Category
Two new AND clause has been introduced in order to make sure the lines created
are belongs to the selected product category
diffstat:
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diffs (19 lines):
diff -r 70088676c5b2 -r c358c1e82f10
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
--- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Tue Jul 13
10:27:32 2010 +0200
+++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Tue Jul 13
15:58:25 2010 +0530
@@ -110,6 +110,7 @@
--AND C_Order_Status(o.C_ORDER_ID)
IN (1, 2, 3)
AND o.PROCESSED = 'Y'
AND ol.QTYORDERED <>
ol.QTYDELIVERED
+ AND ol.m_product_id =
p.m_product_id
AND ol.DatePromised IS NOT NULL
AND Mrp_Check_Planningmethod(
COALESCE(po.MRP_PlanningMethod_ID, p.MRP_PlanningMethod_ID),
@@ -120,6 +121,7 @@
WHERE sf.MRP_SALESFORECAST_ID =
sfl.MRP_SALESFORECAST_ID
AND sf.IsActive = 'Y'
AND sf.C_BPARTNER_ID =
p_BPartner_ID
+ AND sfl.m_product_id =
p.m_product_id
AND Mrp_Check_Planningmethod(
COALESCE(po.MRP_PlanningMethod_ID, p.MRP_PlanningMethod_ID),
'SF',
TO_NUMBER(sfl.DatePlanned - p_PlanningDate), p_TimeHorizon) <> -1
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
