Inventory Details: Item Costs, Item Quantities and Location Information

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, and efficient order fulfillment, helping businesses streamline operations and make informed decisions.

Item Costs

The Item Costs section on the Item Card provides key financial details:
  • Last Cost: The most recent purchase price of the item.
  • Last Cost (with Landed Cost Amount): The most recent purchase price, including additional landed costs like shipping or customs fees.
  • Historical Average Cost: The average cost of the item over time, considering all purchases.
  • Current Unit Cost: The current cost used to value the item in inventory.



Item Quantities

The Item Quantities section displays important stock metrics:
  • On Purchase Order (PO): Total quantity currently on the purchase orders.
  • On Sales Order (SO): Total quantity committed to customer orders.
  • On Pending Assemblies: Quantity reserved for items in the assembly process.
  • On Hand: Quantity physically available in inventory.
  • Available to Promise (ATP): Quantity available for sale after fulfilling all existing commitments.



Location Information

For businesses using the Multi-location feature, the Inventory Details and Location Information button provides detailed insights into:
  • Item Quantities (PO, SO, Pending Assemblies, On Hand, and ATP) by location.
  • Item Costs.
  • Total Item Quantities across all locations.

    Clicking the button opens a table summarizing this critical inventory data by location, helping you make location-specific decisions for stock allocation and replenishment.



Reports

Inventory Item Quick Report

In CustomBooks™, the Inventory Item Quick Report provides a detailed summary of an inventory item, displaying key information such as:
  • Quantity On Hand.
  • Quantity on Purchase Orders (POs) and Sales Orders (SOs).
  • Quantity allocated to transactions.
  • Average Cost.
  • Asset Value.
  • Quantity Available to Promise (ATP).
  • Transaction history.
This report offers a quick snapshot of the item's status and activity, making it an essential tool for inventory management.

To run an Inventory Item Quick Report from the Item Card:
  1. Open the Item Card.
  2. Click the Show drop-down and select Quick Report.



  3. The Item Quick Report will open in a new tab.
  4. Set the desired report Period.
  5. Add a Filter (e.g., by Company, Location, Average Cost, etc.), if desired.
  6. Run the report.
  7. The report can be printed, sent via Email, or exported to Excel or PDF.


Quantity On Hand by Location Report

A Quantity On Hand by Location Report provides a detailed breakdown of inventory quantities available at each location. It includes Item Details such as Code and Description, Preferred Vendor, Re-order Points, a column for each Location, and the Total Quantity On Hand for each item, helping manage stock levels effectively across multiple locations.

To run a Quantity On Hand by Location Report:
  1. Navigate to Inventory > select Quantity On Hand by Location Report under the Reports section.
  2. Set the report Period.
  3. Add a Filter, if desired. E.g., Item Code, Category, Location, Preferred Vendor, etc. By default, the report shows all of the items and locations.
  4. Run the report.
  5. The report can be printed, sent via Email, or exported to Excel or PDF.



Inventory Valuation Report

The Inventory Valuation Report in CustomBooks™ provides a Detailed or Summary view of your inventory's value. It includes Item Details (Item Code, Description, and Category), Company (Customer/Vendor), Quantity Allocated to transactions, Average Cost, Total Transaction Cost, Quantity On Hand, and the Asset Value of each item. This report helps track the financial worth of your inventory and supports accurate accounting and decision-making.

To run an Inventory Valuation Report:
  1. Navigate to Inventory > select Inventory Valuation Report under the Reports section.
  2. Set the report Period.
  3. On the General tab, set the Report Type to either Summary or Detail.
  4. Add a filter on the Filter tab. The report can be filtered by Item Code, Category, Customer/Vendor, Average Cost, and more.
  5. Run the report.
  6. The report can be printed, sent via Email, or exported to Excel or PDF.


By understanding and utilizing the inventory details, including item costs, quantities, and location information, you can effectively manage stock, track costs, and make informed decisions to optimize your inventory processes. CustomBooks™ offers various reports to help you monitor and analyze inventory performance, ensuring that your business stays organized and efficient.

    • Related Articles

    • Quantity on Hand by Location

      Overview The Quantity on Hand by Location report can help you keep track of where you inventory is at any given moment.   Using the reports defaults, see all item and all locations in a grid that shows where everything is located. Navigation Reports ...

    • Inventory Item Quick Report

      How can I see how much product I've sold year-to-date? One way is to view the Inventory Item Quick Report.   Navigate to Reports → Inventory → Inventory Item Quick Report. Inventory Item Quick Report There are several criteria you can use when ...

    • The Inventory Item Quick Report is coming up blank!

      In some cases, the Inventory Item Quick Report will return no data, just a blank page. This is caused by incorrect report settings. ​ To fix this issue, click the settings button and in the More Menu choose "Set Standard Settings". This will reset ...

    • Inventory Adjustments

      Inventory Adjustments Sometimes it is necessary to adjust the quantities on hand or cost of an item. Breakage, theft, loss or miscounting can cause the true quantity on hand to differ from what CustomBooks™ reports. Adjusting inventory counts is a ...

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