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
<[email protected]> 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
> <[email protected]> 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
[email protected]
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.
_______________________________________________
gnucash-user mailing list
[email protected]
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.
