NetSuite Changelog
Inventory ManagementSupply ChainInventoryNew FeatureEnhancementBest Practices

Available Date Calculation for Supply Allocation Strategies

Available date calculation on supply allocation strategies specifies ATP lead time considerations, impacting ship and supply dates.

·2 min read·9 views·View Oracle Docs

The available date calculation on supply allocation strategies allows you to customize whether the ATP lead time is factored into determining the available date for order lines. The strategy you select will dictate which sources are used for this calculation, ultimately yielding the latest date available from those sources.

Available Date Calculation Options

The following table outlines how available date calculation varies with different allocation strategies:

Order Line AllocationDate Source
Calculate Available Date with ATP Lead Time
Fully allocatedSupply By Required Date - Date of latest supply allocation
Current Date
Not fully allocatedSupply By Required Date - Date of latest supply allocation
Current Date + ATP lead time
No allocationSupply By Required Date - Current Date + ATP lead time
Calculate Available Date without ATP Lead Time
Not fully allocatedSupply By Required Date - Date of latest supply allocation
Current Date
No allocation(No available date)

Note: For work orders, the date calculations apply to the Expected Supply Date, while for transfer and sales orders, they relate to the Expected Ship Date. When ATP lead time is not defined or set to zero, only the current date is factored in.

It is important to recognize that Supply Allocation will automatically assign an available date to order lines that utilize allocation strategies that consider the ATP lead time. However, if a strategy disregards the ATP lead time, an available date won't be calculated or assigned when there are no allocations present.

Lead Time Calculation

The total lead time is calculated as follows:

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

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.

Weekly Update History (1)

Inventory Managementupdated

Updated the Supply Allocation Calculations help topic to create a new section for Expected Receipt Date Calculation on Transfer Orders.

View Oracle Docs
Source: Available Date Calculation on Supply Allocation Strategies — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Inventory Management

View all Inventory Management articles →