Inventory Variances (whina1516m000)

Use this session to view inventory variances.

To indicate whether the inventory vairances must be assigned to inventory or posted to Financials, use the To be Consumed by Inventory check box in the current session.

You can execute both the consumption and posting with the Process Inventory Variances (whina1200m000) session.

 

Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
Quantity

The unit of measure in which the inventory of an item is recorded, such as piece, kilogram, box of 12, or meter.

The inventory unit is also used as the base unit in measure conversions, especially for conversions that concern the order unit and the price unit on a purchase order or a sales order. These conversions always use the inventory unit as the base unit. An inventory unit therefore applies to all item types, also to item types that cannot be kept in stock.

Warehouse

A place for storing goods. For each warehouse, you can enter address data and data relating to its type.

Total Amount

The currency in which the item is valued.

From the Tools menu, choose Rotate Currency to switch home currencies.

Transaction Date

The date on which the inventory variance is created.

Quantity

The item quantity of the inventory variance.

Total Amount

The total amount of all effective cost components of the inventory variance per item/warehouse combination.

From the appropriate menu, start the Inventory Variance - Cost Details (whina1517m000) session to view the amounts per effective cost component.

Total Hours

The total number of hours for all the effective cost components of the inventory variance for the item/warehouse combination.

Note

You can view this field only if the Show Hours in Costing check box is selected in the Implemented Software Components (tccom0100s000) session.

Distribution Line

The sequence number of the cost peg distribution line.

To be Consumed by Inventory

If this check box is selected, LN will attempt to consume all the variance by inventory when the Process Inventory Variances (whina1200m000) session is run. Any part of the variance that cannot be consumed by inventory is posted directly to Financials.

If this check box is cleared, the entire variance will be posted directly to Financials when the Process Inventory Variances (whina1200m000) session is run.

Processed

If this check box is selected, the inventory variance is processed. A processed inventory variance is posted directly to Financials, or added to the inventory value.

LN selects this check box if the inventory variance is processed with the Process Inventory Variances (whina1200m000) session.

Inventory Variance Origin

The origin of the inventory variance.

Sequence

The number that identifies a data record or a step in a sequence of activities. Sequence numbers are used in many contexts. Usually LN generates the sequence number for the next item or step. Depending on the context, you can overwrite this number.

Type of Order

The kind of order that created the inventory variance.

Order

The warehouse order number of the order that created the inventory variance.

Order Line

The position number of the line in the warehouse order that created the inventory variance.

/

The internal sequence number of the order line that created the inventory variance.

Receipt Line

The number of the receipt line of the order line that created the inventory variance.

Payable Receipt Sequence

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

Inventory Variance Sequence

The inventory variance sequence number. For a particular order origin, order, order line, order line sequence, receipt, and receipt line, one or more variances can occur. Each variance is numbered by the inventory variance sequence displayed in this field. In this way, you can see which variance caused a particular financial transaction.

This field obtains value 1 for the first combination of a particular origin, order, order line, order sequence, receipt, and receipt line. For the second combination of the same origin, order, order line, order sequence, receipt and receipt line combination, and so on, this field obtains value 2. For example, if a production order is closed with a price variance and an efficiency variance, LN generates two records, with sequence 1 and 2. If the production order is opened again, LN generates two new records, with sequence 3 and 4.

Department

The code of the department, usually the purchase office, that creates the purchase order or purchase schedule that created the inventory variance.

Description

The description or name of the code.

Actual Log Date

The current date and time when the inventory variance takes place.

Note

This is a display field.

Process Date

The date on which the inventory variance is processed.

Warehouse Valuation Group

The code of the warehouse valuation group related to the receipt transaction for the valuation method MAUC by valuation group.

Note

This field is applicable only if the valuation is MAUC by warehouse valuation group.

Description

The description or name of the code.

Project

The code of the project related to the inventory variance.

Note

This field is enabled only if project pegging is implemented.

LN allows you only link the projects that have Project PackageLinked set to Project.

Description

The description or name of the code.

Customer Owned

The items to which the transaction pertains are customer owned.

 

Toggle Consumption

Use this option to check or clear the To be Consumed by Inventory check box for the selected variance line.

If the check box is selected, LN will attempt to consume all the variance by inventory when the Process Inventory Variances (whina1200m000) session is run. Any part of the variance that cannot be consumed by inventory is posted directly to Financials.

If the check box is cleared, the entire variance will be posted directly to Financials when the Process Inventory Variances (whina1200m000) session is run.

Cost Details

Starts the Inventory Receipt Transaction - Cost Details (whina1513m000) session.