Lot Inventory Variances (whltc1503m000)
Use this session to view inventory variances by lot.
To view cost details, on the appropriate menu, click to start the Lot Inventory Variance Cost Details (whltc1504m000) session.
Lot prices are determined by enterprise unit if:
- On the Enterprise Structures tab of the Implemented Software Components (tccom0100s000) session, the Standard Cost by Enterprise Unit field is set to Active. See Activating multisite - overview.
- In the Items (tcibd0501m000) session, the Standard Costs at Level field is set to Enterprise Unit, except for archive companies.
When a lot is received in a warehouse, the enterprise unit of the warehouse is linked to the lot. Therefore, multiple enterprise units can be present for a lot if the items belonging to a particular lot are received in warehouses belonging to different enterprise units. For each enterprise unit linked to the lot, pricing and other lot data can be different.
Field Information
- Item
-
item
- Lot
- Enterprise Unit
-
The enterprise unit present for the lot.
- Process Date
-
Date on which the inventory variances are processed.
- Variance Sequence
- Inventory Variance Origin
-
The origin of the inventory variance, which can be used for mapping to a ledger account. This field has a value other than Not Applicable if the Revaluation check box is cleared.
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.
- 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. The inventory variance sequence can only have a value unequal to zero if the Revaluation check box is cleared.
- Actual Log Date
- Revaluation
-
If this check box is selected, revaluation is applicable.
- Inventory Transaction ID
-
The ID generated for the inventory transaction.
- Revaluation Order
-
The revaluation origin:
- Actualize Standard Cost
- Antedating
- MAUC Correction
- Change Valuation Method
-
The revaluation order number.
- Total Amount
-
Amount of all inventory variances that are processed.
-
currency
- Total Hours
-
The total number of variance hours assigned to the lot for a single unit.
Note: You can view this field only if the Show Hours in Costing check box is selected in the Implemented Software Components (tccom0100s000) session.