Thanks Adrien! I'll give the experimental report a test run. I also like your
technique of putting the vendors bill@ in the notes/memos.
One untested idea I came up with was to enter the check number in the Payment
"Num" field followed by a space & then the vendors bill/invoice id# all in the
num field like for check number 1423 and vendor bill number 08279 I would
enter...1432 08279or maybe put a colon after the ck num.Wonder if that will
break something in one of the reports or else where?
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.
