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
- Inventory Unit
- Warehouse
- 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
- 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
-
Company Owned
-
Consigned
-
Customer Owned
-