[GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

Geert Janssens geert.gnucash at kobaltwit.be
Tue Dec 24 03:32:59 EST 2019


With your most recent commits to maint I'm not exactly seeing what you see 
yet. Do you still have local commits not yet pushed to maint ?

I'll add my findings to the bug report as it's easier to track there.

Regards,

Geert

Op dinsdag 24 december 2019 09:25:11 CET schreef Christopher Lam:
> Oops the HTML file doesn't show the outstanding invoice. Pressed SEND too
> quick.
> 
> On Tue, 24 Dec 2019 at 08:22, Christopher Lam <christopher.lck at gmail.com>
> 
> wrote:
> > I'd forgotten to fix the commit message before push. I've added proper
> > commit message on the github web interface.
> > 
> > I think I've managed to make a decent new-owner-report now.
> > 
> > invoice->lot->splits whereby split->parent is TXN-TYPE-LINK are now
> > queried differently to TXN-TYPE-PAYMENT. These LINK splits will find their
> > peer splits whereby the number sign is opposite, and peer->posting-split
> > is
> > then rendered in the right-hand-side. The result is Invoices offset with a
> > Credit Note will show the actual Credit-Note, and vice versa. Multiple
> > invoices offset with multiple credit notes will show all opposing
> > documents.
> > 
> > See the sample complex invoice<->credit-note report. In this sample book:
> > * 2 invoices of $100 were offset with 2 credit notes of $100, in 1
> > lot-link spanning 4 APAR splits.
> > * 1 invoice $100 with 1 credit note $100 via lot-link spanning 2 APAR
> > splits.
> > * 1 invoice $80 is unpaid/outstanding.
> > * 1 credit-note of $80 is refunded from bank via a regular
> > txn-type-payment transfer.
> > 
> > Partial payments/offsets are also rendered appropriately.
> > 
> > On Tue, 24 Dec 2019 at 08:06, Geert Janssens <geert.gnucash at kobaltwit.be>
> > 
> > wrote:
> >> Op dinsdag 24 december 2019 04:57:43 CET schreef Christopher Lam:
> >> >     - TXN-TYPE-LINK lot-splits are rendered as a generic 'Offset
> >> >     Documents' link to lot-link splits. This helps link invoice to the
> >> >     link transaction to locate the corresponding credit-note. It is not
> >> >     possible to link to the corresponding credit-note because a
> >> >     link-transaction can group many invoices to many credit-notes.
> >> 
> >> Each lot link transaction split will be in a lot if it's offsetting
> >> another
> >> invoice or credit note. Can't you query that lot for the invoice or
> >> credit
> >> note if you want to add links to these in your report ?
> >> 
> >> Geert






More information about the gnucash-devel mailing list