Skip to Content
0
Former Member
Jul 27, 2010 at 08:53 AM

Vendor Invoices Payed

49 Views

Hi Folks

I have already had some excellent help from you guys and thought id try my luck once more.

What im after is a report that tells me how many times and how much we have payed a vendor in a given period.

Vendor Name

Vendor Number

Amount Paid

Amount of invoices processed for vendor (i.e how many times they have been paid)

MCE3 is almost there but the invoice quantity that is displayed is actual quantity of all the orders. I.e if an invoice processed is quantity 100 the result for amount of invoices in MCE3 is 100 as opposed to the figure that im after which would be 1 (the actual processing of the payment)

Do you folks know which tables i need to join in SQVI?

Many thanks

Pyeski