Unit Cost Field, Item Table

  • Article

Contains the cost per unit of the item.

Depending on what you selected in the Costing Method field, the Unit Cost field is filled as follows:

  • If the costing method is Standard, then the field is grayed and non-editable.

  • If the costing method is FIFO, LIFO, Specific, or Average, then the unit cost is calculated as follows:

    Unit cost = inventory value of items on hand (expected cost + invoiced cost) / quantity on hand

If the costing method is FIFO, LIFO, Specific, or Average, then the Unit Cost field is updated in the following cases:

  • When the item is cost-adjusted, automatically or by the Adjust Cost – Item Entries batch job.

  • During the posting of purchase invoices, output, or positive adjustment if one of the following conditions is true:

    • The net invoiced quantity of the item changes from negative or zero to positive.

    • The current unit cost is zero.

If one of these conditions is true, then the Unit Cost field is updated with the value in the Last Direct Cost field on the item card.

Note

The Unit Cost field is not updated if the current unit cost is higher than zero and the new unit cost is zero. A unit cost of zero is considered an exception from regular business. Therefore, the current unit cost is retained to provide the last known, relevant value. This exception applies even if the existing inventory has been revalued to zero.

If the item uses the costing method Average, then you can choose the field to open the Average Cost Calc. Overview window, which shows all the source value entries that are used to calculate the average cost, grouped and summarized by average cost period.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Negative Adjmt. (LCY) Field, Item Table Inventory
Item Table Inventory
Item Table Inventory

See Also

Other Resources

Costing Method
Last Direct Cost
Average Cost Calc. Overview
Automatic Cost Adjustment
Adjust Cost - Item Entries
Item Card
How to: Set Up Items
Design Details: Cost Adjustment