Skip to main content

Report: SKU Volume Summary

SKU Volume Summary Report – Business Intelligence Module

A
Written by Arnold E. Garcia
Updated today

Let's get started!

The SKU Volume Summary Report provides a view of stock purchases across selected branches, suppliers, and product groups within a defined period.

This report helps users to:

  • Monitor the quantity of SKUs purchased.

  • Analyse purchasing trends by branch, supplier, or product group.

  • Track supplier performance and SKU-level activity.

  • Support data-driven inventory and procurement planning.


Getting There

To access the SKU Volume Summary 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 SKU Volume Summary 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 purchase data is displayed.

  • SKU: Filters the report by stock item number or description. This allows you to analyse specific items or groups of items and track their purchasing activity.

  • Period: Filters the report by purchase date or purchase order creation date. This allows you to review recent activity or analyse longer-term purchasing trends.

  • Branch: Filters the report by branch or depot. The report automatically uses the branch selected in the main Service Geeni interface. This allows you to focus on a single branch or review data across the business.

  • Supplier: Filters the report by supplier account. This allows you to track purchasing activity from specific suppliers and analyse supplier trends.

  • Product Group: Filters the report by product group. This allows you to analyse purchasing patterns across different stock categories.


Column Breakdown and Key Fields

Each row in the report represents a purchased stock item in a purchase order.

Column Name

Description

Branch

Branch number and description where the item was purchased.

SKU

Stock item number.

Description

Description of the stock item.

Supplier

Supplier account number linked to the purchase.

Product Group

Product group assigned to the item.

Purchase Order Number

Unique purchase order number.

Line Number

Line number of the item within the purchase order.

Quantity

Quantity of the stock item purchased.

Insight: Regular review of SKU volumes allows procurement teams to track stock purchasing trends, optimise supplier relationships, and maintain accurate inventory records.

The SKU Volume Summary Report helps you monitor purchasing activity at SKU level across branches and suppliers.

It is recommended that you review this report regularly, either weekly or monthly, to maintain accurate stock levels and support procurement decisions.

Did this answer your question?