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