Inventory Revaluation Transaction (whina1622m000)

Use this session to view an individual revaluation transaction that has been posted to Financials following an inventory revaluation.

Field Information

Transaction
Transaction
Revaluation Order

The revaluation origin:

  • Actualize Standard Cost
  • Antedating
  • MAUC Correction
  • Change Valuation Method
Revaluation Order

The revaluation order number.

Sequence

sequence number

Item

The item code.

Warehouse

The warehouse code.

Site

site

Site Description

The description or name of the code.

Revaluation Date

The date on which revaluation took place.

Actual Log Date

actual log date

Reason

reason code

Note: 

The reason code is only shown if both of the following applies:

  • Inventory Valuation Method is Lot Price (Lot).
  • Revaluation Origin is Change Valuation Method.
User

logon code

Lot

lot

Serial Number

The serial number of the item to which the transaction refers. The serial number is only specified if the inventory valuation method is serial pricing.

Quantity

The quantity (Inventory) for which the revaluation was done.

Inventory Unit

The unit in which the quantity is expressed.

Valuation
Old Valuation Method
Standard Cost

The standard cost, including any surcharges or discounts. Item standard costs are calculated in the Calculate Standard Cost (ticpr2210m000) session.

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
Old Valuation by Warehouse Valuation Group

If this check box is selected, valuation was performed by warehouse valuation group

Old Warehouse Valuation Group

warehouse valuation group

New Valuation Method
Standard Cost

The standard cost, including any surcharges or discounts. Item standard costs are calculated in the Calculate Standard Cost (ticpr2210m000) session.

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
New Valuation by Warehouse Valuation Group

If this check box is selected, valuation is performed by warehouse valuation group

New Warehouse Valuation Group

warehouse valuation group

General
Ownership
Owner

The business partner who owns the items. If this field is not filled, your own organization owns the inventory. If the owner is not the same as the buy-from business partner, the owner is the internal business partner of another enterprise unit such as a division in another country, of your organization. If the buy-from business partner is the owner, the items are held in not-owned consignment.

Buy-from Business Partner

buy-from business partner of the inventory.

Project
Project

project

Element

element

Activity

activity

Extension

extension

Cost Component

cost component