0015518: Error in message obtained when processing Bank Statement

Description

Under some conditions, error "In line the debt payment has a change status later than the selected Account Date" is thrown which is wrongly composed because it does not indicate line number

Steps To Reproduce

1. Sales Management || Transactions || Sales Invoice || Header : create invoice with date 02/12/2010, document type "AR Invoice" and any line and COMPLETE it
2. Financial Management || Receivables & Payables || Transactions || Remittance || Header : create remittance for date 02/12/2010 and pressing "create lines from" choose payment associated to previous invoice. Process remittance
3. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create bank statement with date 01/12/2010 and "pressing create lines from" choose negative payment associated to the remmitance
4. Try to process Bank Statement and you will obtain:
error "In line the debt payment has a change status later than the selected Account Date"
without indicating line number

Error is located in C_DP_MANAGEMENT_POST in query
IF(NOT FINISH_PROCESS) THEN
      SELECT count(*), MAX(ml.line)
      INTO v_Aux, v_line
      FROM C_DP_ManagementLine ml,
        C_DP_Management m
      WHERE ml.C_DP_Management_ID=m.C_DP_Management_ID
        AND m.C_DP_Management_ID=v_Record_ID
        AND exists
        (SELECT 1
        FROM C_DP_ManagementLine ml1,
          C_DP_Management m1
        WHERE m1.C_DP_Management_ID=ml1.C_DP_Management_ID
          AND ml1.C_Debt_Payment_ID=ml.C_Debt_Payment_ID
          AND m1.processed='Y'
          AND m1.DateAcct>m.DateAcct
        )
        ;
      if v_Aux!=0 then

       RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@LaterChangeStatus@') ;
      end if;
    END IF;--FINISH_PROCESS

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	backport	0015526	2.50MP26	closed	dalsasua	error message is wrong to process a bank statement
blocks	defect	0015363	2.40MP13	closed	dalsasua	Error in message obtained when processing Bank Statement

Notes
(0033561) hgbot (developer) 2011-01-10 12:04	Repository: erp/stable/2.50 Changeset: e0d091677fc6f126539cc286189a07f1e90897fc Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Mon Jan 10 12:03:29 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/e0d091677fc6f126539cc286189a07f1e90897fc [^] Fixes issue 15518: Error in message obtained when processing Bank St. --- M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml M src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml M src-db/database/sourcedata/AD_MESSAGE.xml ---

Issue History
Date Modified	Username	Field	Change
2010-12-23 18:24	dalsasua	Type	defect => backport
2010-12-23 18:24	dalsasua	fix_in_branch	=> 2.50
2011-01-10 12:04	hgbot	Checkin
2011-01-10 12:04	hgbot	Note Added: 0033561
2011-01-10 12:04	hgbot	Status	scheduled => resolved
2011-01-10 12:04	hgbot	Resolution	open => fixed
2011-01-10 12:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/e0d091677fc6f126539cc286189a07f1e90897fc [^]
2011-01-27 18:41	psarobe	Status	resolved => closed
2011-01-28 10:33	dalsasua	Relationship added	related to 0015526