Item Data by Warehouse (whwmd2510m000)

Use this session to view the item data by warehouse.

Warehouse and item combinations are automatically generated in the current session when:

  • Starting from the Items (tcibd0501m000) session, item ordering data is created in the Items - Ordering (tcibd2100m000) session and item warehousing data is created in the Item - Warehousing (whwmd4100s000) session.
  • An order is created for a warehouse and item combination that is not available in the current session.

You can view the inventory of the items for each warehouse in the Warehouse - Item Inventory (whwmd2515m000) session.

Note

To update processing parameters at multiple item and/or warehousing levels, on the appropriate menu, click Update active Parameters in Warehouses and Items.

 

Warehouse

The warehouse code.

Item

The code identifying the item that is stored in the warehouse.

Status

The status of the warehouse and item combination.

Use Item Ordering Data

If this check box is selected, the item values specified in the Items - Ordering (tcibd2100m000) session are taken into account when item-warehouse combinations are created.

If this check box is cleared, the values of the following fields in the current session are taken into account:

  • Expected Annual Issue
  • Season Pattern for Demand
  • Seasonal Pattern for Safety Stock
  • Order Method
  • Order Quantity Increment
  • Minimum Order Quantity
  • Maximum Order Quantity
  • Fixed Order Quantity
  • Economic Order Quantity
  • Maximum Inventory
  • Reorder Point
  • Safety Stock
  • First Allowed Order Date
  • Last Allowed Order Date

Generate order advice

When you generate order advice by item and warehouse by means of the Generate Order Advice (SIC) (whina3200m000) session, the setting of this check box determines the field values that LN uses as input. For more information, refer to Input data for order advice.

Inventory Valuation Method
Order System

The order system and the order method control how to plan purchase and or/production orders.

Order Method

The order method and, among other data, the order system, determine the order quantity in planned purchase, production, and replenishment orders for the item.

Supply System

The system that is used to coordinate the timely supply of goods to the production lines or assembly lines.

The following supply systems are available in LN:

  • Time-Phased Order Point
  • KANBAN
  • Order Controlled/Batch
  • Order Controlled/SILS
  • Order Controlled/Single

Allowed values

Supply System

Allocation Level

The inventory allocation level for the current item stored in the current warehouse.

Allow Negative Inventory

The default value is taken from the Allow Negative Inventory field of the Item - Warehousing (whwmd4100s000) session.

If the value in the Allow Negative Inventory field of the Item - Warehousing (whwmd4100s000) session is No, the values Yes and If on Order are unavailable in this field.

Create Outbound Advice Despite Inventory Shortage

If this check box is selected, LN allows outbound advice to be generated even if insufficient inventory is available. To generate outbound advice for negative inventory, the Create Outbound Advice Despite Inventory Shortage check box in the Generate Outbound Advice (whinh4201m000) session must also be selected.

If the value of the Allow Negative Inventory field is:

  • No, this check box is unavailable.
  • If on Order, outbound advice for negative inventory cannot exceed the on order quantity expected to be received.
Note

If this check box is cleared, you can still manually create outbound advice through the Outbound Advice (whinh4525m000) session in case of inventory shortage.

Generate Handling Unit Automatically during Projected Shipments

Select Yes if automatic generation of handling units is required when projected shipments are created, otherwise select no No.

Note that the setting made in this field overrules the setting of the Generate Handling Unit Automatically during Projected Shipments field of the Warehouses (whwmd2500m000) session.

Dynamic Cross-docking

If this check box is selected, dynamic cross-docking is possible for this item-warehouse combination.

Note
  • This field can only be selected if the Dynamic Cross-docking check box is selected in both of the following sessions:

    • Item Data by Warehouse (whwmd2110s000)
    • Item - Warehousing (whwmd4100s000)
  • If a cross-dock order exists for this warehouse or item, you cannot clear this check box.

Related topics

Handling Units in Use

If this check box is selected, handling units are used for the selected item in the current warehouse.

Shipments

If this check box is selected, handling units are used in shipment processes carried out for the selected item in the current warehouse.

Kanban ID

The kanban identification number.

Text

If this check box is selected, a text related to the item - warehouse data exists.

Note

To specify the text, go to References > Texts > Text.

Supply from Warehouse

If this check box is selected, supply must take place from a warehouse.

Supply Warehouse

The warehouse from which supply must take place.

Buy-from Business Partner

The buy-from business partner that must supply the item.

Reorder Point

A set inventory level where, if the total stock on-hand plus total on-order falls below that point, action is taken to replenish the stock.

Inventory control is based on a number of decision rules, which determine when, and in what quantity an item is ordered. This depends on the order method and the values of the following fields in the current session:

  • Reorder Point
  • Economic Order Quantity
  • Fixed Order Quantity
  • Order Interval
  • Maximum Inventory

If the reorder point and the economic order quantity are specified, recommended orders to replenish the stock are generated as soon as the economic stock falls below the reorder point.

The order quantity can be fixed or variable, depending of the values specified for the Fixed Order Quantity and Maximum Inventory fields.

If you also specify an order interval, orders are not generated the moment the economic stock falls below the reorder point, but LN checks at fixed points in time whether the economic order quantity has fallen below the reorder point. If yes, LN generates a recommended order.

Note

The reorder point is updated in the Global Update of Inventory Parameters (whina2200m000) session. If the Update Inventory/Order Data check box in this session is selected for the item concerned, the reorder point is updated.

 

Items - Ordering

Starts the Items - Ordering (tcibd2100m000) session.