Invoice and bill payments

[yankyhoffman]

Hi,

First of all, many thanks for authoring this nice codebase.

Question, I have dabbled a bit in the code and tried dabbling in the underlying SQL structure of a SQLite backed GnuCash file... I am looking how I can query for an invoice or bill and see the payments made against them.

I.e. I entered bill 1 with a total of $100 on Dec 1st, on Jan 1st I recorded a payment of $50, and in Feb an additional $25. I want to query and get a (cash based) report of the bill and dates of payment (which I will distribute to the bill line item expense accounts) and see the open amount as well.

Would you be able to guide me how to query/find the correct collection the payments are stored in and how to join them with the invoices collection?

All the best.

[sdementen]

hi, thank you for your kind message!
The easier for me would be to post a simplified version of your gnucash file with the given transactions so I could test some code

[flywire]

@yankyhoffman Can you add the file you referred to?