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

[Fran_3]

 OK, I've brought up the Vendor Report (beta) by clicking
Reports > Experimental  > Vendor Report (beta)
Then  click Edit Options in the popup windowThen in the next window on the General Tab select the date range, enter the vendor nameThen click the Display Columns TabThen at the bottom of the list click Links and select one of the choices.I selected Simple then clicked Apply to see the report come upNow the last column is titled "Links" and at the end of each Payment row the Vendor Bill/Invoice/Reference number shows up so you can see that check was used to pay that bill.
Very Cool !
Thank you Adrien and also the GC dev Team.


    On Monday, February 10, 2020, 01:05:15 PM EST, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:  
 
 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.

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.