Inventory Report

Inventory Report

Introduction

Inventory Report analyzes 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. 

Home > Reports > Inventory Report

Inventory Report 
This report analyzes the stock status of products across 5 parameters:

In Stock 
These are products that have their Available Quantity > 0

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

Critical Stock
A product is marked Critical Stock when its 
Available Quantity < (Minimum Stock Level X 10) / 100

Zero Stock
Available Quantity = 0

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.

Report Data

The Inventory Report data contains the following information:

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.



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.



When exporting the Inventory report, the date is always exported in MM/DD/YYYY format irrespective of the date format specified in Display Settings ( Home > Setup > General Settings > Display Settings ) OR the date time format of the Operating System OR Excel.

Print the Inventory Report

Inventory Report can be Printed using the steps below: 

Step 1. Generate the Transaction Report.  

Step 2. Click the Print button to open the Print Preview page. 

Step 3. Select the destination printer. 

Step 4. Specify the number of copies and pages to be printed.

Step 5. Click on the Print button to print the Transaction Report. 

Suggested Readings



    • Related Articles

    • Inventory Movement Report

      Introduction Inventory Movement Report shows all changes that have occurred to the inventory level including sales / refunds / goods receipts etc. It can be generated on a daily basis, weekly basis, monthly basis, or quarterly basis, depending upon ...
    • Inventory Status Report

      Introduction Inventory Status Report, as is apparent from the name itself, is a report that is used to review and monitor the inventory across stores. It lets you know the actual inventory count across all the stores. It also helps you obtain ...
    • Transaction Report

      Introduction Transaction Report is used for reviewing and monitoring the transactions for all the stores or a particular store. This is a ledger kind of a report that lists all transactions done during a specified date range. Home > Reports > ...
    • Tax on Sales Report

      Introduction The Tax on Sales Report displays the total tax collected for the sales during the selected period in a selected store. It displays the Total before tax and total after tax along with Tax Amount collected in the selected store. It can be ...
    • Tender Collection Report

      Introduction Tender Collection Report is a snapshot of the tender collection activities performed by the company via different sources. It can be generated on a daily basis, weekly basis, monthly basis or quarterly basis, depending upon the need of ...