Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029642Openbravo ERP09. Financial managementpublic2015-04-21 03:062016-12-21 07:42
Reporterrjapoova 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version3.0PR15Q1.3 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029642: Financial account last reconciliation date consider draft reconciliations
DescriptionThe financial account window displays the date the account was last reconciled and the corresponding amount.

If you import a bank statement and you initiate the Match Statement process, a new reconciliation is created. If you do not complete the process, the reconciliation remains in status draft and it should be ignored (you have not executed a reconciliation yet).

However, the window now displays the date of the most recent reconciliation, regardless of its status.

This is incorrect and I believe a regression (it used to work fine prior to PR14Q4).
Steps To ReproduceConfigure a bank account with a Standard matching algorithm
Import a bank statement
Initiate the Match Statement process
When all transactions are cleared, press OK (to not reconcile).

You will see that the last reconciliation date have been updated.
Proposed SolutionOnly consider reconciliations with Document Status = Completed
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-04-21 03:06rjapoovaNew Issue
2015-04-21 03:06rjapoovaAssigned To => Triage Finance
2015-04-21 03:06rjapoovaModules => Core
2015-04-21 03:06rjapoovaTriggers an Emergency Pack => No
2015-04-24 18:51dmitry_mezentsevNote Added: 0076764
2015-04-24 18:51dmitry_mezentsevStatusnew => acknowledged
2015-04-24 18:51dmitry_mezentsevPrioritynormal => high
2015-12-30 16:24markmm82Statusacknowledged => scheduled
2015-12-30 16:24markmm82Assigned ToTriage Finance => markmm82
2016-01-07 12:26aferrazSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10585#r10585
2016-12-20 15:11markmm82Assigned Tomarkmm82 => AtulOpenbravo
2016-12-20 18:32AtulOpenbravoNote Added: 0092868
2016-12-20 18:48AtulOpenbravoNote Edited: 0092868bug_revision_view_page.php?bugnote_id=0092868#r14089
2016-12-20 18:49AtulOpenbravoNote Edited: 0092868bug_revision_view_page.php?bugnote_id=0092868#r14090
2016-12-21 07:34AtulOpenbravoNote Added: 0092880
2016-12-21 07:42AtulOpenbravoNote Added: 0092881
2016-12-21 07:42AtulOpenbravoSummaryFinancial account last reconciliation date and balance consider draft reconciliations => Financial account last reconciliation date consider draft reconciliations
2016-12-21 07:42AtulOpenbravoDescription Updatedbug_revision_view_page.php?rev_id=14093#r14093
2016-12-21 07:42AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14094#r14094

Notes
(0076764)
dmitry_mezentsev   
2015-04-24 18:51   
Checked in 3.0PR14Q3.8 and it works the same so not a regression
(0092868)
AtulOpenbravo   
2016-12-20 18:32   
(edited on: 2016-12-20 18:49)
Solution to set Last Reconciliation Date and Balance was implemented in the issue 17211 [1] commit [2]

[1] https://issues.openbravo.com/view.php?id=17211 [^]
[2] http://code.openbravo.com/erp/devel/pi/rev/7374dac17caf4cca4a63d6d024b4121cc56aae8b [^]
(0092880)
AtulOpenbravo   
2016-12-21 07:34   
Fix for issue https://issues.openbravo.com/view.php?id=21808 [^] introduced a check to pick Last Reconciliation balance of the processed record.

https://code.openbravo.com/erp/devel/pi/rev/e376b0a5e6e5740c0ad7780747b5d0f98ce15f7d [^]
(0092881)
AtulOpenbravo   
2016-12-21 07:42   
Test Plan:-

- Configure a bank account with a Standard matching algorithm
- Import a bank statement
- Initiate the Match Statement process
- When all transactions are cleared, press OK (to not reconcile).

- You will see that the last reconciliation date is the same date which is ending date of the last reconciliation with status completed.