Paying Invoices

[Geert Janssens]

Victor,

Thanks to your data file I have been able to improve the Check & Repair function.

It now works on your book. It still takes over 10 minutes on my computer to run it on your 
Accounts Receivable account.

There were a couple of transactions in there with hundreds of mini splits as a result of poor lot 
link behavior. It turns out that transactions with many splits bog down gnucash more than 
having many transactions. The good news is that the improved check & repair properly fixes 
these enormous transactions.

Unfortunately Check & Repair can't correct everything as sometimes there are multiple ways 
to correct transactions and without more background it's impossible to decide which is the 
right one.

But with the lot link issues out of the way you should be in a much better position to make 
your books match your real invoice and payment history.

I'll send you some more detailed information regarding your particular book in private.

Oh, and the Income Statement did not crash on me after check & repair has run.

Regards,

Geert

On Friday 20 February 2015 12:44:18 R. Victor Klassen wrote:
> Just so you know…
> 
> I tried running an income statement on the file, and it caused 2.6.5
> to crash.  Reverted back to 2.6.3 - no crash.   Something else to
> look into...
> On Feb 19, 2015, at 8:34 AM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
> > I have received your log and trace file. The trace file is not what
> > I had in mind but that's ok.
> > 
> > Here is what I read in the log replay:
> > Check & repair works relatively well until September 2014. There are
> > older lot links in your data file though. At least one is referred
> > to in September 2013.
> > 
> > When you interrupted the check & repair action, the last transaction
> > GnuCash worked on was Oct 23, 2014. So still a while to go.
> > 
> > Unfortunately I don't think gnucash would be able to finish the
> > action. It does remove the lot links, but instead it creates
> > transactions with an abundance of splits. That last transaction has
> > well over 600 splits (I stopped counting).
> > 
> > So my advice is to revert back to the state of your book right
> > before you ran check & repair.
> > 
> > This reminds me I have fixed a bug in check & repair right after
> > gnucash 2.6.5 has been released. This fix was specifically aimed at
> > this splitting going out of control. Not everyone would experience
> > this bug, but clearly with your book you do.
> > 
> > It will be pretty useless to try and run check & repair until this
> > fix gets released (planned for end of March). That is, unless you
> > are able to build your own version of gnucash based on the most
> > recent maint branch head.
> > 
> > If that is not an option for you here is another proposal: if you
> > are willing to share your gnucash book with me privately, I could
> > use it to test the above bugfix and perhaps fix even more bugs I
> > would run into while running check & repair on your book. I will
> > treat it with the proper respect for your privacy (that is: I won't
> > share it nor its contents with anyone else and I will strictly only
> > use it to run my check & repair tests).
> > 
> > Regards,
> > 
> > Geert
> > 
> > On Thursday 19 February 2015 06:53:50 R. Victor Klassen wrote:
> > > The log file is 9.13 Gbytes.
> > > 
> > > I’m going to shoot GnuCash.  I’m guessing it’s still going. I can
> > > re-try and then see if it’s a manageable size.
> > > 
> > > I don’t know where to find the trace file.
> > > 
> > > On Feb 19, 2015, at 3:18 AM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
> > > > On Wednesday 18 February 2015 19:21:16 R. Victor Klassen wrote:
> > > > > On Feb 18, 2015, at 3:06 PM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
> > > > Can you post the trace file that gets generated while running
> > > > check
> > > > & repair ? And also the log replay file. If you consider the
> > > > last
> > > > one to contain sensitive information, feel free to send it to me
> > > > in
> > > > private.
> > > > 
> > > > Geert