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

[Fran_3]

 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 <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.