We are looking to implement a vendor scorecard. We are currently running E10.1.600 with a move to 10.2 scheduled for early next year. This scorecard would measure on time delivery, monthly and yearly spend, quality, and create a rating using this data as the basis. Epicor does not have anything built into E10 that would do this, and we are starting to write queries and dashboards to gather this info, but has anyone done this already? Would love to hear about your experiences and maybe get some sage advice! Thanks very much!
Hi,
Yes I have done something similar.
It really depends upon how ‘jazzy’ you want your dashboards to look.
Epicor dashboards are good to a point, however, I had a customer who wanted to dashboards appearing in the browser, with things like traffic lights, different charts etc, plus drill down.
My solution was to develop the queries as BAQ’s and use the REST API to get a JSON output from your BAQ’s.
Once you have the data as JSON, you are to use the full power of Google Charts (open source and used by Google in its analytics package).
The first couple of dashboards can be tricky, if you not well versed in Javascript, but once you have done a couple, its a very repeatable process.
The Rest API is available in both 10.1.6 and 10.2.
Best Regards,
Andrew.
2 Likes
Epicor does have the shop vision dashboards and if you have the supplier management module there is provision to enter supplier ratings.
Not a full metric package, but a start.
Brad
1 Like