I recently made a BAQ listing the parts that we bought from a specific vendor in a given timeframe. The goal is to understand how many parts we buy at each vendor. My output is the Vendor, Part Number, Qty, and Price. Purchase Advisor is nice, but not quite what I need here.
My question is, does a built-in report in Epicor cover this kind of query?
How about Supplier tracker?
Thanks Nancy. I don’t see quantity in my list. We need to total the parts by part number. So if this had quantity it would be great!
Create a BAQ with Advance Grouping.
Group by Customer, Part and year, Sum up Qty of POs, Qty of Parts, Cost of Parts
Not too much reporting on purchasing.
The data is in the collection, just hidden. So a personalization could show it or a customization.
And depending on how you process credit card transactionsa, you might miss some items. If you treat the credit card company as a supplier, those parts will show up under Visa, MasterCard, AMEZ, etc. If you set up your card as a bank, then you will get accurate part data.