Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027183Openbravo ERP09. Financial managementpublic2014-07-24 17:312014-08-08 18:54
Reporterjonalegriaesarte 
Assigned Toeduardo_Argal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q4Fixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027183: Reconcilation ending balance is incorrect for account with mix of manual and bank statement reconcilations
DescriptionThe changes introduce in https://code.openbravo.com/erp/devel/pi/rev/627fb422fbe8 [^] result in the ending balance of a reconciliation
being incorrect if
a) current reconciliation is using an imported bank statement
b) a previous reconciliation was done manually without importing bank statement.

This is because the ending balance of the reconciliation is calculated in MatchTransactionDao as the initial balance of the account plus
all the sum of all processed bank statement lines to the ending date.
However if the account has manual reconciliation then the ending balance does not include any transactions reconciled by those manual
reconciliations.
Steps To ReproduceTo reproduce
1) Create a financial account
2) Enter transactions and manually reconcile
3) Enter transactions and reconcile using bank statement.
Note that ending reconciliation balance does not equal account balance.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-24 17:31jonalegriaesarteNew Issue
2014-07-24 17:31jonalegriaesarteAssigned To => eduardo_Argal
2014-07-24 17:31jonalegriaesarteModules => Core
2014-07-24 17:31jonalegriaesarteResolution time => 1407621600
2014-07-24 17:31jonalegriaesarteTriggers an Emergency Pack => No
2014-07-24 17:42hgbotCheckin
2014-07-24 17:42hgbotNote Added: 0068873
2014-07-24 17:42hgbotStatusnew => resolved
2014-07-24 17:42hgbotResolutionopen => fixed
2014-07-24 17:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7c7efd35f42f29b5b13d7c501c0577d89c7666bb [^]
2014-08-04 09:04rafarodaReview Assigned To => rafaroda
2014-08-04 09:04rafarodaNote Added: 0069058
2014-08-04 09:04rafarodaStatusresolved => closed
2014-08-08 18:54hudsonbotCheckin
2014-08-08 18:54hudsonbotNote Added: 0069223

Notes
(0068873)
hgbot   
2014-07-24 17:42   
Repository: erp/devel/pi
Changeset: 7c7efd35f42f29b5b13d7c501c0577d89c7666bb
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Jul 24 17:41:49 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7c7efd35f42f29b5b13d7c501c0577d89c7666bb [^]

Fixes bug 27183: Reconcilation ending balance is incorrect

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/dao/MatchTransactionDao.java
---
(0069058)
rafaroda   
2014-08-04 09:04   
Final reconciliation now sets properly Current Balance and Last reconciliation balance: see https://drive.google.com/folderview?id=0B649lz4ZYJcHdXRIZ00yRjhJSnM&usp=sharing [^]
(0069223)
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