[grisbi-bugs] [Grisbi 0001514]: Reconcile history wrong, cannot reconcile

[Grisbi Bug Tracker]

The following issue has been ASSIGNED. 
====================================================================== 
http://www.grisbi.org/bugsreports/view.php?id=1514 
====================================================================== 
Reported By:                stephane.gourichon
Assigned To:                pbiava
====================================================================== 
Project:                    Grisbi
Issue ID:                   1514
Category:                   Main
Reproducibility:            always
Severity:                   major
Priority:                   high
Status:                     assigned
OS:                         Ubuntu 
Unstable Impact:            Yes 
Version OS:                  
Version GTK:                 
====================================================================== 
Date Submitted:             2012-08-08 18:18 CEST
Last Modified:              2012-08-19 21:33 CEST
====================================================================== 
Summary:                    Reconcile history wrong, cannot reconcile
Description: 
We used Grisbi for years with 6 accounts, manual typing of all operations,
reconcile regularly.

We now observe that reconcile fails on one account due to wrong initial balance
(92,44 instead of 90,60).


Steps to Reproduce: 
* Open account file ( account file not included here due to bug
http://www.grisbi.org/bugsreports/view.php?id=1512 ).
* Observe correct balance (13090,60) (see first attached image) and initial
balance for reconcile to come (90,60).
* Try to reconcile. Observe bad initial balance (92,44 instead of 90,60) (see
second attached image).


Additional Information: 

We used Grisbi 0.5.9 on Mac OS X for years.
Recently we switched to Ubuntu Linux and use Grisbi 0.8.8 from official Ubuntu
packages.

Bug looks like bug http://www.grisbi.org/bugsreports/view.php?id=1246 (and maybe
bug http://www.grisbi.org/bugsreports/view.php?id=1470).

====================================================================== 

---------------------------------------------------------------------- 
 (0003479) stephane.gourichon (reporter) - 2012-08-08 19:40
 http://www.grisbi.org/bugsreports/view.php?id=1514#c3479 
---------------------------------------------------------------------- 
When looking at the gsb file, I can't correlate the reconcile history with the
transaction history. The transaction history looks good, while the reconcile
history seems to contain whimsical balances. Especially, the last reconcile that
changes from 90,60 to 92,44 does not make sense. There *is* a transaction of
1.84 but it is marked as already reconciled, so should not be reconciled again.

See attached file extract_from_gsb_file.txt

I'm afraid that removing the bad reconcile line might break thing. I'll try to
just change manually the final balance (and date) to see if I can go on using
the software.

The important part here is : seems I'm not alone in having such a problem.
Grisbi will be better if the origin of this bug can be tracked and fixed. I can
provide additional information, just ask precisely what you need. I have kept
several intermediary backup files (which have same history inside) and the old
account file of version 0.5.9, which is obviously in a very different format.

I noticed that the last operation (of 1.84) inserted on that account has date
2012-12-31 which is wrong (don't know if it was indeed the date entered
manually).

The bug might be that the conversion from old format to new format made
assumptions like "no new operations is ever inserted on a date older than date
of last reconcile". That assumption is false here since last operation (+13000)
has date 2012-04-10.


That makes a lot of information, I tried to provide every useful hint. Thank you
for your attention and keep the ball rolling. 

---------------------------------------------------------------------- 
 (0003484) c.schroeder (reporter) - 2012-08-18 22:04
 http://www.grisbi.org/bugsreports/view.php?id=1514#c3484 
---------------------------------------------------------------------- 
Just encountered this bug with one of my accounts in v0.8.7.  Upgraded to
v0.8.8, but the problem persists.

In my case, the last reconciled transaction amount is correct, but it is not
being included in the initial balance for the next reconcile task, so there is a
variance equal to this last reconciled transaction.  My first thought was to
mark the offending transaction as unreconciled and then simply re-reconcile it,
but I cannot find any method in the GUI to accomplish this.  Also of note, the
transaction in question is a transfer between accounts.  The corresponding
transaction in the other account does not share this problem.

Last data point is the account in which this bug has occurred is a savings
account with infrequent transactions and has not needed to be reconciled for
several months. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2012-08-08 18:18 stephane.gourichonNew Issue                                    
2012-08-08 18:18 stephane.gourichonFile Added:
grisbi_bug_00_correct_account_balance.png                    
2012-08-08 18:19 stephane.gourichonFile Added:
grisbi_bug_01_bad_reconcile_initial_balance.png                    
2012-08-08 19:40 stephane.gourichonNote Added: 0003479                          
2012-08-08 19:47 stephane.gourichonFile Added:
extract_from_gsb_file_anonymized_for_bugtracker.txt                    
2012-08-18 22:04 c.schroeder    Note Added: 0003484                          
2012-08-19 21:33 pbiava         Assigned To               => pbiava          
2012-08-19 21:33 pbiava         Status                   new => assigned     
======================================================================