| Valuation MethodDuring 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 Warehouse - Item (whwmd2510m000) session; and the inventory valuation is based on
the MAUC by Warehouse Valuation Group valuation method. 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. Example |
---|
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 |
---|
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. Example |
---|
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 |
---|
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 FTP value. For more information, refer to Lot pricing. Example |
---|
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 |
---|
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 FTP value. Example |
---|
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 |
---|
| |