0015363: Error in message obtained when processing Bank Statement

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015363

Openbravo ERP

09. Financial management

public

2010-12-02 19:44

2010-12-25 00:00

Reporter

maite

Assigned To

dalsasua

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

2.40MP12

Target Version

2.40MP13

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

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