How can I see the stock status of all products across stores?

How can I see the stock status of all products across stores?

Introduction

There are 2 reports that give the status of products in your stores. Inventory Report and Inventory Status Report


Inventory Report analyses the stock status across 5 parameters. Inventory Status Report gives other details like, Quantity Sold, Quantity pending in Purchase Orders, Quantity reserved for delivery or pickup orders. 


Inventory Report 

This report analyses the stock status of products across 5 parameters:


  1. In Stock 

These are products that have their Available Quantity > 0


  1. Low Stock 

A product is marked Low Stock when its Available Quantity < Minimum Stock Level (specified in the product master)


  1. Critical Stock

A product is marked Critical Stock when its 

Available Quantity < (Minimum Stock Level X 10) / 100


  1. Zero Stock

Available Quantity = 0


  1. Negative Stock

Available Quantity < 0


Steps To Generate Inventory Report

To generate Inventory Report, navigate to Home > Reports > Inventory Report, and perform the following steps:


  • Select a Store

  • Select a Product

  • Select a Product Group

  • Select a Filter type (In Stock, Low Stock, Critical Stock, Zero Stock, Negative Stock) 

  • Click on Search Button

  • Inventory Report for the selected fields is populated.


Once the report is generated, it can be then filtered by In Stock Only, Low Stock Only, Critical Stock, Zero Stock or Negative Stock.


A screenshot of a computer

Description automatically generated


Products which are marked with a green dot signify products with sufficient stock, and those marked with a red dot signify products which are in negative stock.


Export the Inventory Report

Inventory Report can be exported using the "Export" button. Click on the Export button and browse to a location where you want to save the Inventory Report. Click on the Save button to save the file.


Inventory Report can be Printed using the "Print" button. Click on the Print button, Print Preview pops up, select the destination printer, pages, Copies, Color and configure more settings, if required. Click on the Print button to print the Inventory Report.


Report Data

 

Status

The green circular dot represents that the product inventory is available. The red circular dot represents that the product is not available in inventory. 


Store

Store is the name of the store where the stock is.


Product

This is the code of the product.


Description

This is the name and description of the product.


Product Group

This is the name of the product group to which the product belongs.


Brand

This is the brand name of the product listed for the inventory report.


Base Price

This is the base price of the product with which the product is listed in the warehouse.


Total Available Quantity

Reorder level is the level that has been set.


Suggested Readings

Inventory Report

Inventory Movement Report

Inventory Status Report


    • Related Articles

    • Performing Stock Count of Standard Products

      Introduction Stock Counting Plugin is a software module that seamlessly integrates with Tagrain POS and allows you to keep a track of your inventory. It helps you reconcile the actual physical stock in hand at the store with the stock recorded in the ...
    • Stock Counting of Products with Multiple UoM

      In this article, we are briefly going to cover the Stock Counting process for products with Multiple Units of Measurement Introduction Stock Counting Plugin is a software module that seamlessly integrates with Tagrain POS and allows you to keep a ...
    • Stock Counting of Products with Multiple UoM

      In this article, we are briefly going to cover the Stock Counting process for products with Multiple Units of Measurement Introduction Stock Counting Plugin is a software module that seamlessly integrates with Tagrain POS and allows you to keep a ...
    • Performing a Stock Count of Variant and Composite Products

      In this Knowledge Article, we are going to cover the steps to count inventory for some Variant Products. For illustration purposes, we have considered the following product: Product Name - Women Coat product Product Code - WC-1001 Product Description ...
    • Performing a Stock Count of Serial and Batch Products

      In this Knowledge Article, we are going to cover the steps to count inventory for some Serial Products. For illustration purposes, we have considered the following product: Product Name - Women Watch product Product Code - WW-1001 Product Description ...