[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