Item Last Costs

Item Last Costs

Understanding Item Last Cost

The Item Last Cost refers to the cost of an item from its most recent purchase or receiving transaction (through an Item Receipt or Bill) and inventory adjustment. It reflects the last price paid for that specific item, generally excluding additional costs like taxes or freight.

You can find the Last Cost displayed on the Item Card's 'Cost and Quantity' tab.




Viewing the List of Item Last Costs

To view a comprehensive list of the last cost for all your items, open the Item Last Costs List. Navigate to Inventory > under the Tools section, choose Item Last Costs. This report lists all inventory items along with the most recent price you paid for them.

The Item Last Costs report displays the following columns: Date of the transaction, Item Code, Item Description, Cost, and Cost with Landed Cost.

Double-clicking on any line within the Item Last Costs report will take you directly to the Purchase Order, Item Receipt, or Item Adjustment where that last purchase or adjustment was recorded.


From the Item Last Costs window, you can:
  1. Find or search for a specific item.
  2. Export the list to PDF, Excel, or Word format.
  3. Refresh the list.

    • Related Articles

    • Item Last Costs

      Item Last Cost The Last Cost is the most recent purchase price of an item. It is derived from the cost on the Bill received for a Purchase Order. Inventory adjustments, item receipts, and assembly builds also update an item's Last Cost. The Item Last ...

    • Choose Item Purchase Cost (extension)

      Introduction This extension allows users to choose between item expected cost (from the Item Detail Card) and item last cost 9cost the last time the item was purchased) when creating purchase orders. The Purchase Order draft is automatically updated ...

    • Item Last Cost

      CustomBooks™ uses the Item Last Cost on Purchase Orders when adding an item. The Item Last Cost is the amount that you last paid for this item on a Bill / Bill Payment recorded in CustomBooks™. For more about last costs, see this article.

    • Inventory Details: Item Costs, Item Quantities and Location Information

      Inventory Details Overview Understanding inventory details, such as item costs, quantities, and location information, is essential for effective inventory management. Accurate insights into these details ensure proper stock control, cost tracking, ...

    • Landed Costs

      Overview The Landed Costs feature enables you to allocate expenses incurred in transporting products from the vendor to your warehouse. These costs can be distributed automatically or manually across the cost of goods sold for items on a Purchase ...