Item Data by Warehouse (whwmd2510m000)

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.

Allowed values

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

Allowed values

Standard Cost

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

The standard cost valuation method is allowed for project pegged items and non-project pegged items.

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.

Rental Inbound Lead Time

The inbound lead time for an item of type, Rental Product, that is returned after rental period.

This rental inbound lead time is used to determine the default available after return time on the equipment line of the rental order in Service.

Note: 

• This field is displayed only if the Equipment as a Service check box is selected in the Implemented Software Components (tccom0100s000) session.
• This field is enabled only if the item is of type, Rental Product.
• The value of this field is defaulted from the Inbound field in the Warehouses (whwmd2500m000) session.

Rental Inbound Lead Time Unit

The unit in which the Rental Inbound Lead Time is expressed.

Allowed values

Days

Hours

Note: 

• This field is displayed only if the Equipment as a Service check box is selected in the Implemented Software Components (tccom0100s000) session.
• This field is enabled only if the item is of type, Rental Product.
• The value of this field is defaulted from the Rental Inbound Lead Time Unit in the Warehouses (whwmd2500m000) session.
• This field is set to Hours by default.

Rental Outbound Lead Time

The outbound lead time for an item of type, Rental Product, that is shipped for rental usage.

This rental outbound lead time is used to determine the default ‘planned release time’ on the equipment line of the rental order in Service.

Note: 

• This field is displayed only if the Equipment as a Service check box is selected in the Implemented Software Components (tccom0100s000) session.
• This field is enabled only if the item is of type, Rental Product.
• This value is defaulted from the Outbound field in the Warehouses (whwmd2500m000) session.

Rental Outbound Lead Time Unit

The unit in which the Rental Outbound Lead Time Unit is expressed.

Allowed values

Days

Hours

Note: 

• This field is displayed only if the Equipment as a Service check box is selected in the Implemented Software Components (tccom0100s000) session.
• This field is enabled only if the item is of type, Rental Product.
• • This value is defaulted from the Rental Outbound Lead Time Unit in the Warehouses (whwmd2500m000) session.
• This field is set to Hours by default.

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.
• You cannot select a MES controlled warehouse in this field. See Supply controlled by Infor Forcam MES.

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

Rental Owner Registration by Location

Indicates whether only the locations dedicated to a specific Rental Owner can be used for the rental products. The inventory in this type of location includes only the inventory of the rental owner to which the location is allocated.

Note: 

• This setting is defaulted from Item - Warehousing by Site (whwmd4604m000) session if site concept is implemented else, the setting in theItem - Warehousing (whwmd4500m000) session is considered.
• This field is displayed only if the Equipment as a Service check box is selected in the Implemented Software Components (tccom0100s000) session.

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.