Inventory Detail Report on SkyTab Lighthouse Business Manager

Description: Learn how to use the Inventory Detail Report to view current inventory levels and the total cost and value of each item. This report provides management with visibility into stock on hand, item status, and pricing information, helping track inventory levels and make informed purchasing or restocking decisions.

---

Purpose

The Inventory Detail Report displays the current inventory on hand for all items in the system. It shows the quantity, cost, and price of each item, along with the item’s status (active or inactive).

This report is useful for monitoring stock levels, identifying items approaching their alert thresholds, and evaluating the total inventory value.

Running the Report

1. Log in to Lighthouse Business Manager.
2. Navigate to Reporting > Reports.
   
3. Select SkyTab POS and location(s) from the dropdowns. You can select multiple locations for this report.
   
4. Select the Inventory Detail report.
   
5. Select Generate. The report displays on the screen. You can also download or print it.
   Note: No date range selection is required for this report; it reflects current inventory levels at the time of generation.
   

How the Report Organizes Data

• Data Grouping & Sorting:
  • Items are listed alphabetically by Item Name.
  • Active items appear first, followed by inactive items.
• Displayed Details:
  • Item Name
  • Item UPC
  • Quantity on Hand (Current stock quantity)
  • Alert Threshold (Minimum quantity before an alert is triggered)
  • Cost per unit of the item
  • Total cost (Quantity on Hand × Unit Cost)
  • Price per unit for sale
  • Total Price (Quantity on Hand × Unit Price)
  • Status (Active or Inactive)