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 Item Defaults (tcibd0102m000) session, item ordering data is created in the Items - Ordering (tcibd2100m000) session and item warehousing data is created in the Item - Warehousing (whwmd4600m000) 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.

Field Information

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.

Tentative

If the status is Tentative, you cannot yet use the warehouse and item combination in Warehousing . As a result, you cannot receive the item in the warehouse.

Active

If the status is Active, you can use the warehouse and item combination in Warehousing .

Note: If the item warehouse status is Active, you cannot change it to Tentative.
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 (SIC).

Inventory Valuation Method
Standard Cost

The standard cost, including any surcharges or discounts. Item standard costs are calculated in the Calculate Standard Cost (ticpr2210m000) session.

For further information, see:

  • Cost Calculation Code
  • Standard Cost
Moving Average Unit Cost (MAUC)

During receipt, goods are valued against the receipt price. For further information, see Moving Average Unit Cost (MAUC).

If Inventory Valuation Method is set to Moving Average Unit Cost (MAUC), LN allows you to select the Valuation by Warehouse Valuation Group check box in the Item Data by Warehouse (whwmd2510m000) session; and the inventory valuation is based on the MAUC by Warehouse Valuation Group valuation method.

First In First Out (FIFO)

When issued, goods are valued against the oldest inventory value. During receipt, the inventory value and the receipt quantity is stored in the Inventory Receipt Transactions (whina1512m000) session .The value of these receipts will be consumed during each issue in FIFO order.

Receipt 1 100 pcs of $5 each
Receipt 2 100 pcs of $6 each
Inventory value 100 x $5 + 100 x $6 = $1100
Issue 1 150 pcs consisting of 100 x $5 + 50 x $6 = $800
Remaining Value 50 pcs of $6 each = $300
Last In First Out (LIFO)

When issued, goods are valued against the most recent inventory value. During receipt, the inventory value and the receipt quantity is stored in the Inventory Receipt Transactions (whina1512m000) session. The value of these receipts will be consumed during each issue in LIFO order.

Receipt 1 100 pcs of $5 each
Receipt 2 100 pcs of $6 each
Inventory value 100 x $5 + 100 x $6 = $1100
Issue 1 150 pcs consisting of 100 x $6 + 50 x $5 = $850
Remaining Value 50 pcs of $5 each = $250
Lot Price (Lot)

The inventory is valued against the lot price defined for the specific item during receipt or issue. The lot price is filled with the purchase order price. For manufactured lot items, the lot price is filled with the standard cost value. For more information, refer to Lot pricing.

Lot price 6.50
Receipt 1 100 pcs of $6.5 each
Receipt 2 100 pcs of $6.5 each
Inventory value 200 x $6.5 = $1300
Issue 1 150 pcs of $6.5 each = $975
Remaining Value 50 pcs of $6.5 each = $325
Serial Price (Serial)

The inventory is valued against the lot price defined for the specific item during receipt or issue. The serial price is filled with the purchase order price. For manufactured serialized items, the serial price is filled with the standard cost value.

Serial price 6.50
Receipt 1 100 pcs of $6.5 each
Receipt 2 100 pcs of $6.5 each
Inventory value 200 x $6.5 = $1300
Issue 1 150 pcs of $6.5 each = $975
Remaining Value 50 pcs of $6.5 each = $325
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

supply system

Allowed values

Time-Phased Order Point

Time-phased order point (TPOP)

Kanban

Kanban is typically used for low-cost component items, and not used for External Kanban Controlled Items. See Kanban.

Order Controlled/Batch

Used if Manufacturing is implemented. See Order Controlled/Batch setup and order generation.

Order Controlled/SILS

Used if Manufacturing is implemented. See Order Controlled/SILS setup, assembly kits, and order generation.

Order Controlled/Single

Used for subassembly items if Manufacturing is implemented. See Order Controlled/Single setup and order generation.

None

Used for purchased configurable items.

Automatically Release Production Orders

If this check box is selected, production orders created for kanban supply are automatically released.

If this check box is cleared, production orders are released in the Release Production Orders (tisfc0204m000) session.

Allocation Level

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

Allow Negative Inventory

Allowed values

Yes

LN allows outbound advice, even if insufficient inventory is available and even if no on-order quantity is available to fulfill the demand.

No

LN allows no outbound advice if insufficient inventory is available. A shortage report is printed instead.

If on Order

LN allows outbound advice if insufficient inventory is available, but only up to the on-order quantity to be received that will fulfill the demand.

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

If the value in the Allow Negative Inventory field of the Item - Warehousing (whwmd4600m000) 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

The settings that control automatic generation of handling units when projected shipments are created.

Allowed values

Always

Always generate handling units automatically for the current warehousing process.

For Ownership/Specification

Generate a handling unit when the current warehousing process is launched and one of the following applies:

  • The value of the ownership registration level for the item, warehouse and business partner is Physical Item or Physical Item and Location
  • The inventory allocation level is Physical Item

Note that for this option to work, for the current warehouse and/or item, handling units must be in use for receipts, inbound and outbound inspections, and shipments. For further information about other settings required for handling units and ownership registration, see Ownership registration setup in Warehousing. For information about handling units and allocation and hard pegging, see Demand pegging overview.

Never

Never generate handling units automatically for the current warehousing process.

Note: The setting specified 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 (whwmd4600m000)
  • If a cross-dock order exists for this warehouse or item, you cannot clear this check box.

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.

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.
Inventory Inspection

If this check box is selected, inventory inspections are implemented.

If this check box is cleared, storage inspections are used, provided that the integration with Quality storage inspections is set up.

