- When Demand Planning feature is enabled and the Replenishment Method is Time Phased, the Expected Receipt Date is found as one of the columns on the Purchase Order form.
- The Expected Receipt Date is computed based on the Purchase Lead Time field value on the Item record. It will be computed from the date of the purchase order.
- Consider the item record has purchase lead time as 5.
- Create a purchase order record for that item. If the trandate of purchase order is December 1, the expected receipt date is December 6.
- There is a checkbox near Purchase Lead Time body field named Auto-Calculate. If the checkbox is checked, the purchase lead time will auto calculate by NetSuite based on recent order history of the item. This is calculated by taking the number of days between the order entry and receipt on the three most recent purchase orders and dividing by three.
- If the user creates and receive the purchase order in same day for 3 times, the purchase lead time will be automatically set as 0. i.e., when purchase order is created for the item, the expected receipt date will be set as same day as trandate.
- If there are multiple receipts for the item against the same purchase order, only the first receipt is used for the calculation.
- Lead time calculation is not weighted by number of units received. More recent purchase orders without receipts are ignored.
- User can uncheck the Auto-Calculate box to manually enter a lead time value in days.
- If the Auto-Calculate box is cleared and no value is entered, then the default value from the Set-Up Inventory Management page is used.
- The user can also set Expected Receipt Date manually.