Item Last Costs

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 Cost feature helps businesses track the most recent purchase price of inventory items, enabling accurate pricing, cost analysis, and informed purchasing decisions, which improves profitability and inventory management.
​
For more information about costs in CustomBooks™, please see this knowledgebase article.

Viewing the List of Item Last Costs

The Item Last Costs list shows all inventory items with the last price you paid for them. Clicking on a line will open and navigate to the Purchase Order or the Bill where the last purchase was made.

To view the Item Last Costs List: Navigate to Inventory > Item Last Costs.



From the Item Last Costs List, you can:
  • Find or search for an item. You can search by date, item code, item description, and cost.
  • Export the list of Item Last Costs to Excel, PDF, or other formats.
  • Add or remove columns/fields.
  • Create multiple custom views using filters, sorting, ordering, and conditional appearance settings.

    • Related Articles

    • Item Last Costs

      Item Last Costs The item last costs page lists all inventory items with the last price you paid for them. Clicking on the line will navigate to the Purchase Order where this last purchase was made. Navigate to Inventory → Item Last Costs.

    • 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 ...

    • 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 ...

    • 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.