Skip to Content
Menu
This question has been flagged
1 Reply
3140 Views

When looking at the Vendor Master record, I see a Truck icon with a percentage beside it:


How is this percentage calculated?

Avatar
Discard
Best Answer


The statistic looks at all products that have been received, on a purchase order line basis, and tells you how many of them were received "on time" (on or before the date promised).

  1. Find all Purchase Order Lines that were ordered in the last 365 days, where at least 1 product has been received against them.

  2. For lines where products were received, count how many were received "on time".

  3. Divide the total quantity received on time by the total quantity ordered (only on the lines identified in step 2 above).

Note:

  • Purchase Orders lines for Service products are ignored. 

  • Based on the algorithm, the value of the product has no influence on the statistic. A late 'expensive' item counts the same as a late 'cheaper' item.

  • Purchase Order lines NOT received yet do not factor into the statistic (we don't know how late they will be, we just know they are not on-time, so they are excluded for that reason).

  • If NOTHING has been received, there is "no data" and therefore no statistic.

  • If you order 10 products on a line, receive 5 on time, and later change the ordered quantity on the purchase order to 5, you remove the penalty to the on-time statistic (and will see it increase) because you no longer have 5 products received on time out of 10 total, you have 5 products received on time out of 5 total.


Avatar
Discard
Related Posts Replies Views Activity
1
Nov 24
1483
1
Nov 24
1190
2
Sep 24
1047
1
Aug 24
2453
3
Aug 24
2687