Inventory Status Report

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 detailed information about the Total Available Quantity, Quantity Sold, PO Pending Quantity, and Reserved Quantity.

Home > Reports > Inventory Status Report

Steps to generate Inventory Status Report

Log in to your Tagrain Tenant and navigate to Home > Reports > Inventory Status Report. This will open the Inventory Status Report Master Screen. 
You need to select a Store, select a Product, select a Product Group, specify a date range, and click on the Search button to generate the Inventory Status Report. 


Report Data

The Inventory Status Report Master Data is split into Rows and Columns also known as Grids. Each Grid displays information pertaining to the Inventory Status. This inventory status data is crucial to your business and must be handled with caution. The various grid fields in the Inventory Status Report are explained below: 

Store
This grid displays the name of the store against which the Inventory Status Report has been generated. 

Product
This grid displays the Product Code as updated in the Product Master Data. Every Product Code is unique.

Description
This grid displays a brief description of the Product (above). It makes it easy to identify the product especially when you have a huge product portfolio.

Product Group
This grid displays the name of the product group the product (above) is associated with. 

UPC (Universal Product Code)
This grid displays the Universal Product Code assigned to the product in the Product Master.

Brand
This grid displays the Manufacturer (Brand) of the product.

Stock on Hand (now)
This grid displays the quantity of the product in hand on the date specified, per store(s).

Qty Sold (Date Range)
This grid displays the quantity of the product sold on the date specified, per store(s).

Purchase Order Pending Quantity 
This grid displays the quantity of the product for which the order has been received but is still yet to be fulfilled. 

Export the Inventory Status Report

Tagrain allows you to export your inventory status report via the export template. This template is excel based and allows you to review the inventory status across all your stores in one single sheet. This feature proves useful to managers and administrators who are held responsible and accountable for application management. Once you have generated the Inventory Status Report as per the steps explained above, you need to click on the Export button. Clicking the Export symbol will download the InventoryStatusReport.xls file to your Downloads folder. However, if you want to save the file to a different location on the drive, you may click the Save As button and then navigate to your desired location on the drive and then click the Save button.



Print the Inventory Status Report

Tagrain allows you to print the Inventory Status Report. You can follow the steps below to print the Inventory Status Report. 

Step 1. Generate the Inventory Status 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 Inventory Status Report. 

Suggested Readings


    • Related Articles

    • 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 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 ...
    • 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 ...