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

[Grisbi Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://www.grisbi.org/bugsreports/view.php?id=1514 
====================================================================== 
Reported By:                stephane.gourichon
Assigned To:                
====================================================================== 
Project:                    Grisbi
Issue ID:                   1514
Category:                   Main
Reproducibility:            always
Severity:                   major
Priority:                   high
Status:                     new
OS:                         Ubuntu 
Unstable Impact:            Yes 
Version OS:                  
Version GTK:                 
====================================================================== 
Date Submitted:             2012-08-08 18:18 CEST
Last Modified:              2012-08-08 19:40 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. 

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                          
======================================================================