GnuCash can't calculate?!

[Geert Janssens]

On Thursday 21 January 2010, Wouter van Marle wrote:
> On Wed, 2010-01-20 at 10:20 -0500, Derek Atkins wrote:
> > Hi,
> > Another question is are there outstanding invoices from more than a year
> > ago?  Do a search for invoices from this customer and see if the
> > invoices are marked as paid or not.
> 
> Most invoices (there are about two dozen of them) are not marked paid.
> This is a recurring issue to me, for some customers it works, for some
> not.
> 
Just to be clear: you have a number of invoices for which you have entered 
payments (and that are payed completely) while GnuCash doesn't indicate them 
as paid ?

That suggests GnuCash has lost track internally of your payments and it's not 
only a display issue.

The bugreport I indicated in my previous reply is one way to get into such a 
situation (paying invoices before they are posted).

> > Also, what date did you use for the report?
> 
> 1/1/09 to now - while indeed the oldest invoices date from 2008.
> 
> I just re-ran the report with a starting date from before the first
> invoice or payment from them (the first payment is from before the first
> invoice, by the way) and the total doesn't change.
> 
Indeed, if GnuCash looses track internally, your report won't display 
correctly no matter what you do.

You should get GnuCash into a state that your paid invoices are effectively 
marked as paid.


As for the first payment being before the first invoice: this is not 
necessarily a problem. For the bug to trigger it's the action sequence that's 
important, not the actual dates used by the actions.

So it's perfectly fine to
1. post an invoice with post date 30/01/2010
2. then afterwards add a payment for the invoice with payment date 20/01/2010

while the other way around may corrupt your data:
1. make a payment for an unposted invoice
2. post the invoice

In your use case (payment before invoice), it should also be ok to
1. create a payment for the customer (without choosing a particular invoice!)
2. then afterwards create and post an invoice for that customer
GnuCash should then automatically assign the payment to that invoice (or part 
of the payment, if it is more than the invoice amount).

If it's really this bug you ran into, I'm not sure what to suggest to fix it.

I have remedied one of my books in the past, but I can't recall exactly what I 
did.

I think it was this:
* Open the Accounts Receivable account
* Remove all payments for the customer with the corrupt payment information, 
including all automatic payment forwards for that customer, starting from the 
first invoice (with payments) that doesn't show up as paid properly.
* Be sure all relevant invoices are posted.
* Enter the payments again.

I hope that helps.

Geert

> Wouter.
> 
> > > Wouter.
> > >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>