Available Date Calculation for Supply Allocation in NetSuite

Starting in NetSuite 2026.1, the allocation strategies now include an updated Available Date Calculation setting. This enhancement allows users to define whether the Available-To-Promise (ATP) lead time should be considered when calculating the available date for supply allocations. The new setting facilitates more accurate scheduling in order management processes, ensuring a reliable determination of available dates for products based on their attributes.

Key Features of Available Date Calculation

The Available Date Calculation determines which sources to consider for calculating available dates based on the ATP lead time setting. The following table summarizes how the calculation works across different allocation scenarios:

Allocation Status	Date Source	Calculation Method
Fully allocated	Supply By Required Date	Date of latest supply allocation
Not fully allocated	Supply By Required Date	Current Date + ATP lead time
No allocation	Supply By Required Date	Current Date + ATP lead time

Calculation Details

For orders fully allocated, the available date is taken from the latest supply allocation date.
In scenarios where allocations are not fully realized, the calculation will add the ATP lead time to the current date unless specified otherwise.
If no allocations are made, and the ATP lead time is not accounted for, no available date will be calculated for that order line.

Important Note: For work orders, the method of calculation is specifically tied to the Expected Supply Date whereas for transfer and sales orders, it applies to the Expected Ship Date.

Lead Time Calculation Formula

The total lead time can be calculated using the formula:

Total Lead Time = <Work Order Fixed Lead Time> + <Work Order Variable Lead Time> * ceiling(<order quantity> / <Work Order Lead Time Lot Size>)

This formula integrates both fixed and variable components of the lead time into a unified calculation, allowing for precise tracking and management of supply chains.

Who This Affects

This feature primarily impacts the following roles and modules:

Supply Chain Managers who manage inventory and logistics.
Order Management Teams that handle order fulfilment processes.
Inventory Administrators looking to optimize supply allocation practices.

Key Takeaways

The Available Date Calculation setting provides flexibility in considering ATP lead times for determining order availability.
Accurate allocation strategies are crucial for effective inventory management, particularly when dealing with partial allocations.
This feature enhances operational efficiency by automating date calculations based on real-time supply data.
Understanding the nuances of lead time calculations can significantly improve supply chain responsiveness.

Frequently Asked Questions (4)

Does the Available Date Calculation feature apply to all types of orders in NetSuite?

Yes, the Available Date Calculation feature applies to work orders, transfer orders, and sales orders, each with specific date calculation considerations.

How does the Available Date Calculation handle orders that are not fully allocated?

For orders not fully allocated, the available date is calculated by adding the ATP lead time to the current date unless specified otherwise.

What is the formula for calculating total lead time in NetSuite 2026.1?

The total lead time is calculated using the formula: Total Lead Time = <Work Order Fixed Lead Time> + <Work Order Variable Lead Time> * ceiling(<order quantity> / <Work Order Lead Time Lot Size>).

How does the new Available Date Calculation affect work orders specifically?

For work orders, the method of calculation is tied to the Expected Supply Date rather than the Expected Ship Date, as it is with transfer and sales orders.