On Hand Inventory

Reports > Inventory > On Hand Inventory

The On Hand Inventory report is used to see the current on-hand quantity of inventory items.

1. Name - enter a report name
   Default: On Hand Inventory

2. Output - select output format (Html, Pdf (default))

3. Template - select a report template

4. Reset - click to reset to default options

5. Warehouses - select warehouse(s)

6. Item Tags - filter by item tag(s)

7. Vendors - filter by vendor(s)

8. Items - filter by item(s)

9. Show Zero Quantity Items - check to include items on the report that have a Total Quantity of zero

10. Show Back Ordered Items Only - check to filter for only items with a Total Quantity of less than zero

11. Save as Template - click to save the selected filters and columns as a template
    

1. Name - enter a template name

2. Public - check to make the template available to other users

3. Security Roles - select the security roles that can access a Public template

4. Cancel - click to return to the previous screen without saving the template

5. Save - click to save the template

12. Reset - click to reset to defaults

13. Request Report - click to request report
    Note: Report will appear in the bell icon when complete

Report Format

1. Header - notice the District Logo and Report Title.

2. Warehouse - notice the warehouse name

3. District Name - notice the district name

4. Identifier - item identifier

5. Name - item name

6. On Hand Quantity - notice the current on hand quantity

7. On Order Quantity - notice the current on order quantity

8. Requested Quantity - notice the current requested quantity

9. Total Quantity - notice the total quantity = On Hand + On Order - Requested

10. Current Cost - notice the current total actual cost (assumes FIFO)

11. Current Value = Total Quantity x Vendor Cost

12. Filters - notice the name(s) and value(s) of selected filters

13. Footer - notice the date and time the report was requested, pages, and TITAN logo