[GNC] How to handle multiple entries of multiply reconciled entries

[Jeff]

On 2/3/22 10:07 AM, Alan A Holmes wrote:
> Hi Jeff,
>
> Did you take a copy of the database before you upgraded to version 4.9. If so you could take a copy of this backup and open that in version 4.9, which might tell you if the corruption existed before upgrading to version 4.9.
>
> Do you have anyway of finding out which version you had before version 4.9? Was it another flatpack version, or was it the version as part of Ubuntu 20.04 LTS? That version might still be available on your machine, or you could re-install that version, which would allow you to look at any backup copy before upgrading to version 4.9 in that version to see if the corruption existed.
>
> You could also look at any/all backup copy taken automatically by version 4.9 to see if the corruption exists. This depends on how many days of backups/logs you have specified should be kept in the settings. This might show when the corruption first started.
>
> If you can find a backup copy that isn't corrupted then you could start with that copy and then either manually enter all transactions since then, or use the log files created since then to re-apply a subset of transactions (I think I remember a thread somewhere that said you can be selective in which transactions to re-apply).
>
>
> Alan A Holmes
>
> -----Original Message-----
> From: gnucash-user <gnucash-user-bounces+gnucash=alanaholmes.me.uk at gnucash.org> On Behalf Of Jeff
> Sent: 03 February 2022 07:43
> To: Gnucash userlist <gnucash-user at gnucash.org>
> Subject: [GNC] How to handle multiple entries of multiply reconciled entries
>
> How I did this is beyond me, somehow I confused GNC to let it happen or had a data corruption when the journal was improperly saved (power outage, GNC lost a poker game, thought it was Quirken, etc).  I use uncompressed XML on Ubuntu 20.04LTS.
>
> I have discovered multiple (dozens) of transactions that are duplicates in several registers but; reconciled to the wrong accounts.  I am not sure of the easiest and proper way to correct them.
>
> Example of the simplest ones are:  using Check 101, Cash, salary.
>
> 01/01/10 chk 101 -> Cash -> chk 101 reconciled
>
> 01/01/10 chk 101 -> salary -> salary reconciled
>
> These are posted as 2 entirely separate transactions, in the same register, but are supposed to be only one transaction:
>
> 01/01/10 chk 101 -> salary -> both reconciled
>
> As a result my current balance is now off by off by over $4,000.
>
> And the real kicker, is that these errors now go back 3 years in this journal.  I know these errors did not exist prior to FlatPak 4.9, not sure which version I upgraded from to 4.9.  Plus they would have shown up when I did reports for taxes and income expense statements last year.
>
> Suggestions, besides burning more midnight oil than this old man has left, other than to delete all of them and enter all of them correctly as I find them.  I'm in tax time crunch here.
>
> --
> --JEffrey Black M.B.A.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> .

I always make a backup before doing an upgrade, unfortunately I deleted 
it some time after upgrading as I believed that everything was working 
as it should.  I do not remember what version I used prior to FlatPak 
4.9.  I want to say 4.2 but I'd be lying if I said I knew that for sure.

As for the log copies I only keep 7 days worth and I have the bad habit 
of running GNC multiple times on any given day.  I could try loading the 
oldest one and see if the problem is still there.

It may be that I got the backups mixed up while trying to build 4.9 from 
source.  I have yet to successfully create a version that runs.

-- 
--JEffrey Black M.B.A.