Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015526Openbravo ERP09. Financial managementpublic2010-12-24 14:182011-01-28 12:23
Reportermalsasua 
Assigned Todalsasua 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP24 
Target Version2.50MP26Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015526: error message is wrong to process a bank statement
Descriptionwhen 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
TagsNo tags attached.
Relationships
related to backport 00155182.40MP13 closed dalsasua Error in message obtained when processing Bank Statement 
depends on defect 0015612 closed dalsasua error message is wrong to process a bank statement 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-24 14:18malsasuaNew Issue
2010-12-24 14:18malsasuaAssigned To => dalsasua
2010-12-24 14:18malsasuaModules => Core
2010-12-24 14:18malsasuaOBNetwork customer => Yes
2011-01-11 13:10adrianromeroStatusnew => scheduled
2011-01-11 13:10adrianromerofix_in_branch => pi
2011-01-11 13:11adrianromeroTypedefect => backport
2011-01-11 13:11adrianromerofix_in_branchpi =>
2011-01-11 13:12adrianromeroIssue cloned0015612
2011-01-11 13:12adrianromeroRelationship addeddepends on 0015612
2011-01-28 09:21dalsasuafix_in_branch => 2.50
2011-01-28 10:33dalsasuaRelationship addedrelated to 0015518
2011-01-28 12:23malsasuaNote Added: 0033951
2011-01-28 12:23malsasuaStatusscheduled => closed
2011-01-28 12:23malsasuaResolutionopen => duplicate

Notes
(0033951)
malsasua   
2011-01-28 12:23   
the problem was solved with fix https://issues.openbravo.com/view.php?id=15518 [^]