Identifying invoices paid this month

[Chris Good]

> Message: 7
> Date: Thu, 29 Sep 2016 15:48:02 +1000
> From: <daniel at cogna.com.au>
> To: <gnucash-user at gnucash.org>
> Subject: Identifying invoices paid this month
> Message-ID: <013301d21a15$0bb23730$2316a590$@com.au>
> Content-Type: text/plain; charset="us-ascii"
> 
> Hi guys,
> 
> I'm trying to figure out how to report which invoices were paid over the
last
> month. Of course, not everyone pays on time so receivable aging won't help
> me.
> 
> I can see payments made to the Checking Account of the last month quite
> easily but there doesn't seem to be a link between these and the invoices
> they were for.
> 
> Any ideas/help?
> 
> Regards,
> Daniel Sherwin, B.Eng (Mech), MIEAust 2989721
> M: 0422 458 795
> E:  <mailto:daniel at cogna.com.au> daniel at cogna.com.au
> W:  <http://www.cogna.com.au> www.cogna.com.au
> ABN: 41 996 673 689

Hi Daniel,

As far as I know there is no report to list the payments and the invoices
they are paying for a particular time period.
It should be possible to do. Every invoice has a lot and each Accounts
Receivable/Payable payment split allocated to an invoice points to the same
lot as the invoice split.
If you are OK with sql, you might be able to get what you want by saving
gnucash to an sqllite database then doing an sql query joining payment
splits for the date range to their lots and then joining the invoices with
the same lot.

Such a report would be useful to many GnuCash users as I think auditors
often ask for such info, so you may like to raise this on
https://gnucash.uservoice.com/forums/101223-feature-request

Regards, Chris Good

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4817 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20160930/903fc5ba/attachment.p7s>