Item - Warehouse - Inventory Transaction (whinr1510s000)

Use this session to view the details of an inventory transaction.

Field Information

Order
Item

item

Packaging

If this check box is selected, the item is a packaging item.

Warehouse

warehouse

Site

site

Site Description

The description or name of the code.

Transaction Date

transaction date

You cannot change this date.

Actual Log Date

actual log date

Effectivity Unit

effectivity unit

Lot

lot

Serial Number

The serial number of the item to which the transaction refers. If the item is not serialized and serial pricing does not apply to the item, this field is not filled.

Order
Order Type

order type

Inventory Transaction Type

inventory-transaction type

Order

warehousing-order number

Line

position (number)

Sequence

sequence number

BOM Line

BOM line

Receipt

receipt number

Payable Receipt Sequence

The sequence number of the purchase payable receipt generated for the receipt and purchase order that created the inventory variance.

Receipt Line

The receipt line number.

Shipment

shipment

Inventory Transaction ID

The inventory transaction code.

Business Partner

The business partner code.

Name

The business partner's name.

Quantity in Inventory Unit

The quantity with which the inventory is adjusted, expressed in the inventory unit.

Miscellaneous
Project
Project

If the inventory is allocated to a project, this field shows the project's code.

Element

element

Activity

activity

Extension

extension

Cost Component

cost component

Ownership
Ownership

The ownership of the goods involved in the transaction.

Owner

The owner of the goods involved in the transaction.

Buy-from Business Partner

The buy-from business partner of the goods involved in the transaction.

Miscellaneous
Channel

sales channel

Inventory After Transaction

The inventory on hand available after the inventory transaction.

Unit

inventory unit

User

The logon code of the employee who entered the inventory transaction.

Valuation Method
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, inventory valuation for this warehouse is performed by warehouse valuation group.

Warehouse Valuation Group

warehouse valuation group.

Inventory Transaction Printed

If this check box is selected, the inventory transaction was printed.

Receipt Correction

If this check box is selected, the inventory transaction concerns a receipt correction.

Quarantine

If this check box is selected, the inventory transaction concerns rejected inventory.

Physical Transaction

If this check box is selected, the inventory transaction concerns a logistic transaction, that is, an actual inbound or outbound movement of goods.

Specification
Demand Peg
Allocated to Sold-to Business Partner

The sold-to business partner to which the inventory is allocated.

LN can use the inventory specified by this record for the business partner specified by this field; LN does not use this inventory for any other business partner.

Allocated to Ship-to Business Partner

The ship-to business partner to which the inventory is allocated.

Business Object Type

The type of order to which the inventory was allocated, such as, Sales Order, or Service Order.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Allowed values

Service (Manual)

Maintenance Sales Order

maintenance sales order

Maintenance Sales (Manual)

Maintenance Work Order

maintenance order

Maintenance Work Order (Manual)
Sales Order

sales order

Sales Schedule

sales schedule

Not Applicable

Sales (Manual)

Service Order

service order

Business Object

The order, or order line, to which the inventory was allocated.

Note: 

The following fields are always used in combination; together, they identify the relevant order or order line:

  • Business Object Type
  • Business Object
  • Business Object Reference

Reference

A reference code to which the inventory was allocated.

LN can use the inventory specified by this record to fulfill a demand specified by this reference and for no other purpose.

LN can use this field in two ways:

  • If the Sold-to Business Partner field is filled, LN uses the Reference field to record a reference code defined by a customer.
  • If the Sold-to Business Partner field is empty, LN uses the Reference field to record an internal reference.

You can use a reference code to keep a collection of parts linked together, even if they follow different routings, for example, if some of the parts are transported to a subcontractor to be returned later.

Derived from Product Variant

product variant

Product Variant

The description or name of the code.

Option List ID

option list ID

The ASN specifications include the option list ID. The ASN specifications are populated from the Inbound Order Lines (whinh2110m000) session. In turn, the specifications on the inbound order line are populated from the purchase schedule line.

For configurable purchased items in Warehousing , only the option list ID is part of the specifications. This means that inventory is maintained per option list ID and is the total of inventory of all product variants with the same option list ID.

Note: 
  • The field is displayed only if the Assembly - Single Location check box is selected in the Implemented Software Components (tccom0100s000) session.

  • The field is populated only for configurable purchased items and manufactured assembly (FAS) items.