Lead Time in Saved Transaction Search

Lead Time

Lead is the time it takes for orders to be fulfilled from the date of purchase to the date of receipt.

Scenario

You are a procurement manager for a retail chain, responsible for managing inventory levels and supplier relationships. Your task is to create a saved search in NetSuite to identify suppliers with whom you have had the most significant purchasing volume over the past year. However, you also want to calculate the average lead time for each supplier, which is the average time it takes for orders to be fulfilled from the date of purchase to the date of receipt. This information will help you evaluate supplier performance and make informed decisions about inventory management and supplier relationships.

To implement the scenario, steps are given below.

1. Create a Transaction Saved Search
2. Fill in the Criteria according to the scenario.
3. Fill in the Results Tab according to the scenario.
4. Add Formula Field (Text)
5. Import Date and Date from “Fulfilling/Receiving Transaction Fields”.

Formula: {fulfillingtransaction.trandate} – {trandate}

Click on “Save and Run”.