details: https://code.openbravo.com/erp/stable/2.50/rev/5261a6a48f66
changeset: 9762:5261a6a48f66
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Dec 02 14:02:58 2011 +0100
summary: Fixes issue 19199: There is a column not implemented with code
related
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 18 ++++++++++--------
src-db/database/sourcedata/AD_FIELD.xml | 2 +-
2 files changed, 11 insertions(+), 9 deletions(-)
diffs (47 lines):
diff -r e621214afca2 -r 5261a6a48f66
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Thu Dec 01
10:26:22 2011 +0100
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Fri Dec 02
14:02:58 2011 +0100
@@ -763,9 +763,10 @@
END LOOP;
IF (v_IsSOTrx='Y') THEN
-- Undo revenue and credit limit
- UPDATE C_BPARTNER
- SET ActualLifeTimeValue=ActualLifeTimeValue -(v_Multiplier *
C_Base_Convert(v_GrandTotal, v_Currency_ID, v_Client_ID, v_DateAcct, v_Org_ID))
- WHERE C_BPartner_ID=v_BPartner_ID;
+ --The next lines (3) have been commented due to the issue 19199
+ --UPDATE C_BPARTNER
+ --SET ActualLifeTimeValue=ActualLifeTimeValue -(v_Multiplier *
C_Base_Convert(v_GrandTotal, v_Currency_ID, v_Client_ID, v_DateAcct, v_Org_ID))
+ --WHERE C_BPartner_ID=v_BPartner_ID;
FOR Cur_ReactivateInvoiceLine IN
(SELECT C_InvoiceLine_ID, C_Orderline_ID, M_InoutLine_ID, QtyInvoiced
FROM C_INVOICELINE
@@ -1266,11 +1267,12 @@
WHERE AD_User_ID=v_BPartner_User_ID;
-- Update total revenue and credit limit
-- It is reversed in C_Allocation_Trg
- IF (v_IsSOTrx='Y') THEN
- UPDATE C_BPARTNER
- SET ActualLifeTimeValue=ActualLifeTimeValue +(v_Multiplier *
C_Base_Convert(v_GrandTotal, v_Currency_ID, v_Client_ID, v_DateAcct, v_Org_ID))
- WHERE C_BPartner_ID=v_BPartner_ID;
- END IF;
+ --The next lines (5) have been commented due to the issue 19199
+ --IF (v_IsSOTrx='Y') THEN
+ --UPDATE C_BPARTNER
+ --SET ActualLifeTimeValue=ActualLifeTimeValue +(v_Multiplier *
C_Base_Convert(v_GrandTotal, v_Currency_ID, v_Client_ID, v_DateAcct, v_Org_ID))
+ --WHERE C_BPartner_ID=v_BPartner_ID;
+ --END IF;
END IF;--FINISH_PROCESS
IF (NOT FINISH_PROCESS AND NOT END_PROCESSING) THEN
/**************************************************************************
diff -r e621214afca2 -r 5261a6a48f66 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Thu Dec 01 10:26:22 2011 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml Fri Dec 02 14:02:58 2011 +0100
@@ -22528,7 +22528,7 @@
<!--2128--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
<!--2128--> <AD_TAB_ID><![CDATA[220]]></AD_TAB_ID>
<!--2128--> <AD_COLUMN_ID><![CDATA[2925]]></AD_COLUMN_ID>
-<!--2128--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--2128--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
<!--2128--> <DISPLAYLOGIC><![CDATA[@IsProspect@='Y']]></DISPLAYLOGIC>
<!--2128--> <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
<!--2128--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
