Fill rate is a supply chain performance metric that measures the percentage of customer orders fulfilled from available stock without backordering or delays.
Formula:
Fill Rate (%) = (Number of Orders Fulfilled from Inventory / Total Number of Orders) × 100
Fill rate can be analyzed across different dimensions:
- Order Fill Rate (complete orders)
- Line Fill Rate (order lines filled)
- Unit Fill Rate (individual item units fulfilled)
How to Calculate Fill Rate in Netsuite
Though NetSuite does not offer a pre-built “fill rate report,” you can create custom reports or saved searches using the following steps:
Using Saved Search:
- Go to Reports > Saved Searches > All Saved Searches > New.
- Choose Transaction as the record type.
- Filter by Sales Orders and Item Fulfillments.
- Use formulas to compare order quantity and fulfillment quantity.
- Add criteria to calculate the number of fully and partially fulfilled orders.
- Use summary type “Count” to track total and fulfilled records.
- Export results to Excel or view as a KPI in your dashboard.
Using Reports & KPIs:
- Use Sales Order vs. Fulfillment Reports under Reports > Sales.
- Create a custom KPI with a calculated formula to track fill rate trends over time.
- Integrate with NetSuite Analytics Warehouse (NSAW) for enhanced dashboard views.