details: https://code.openbravo.com/erp/devel/pi/rev/f40da034b00f
changeset: 16745:f40da034b00f
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Thu May 31 17:34:22 2012 +0200
summary: Fixes issue 20436: Purchasing tab process does not take into account
discontinued configuration.
diffstat:
src-db/database/model/functions/MRP_PURCHASEPLAN.xml | 1 +
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml | 1 +
src-db/database/sourcedata/AD_COLUMN.xml | 2 +-
src-db/database/sourcedata/AD_FIELD.xml | 4 ++--
4 files changed, 5 insertions(+), 3 deletions(-)
diffs (55 lines):
diff -r b918c284db12 -r f40da034b00f
src-db/database/model/functions/MRP_PURCHASEPLAN.xml
--- a/src-db/database/model/functions/MRP_PURCHASEPLAN.xml Tue Jun 05
11:53:09 2012 +0200
+++ b/src-db/database/model/functions/MRP_PURCHASEPLAN.xml Thu May 31
17:34:22 2012 +0200
@@ -85,6 +85,7 @@
FROM M_PRODUCT_PO
WHERE ISCURRENTVENDOR = 'Y'
AND (p_Vendor_ID IS NULL OR M_PRODUCT_PO.C_BPARTNER_ID =
p_Vendor_ID)
+ AND M_PRODUCT_PO.DISCONTINUED = 'N'
GROUP BY M_PRODUCT_ID) PRODUCT_PO --CASE WITH MORE THAN ONE
DEFAULT VENDOR
WHERE MRP_RUN_PURCHASE_ID = p_Run_ID
AND M_PRODUCT.M_PRODUCT_ID = M_PRODUCT_PO.M_PRODUCT_ID
diff -r b918c284db12 -r f40da034b00f
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
--- a/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Tue Jun 05
11:53:09 2012 +0200
+++ b/src-db/database/model/functions/MRP_RUN_INITIALIZE.xml Thu May 31
17:34:22 2012 +0200
@@ -99,6 +99,7 @@
AND M_PRODUCT_PO.C_BPARTNER_ID =
p_Vendor_ID
AND M_PRODUCT_PO.ISCURRENTVENDOR =
'Y'
AND M_PRODUCT_PO.ISACTIVE = 'Y'
+ AND M_PRODUCT_PO.DISCONTINUED = 'N'
)))
AND (p_BPartner_ID IS NULL
OR EXISTS (SELECT 1
diff -r b918c284db12 -r f40da034b00f src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Jun 05 11:53:09 2012 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu May 31 17:34:22 2012 +0200
@@ -39849,7 +39849,7 @@
<!--2712--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
<!--2712--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
<!--2712--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--2712--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2712--> <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS>
<!--2712--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--2712--> <POSITION><![CDATA[23]]></POSITION>
<!--2712--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
diff -r b918c284db12 -r f40da034b00f src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Tue Jun 05 11:53:09 2012 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Thu May 31 17:34:22 2012 +0200
@@ -27101,7 +27101,7 @@
<!--2312--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
<!--2312--> <AD_TAB_ID><![CDATA[239]]></AD_TAB_ID>
<!--2312--> <AD_COLUMN_ID><![CDATA[2712]]></AD_COLUMN_ID>
-<!--2312--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--2312--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
<!--2312--> <DISPLAYLOGIC><![CDATA[@Discontinued@='Y']]></DISPLAYLOGIC>
<!--2312--> <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
<!--2312--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
@@ -27109,7 +27109,7 @@
<!--2312--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
<!--2312--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--2312--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--2312--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--2312--> <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
<!--2312--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
<!--2312--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--2312--> <GRID_SEQNO><![CDATA[200]]></GRID_SEQNO>
------------------------------------------------------------------------------
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
