0015612: error message is wrong to process a bank statement

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0015612

Openbravo ERP

09. Financial management

public

2011-01-11 13:12

2011-01-29 00:00

Reporter

adrianromero

Assigned To

dalsasua

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Community Appliance

Product Version

3.0RC3

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0015612: error message is wrong to process a bank statement

Description

when you try process a bank statement, with a debt payment created by remittance (a debt payment negative ), and the initial debt payment of remittance has been cancelled, the system returns :"ERROR:"

Steps To Reproduce

. create and process a new sales invoice, date 01/12/2010
a debt payment is generated: DP1 (amount 10)

. create a consolidated remittance (date 05/12/2010) and add DP1 debt payment.
. process remittance.
a debt payment is generated: -DP1 (amount -10)

. create a new settlement (date 10/12/2010) and add the initial debt payment DP1
. process settlement

. create a new bankstatement (date 15/12/2010) and add the debt payment generated in remittance (-DP1)
. process bankstatement
error is returned: "ERROR: "

Proposed Solution

. in line 157 of c_dp_management_post , v_line is null
replace RAISE EXCEPTION '%', '@Inline@'||v_line||' '||'@debtpayment@'||' '||'@ConciliatedDebtPaymentCancel@'||v_documentno_Settlement||' '||'@Bydate@'||v_dateSettlement ; --OBTG:-20000--
by
RAISE EXCEPTION '%', '@Inline@'|| coalesce(v_line,0)||' '||'@debtpayment@'||' '||'@ConciliatedDebtPaymentCancel@'||v_documentno_Settlement||' '||'@Bydate@'||v_dateSettlement ; --OBTG:-20000--

Additional Information