Inventory is constantly moving. With the inventory movements view, you can monitor product inventory movements, the users involved, and the average cost of the product, to identify discrepancies and improve efficiency.

Viewing inventory movements

1. Navigate to Catalog > Products and locate the product you want to view.
2. Click on the product row to expand it.

3. On the right, click View inventory movements.

   

4. On the product's inventory movements page, you can review:
   • Date: Date of the movement.
   • Variant: The specific variant product, if applicable.

   • Movement: Type of movement event (orders and deliveries, stock transfers, sales and returns, fulfillment, and other inventory changes).

     If an event in the Movement column is underlined, you can click it to view the associated Sales history, Stock control, or Fulfillment page record.

   • From: The original location of the product.
   • To: The destination after the product was moved.
   • User: Retail POS user who initiated the movement.
   • Quantity: Quantity of products moved.
   • Average cost: The average cost of the product, showing the amount increased or decreased.

5. You can refine your search by using the filter dropdowns:

   • Movement type: Show all or a specific movement type:
     • Supplier order: Stock added to inventory through supplier purchase orders being received.
     • Transfer: Stock moved between outlets.
     • Supplier return: Stock leaving inventory due to a supplier return.
     • Inventory count: Stock leaving or re-entering inventory as part of an inventory count.
     • Sale: Stock leaving inventory due to a customer sale.
     • Sale return: Stock re-entering inventory due to a customer return or refund.
     • Fulfillment: Stock movement associated with fulfilling a customer order or service, regardless of where the order originated.
     • Inventory edit: A manual adjustment made on the Product page.
     • Package breakdown: Stock change from dividing a larger amount into smaller quantities to sell.
     • Inventory adjustment: Changes made to inventory outside the standard sales, receiving, transfer, or fulfillment flows:
       • Manual inventory adjustment: A user directly edits the inventory quantity from the Product page.
       • Stock adjustment: A user adds or removes stock from the system and records a reason, such as damaged, write-off, stock found, or stock loss.
       • System adjustment: A one-off adjustment made by Lightspeed to correct inventory data and maintain system accuracy.
     • Purchase order delivery: Stock added to inventory through supplier purchase order being received.
   • Outlet: Show all or one specific outlet.
   • Variant: Show all or one specific product variant.
   • Date range: Show movements from a specific date range.

   

Viewing average cost

You can view average cost for specific variants and outlets on the inventory movements page. You can also view average cost on the Inventory summary report.

1. Navigate to Catalog > Products and locate the product you want to view.
2. Click on the product row to expand it.
3. On the right, click View inventory movements.
4. Use the filters to choose a single outlet and a single variant (if applicable). Average cost will only display for one outlet and one variant at a time.
5. The cost column will show the average cost and if it has increased or decreased with each inventory movement.

Viewing inventory on hand

To quickly view on-hand product inventory:

1. Navigate to Reporting > Inventory reports.

   

2. Next to Search, click More filters.

   

3. Using the dropdowns, filter by:
   1. Report type > Product.
   2. Measure > On-hand inventory.
   3. Select a desired Date range.

   4. (Optional) Include or Exclude a brand, outlet, product, or other keyword.

      

4. Click Search.

What's next?