Supplier Scorecards / Vendor Performance Reporting

Did you get any responses regarding this topic? I would be interested to know a solution if any.

@jdabney37 nope. definitely still a need.

I’m working on a report for my company to do this as well, commenting to see if there are updates at some point in the future.

​@jfarrell I don’t have any updates. I hope others have tackled this problem that could chime in.

I haven’t done anything with the eWorkplace, but I built our Purchasing Manager a GI / Pivot, and posted it to their dashboard.

POOrder → POLine

POOrder → POPR → POReceipt → POReceiptLine

Then Pivot to Dashboard.

In this example five Vendors undershiped and two overshipped, one is regularly 1.5 months late.  Another is ~2 weeks early.  Drilldown allows the Purchasing Manager to review better details and determine if it was holidays or weather delays, etc so we can dial in our Vendor lead time.  Once we get that populated, we will join that table(s) and add that to the pivot.

@adaughenbaugh95 do you have this available to share on setting it up as I am interested in setting this up for our purchasing department.

I have this, if that helps, it is fairly rudimentary.  Or you can email me and I can help based on your specific needs.

Thanks for this GI.  After downloading and tweaking a bit to match my clients needs this is perfect.  Appreciate your help.

​@jwright 

We used Dashboard which you can readily used in Acumatica, and also we integrate Dashboard created in Power BI using Odata from Acumatica.

 

Did you use the above GI to get a dashboard or build a different one?

​@cwomack98 

No, we create our own G.I to get the data we need for the dashboard.

Can I see what your dashboard looks like, please?

​@cwomack98 

here’s the sample