details: http://code.openbravo.com/erp/devel/pi/rev/79c84bba17f3
changeset: 3265:79c84bba17f3
user: Eduardo Argal Guibert <eduardo.ar...@openbravo.com>
date: Fri Feb 27 17:05:58 2009 +0100
description:
Fixes bug 0007810: A posted manual settlement causes an uncorrect accounting
situation
diffs (65 lines):
diff -r 309965dd1e4a -r 79c84bba17f3
src-db/database/model/functions/C_SETTLEMENT_POST.xml
--- a/src-db/database/model/functions/C_SETTLEMENT_POST.xml Fri Feb 27
17:08:27 2009 +0100
+++ b/src-db/database/model/functions/C_SETTLEMENT_POST.xml Fri Feb 27
17:05:58 2009 +0100
@@ -303,6 +303,22 @@
END IF;
END IF;--FINISH_PROCESS
+ IF(NOT FINISH_PROCESS) THEN
+ /*
+ * Checking Restrictions
+ */
+ v_ResultStr:='CheckingRestrictions - C_DEBT_PAYMENT MANUAL IS NOT
SPLIT';
+ SELECT COUNT(*), AD_COLUMN_IDENTIFIER_STD ('C_Debt_Payment',
TO_CHAR(MAX(c.C_Debt_Payment_Id)))
+ INTO v_Aux, v_column_identifier
+ FROM C_DEBT_PAYMENT c
+ WHERE c.C_SETTLEMENT_CANCEL_ID=v_Record_ID
+ AND c.ISMANUAL = 'Y'
+ AND c.ISPAID = 'N';
+ IF v_Aux>0 THEN
+ RAISE '@ManualDebtpayment@'||' "'||v_column_identifier||'"
'||'@CanNotBeSplit@';
+ END IF;
+ END IF;--FINISH_PROCESS
+
IF(NOT FINISH_PROCESS) THEN
v_ResultStr:='CheckingRestrictions - C_DEBT_PAYMENT ORG IS IN
C_SETTLEMENT ORG TREE';
diff -r 309965dd1e4a -r 79c84bba17f3 src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Fri Feb 27 17:08:27 2009 +0100
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Fri Feb 27 17:05:58 2009 +0100
@@ -63470,6 +63470,17 @@
<!--33ED747B6F0B4F27B0000B5F1818F8BB-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--33ED747B6F0B4F27B0000B5F1818F8BB--></AD_MESSAGE>
+<!--34666DED1BD5497CB1B5E39A4307E781--><AD_MESSAGE>
+<!--34666DED1BD5497CB1B5E39A4307E781-->
<AD_MESSAGE_ID><![CDATA[34666DED1BD5497CB1B5E39A4307E781]]></AD_MESSAGE_ID>
+<!--34666DED1BD5497CB1B5E39A4307E781-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--34666DED1BD5497CB1B5E39A4307E781--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--34666DED1BD5497CB1B5E39A4307E781--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--34666DED1BD5497CB1B5E39A4307E781-->
<VALUE><![CDATA[ManualDebtpayment]]></VALUE>
+<!--34666DED1BD5497CB1B5E39A4307E781--> <MSGTEXT><![CDATA[This manual
payment]]></MSGTEXT>
+<!--34666DED1BD5497CB1B5E39A4307E781--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--34666DED1BD5497CB1B5E39A4307E781-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--34666DED1BD5497CB1B5E39A4307E781--></AD_MESSAGE>
+
<!--362978666B7D40CBB234EDEB09057CBB--><AD_MESSAGE>
<!--362978666B7D40CBB234EDEB09057CBB-->
<AD_MESSAGE_ID><![CDATA[362978666B7D40CBB234EDEB09057CBB]]></AD_MESSAGE_ID>
<!--362978666B7D40CBB234EDEB09057CBB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -63658,6 +63669,17 @@
<!--55F87823043F485082AE98D29F5A997D-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--55F87823043F485082AE98D29F5A997D--></AD_MESSAGE>
+<!--570FBA13196A4136A3E36AFC0EFF0948--><AD_MESSAGE>
+<!--570FBA13196A4136A3E36AFC0EFF0948-->
<AD_MESSAGE_ID><![CDATA[570FBA13196A4136A3E36AFC0EFF0948]]></AD_MESSAGE_ID>
+<!--570FBA13196A4136A3E36AFC0EFF0948-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--570FBA13196A4136A3E36AFC0EFF0948--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--570FBA13196A4136A3E36AFC0EFF0948--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--570FBA13196A4136A3E36AFC0EFF0948-->
<VALUE><![CDATA[CanNotBeSplit]]></VALUE>
+<!--570FBA13196A4136A3E36AFC0EFF0948--> <MSGTEXT><![CDATA[can not be split,
as it may cause inconsistent data in accounting. Please, reactivate the manual
settlement were it was created and split it there.]]></MSGTEXT>
+<!--570FBA13196A4136A3E36AFC0EFF0948--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--570FBA13196A4136A3E36AFC0EFF0948-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--570FBA13196A4136A3E36AFC0EFF0948--></AD_MESSAGE>
+
<!--57901FDF810046F3A5C6DFCC31C0665E--><AD_MESSAGE>
<!--57901FDF810046F3A5C6DFCC31C0665E-->
<AD_MESSAGE_ID><![CDATA[57901FDF810046F3A5C6DFCC31C0665E]]></AD_MESSAGE_ID>
<!--57901FDF810046F3A5C6DFCC31C0665E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
