0015363: 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 ]

depends on	backport	0015517	2.40MP13	closed	dalsasua	Error in message obtained when processing Bank Statement
depends on	backport	0015518	2.40MP13	closed	dalsasua	Error in message obtained when processing Bank Statement

Notes
(0033388) dalsasua (reporter) 2010-12-24 13:34	In 3.0 Remittances do not exist any more.

Issue History
Date Modified	Username	Field	Change
2010-12-02 19:44	maite	New Issue
2010-12-02 19:44	maite	Assigned To	=> dalsasua
2010-12-02 19:44	maite	Modules	=> Core
2010-12-23 18:24	dalsasua	Steps to Reproduce Updated	View Revisions
2010-12-23 18:24	dalsasua	Status	new => scheduled
2010-12-23 18:24	dalsasua	fix_in_branch	=> pi
2010-12-24 13:34	dalsasua	Note Added: 0033388
2010-12-24 13:34	dalsasua	Status	scheduled => closed
2010-12-24 13:34	dalsasua	Resolution	open => no change required
2010-12-25 00:00	anonymous	sf_bug_id	0 => 3143688