Inventory Variances (whina1516m000)

Use this session to view inventory variances.

To indicate whether the inventory variances 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.

Field Information

Item

item

Inventory Unit

inventory unit

Warehouse

warehouse

Site

site

Site Description

The description or name of the code.

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.

Allowed values

Receipt Price Change

A change of the receipt price.

Currency Variance (Stage Payment)

The variance caused by the difference between the home amounts of the stage payment purchase invoice and the related receipt transaction. The home amounts of the purchase invoice are calculated with currency rates of the invoice and the home amounts of the receipt transaction are calculated with currency rates of the purchase order.

Not Applicable

Inventory variance is not applicable.

Expense Tax (Stage Payment)

The variance caused by the amount of the expense purchase tax of the purchase invoice.

Currency Variance

The variance caused by the difference between the home amounts of the purchase invoice and the related receipt transaction.

Currency Gain and Loss

The variance caused by the difference in currency rates used for the credit and debit side of a financial transaction. For example, at the invoice accrual (credit) side of a Purchase Order / Receipt transaction, currency rates of the purchase rate type are used and at the interim transit (debit) side, the currency rates of the internal rate type are used. The difference in home amounts credit and debit are booked as gain and loss.

Currency Variance (Landed Costs)

The variance caused by the difference between the home amounts of the landed cost purchase invoice and the related landed costs invoiced transaction.

Invoice Variance

The invoice price is different from the receipt price.

Additional Calculation Office Variance

calculation office variance

Expense Tax

The purchase invoice included expense tax, which was processed to the inventory.

Efficiency Variance

Efficiency variance is a part of the production result that is created by differences between the estimated and actual material quantities and hours. The efficiency variance shows how efficiently materials and resources are used.

Price Variance

price variances

Landed Cost Receipt Price Change

The variance caused by a change of the price of a landed cost line after the receipt was processed.

Landed Cost Invoice Variance

The variance caused by the difference between the amount of the landed cost purchase invoice and the related landed costs invoiced transaction.

Landed Cost Expensed Tax

The variance caused by the amount of the expense purchase tax of the landed cost invoice.

Landed Cost Tax Correction

The variance caused by tax amounts added to or subtracted from the landed cost value according to local tax regulations.

Tax Correction

The variance caused by tax amounts added to or subtracted from the purchase value according to local tax regulations.

Sequence

sequence 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.

Sequence

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 Package Linked set to Project.

Description

The description or name of the code.

Ownership

The ownership of the inventory.

Allowed values