Good morning,
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?
Thanks!
Nate
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.
Bruce
Hi Nate,
The data is in the collection, just hidden. So a personalization could show it or a customization.
Nancy
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.
