sql query to link invoice payments to invoice id?

Jannick Asmus jannick.news at gmail.com
Sun Jan 9 19:40:25 EST 2011


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.

I am aware that the payment amount need not be identical to the invoice 
amount. As there might be slight differences between these two amounts 
in reality anyway, I prefer not to have a query using the invoice 

Any ideas on this highly appreciated!


More information about the gnucash-user mailing list