[GNC] Payment paid which Bill? How to see which check paid which bill?

[Adrien Monteleone]

There is a way, but it is quite cumbersome. (using the Lot viewer) I won’t go into any detail on that because there is a much simpler method using a new Customer Report (still in beta, introduced in 3.8) found in Reports > Experimental.

At first the report will come up blank and you’ll need to choose a customer in Options.

Then in Options > Display you can choose to show the linked documents either in a simple, or detailed format. Play with both to see what works for you.

The dev working on this (and other beta reports) would much appreciate as many people using and testing it as possible and reporting any issues.

For some years now I have also been putting in my payment transaction notes/memos the bill# that is being paid by that transaction/split and if partial or final payment, indicate that as well.

Thus:

“for invoice #1234”
“1st partial for invoice #1234”
“2nd partial for invoice #1234”
“final for invoice #1234”

You could also repurpose the action field for applied invoice numbers, but memo is probably better unless you need that field for something else. (you have more space to see the number, for one)

Unfortunately, there is a bug still in the AR/AP registers that setting the text on a memo also changes the notes field to match, and setting the notes field changes the first memo to match, so keep that in mind.

Regards,
Adrien



> On Feb 10, 2020 w7d41, at 11:48 AM, Fran_3 via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> There is no way to see what bill a check paid... is there?
> When paying a bill you get 5 fields...DatePaymentRefundNumMemo
> Date, Payment, and Refund won't do it.Num is for the check numberMemo could be used but that is just a visual association... 
> Seems like the system ought out to have a report showing Vendor's Bill/Invoice number & date plus the Payment Check number and date...
> Is noting the vendors invoice/bill number in the Memo field the only way to do it?
> We considered putting the vendors invoice/bill number in the Num field but that field is for our check number...
> Am I missing something obvious? (Won't be the first time :-)
> Thanks for any help.