The default setting of this check box is taken from the Item - Warehousing (whwmd4500m000) session, the Item - Warehousing (whwmd4600m000) session, or the Item - Warehousing by Site (whwmd4104m000) session.

You cannot select this check box if unprocessed storage inspections are present in Quality . You cannot clear this check box if unprocessed inventory inspections are present in Warehousing .

Frequency for Inventory Inspection

The frequency for inventory inspections of the current item expressed in days.

When inventory inspections are generated, the value in this field is added to the last date on which an inventory inspection was performed to determine the inventory inspection due date.

If the Inventory Inspection check box is selected, the frequency applies to inventory inspections. If the Inventory Inspection check box is cleared, the frequency applies to storage inspections.

To generate inventory inspections, the value in this field must be greater than zero. Inventory inspections are generated in the Generate Inventory Inspections (whinh2211m000) session.

Allowed values

Minimum: 0

Maximum: 999

Default value

0

Allow Stock Point Issue during Inventory Inspection

If this check box is selected, issues of unblocked quantities from stock points for which an inventory inspection is performed are allowed.

Supply from Warehouse

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

If this check box is cleared, a supply order is created based on the item source.

For planned items this check box must be selected.

This check box must be selected for planned items and for supply system Order Controlled/Single.

Supply Warehouse

The warehouse from which supply must take place.

The selected supply system and the order for which the supply is required determine whether the warehouse from which supply takes place is the supply warehouse specified in the Supply Warehouse field or the warehouse defined for the order.

Note: For planned items, the warehouse and the supply warehouse should reside in the same planning cluster.

Buy-from Business Partner

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

Reorder Point

reorder point

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, order advice to replenish the stock is 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, order advice is 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 order advice.

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.

Order Interval

The order interval for ordering the same item. By using an order interval you can prevent a too big and frequent flow of planned orders.

Note: If you select the Use Item Ordering Data check box in the current session, the order interval is retrieved from the Items - Ordering (tcibd2100m000) session.
QM Overrules Warehouse Inbound Order Type

If this check box is selected, the settings in the Testing Combinations (qmptc0119m000) session determine whether inbound inspections are performed in Quality and Warehousing for receipts of the item in the current warehouse.

Default value

By default this check box is selected.

This check box is unavailable if Quality is not implemented.

Note: 

For purchased items, the inspection settings in Purchase Control are leading. If inspection is required for an item according to Purchase Control settings, an inbound inspection is automatically created even if no inspection procedure is present in Warehousing and no testing combinations are present in Quality.

Conversely, if no inspection is required according to the Purchase Control settings, no inspection is created regardless of the inspection settings in Warehousing and Quality.

See

Kanban Horizon for Historical Demand in Days

The number of days in the past up to and including the current day for which LN checks the issues for production orders in the Item - Warehouse - Inventory Transactions (whinr1510m000) session to calculate the average daily demand. The average daily demand is used to calculate the number of kanban signals.

Kanban Horizon for Future Demand in Days

The number of days from the current day onwards for which LN checks the planned issues for production orders in the Planned Inventory Transactions (whinp1500m000) session to calculate the average daily demand. Issues planned for a date in the past that are yet to occur are also included. The average daily demand is used to calculate the number of kanban signals.

Kanban Average Daily Demand

The average daily demand for (end) items from the current warehouse based on Job Shop Control production orders.

The items supplied by the kanban order are used to assemble or produce the (end) items. The average daily demand is used to calculate the number of kanban signals.

Kanban Buffer

A percentage of the average daily demand used to calculate the number of kanban signals and the supply quantity of kanban loops. This percentage is added to the average daily demand, which results in a higher supply quantity for the kanban loops. This is used to prevent underdeliveries.

Percentages in excess of 100% are allowed.

Kanban Stock Coverage

The number of days within the future horizon, which usually represents the lead time of an end product for which the component demand is covered by the available stock. The lead time is the transport time added with the production time.

The stock coverage is used to calculate number of kanban signals. The stock coverage is manually specified.

Total Supply Quantity

supply quantity

The total supply quantity is the kanban signal quantity multiplied by the number of signals.

Kanban Average Daily Demand Modification Date

The date and time on which the average daily demand is changed.

Kanban Average Daily Demand Manually or Calculated

Specifies whether the average daily demand is calculated or manually specified.

This information is used in the Global Update of Kanban Parameters (whinh2200m100) session, where you can specify whether manually entered average daily demands must be updated.

Signal Supply Quantity

The quantity of items that must be supplied by a kanban signal. This quantity is manually specified.

Number of Signals

The default number of kanban signals that is used to supply the assembly line or production line if the supply system is Kanban. This value can be specified manually or calculated by LN.

Label Layout

The code of the layout based on which the labels, that are used for Kanban, must be printed.

Note: If the supply system is Kanban, you must specify the label layout.

Choose Print to print the label to be attached to the Kanban signal.

Active Signals Present

If this check box is selected, active kanban signals are present for the current item and warehouse combination.

Generate Kanban Orders/Advice Automatically

If this check box is selected, LN generates a kanban supply order or order advice when a kanban signal is created or activated.

If the Generate Order Advice check box is selected in the current session, order advice is generated. If the Generate Order Advice check box is cleared, a kanban supply order is created.

Number of Signals Modification Date

The date and time on which the number of kanban signals is changed.

Number of Signals Manually or Calculated

Specifies whether the number of kanban signals is calculated by LN or manually specified.

This information is used in the Global Update of Kanban Parameters (whinh2200m100) session, where you can specify whether manually entered numbers of kanban signals must be updated.