Purchasing

This section lists the Key Performance Indicators (KPI) for the Purchasing domain and the calculation used to determine their results.
KPI name KPI calculation
Ordered Amount
[POEH.poeh_totlineamt]
Received Amount
[POEH.poeh_totrcvamt]
Invoiced Amount
[POEH.poeh_totinvamt]
Fill Rate Order
IF([poeh_enterdt: # pono] is null or [poeh_enterdt: # pono]  =0 or [poeh_enterdt: # poeh_shipcom_flag] is null,0,(([poeh_enterdt: # poeh_shipcom_flag] WHERE [POEH.poeh_shipcom_flag] = 'Yes') / [poeh_enterdt: # pono])*100)
Fill Rate Unit
IF([poel_enterdt: Sum: poel_qtyord] is null or [poel_enterdt: Sum: poel_qtyord] = 0 or [poel_enterdt: Sum: poel_qtyrcv] is null or [poel_enterdt: Sum: poel_qtyrcv] =0,0,([poel_enterdt: Sum: poel_qtyrcv]/[poel_enterdt: Sum: poel_qtyord])*100)
Fill Rate Line
IF([poel_enterdt: # pono] is null or [poel_enterdt: # pono] =0 or [poel_enterdt: # poel_shipcom_flag] is null,0,(([poel_enterdt: # poel_shipcom_flag] where [POEL.poel_shipcom_flag] = 'Yes')/ ([poel_enterdt: # pono]))*100)
On Time Lines Perc
IF([poel_enterdt: # lineno] is null or [poel_enterdt: # lineno] =0 or [poel_enterdt: Sum: poel_ontime] is null,0,([poel_enterdt: Sum: poel_ontime] / [poel_enterdt: # lineno]) * 100)
On Time Lines 2 Days Perc
IF([poel_enterdt: # lineno] is null or [poel_enterdt: # lineno] =0 or [poel_enterdt: Sum: poel_ontime_2days] is null,0,([poel_enterdt: Sum: poel_ontime_2days] / [poel_enterdt: # lineno]) * 100)
On Time Lines 5 Days Perc
IF([poel_enterdt: # lineno] is null or [poel_enterdt: # lineno] =0 or [poel_enterdt: Sum: poel_ontime_5days] is null,0,([poel_enterdt: Sum: poel_ontime_5days] / [poel_enterdt: # lineno]) * 100)
On Time Orders Perc
IF([poeh_enterdt: # pono] is null or [poeh_enterdt: # pono] =0 or [poeh_enterdt: Sum: poeh_ontime] is null,0,([poeh_enterdt: Sum: poeh_ontime] / [poeh_enterdt: # pono]) * 100)
On Time Orders 2 Days Perc
IF([poeh_enterdt: # pono] is null or [poeh_enterdt: # pono] =0 or [poeh_enterdt: Sum: poeh_ontime_2days] is null,0,([poeh_enterdt: Sum: poeh_ontime_2days] / [poeh_enterdt: # pono]) * 100)
On Time Orders 5 Days Perc
IF([poeh_enterdt: # pono] is null or [poeh_enterdt: # pono] =0 or [poeh_enterdt: Sum: poeh_ontime_5days] is null,0,([poeh_enterdt: Sum: poeh_ontime_5days] / [poeh_enterdt: # pono]) * 100)
Lead Time
[POEH.poeh_leadoverty]
Filled Orders
IF((IFNULL([POEH.poeh_totqtyord],0.00) >IFNULL([POEH.poeh_totqtyrcv],0.00)),0,1)
# Filled Orders
[poeh_enterdt: Sum: poeh_shipcom_bflag]
On Time Orders
IF([POEH.poeh_receiptdt] is null or [POEH.poeh_duedt] is null,1,IIF( DATEDIFF(DAY,[POEH.poeh_receiptdt],[POEH.poeh_duedt]) = 0,1,0))
# On Time Orders
[poeh_enterdt: Sum: poeh_ontime]
# of Orders
Count of total purchase orders (#pono)