Vendor Payments

Kinetic ERP
1

Happy Friday folks!

Our purchasing department is asking for a report/dashboard to show how much we’ve paid to a vendor in a certain time period – used as a negotiation tool.

I’m aware of Supplier Tracker → Links → Payments → List that I can then export to Excel and manipulate…

…is that how you would do it too if you needed to get that information? Or is there an easier way?

Because they aren’t currently aware of ANY way to get the information, They are asking for a custom dashboard with a Vendor ID and date range filter to make it easier instead of dumping an entire history of payments out to Excel and going that route. If there isn’t a better option than the above, and I’m required to make a dashboard, would reproducing the BAQ be a relationship of Invoice to Vendor or something like that?

Thanks for any tips.:+1:

2

I used this BAQ but it is filtered by part class it might get you close and need to adjust for your purpose.
SupplierSpendByPartClass.baq (36.4 KB)

1 Like
3

Hello! My company is looking for something very similar as Jeff_Owens. I went to review the word doc that you attached but I didn’t work. I was hoping to get a copy of that word doc to help me out I am fairly new to BAQ’s. Thank you!

4

@emattle , he attached an actual BAQ file, not a Word doc. If you save the file to your computer, you can import the file in your Epicor client using the BAQ tool and review his solution.

5

@Jeff_Owens I got it! this helps a ton. Still learning a lot with BAQs

1 Like