AW: sql query to link invoice payments to invoice id?
jannick.news at gmail.com
Mon Jan 10 08:15:17 EST 2011
Derek Atkins wrote:
>> I am trying to identify the invoice payments TOGETHER with the
>> associated invoice in the sqlite file of my GnuCash file. Since
>> there is a window to process the payment, I suspect there should be
>> a link between the payment and the invoice guid.
> The way they are mapped is via the LOT in the A/R account. When you
> post an invoice is "creates" a lot, and then payments are applied to
> that lot until the balance reaches 0 (at which point any remaining
> proceeds get applied to the next lot owned by the same customer).
Aah, that explains a lot. I will see how I can manage to get things
straight out of the sqlite file.
> So, the mapping would be via the lot's in the splits in the A/R
> account for the payment transaction. Note that you could have
> multiple splits in the A/R account in the case of a payment being
> applied to multiple invoices.
This seems to be a problem at the moment. I will think how I can handle
Thanks for your input!
More information about the gnucash-user