details: /erp/devel/pi/rev/2c1319271a23
changeset: 9070: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
diffstat:
src-db/database/model/functions/C_GENERATESOFROMPROJECTPHASE.xml | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (30 lines):
diff -r ee0cf8460654 -r 2c1319271a23
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:53:54 2010 +0530
@@ -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
);
------------------------------------------------------------------------------
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
