AP Bills Not Marked "Paid"

[Blackhawke]

On Thu, 2009-01-08 at 19:58 -0500, Derek Atkins wrote:
> Quoting Blackhawke <blackhawke at vetl.org>:

> >> Wait.... How is there a Split transaction?   Process Payment doesn't
> >> create any split transactions, so how did this payment get created?
> >
> >
> > Umm... All of the payments have splits.  And all the payments are made
> > using the "Process Payment" feature. Here are two more screen shots from
> > just a few months ago. The first shows what looks like a string of
> > payments. The second shows the splits of one of those payments.
> > Actually, to be honest, it shows the splits of all of the payments,
> > since they're all identical. The number of splits is equal to the number
> > of individual payment entries on the screen.
> 
> Interesting... At some point the code was changed to do split
> transactions instead of adjusting transactions.  Clearly this is
> a better way of doing it, but I don't remember doing it myself.
> It must've been something someone submitted.
> 
> Maybe you can use the Lot Viewer to look at the lots in the account
> and see what the balances are?

Hurm... Well I think you've just exceeded my knoweldge of the program.
How do you look at the lots?

> FYI, a "closed" invoice is purely based on the Lot Balance.  For
> an invoice to be "closed" it's associated Lot must have a balance
> of 0.
> 
> This means you /might/ need to go and re-enter all your payments again
> back to when it started failing.   Unfortunately.  There's no other
> way to "force it" because you need to get the lots balanced out.

Well, let's hope it doesn't come to that.

I've seen a number of message threads on the forum boards about this
problem. Maybe it's time to introduce some database tools to deal with
some of these kinds of problems. I mean it's one thing to go in and
manually re-enter a handful of transactions, it's entirely another to
have to do so in a database going back years. 

Just a suggestion for the future. :)

-=Blackhawke