Let's get started!
The Stock Issue/Receipt Summary Report provides a combined view of stock issued and stock received within a selected period.
This report helps users to:
Track stock movement into and out of the business.
Review costs, quantities, and supplier details for received stock.
Analyse stock issued to jobs, engineers, customers, or requisitions.
Support financial reconciliation of stock costs and revenue.
Audit stock activity for accuracy and compliance.
Getting There
To access the Stock Issue or Receipt Summary Report in Service Geeni, follow these steps:
Open the Business Intelligence module.
Select the Reports sub-module.
In the Reports window, choose the Stock category.
Click the Stock Issue Summary Report or Stock Receipt Summary Report module to open the report.
Add the desired filters (explained below), then click the Apply button to generate the report.
Available Filters and Their Impact
Use the filters at the top of the report to refine which stock transactions are displayed.
Branch: Filters the report by the depot where stock was issued from or received into. The report uses the branch selected in the main Service Geeni interface. This allows you to isolate stock activity for a specific depot or compare across branches.
SKU: Filters the report by specific stock items. Only transactions relating to the selected item(s) are displayed. This is useful for analysing usage or supplier cost trends for individual items.
Transaction Type: Filters the report by stock movement type. Select Receipt to view goods received or Issue to view stock issued (including manual issues). This allows you to focus on either inbound or outbound stock activity.
Period: Filters the report by transaction date. For issues, this is based on the Stock Issue Date. For receipts, this is based on the GRN Date. Only transactions within the selected range are displayed.
Product Group: Filters the report by stock category. This allows you to analyse stock movement by item type, such as consumables, parts, or tools.
Column Breakdown and Key Fields
Each row in the report represents either a stock issue or stock receipt, depending on the selected transaction type.
Below is a breakdown of column names and their meaning:
Column Name | Description |
SKU | The stock item number. |
Description | Description of the item. |
Bin Location | The bin location of the item. |
Received Date | Date the item was received (Receipt mode only). |
Supplier | Supplier account number and name (Receipt mode only). |
Issue Date | Date the item was issued (Issue mode only). |
Issue Time | Time the item was issued (Issue mode only). |
Qty. | Quantity issued or received. |
Unit Cost | Cost per unit of the item. |
Total Cost (Stock Issue) | Total cost for issued stock. |
Total Cost (Stock Receipt) | Total cost for received stock. |
Supplier Unit Cost | Supplier cost per unit. |
Supplier Total Cost | Total supplier cost. |
Reason Code | Reason for the issue or receipt. |
GRN Number | GRN reference for received stock. |
Receipt Number | Goods receipt number. |
Previous Receipt No. | Parent receipt reference if split. |
Product Group | Product group assigned to the item. |
PA Code | Purchase analysis code. |
PO No. | Purchase order number linked to the receipt. |
Run Number | Stocktake run number (if applicable). |
Job Number | Job or requisition linked to the issue. |
Sales Order Number | Sales order reference (if applicable). |
Customer | Customer linked to the issued stock. |
Equipt. ID | Equipment ID linked to the task. |
Make | Equipment make. |
Model | Equipment model. |
Equipt. Serial No. | Equipment serial number. |
Item Serial No. | Stock item serial number. |
Revenue | Selling price of issued stock. |
SA Code | Sales analysis code. |
Actioned By | User or engineer who processed the transaction. |
Comments | Notes added during issue or receipt. |
Insight: This report captures all relevant costing and transaction information, making it an essential reference for stock audits, financial reviews, and operational reporting.
The Stock Issue/Receipt Summary Report provides a detailed view of stock movement and associated costs.
It is recommended that you review this report regularly, either weekly or monthly, to ensure stock activity aligns with purchasing, inventory levels, and job costings.