How to View Stock Report in GPOS
This tutorial will guide you through the process of generating and understanding the Stock Report in GPOS. The Stock Report helps you track available products, their stock locations, cost, selling price, and overall stock value
🛠️ Why You Need a Stock Report
-
To check current stock levels for each product
-
To monitor product movement across warehouses/business locations
-
To calculate stock valuation based on purchase cost
-
To avoid stock-outs or overstocking issues
📋 Steps to View Stock Report in GPOS
✅ Step 1: Go to the Stock Report Module
-
Log in to your GPOS dashboard.
-
From the side menu, navigate to “Reports”.
-
Click on “Stock Report” from the report list.
✅ Step 2: Apply Search Filters
Use the available filters to narrow down your stock report:
-
Search Product – Enter product name or code.
-
Business Location – Select the specific branch/outlet.
-
Warehouse – Choose the warehouse to view stock for.
-
Category – Filter products by category.
-
Brand – View stock of a specific brand.
✅ Step 3: View the Stock Report Table
The report will display in a structured table with the following details:
| Column | Description |
|---|---|
| Product | Name of the item |
| Code (SKU) | Unique product code |
| Stock Location | Warehouse or business location |
| Default Unit Cost (Exc. Tax) | Purchase cost of the product (excluding tax) |
| Default Unit Price (Inc. Tax) | Selling price of the product (including tax) |
| Current Stock | Available quantity in stock |
| Stock Value (By Unit Cost Exc. Tax) | Total value of stock based on unit purchase cost |
✅ Step 4: Customize the Report View
-
Use the Show Entries dropdown to display 10, 25, 50, or 100 rows per page.
-
Use the Search Bar to quickly find specific products.
✅ Step 5: Export or Print the Report
-
Once you have the required report, you can export it to Excel, CSV, or PDF.
-
Use the Print option if you want a hard copy of the stock report for records or audits.
🔐 Important Notes
-
Only authorized users with report access can view stock reports.
-
Stock values are calculated in real-time based on sales, purchases, and returns.
-
Ensure all products are entered with the correct cost and selling price for accurate stock valuation.
🎯 Tips
-
Use filters like Warehouse and Business Location to manage multi-store operations.
-
Check the stock report daily or weekly to prevent stock shortages.
-
Compare Stock Value against sales reports to measure profitability.
By following these steps, you can easily generate and analyze the Stock Report in GPOS — helping you maintain accurate inventory records and make better purchasing decisions.