Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031698Openbravo ERPZ. Otherspublic2015-12-11 14:402017-07-03 18:29
Reportermaite 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
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
Summary0031698: Browser freezes when selecting "clear all" option in "Reconcile" button and more than 1500 transactions are pending
DescriptionBrowser freezes when selecting "clear all" option in "Reconcile" button and more than 1500 transactions are pending
Steps To Reproduce1. Access "Caja" Financial Account having >=1500 transactions pending of reconciliation.
2. Run "Reconcile" process
3. Check "clear all" option and after some time browser crashes

NOTE: I can provide environment with huge amount of data where problem is reproducible
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 31698_workaround_reconcileall.diff (37,477) 2015-12-22 09:17
https://issues.openbravo.com/file_download.php?file_id=8835&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-12-11 14:40maiteNew Issue
2015-12-11 14:40maiteAssigned To => Triage Finance
2015-12-11 14:40maiteModules => Core
2015-12-11 14:40maiteTriggers an Emergency Pack => No
2015-12-11 14:40maiteResolution time => 1451602800
2015-12-11 14:40maiteTarget Version => 3.0PR16Q1
2015-12-11 14:41maiteIssue Monitored: networkb
2015-12-12 00:02eugeniIssue Monitored: eugeni
2015-12-14 12:18maiteResolution time1451602800 => 1450306800
2015-12-14 12:18maitePriorityurgent => immediate
2015-12-15 16:49vmromanosNote Added: 0082776
2015-12-15 16:49vmromanosStatusnew => feedback
2015-12-15 18:54maiteNote Added: 0082782
2015-12-15 18:54maiteStatusfeedback => new
2015-12-17 16:12vmromanosAssigned ToTriage Finance => vmromanos
2015-12-17 16:12vmromanosStatusnew => acknowledged
2015-12-21 16:15vmromanosTarget Version3.0PR16Q1 =>
2015-12-22 09:17vmromanosFile Added: 31698_workaround_reconcileall.diff
2015-12-22 09:28vmromanosResolution time1450306800 =>
2015-12-22 09:28vmromanosNote Added: 0082920
2015-12-22 09:28vmromanosTypedefect => design defect
2017-07-03 18:29ngarciaIssue Monitored: ngarcia

Notes
(0082776)
vmromanos   
2015-12-15 16:49   
Hi Maite,

Please provide the developers tool log with the crash message if possible.

Thanks.
(0082782)
maite   
2015-12-15 18:54   
Hi Victor,

I can not see any error in the console. After some time waiting the developers console's window is automatically closed and Openbravo's window becomes black.

I shared environment internally

Thanks,
(0082920)
vmromanos   
2015-12-22 09:28   
When the number of loaded transactions is too high, the browser crashes due to the big amount of JS operations it must run, because the grid loads all the transactions without using pagination.

Besides, the POST data size is also exceeded when trying to send the form back to the servlet.

Moved to design defect, since a proper fix will require a deep refactor, specially in the UI stuff.

As a workaround you can find attached a patch that adds a new button, called Reconcile All, to the Financial Account window. It opens a popup where the user must specify the statement date and the ending balance.
The process will reconcile all the available transactions in the selected financial account up to the provided statement date.

To check the ending balance, you can add a SUM function at the Deposit/Withdrawal Amount columns in the Transaction tab, and use the filters if necessary.