Let's get started!
The Zero Issued Stock Report identifies all stock items that have never been issued since their receipt into the system.
This report is an essential stock control tool that helps teams:
Highlight slow-moving, dormant, or obsolete inventory.
Identify stock that is being purchased but never used operationally.
Support warehouse optimisation and reduce unnecessary storage costs.
Improve procurement accuracy by identifying items that may have been over-ordered.
Validate stock accuracy by comparing received quantities against issued quantities.
By focusing on items with zero outgoing stock activity, this report provides a clear view of inventory that may require review, redistribution, or removal.
Getting There
To access the Zero Issued Stock Report in Service Geeni, follow these steps:
Open the Business Intelligence module.
Click on the Reports sub-module.
In the Reports window, navigate to the Stock category.
Click the Zero Issued Stock module to open the report.
This report does not contain any filters, so simply click Apply to generate the report.
Available Filters and Their Impact
Use the filters at the top of the report to refine which data is displayed.
Search: Filters the report using free text where available. This allows you to locate specific records based on key values such as SKU or description, depending on the report configuration.
SKU: Filters the report by stock item number or description. This allows you to analyse specific items or focus on individual stock activity.
Product Group: Filters the report by product group. This allows you to analyse data by stock category.
Period: Filters the report by date based on the report context. Only records within the selected range are displayed.
Column Breakdown and Key Fields
Each row in the report represents a stock item that has never been issued but has been received into stock at some point.
Column Name | Description |
SKU | Unique stock item number used to identify the item. |
Product Group | Shows the product group/category the item belongs to. |
Current On Hand Branch Qty | The total quantity currently available in stock across relevant branches. |
Total Qty. Moved Into Stock | Total accumulated quantity received into stock. |
Total Qty. Moved Out Of Stock | Total accumulated quantity issued (this will be 0 for all items in this report). |
Receipt Number | The receipt reference is associated with the goods receipt or movement. |
Movement Type | The type of transaction that brought the item into stock (e.g., PurchaseOrder, StockTransfer, ManualStockReceipt, StockTake). |
Date Received | The date the stock was received (based on GRN date). |
Identifier No. | A secondary reference depending on movement type (e.g., Purchase Order No., Transfer Note, Manual Receipt Note). |
GRN No. | The Goods Receiving Note number is linked to the receipt. |
Bin No. | The bin/location number where the item is stored. |
From | The supplier or source location from which the stock originated. |
Qty. Received | Quantity recorded as received on the goods receipt. |
Batch Number | The batch/lot number assigned to the received item, where applicable. |
Invoice No. | Supplier invoice number or related invoice reference (if applicable). |
Actioned By | The user who performed or confirmed the transaction, based on audit information. |
Cost Price | The cost price is recorded at the time of receipt. |
Selling Price | The selling price registered for the item at the time of receipt. |
Insight: Reviewing these fields helps identify why the stock exists, how long it has remained unused, and where it is stored - essential information for effective stock management.
The Zero Issued Stock Report is a vital tool for maintaining healthy and efficient inventory levels within Service Geeni.
Review this report on a monthly or quarterly basis to ensure stock items are actively managed, reallocated, or written off where appropriate. Continuous oversight helps reduce waste, save costs, and keep inventory aligned with operational needs.