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