Report - Invoice by Check

[tastjuste]

I am trying to find a report that details which invoices were paid with what check number. I am constantly getting calls from vendors asking me if a particular invoice has been paid and what check number it was paid with.

When I go into purchases and click edit on the invoice or when I use the "find" feature and search for the invoice, it simply goes to the purchases screen and say "PAID IN FULL", however is there anyway to find out what check number paid that invoice?

[westphal]

Go to Edit, Find Transactions. Enter the amount of the invoice in both of the transaction amount boxes. Click find. It will list the amount, date, which journal, and the check number used.

[tastjuste]

Thank you for responding to my question so fast, however, that procedure will only work if you only paid 1 invoice on that 1 check. I have vendors with 75+ invoice per month and I haven't found a fast way to located the check number of a paid invoice.

[westphal]

You're right, it does only work for a single invoice. I tried looking for a way within the other reports available in AP Reports, but didn't see another solution. Sorry!

[tastjuste]

Thank you so much for looking for me. You did teach me a good trick when I'm looking for 1 invoice and 1 check though. Thanks again!

[Unregistered]

You could try previewing a cash disbursement journal for that vendor. It should show you the check# with any invoice paid in the time frame you choose!

[riscniaga]

Use the vendor ledger report. This lists out the invoices and payments. Double-click the payment to see which invoices it is applied to.

Very easy, very quick, and very good - as you get to see all related transactions.