Earliest Item Availability

The Supply Allocation Earliest Item Availability page computes item and location level availability information based on simulated allocations. The system then populates the computed availability date to provide answers to item availability inquiries regarding future demand.

Earliest Item Availability is now compatible with Sales Channel Allocation. This improves the earliest availability calculation by leveraging the allocation process to allocate supplies set aside for sales channels.

The Earliest Item Availability page enables you to:

Reviewing Earliest Item Availability

The Supply Allocation Earliest Item Availability page displays answers to item availability inquiries regarding future demand.

To review earliest item availability:

  1. Go to Transactions > Order Management > Earliest Item Availability.

  2. Select a Subsidiary.

  3. Select the Item you want to display availability for.

    The locations holding inventory are displayed and the related columns are populated.

  4. To filter your item availability, select a Sales Channe l.

    To display the available supply pool, leave the field empty.

  5. Enter the number of items you need in the Quantity field.

    If the displayed Earliest Available Dates dates do not match your required date, enter a lower quantity, and review other locations for available inventory.

  6. To apply rules to the date calculation, select an Allocation Strategy.

  7. If your allocation strategy has an allocation period, select a Supply Required by Date.

    This period can be before or after Supply Required By Date.

  8. Click Save.

To reserve an order:

  1. Go to Transactions > Order Management > Enter Order Reservations > List.

  2. Beside the reservation you wan to approve, click Edit.

  3. Click Approve.

    For more information, see Order Reservations.

Maximize Existing Supply

After Supply Allocation is enabled, the NetSuite allocation optimization can compute the maximum sales outcome based on the existing supplies and achieve:

  • Maximum sales order fill rate

  • Maximum sales revenue

  • Maximum sales profit

To maximize existing supply:

  1. Go to Transactions > Order Management >Allocate Orders.

    For example:

    • Subsidiary is United States

    • Location is San Francisco

    • Item is PR100-A

    • Transaction Type is Sales Order

  2. In the Allocation Processing Option field, select Using Gross Profit Optimization on Sales Orders.

    Show Gross Profit Percentage information is displayed on the sub-list.

  3. After clicking Submit, the system will:

    • maximize gross profit while making perfect allocations when possible.

    • allocate the leftover inventory to the remaining sales orders, as outlined in the supply allocation setup demand sorting options.

    • setup is primarily by Supply Required By Date.

  4. Go to Setup >Order Management >Supply Allocation.

  5. In the Demand Preferences subtab, select Demand Transaction Sorting Options.

  6. Allocate the sales orders according to their allocation strategy. Start with the earliest available date (today and forward).

Because the sales order-book changes, the optimized allocation needs to be regularly re-calculated. The entire process can be automated using the Order Allocation Schedule.

To set up optimized allocation batch:

  1. Optimize allocations and consume suitable current and future inventory.

    • Ignores allocation strategies and follows its own algorithm.

    • Targets perfect allocation.

  2. The system allocates leftover supplies:

    According to the allocation strategies and the default demand sorting options.

  3. In the Supply Allocation Setup, in the Demand Transaction Sorting Options section, Sort By field, select Supply Required by Date.

    If you used saved search on the optimization batch, sort the saved search by requested date.

  4. On the Order Allocation Strategy page, under the Allocation Method section, select Allocate as Soon as Available Before Supply Required by Date option.

    Do not use the Allocate Complete and Allocation Period options.

    This allocation keeps the remaining current and future inventory after the gross profit optimization in inventory for the shortest possible time.

Related Topics:

Earliest Item Availability Examples

The following table shows that on Feb 15, 2020 supply-demand called for a complete bicycle item with an ATP Lead Time of 90 days, from the Parent Location.

Supply Required by Date

Expected Supply Date

Order

Supply Quantity

Demand Quantity

Allocated Demand

Allocated Supply

Notes

 

Feb. 15, 2020

LOC-INV

10

 

10

 

 

 

Feb. 21, 2020

Purchase order #1/1

10

 

10

 

Allocation Strategy: All supplies are limited to 30 days before 0 days after the Supply Required by Date

Feb. 22, 2020

Feb. 22, 2020

Sales order #2

 

6

 

6

 

 

Feb. 28, 2020

Purchase order #1/2

15

 

1

 

 

Mar. 5, 2020

Mar. 5, 2020

Sales order #1

 

15

 

15

Allocation Strategy: All supplies are limited to 30 days before 0 days after the Supply Required by Date.

Apr. 1, 2020

Mar. 16, 2020

Sales order #3

 

15

 

 

Allocation Strategy: All supplies are limited to 30 days before 0 days after the Supply Required by Date (not allocated, but ATP-LT).

 

Total

 

35

36

21

21

 

In another scenario, the following procedure describes a customer asking for the earliest availability of 10 Complete Bike Items from the Parent Location, ideally in two day’s time. The Supply Required By Date is Feb. 17, 2022.

Example 2 procedure:

  1. In a new Sales Order, enter the required Item Quantity, Location, Date , and Allocation Strategy for All Supplies.

  2. In the Availability pop-up window the earliest supply allocation date Feb. 28, 2020.

    The Supply Allocation calculation uses the following data:

    • The Allocation Strategy determines which source of supply to use in the calculation.

    • It considers the allocation strategy on the order line. This can be changed in Availability window.

    • It does not allocate supplies, it only simulates an allocation.

  3. Optionally, to populate the computed Earliest Availability Date as Supply Required By Date, on the order line on the availability pop-up window, click OK.

    The Available To Promise feature would have computed the following availabilities for the same scenario:

    • The Discrete ATP, Earliest Available Date is Feb. 21, 2020. This result ignores the on hand balance from Feb 15 as is committed.

    • The Cumulative ATP with Look Ahead Earliest Available Date is March 1, 2020. This date considers all existing supply and demand, even if allocated, but not if it is committed.

General Notices