details: /erp/devel/main/rev/2c1319271a23
changeset: 9081:2c1319271a23
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Wed Dec 08 09:53:54 2010 +0530
summary: Fixes Issue 14994: Field \"Order Reference\" in Multiphase Project
is not used when creating Orders
Solution:
The INSERT query has been modified in order to use Order Reference value in
Sales Order creation.
Impacts:
None
details: /erp/devel/main/rev/5535c247b006
changeset: 9082:5535c247b006
user: RM packaging bot <staff.rm <at> openbravo.com>
date: Wed Dec 08 09:55:50 2010 +0000
summary: CI: promote changesets from pi to main
diffstat:
src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml | 6 +++---
src-db/database/sourcedata/AD_MODULE.xml | 4 ++--
2 files changed, 5 insertions(+), 5 deletions(-)
diffs (51 lines):
diff -r ee0cf8460654 -r 5535c247b006
src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml
--- a/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml Tue Dec
07 19:30:39 2010 +0100
+++ b/src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml Wed Dec
08 09:55:50 2010 +0000
@@ -79,7 +79,7 @@
P.C_CURRENCY_ID, P.PAYMENTRULE, P.C_PAYMENTTERM_ID,
P.M_WAREHOUSE_ID, P.SALESREP_ID,
P.BILLTO_ID, P.C_CAMPAIGN_ID, P.C_PROJECT_ID, P.AD_USER_ID,
P.DESCRIPTION, P.PROJECTSTATUS,
PP.NAME AS PHASE_NAME, PP.AD_CLIENT_ID, PP.AD_ORG_ID,
OI.C_LOCATION_ID AS ORGLOCATIONID,
- P.FIN_PAYMENTMETHOD_ID
+ P.FIN_PAYMENTMETHOD_ID, P.POREFERENCE
FROM C_PROJECT P,
C_PROJECTPHASE PP,
M_PRICELIST PL,
@@ -150,7 +150,7 @@
TOTALLINES, GRANDTOTAL, M_WAREHOUSE_ID, M_PRICELIST_ID,
ISTAXINCLUDED, POSTED, PROCESSING, SALESREP_ID,
BILLTO_ID, C_CAMPAIGN_ID, C_PROJECT_ID, AD_USER_ID,
- COPYFROM, DATEPROMISED, DESCRIPTION, FIN_PAYMENTMETHOD_ID
+ COPYFROM, DATEPROMISED, DESCRIPTION, FIN_PAYMENTMETHOD_ID,
POREFERENCE
)
VALUES
(
@@ -164,7 +164,7 @@
'N', 'N', 'N', Cur_SO.SALESREP_ID,
v_Billto_ID, Cur_SO.C_CAMPAIGN_ID, Cur_SO.C_PROJECT_ID,
Cur_SO.AD_User_ID,
'N', TRUNC(now(), 'DD'), Cur_SO.PHASE_NAME || ' - ' ||
COALESCE(TO_CHAR(Cur_SO.DESCRIPTION),''),
- COALESCE(Cur_SO.FIN_PAYMENTMETHOD_ID, v_fin_paymentmethod_id)
+ COALESCE(Cur_SO.FIN_PAYMENTMETHOD_ID, v_fin_paymentmethod_id),
Cur_SO.POREFERENCE
);
diff -r ee0cf8460654 -r 5535c247b006 src-db/database/sourcedata/AD_MODULE.xml
--- a/src-db/database/sourcedata/AD_MODULE.xml Tue Dec 07 19:30:39 2010 +0100
+++ b/src-db/database/sourcedata/AD_MODULE.xml Wed Dec 08 09:55:50 2010 +0000
@@ -6,7 +6,7 @@
<!--0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--0--> <NAME><![CDATA[Core]]></NAME>
-<!--0--> <VERSION><![CDATA[2.50.19053]]></VERSION>
+<!--0--> <VERSION><![CDATA[2.50.19081]]></VERSION>
<!--0--> <DESCRIPTION><![CDATA[Core module is the base one]]></DESCRIPTION>
<!--0--> <HELP><![CDATA[Core module is the base one, all developments in core
are included as part of the standard Openbravo ERP.]]></HELP>
<!--0--> <URL><![CDATA[www.openbravo.com]]></URL>
@@ -22,7 +22,7 @@
<!--0--> <ISTRANSLATIONMODULE><![CDATA[N]]></ISTRANSLATIONMODULE>
<!--0--> <HASREFERENCEDATA><![CDATA[Y]]></HASREFERENCEDATA>
<!--0--> <REFERENCEDATAINFO><![CDATA[Standard document types for orders,
invoices, etc. and settings]]></REFERENCEDATAINFO>
-<!--0--> <VERSION_LABEL><![CDATA[dev]]></VERSION_LABEL>
+<!--0--> <VERSION_LABEL><![CDATA[CI]]></VERSION_LABEL>
<!--0--> <ISCOMMERCIAL><![CDATA[N]]></ISCOMMERCIAL>
<!--0--></AD_MODULE>
------------------------------------------------------------------------------
What happens now with your Lotus Notes apps - do you make another costly
upgrade, or settle for being marooned without product support? Time to move
off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
use, and manage than apps on traditional platforms. Sign up for the Lotus
Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
