Inventory on Hand Report

Occasionally, inventory is miscounted during shipments or audits or must be adjusted due to theft or other mishaps. The easiest way to make inventory adjustments is through the Inventory on Hand Report.

Where is it located? 

Follow this menu path: Reports => Inventory => Inventory On Hand

How do I adjust inventory with this report?

1. Open the report: Reports => Inventory => Inventory On Hand
2. Choose a location with the dropdown menu above. If it's set to "All Locations," you cannot adjust the inventory on hand. If you have only one location and do not use the Online Store Feature, then your Inventory on Hand Report will display just your solo location instead of "All Locations."
3. In the Change on Hand column, type in the correct inventory amount. For example, if your T-shirts are currently recorded as a count of 4 in the software. But a stock check revealed that you really only have 3 T-shirts, then type three in the Change On Hand column.
4. Click the Update Inventory button at the bottom to save changes.
   
   

The Report's Filters

• Location - Choose the location for which you'd like to run the report, or choose All Locations.
• Supplier - You may restrict the report's results to a specific supplier by choosing their name from the dropdown menu, or select All Suppliers.
• Category - You can run the report for single, multiple, or all product categories by choosing one or more from the multi-select menu.
• Sort By - Choose from the dropdown menu to sort the report's results by Product Name, Product Barcode, Retail Price, or Product Cost.
• Only Show Products Needing Reorder - Each product can have a reorder value. When the inventory level for this product drops below its reorder level, you can check this filter and the Inventory On Hand Report will only show products that need to be reordered, based on the reorder level.
• Include Unused Products - If you check this box, it will show products that have 0 inventory values.
• Include Discontinued Products - Each product has a Discontinued box, that, if checked, will make the product disappear from inventory reports and the Manage Products screen. If you check this box, the report will even show those products that you marked as discontinued.
• Include Negative Quantities in Asset Value - If unchecked, the negative on-hand numbers are treated as zero for total asset value. Meaning, if you aren't keeping up with inventory and sold more T-shirts than you originally told the system you had, the inventory goes into the negative taking the asset value with it. The total RETAIL value is calculated with the negative number. Asset is your real value that you have for all inventory. We do this so that your Retail value would include things that are lost, stolen, defective etc. We currently use a simple calculation based on units and the current our cost / retail price values. If the units go negative, they take the value with them.
• Use Paging - If you have a large list of products, it will break the report into different pages.
• Only Show Products with Non Zero In Stock Values - Check this box to filter out all products with "0" as their inventory count. This can help to track items overstocked, on back-order, or sold incorrectly.

This report can also be used to calculate your total asset value for inventory on hand.

Generate the report and scroll to the bottom of the screen to see the total asset value listed for all products.

Click here to learn about report icons.

Back to Reports

Back to FAQs

Back to Advanced Features

Open topic with navigation