Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026960Openbravo ERPZ. Otherspublic2014-06-27 13:242014-08-08 18:54
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q4Fixed in Versionpi 
Merge Request Status
Review Assigned Tomaite
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026960: It is not possible to "unmatch" a split bank statement line
DescriptionNo error is shown to end-user but line is not unmatched if it is a split line
Steps To Reproduce1. Access Financial Account window and create new Bank Statement. Add Bank Statement Line with "Amount IN"=10. Process bank statement
2. Run "Add transaction" process and create GL item transaction with "Amount OUT"=2
3. Run "Match Statement" process and match previously created transaction and bank statement line. Line will be split. Press "OK" button to save reconciliation
4. Run "Match Statement" process again and try to unmatch cleared line. Process reconciliation and realize that line has not be unmatched. If you run "Match Statement" process again you will see line still matched.

Proposed SolutionReal problem is that when following statement is executed in database "delete from FIN_BankStatementLine where FIN_Bankstatementline_ID='XXXXX'" error @20501@ is obtained.

This deletion is executed in "mergeBankStatementLine" method --> line 1240 of MatchTransaction.java
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-27 13:24maiteNew Issue
2014-06-27 13:24maiteAssigned To => dmiguelez
2014-06-27 13:24maiteModules => Advanced Payables and Receivables Mngmt
2014-06-27 13:24maiteResolution time => 1406584800
2014-06-27 13:24maiteTriggers an Emergency Pack => No
2014-06-27 13:25maiteAssigned Todmiguelez => jonalegriaesarte
2014-06-27 13:25maiteIssue Monitored: networkb
2014-07-16 18:02maitePriorityurgent => immediate
2014-07-17 10:00AtulOpenbravoAssigned Tojonalegriaesarte => AtulOpenbravo
2014-07-17 10:01AtulOpenbravoStatusnew => scheduled
2014-07-17 10:01AtulOpenbravofix_in_branch => pi
2014-07-17 16:32jecharriIssue Monitored: jecharri
2014-07-28 09:54hgbotCheckin
2014-07-28 09:54hgbotNote Added: 0068902
2014-07-28 09:54hgbotStatusscheduled => resolved
2014-07-28 09:54hgbotResolutionopen => fixed
2014-07-28 09:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/714e8ad187a0417da9cba1f568b1e40d521ad699 [^]
2014-07-28 09:55AtulOpenbravoNote Added: 0068903
2014-07-28 09:55AtulOpenbravoStatusresolved => new
2014-07-28 09:55AtulOpenbravoResolutionfixed => open
2014-07-28 09:57AtulOpenbravoReview Assigned To => maite
2014-07-28 09:57AtulOpenbravoNote Added: 0068904
2014-07-28 09:57AtulOpenbravoStatusnew => scheduled
2014-07-28 09:57AtulOpenbravofix_in_branchpi =>
2014-07-28 09:57AtulOpenbravoStatusscheduled => resolved
2014-07-28 09:57AtulOpenbravoFixed in Version => pi
2014-07-28 09:57AtulOpenbravoResolutionopen => fixed
2014-07-28 18:45maiteNote Added: 0068932
2014-07-28 18:45maiteStatusresolved => closed
2014-08-08 18:54hudsonbotCheckin
2014-08-08 18:54hudsonbotNote Added: 0069230

Notes
(0068902)
hgbot   
2014-07-28 09:54   
Repository: erp/devel/pi
Changeset: 714e8ad187a0417da9cba1f568b1e40d521ad699
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Jul 25 16:39:43 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/714e8ad187a0417da9cba1f568b1e40d521ad699 [^]

Fixes Issue 26960:Unable to merge a previously splitted bank statement line

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_BNKSTM_LINE_CHECK_TRG.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
---
(0068903)
AtulOpenbravo   
2014-07-28 09:55   
Reopen to update "Review Assigned To"
(0068904)
AtulOpenbravo   
2014-07-28 09:57   
Test Plan
1. Access Financial Account window and create new Bank Statement. Add Bank Statement Line with "Amount IN"=10. Process bank statement
2. Run "Add transaction" process and create GL item transaction with "Amount OUT"=2
3. Run "Match Statement" process and match previously created transaction and bank statement line. Line will be split. Press "OK" button to save reconciliation
4. Run "Match Statement" process again and try to unmatch cleared line. Process reconciliation and realize that line has be unmatched. If you run "Match Statement" process again you will see line is unmatched.
(0068932)
maite   
2014-07-28 18:45   
verified
(0069230)
hudsonbot   
2014-08-08 18:54   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4450016dee64 [^]
Maturity status: Test