Identifying invoices paid this month

[Chris Good]

> -----Original Message-----
> > 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
> 
> -----Original Message-----
> From: Chris Good [mailto:chris.good at ozemail.com.au]
> Sent: Friday, 30 September 2016 12:37 PM
> To: gnucash-user at gnucash.org
> Cc: daniel at cogna.com.au
> Subject: RE: Identifying invoices paid this month
> 
> 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
> From: daniel at cogna.com.au [mailto:daniel at cogna.com.au]
> Sent: Friday, 30 September 2016 6:43 PM
> To: 'Chris Good' <chris.good at ozemail.com.au>
> Subject: RE: Identifying invoices paid this month
> 
> Chris,
> 
> Thank you for your reply.
> 
> Is it possible to make a custom report in Gnucash to do this myself rather
> than burdening the dev team? I'm more than happy to share it with the
> community thereafter.
> 
> Regards,
> Daniel Sherwin, B.Eng (Mech), MIEAust 2989721
> M: 0422 458 795
> E: daniel at cogna.com.au
> W: www.cogna.com.au
> ABN: 41 996 673 689
> 

Hi Daniel,

Please copy gnucash-user at gnucash.org as there are other interested people
who may also contribute.

It IS possible to do within GnuCash and making that available to all users
would be great.
You would need to use language 'scheme'.
Please see http://wiki.gnucash.org/wiki/Custom_Reports
You may be able to use some the code from the Easy Invoice
(easy-invoice.scm) as that lists payments against the invoice being printed.

If you need any help, I suggest you join and ask on the developers email
list gnucash-devel at gnucash.org.

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/20161001/205eeb15/attachment.p7s>