I have couple of questions:
- ERPNext has single “Supplier” and doesn’t make distinction between Service Provider and Supplier. So I am assuming you will make that distinction when generating score cards?
- Where/how are you storing Complaints per Service Provider? – Because you might need to figure out way to add
Supplier Scorecard Variable - Right now we have notion of “Rejected Items” as opposed to number of “Rejections”
Assuming for simplicity sake: We treat Number of Rejected items as Rejections. Following is General flow for scorecard is defined in official document. Steps you need to follow are:
- Define
Supplier Scorecard Variables: For this we do have Total Rejected Items. You need to figure out how to capture “Number of Complaints” - Define
Supplier Scorecard Criteria. For this based on your excel you need Supplier Quality, Service Provider Quality and Delivery - Specify Criteria Formula. Based on your logic for Supplier Quality I believe formula should be
50 - (10 * {total_rejected_items}) if {total_rejected_items} < 3 else 30
Note: I’ve not tested it. But based on what I’ve read in official documentation this should work