Item Data by Warehouse (whwmd2110s000)
Use this session to view and maintain data and settings for items stored in particular warehouses.
LN automatically generates warehouse and item combinations 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 an item-warehouse combination that is not available in the current session.
By default, LN takes the data from the Items - Ordering (tcibd2100m000) session. Clear the Use Item Ordering Data check box, if you want to define exceptions for the item-warehouse combination.
When generating order advice, by default LN uses data from the Items - Ordering (tcibd2100m000) session or the Items - Purchase Business Partner (tdipu0110m000) session as input. Clear the Use Item Ordering Data check box if order advice must be based on data from the current session. For more information, refer to Input data for order advice (SIC).
If you want to delete items from a warehouse, LN checks whether inventory on hand, allocations, or planned receipts of the item are present before deleting items. If this is the case, the item is not deleted.
Field Information
- General
-
- Warehouse
-
The warehouse in which the item is stored.
- Item
-
The code identifying the item that is stored in the warehouse.
- General
-
- Item Warehouse Status
-
The status of the item/warehouse 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.
- Storage Zone
-
The code of the zone where the item is stored. This zone is used only in warehouses that do not use locations.
Note: This field is for information only. - Default Location Type for Inbound Advice
-
The type of location to which the received items are preferably advised.
Allowed values
- Receiving location
-
The location in which the received goods are placed while they await the generation of an inbound advice.
- Pick location
-
The inventory location designated for order picking purposes. A pick location is mainly used for the outbound of small quantities and/or containers that can be replenished by bulk locations.
- Bulk location
-
The location used mainly for large inbound quantities and/or containers and to indicate from which pick locations can be replenished.
- Staging location
-
A shipping dock in the warehouse where items are held just before they are placed on any means of transport for shipment.
- Inspection location
-
A type of inventory location exclusively designated to store items that are eligible for inspection upon receipt.
After the items have passed inspection, they are transferred to:
- A normal location if they are approved.
- A quarantine location if they are rejected.
Goods in an inspection location are always considered to be on-hold inventory.
- Quarantine location
-
A type of warehouse location in which goods initially rejected during warehousing inspection or production are stored for further examination to determine their disposition.
Note: In locations of type Receiving, stock points are not supported.
Default value
LN retrieves the default value from the Default Location Type field in the Warehouses (whwmd2500m000) session.
This parameter does not affect the following special cases:
- If the received items must be crossdocked, LN advises the received items preferably to a staging location.
- If the received items must be inspected, LN always advises the received items to the inspection location. After the item is approved during inspection, the item is advised to the type of location as specified in the current field.
- If a package definition is specified on the receipt, LN preferably advises the received items to a location of the Location Type that is specified in the Package Definition Levels (whwmd4120s000) session.
If LN cannot advise the received items to a location of the preferred location type (either Bulk or Pick) and there is no package definition defined for the received items, LN advises the received items to a location of the other location type (either Pick or Bulk).
- Package Definition
- Order Costs
-
The order costs for the item. This is used to determine the economic order quantity.
- Order Costs
-
The reference currency in which the value of the item inventory is expressed.
- Inventory Carrying Costs per Year
-
The inventory-carrying costs per year for the item per inventory unit. This is used to determine the economic order quantity.
- Allocation Level
-
The inventory allocation level for the current item stored in the current warehouse.
- Net Change
-
If this check box is selected, this item is taken into account when you run the Generate Order Planning (cprrp1210m000) session.
- Text
-
If this check box is selected, a text related to the item - warehouse data exists.
Note: To specify the text, go to . - 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.
- Ownership
-
- Registration Level
-
Allowed values
- Warehouse
-
Inventory ownership registration for the entire warehouse. The entire inventory of the warehouse is owned by one particular business partner. For example, this is used for a supplier, who owns the inventory held in consignment in a particular warehouse, usually located at the customer's.
- Location
-
Inventory ownership registration by location. Each location within a warehouse can contain inventory owned by a particular business partner. Locations can be allocated to a business partner, and the inventory stored in a particular location is owned by the business partner to which the location is allocated.
- Physical Item
-
Inventory ownership registration by individual item. To enable ownership registration for an individual item, the item must be contained in a handling unit. Note, however, that no reference is made to any subdivisions of the warehouse, such as locations or zones. In fact, the owner of the item contained in the handling unit can be different from the business partner of the location in which the handling unit is stored.
Note also that a handling unit can contain child handling units, each owned by a different business partner.
- Physical Item and Location
-
Inventory ownership registration by location and individual item. To enable ownership registration for an individual item, the item must be contained in a handling unit. The items contained in the handling units stored in a particular location are owned by the business partner to which the location is allocated.
- Not Applicable
-
Ownership registration is not used.
- Issue Priority
-
Allowed values
- Free
-
Outbound advice control the issue of the item from the current warehouse, without ownership restrictions.
- Owned Inventory First
-
Outbound advice for owned inventory is issued before not-owned inventory.
- Not Owned Inventory First
-
Outbound advice for not-owned inventory is issued before owned inventory.
- Not Applicable
-
Outbound advice is not used in the current warehouse, for example, because the warehouse is a financial warehouse.
The default value in this field is taken from the Items - Warehousing Defaults (whwmd4101s000) session.
List value Not Owned Inventory First is applicable to manufactured items, purchased items, and generic items that are no customized standard-to-order (STO) items. For customized STO items, you must select value Free. However, this value is not available if the value in the Registration Level field is Warehouse.
- Ownership for Return to Warehouse
-
This field determines how to handle the ownership for production return orders. On a production order, a business partner is not known. As a result, Manufacturing cannot read an agreement. Instead, Manufacturing obtains a default value from the current field. The default value in this field is retrieved from the field Ownership for Return to Warehouse of the Item - Warehousing (whwmd4600m000). The following values are available: Ownership
- Usage at Warehouse Transfer
-
The issue of the current item from the current warehouse for a warehouse transfer is a usage, resulting in a change of ownership: Usage at warehouse transfer
- Settings
-
- 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).
- Update Inventory/Order Data
-
If this check box is selected, you can automatically update item data in the following sessions:
- Global Update of Inventory Parameters (whina2200m000)
- Calculate Economic Order Quantity (Camp) (whina2201m000)
- Calculate Demand Forecast (whina2202m000)
If you run the sessions mentioned previously, LN overwrites some data in the following sessions:
- Item - Warehousing (whwmd4600m000)
- Item Data by Warehouse (whwmd2110s000)
- Exclude from Cycle Counting
-
If this check box is selected, the current item will be ignored for cycle counting.
- Process Inventory Variances Automatically
-
If this check box is selected, LN processes inventory variances automatically.
- 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
- Use Fulfillment Plan
-
If this check box is selected, the Fulfillment Planning functionality of the Inventory Control Services module (ICS) controls outbound advice for the warehouse and the item. The outbound advice and the fulfillment plan from ICS must match. If no fulfillment plan is present, LN cannot create outbound advice for the warehouse and item.
- Allow Negative Inventory
-
- 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.
- Date/Time Settings
-
- Date/Time Settings
-
- 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. - First Allowed Order Date
-
The date from which an order can be created for the item. LN gives a warning when a purchase order, production order or replenishment order is created before this date.
- Last Allowed Order Date
-
The last date on which an order can be created for the item. LN gives a warning when a purchase order, production order or replenishment order is created after this date.
- Lead Time
-
- Inbound
-
Default value
LN retrieves the default value from the Inbound field of the Warehouses (whwmd2500m000) session.
- Inbound Lead-time Unit
-
The unit in which the inbound lead time is expressed.
- Outbound
-
Default value
LN retrieves the default value from the Outbound field of the Warehouses (whwmd2500m000) session.
- Outbound Lead-time Unit
-
The unit in which the outbound lead time is expressed.
- Cross-dock
- Cross-dock Lead Time Unit
-
The unit in which the cross-dock lead time is expressed.
- Safety
-
LN uses the Safety to calculate the demand forecast in the Calculate Demand Forecast (whina2202m000) session.
LN retrieves the default safety time from the Safety Time field of the Items - Ordering (tcibd2100m000) session.
- Safety Time Unit
-
The unit in which the safety time is expressed.
- Rental Lead Times
-
- Inbound
- 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 the Service module.
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 Inbound 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.
- Outbound
- 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 Outbound 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.
- Forecast
-
- Forecast
-
- Forecast Method
-
The forecast method code for a standard item. The forecast-method code is only used when LN calculates a demand forecast in the Calculate Demand Forecast (whina2202m000) session.
- Expected Annual Issue
-
The standard item's expected annual usage or issue tem.
This is used to calculate the expected safety-time usage. If the Update Inventory/Order Data field is selected the field is updated in the Global Update of Inventory Parameters (whina2200m000) session. The expected annual issue is calculated on the basis of the calculated values of the Trend field and the Forecast Period Demand field.
- Inventory Unit
- Period
-
The number of periods the forecast applies to.
- Period Type
-
The period type.
- Season Pattern for Demand
-
The seasonal-pattern code for demand is filled if:
- There is a season-dependent demand for the item.
- The demand forecast must be calculated by using the Calculate Demand Forecast (whina2202m000) session.
- Service Level [%]
-
The service level, expressed as a percentage. You can use the service-level percentage to calculate the safety stock.
Allowed values
0 -100
Default value
0
The service-level percentage indicates the percentage of the demand for the item that can be delivered from inventory. A service level of 95% means that 5% of the demand cannot be met.
- Turnover
-
- Slow-Moving Percentage
-
The slow-moving percentage of a standard item. This percentage indicates the item's turnover rate.
- ABC Code
-
The ABC code of the item for the current warehouse.
If the Manually Entered ABC Code check box is selected, the current field is updated by the Perform ABC Analysis (whina6210m000) session.
You can set the boundaries of the ABC classification in the Inventory Analysis Parameters (whina0100m000) session.
- Manually Entered ABC Code
-
If this check box is selected, the ABC code is overwritten by using the Item Data by Warehouse (whwmd2110s000) session.
- Replenishment
-
- Order Settings
-
- 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).
- Order System
-
The order system and the order method control how to plan purchase and or/production orders.
The choice of order system depends on the selected item type and order policy.
- 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.
- Order Quantity Increment
-
The multiplication factor of the order quantity. When LN generates planned orders, it also checks whether the order quantity is a multiple of the factor entered in this field.
- Minimum Order Quantity
-
The minimum order-quantity prevents purchasing, producing, or replenishing this item in too small quantities for an order.
Allowed values
Numeric values
Note: When planned orders are generated, the quantity of items to be purchased, produced, or replenished will never be less than the minimum order-quantity. - Maximum Order Quantity
-
The maximum order-quantity prevents purchasing, producing, or replenishing too many items for an order.
Allowed values
Numeric values
Note: When planned orders are generated, the quantity of items to be purchased, produced, or replenished is never greater than the maximum order-quantity. - Fixed Order Quantity
-
If you use the fixed order quantity order method, this field shows the item quantity that appears on:
- Planned purchase-orders
- Replenishment orders
- Production orders
Default value
0
- Economic Order Quantity
-
If you use the Economic Order Quantity order method, this field shows the item quantity that appears on:
- Planned purchase-orders
- Replenishment orders
- Production orders
Update this order quantity in the Calculate Economic Order Quantity (Camp) (whina2201m000) session.
- Maximum Inventory
-
The item's maximum inventory in the warehouse.
Note: If the item's method is Replenish to Maximum Inventory, the maximum inventory determines the quantity that LN uses to generate purchase, production, and/or replenishment orders. - 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. - Safety Stock
-
The safety stock of an item in a specific warehouse.
The purpose of safety stock is to cushion the effect of deviations between expected and actual demand and between:
- Expected delivery time
- Actual delivery time
In addition, LN takes the safety stock into account when generating replenishment advice in Enterprise Planning .
Note: The value of safety stock must always be lower than or equal to the maximum inventory. If not, LN displays a message. - Seasonal Pattern for Safety Stock
-
The seasonal-pattern code for the safety stock.
Through the seasonal pattern selected here you can define a time-dependent safety stock. You can use this seasonal pattern to build a safety stock during a period with low demand for the item.
- Valuation Method
-
- Serials
-
- Serial Price
-
If this check box is selected, the serial price is maintained by default. You can select this check box if, in the Item - Warehousing (whwmd4600m000) session, the Serials in Inventory check box is selected for the item. This check box is selected by default if the Serial Price check box is selected in the Item - Warehousing (whwmd4600m000) session.
If the item is not present in the Serialized Items (tcibd4501m000) session, you can select or clear this check box. If the item is present in the Serialized Items (tcibd4501m000) session, the value in this field can only be changed if the inventory valuation method is changed for the item.
- Inventory Valuation Method
-
- 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
- Valuation by Warehouse Valuation Group
-
If this check box is selected, valuation for this warehouse is performed by warehouse valuation group.
- Supply
-
- Line Supply Settings
-
- Supply System
-
- 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 Company
-
The logistic company to which the warehouse in the Supply Warehouse field belongs.
- 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.
You can only specify a buy-from business partner in the current field if the Supply from Warehouse check box is cleared.
If no buy-from business partner is specified in the current field, LN retrieves the buy-from business partner from the Items - Purchase (tdipu0101m000) session.
- Ship-from Business Partner
-
The ship-from business partner that is related to the buy-from business partner in the Buy-from Business Partner field.
You can only have a ship-from business partner in this field if the supply type is Supplier.
You can only specify a ship-from business partner in this field who can deal with electronic data interchange (EDI) 866 messages. You can specify if a ship-from business partner can deal with EDI messages in the Communication Channel field of the Items - Purchase Business Partner (tdipu0110m000) session.
- 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.
- Assembly Kit
-
Note: You can only specify an assembly kit if the supply system is Order Controlled/SILS.
- Trigger-from Station
-
Note: You can only specify a trigger-from station if the supply system is Order Controlled/Batch or Order Controlled/SILS.
- Miscellaneous
-
- Packaging Item
- Handling Remark
-
The container method that is associated to the packaging item.
- Location for Transfer
-
The code of the default location in the current warehouse to which the item is replenished from the Normal warehouse.
You can only specify the Location for Transfer if:
- A supply system is specified.
- The warehouse is location controlled.
- The item is location controlled.
- The warehouse type is Normal, Shop Floor, or Service.
You can only use locations of the following types:
- Pick
- Bulk
If a Storage Zone is specified for the current item/warehouse combination that is different from the zone to which the Location for Transfer belongs, LN assigns the zone as specified for the current item/warehouse combination to the Location for Transfer. In the Warehouse - Locations (whwmd3500m000) session, you can view the zone to which the location belongs.
- Kanban Supply
-
- Generate Order Advice
-
If this check box is selected, warehouse-order advice is generated for kanban signals in the Generate Orders (Kanban) (whinh2200m000) session.
- Combine Order Advice
-
If this check box is selected, supply requests for the same warehouse and item are combined into a single kanban-order advice.
If unconfirmed order advices with matching items and warehouses are present, the supply requests are combined with the existing advices.
- Automatically Confirm Order Advice
-
If this check box is selected, kanban-order advice is automatically confirmed after creation.
- Kanban
-
- Loop Settings
-
- Horizon for Historical Demand
-
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.
- Horizon for Future Demand
-
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.
- Offset Date
-
If this check box is selected, you can specify an offset date for the future horizon in the Offset Date field.
- Offset Date
-
The offset date for the future horizon.
The offset date is the starting point for the future horizon. For example, the current date is January 10th and the future horizon is 14 days. If you specify offset date January 24th, the future horizon spans from January 24th up to February 7th. The default offset date is the current date added with the Stock Coverage.
- 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.
- 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.
- 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
-
The total supply quantity is the kanban signal quantity multiplied by the number of signals.
- Average Daily Demand
-
- Average Daily Demand - Modification Date
-
The date and time on which the average daily demand is changed.
- Average Daily Demand - Calculated or Manually Entered
-
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 Settings
-
- 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 label to be attached to the Kanban signal.
to print the - 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
-
- Number of Signals - Modification Date
-
The date and time on which the number of kanban signals is changed.
- Number of Signals - Calculated or Manually Entered
-
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.
- Handling Units
-
- Use Handling Units in
-
If this check box is selected, handling units are used for the selected item in the current warehouse.
- Use Handling Units in
-
- Receipts
-
If this check box is selected, handling units are used in receipts taking place for the selected item in the current warehouse.
- Inbound Inspections
-
If this check box is selected, handling units are used in inbound inspections taking place for the selected item in the current warehouse.
- Inventory
-
If this check box is selected, handling units are used in inventory for the selected item in the current warehouse.
- Outbound Inspections
-
If this check box is selected, handling units are used in outbound inspections taking place 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.
- Outbound
-
- Advise Alternative Package Definition Allowed
-
If this check box is selected, LN allows you to generate an outbound advice for the inventory related to package definitions other than the one defined on the order, or inventory to which package definitions are not linked.
Note:If this check box is cleared, only the package definitions defined on the outbound order line is used in searching inventory for outbound advice.
This field is not applicable when the package definitions of type Fixed are ordered. For the package definitions of the type Fixed, LN uses only fixed package definitions to search the inventory during the outbound procedure.
- Consolidate Handling Units in one Shipment Line during Picking
-
If this check box is selected, multiple handling units picked for a specific outbound line are linked to one shipment line when the picking is confirmed.
If this check box is cleared, separate shipment lines are generated for each handling unit when the picking is confirmed.
Note: This parameter is relevant in case handling units are in stock and picked from stock. The parameter is not so relevant when handling units are (automatically) created when the picking is confirmed. - Fill Up Staged Handling Units with Newly Picked Items
-
If this check box is selected, picked anonymous stock can be used to fill up a handling unit that is Staged and has a variable package definition.
For example, variable package definition A has a template including one pallet containing 10 boxes, and each box contains 10 items B.
Handling unit 001 is staged and contains one pallet, 8 full boxes and one box containing four items B.
16 items B are picked from inventory. If this check box is selected, these items are added to handling unit 001: 6 items B are put in the partially filled box and the remaining 10 items B are packed in a box and put on the pallet.
- Generate Handling Units Automatically during
-
- Creation ASN
-
The settings that control automatic generation of handling units from advance shipment notices that include the selected item and the current warehouse.
Allowed values
- Always
-
Always generate handling units automatically from inbound ASNs.
- Handling Unit Received
-
Generate a handling unit if the inbound ASN includes handling unit codes provided by the supplier. LN generates an internal handling unit code if the external handling unit field has a value. If LN generates an internal handling unit code, LN creates an internal handling unit code that is identical to the external handling unit code. However, if an identical handling unit code exists in LN before the arrival of the ASN, this would result in duplicate records. In such cases, LN generates a new unique internal handling unit code using the mask functionality. The new internal code is also saved on the ASN.
- For Ownership/Specification
-
Generate a handling unit when an inbound advance shipment notice (ASN) is created and the value of the ownership registration level for the item, warehouse and business partner is Physical Item or Physical Item and Location.
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.
- Never
-
Never generate handling units automatically from inbound ASNs.
Note that the setting made in this field overrules the setting of the Creation ASN field of the Warehouses (whwmd2500m000) session.
- Confirm Receipts
-
Generate Handling Units automatically.
Note that the setting made in this field overrules the setting of the Confirm Receipts field of the Warehouses (whwmd2500m000) session.
- Confirm Picking
-
Select Yes if automatic generation of handling units is required when picking is confirmed, otherwise select no No.
Note that the setting made in this field overrules the setting of the Confirm Picking field of the Warehouses (whwmd2500m000) session.
- Creation of 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: This setting overrules the setting of the Generate Handling Unit Automatically during Projected Shipments field of the Warehouses (whwmd2500m000) session. - Process Adjustments Orders
-
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.
If handling unit generation is enabled, LN generates handling units for open adjustment order lines with positive variances. The handling units obtain the Adjustment Open status.
The setting made in this field overrules the setting of the Process Adjustments Orders field of the Warehouses (whwmd2500m000) session.
- Process Cycle Counting Orders
-
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 that the setting made in this field overrules the setting of the Process Cycle Counting Orders field of the Warehouses (whwmd2500m000) session.
- Dynamic Cross-docking
-
- Dynamic Cross-docking
-
- 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:
- Warehouses (whwmd2500m000)
- Item - Warehousing (whwmd4600m000)
- If a cross-dock order exists for this warehouse or item, you cannot clear this check box.
-
- Generate Cross-dock Order for Outbound Advice Shortage
-
If this check box is selected, and, after generating an outbound advice, an inventory shortage occurs, a cross-dock order is created for the inventory shortage.
Note: In the Generate Outbound Advice (whinh4201m000) session, you can still select or clear this check box. However, if you generate an outbound advice directly, for example, from within the Outbound Order Lines (whinh2120m000) session, this option applies to the warehouse-item level ( Item Data by Warehouse (whwmd2510m000)/ Item Data by Warehouse (whwmd2110s000)). - Generate Cross-dock Order Lines when Confirming Receipt
-
If this check box is selected, LN checks if there are any open cross-dock orders that must be fulfilled by incoming goods.
Note: Before confirm receipt takes place, you can overrule this setting by either selecting or clearing the Generate Cross-dock Order Lines when Confirming Receipt check box in the Receipt Lines (whinh3112s000) session. - Automatically Approve Cross-dock Order Lines
-
If this check box is selected, and cross-dock order lines are generated, these inbound order lines will immediately receive the status Approved.
Note:It is strongly recommended to select this option, if both of the following applies:
- The Generate Cross-dock Order Lines when Confirming Receipt check box is selected.
- The warehouse and/or the item is not location controlled.
- Priority Definition
-
cross-dock priority definition
Note:- The default value is the value as defined in the Warehouses (whwmd2500m000) session.
- If this field is empty when creating a cross-dock order, the cross-dock order priority definition will be retrieved from the Warehouses (whwmd2500m000) session.
- Restriction Definition
-
cross-dock restriction definition
- Minimum Cross-dock Quantity
-
No cross-dock orders will be generated for quantities less than this value.
Note:- The value in this field is defaulted from the Item - Warehousing (whwmd4600m000) session.
- You can always manually create cross-dock orders that do not comply with the values of the quantity fields. These fields only apply to the generation of cross-dock orders during release to warehousing and the Generate Cross-dock Orders (whinh6200m000) session.
- Maximum Cross-dock Quantity
-
No cross-dock orders will be generated for quantities more than this value.
Note:- The value in this field is defaulted from the Item - Warehousing (whwmd4600m000) session.
- You can always manually create cross-dock orders that do not comply with the values of the quantity fields. These fields only apply to the generation of cross-dock orders during release to warehousing and the Generate Cross-dock Orders (whinh6200m000) session.
- Create Cross-dock Order for Maximum
-
Indicates whether a cross-dock order will be generated for the maximum cross-dock quantity if the ordered quantity of the outbound order line is more than the quantity defined in the Maximum Cross-dock Quantity field.
Note:- The value in this field is defaulted from the Item - Warehousing (whwmd4600m000) session.
- You can always manually create cross-dock orders that do not comply with the values of the quantity fields. These fields only apply to the generation of cross-dock orders during release to warehousing and the Generate Cross-dock Orders (whinh6200m000) session.
- Generate Cross-dock Order when Releasing Order to Warehousing
-
- Generate Cross-dock Order when Rel. Order
-
Allowed values
- Never
-
No cross-dock orders are created.
- Always
-
Cross-dock orders are created when, for example, sales orders are released to Warehousing . Every cross-dock order is created for the entire order quantity.
- Time Phased Shortage
-
Cross-dock orders are created when, for example, sales orders are released to Warehousing . For each order, LN checks whether there will be an inventory shortage on the planned delivery date. In case of inventory shortage, a cross-dock order is created for the entire order quantity. The expected inventory is calculated based on the following types of transactions:
- On-hand inventory
- Planned issue transactions
- Planned receipt transactions
- Time Phased Shortage, Ignoring Receipts
-
Cross-dock orders are created for the entire order quantity of the outbound order line, when the time phased inventory is less than zero. You can select the Time Phased Shortage, Ignoring Receipts option, when you are not certain about the supplier's on-time delivery performance.
If you select the Time Phased Shortage, Ignoring Receipts option, the expected time phased inventory on the planned delivery date is calculated based on:
- Current available inventory ( inventory on hand less the inventory blocked).
- Planned inventory issue transactions, including:
- Inventory issue transactions for the planned delivery date.
- Other issue orders within the order lead time, but cannot be replenished with that time.
Time phased inventory = available inventory - planned inventory issue transactions
The planned inventory receipt transactions are excluded from the calculation. Therefore, the receipt transactions are not added to the expected time phased inventory.
Note: When an issue order is released to Warehousing or when you create a manual Warehousing issue order, the value of the Generate Cross-dock Order when Releasing Order to Warehousing field in the Item Data by Warehouse (whwmd2510m000) session determines how the inventory on the planned delivery date of the outbound order line is calculated.
- Cross-docking Time Fence
-
- Cross-docking Time Fence
-
The minimum and maximum time fence tolerances for the receipt date.
- Force Cross-docking Range
-
- Force Cross-docking Range
-
If the receipt quantity of the receipt line is between the minimum and maximum quantities specified, LN will look for demand and try to cross-dock the goods accordingly.
- Direct Material Supply
-
- DMS Supplied
-
If this check box is selected, this warehouse can be supplied via direct material supply (DMS). In other words: netted demand from the warehouse will be taken into account when carrying out a DMS run for a warehouse within the same warehouse supply structure. The DMS run can take place for this warehouse or another warehouse within the same cluster.
- DMS upon Receipt
-
Indicates whether DMS will be carried out in this warehouse after receipt of goods and, if so, in what way. For more information, refer to DMS upon Receipt.
- DMS upon JSC Receipt
-
Indicates whether DMS will be carried out in this warehouse after receipt of manufactured goods and, if so, in what way. For more information, refer to DMS upon JSC Receipt.
- DMS on Inventory
-
Indicates whether DMS will be applied to available on-hand inventory in this warehouse and, if so, in what way.
The setting of this parameter also indicates whether stock must be taken into account to meet demand from other (JSC) warehouses based on planning priorities, when goods are stored in the warehouse. For more information, refer to DMS on Inventory.
- DMS Supply Location
-
The default location for the item used as material, and supplied by DMS. For more information, refer to Supply location and demand location.
- DMS Demand Location
-
The default location for the item used as end item. For more information, refer to Supply location and demand location.
- Planning Horizon for DMS upon Receipt
-
The planning horizon of the destination warehouse when running DMS upon receipt in the supply warehouse. For more information, refer to DMS planning horizon.
- Planning Horizon for DMS on Inventory
-
The planning horizon of the destination warehouse when running DMS on inventory in the supply warehouse. For more information, refer to DMS planning horizon.
- Demand Type for DMS upon Receipt
-
- Demand Type for DMS upon Receipt
-
The type of demand that must be taken into account when DMS is carried out after receipt of goods. For more information, refer to DMS demand type.
- DMS upon Receipt Demand Type
-
If this check box is selected, this demand type is included in the current selection.
- Warehousing Orders from Status
-
The warehousing orders that must be included in the receipt demand type. Relevant warehousing orders with equal or higher statuses than the selected status are included in the DMS receipt demand type.
The following options are available:
-
Planned
This is the lowest warehousing order status. Therefore, all relevant warehousing orders are included in DMS demand type receipt. -
Open
Only relevant warehousing orders with status Planned are excluded from DMS demand type receipt. -
Advised
Only relevant warehousing orders with status Planned or Open are excluded from DMS demand type receipt.
-
- Demand Type for DMS on Inventory
-
- Demand Type for DMS on Inventory
-
The type of demand that must be taken into account when DMS is applied to inventory. For more information, refer to DMS demand type.
- DMS on Inventory Demand Type
-
If this check box is selected, this demand type is included in the current selection.
- Warehousing Orders from Status
-
The warehousing orders that must be included in the inventory demand type. Relevant warehousing orders with equal or higher statuses than the selected status are included in the DMS inventory demand type.
The following options are available:
-
Planned
This is the lowest warehousing order status. Therefore, all relevant warehousing orders are included in DMS demand type inventory -
Open
Only relevant warehousing orders with status Planned are excluded from DMS demand type inventory. -
Advised
Only relevant warehousing orders with status Planned or Open are excluded from DMS demand type inventory.
-