Sales By Product Group (1214 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

Originally written by John Hardwick, last updated Apr 29, 2026, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


This report is designed to show sales of measured goods broken out by product group.

image-20250808-095757.png

Crystal report name Sales by Product Group 10

This report has been replaced with the Sales by Group report. This new version offers collation by product or sales departments.

Click to view details Sales By Group

Selection Criteria

Run time choices, user selectable.

  • Transaction Date Range

  • Restricted Selling Location(s)

  • Supplier(s)

  • Product Group(s)

  • Group By Supplier & Range

    • Yes / No

  • Measured Goods with a specific with or all widths

  • Product Group

  • Mode

    • Summary / Detailed with Options / Detailed without Options

  • Show Origin

    • Yes / No

This option will show the origin of the stock, i.e., the Write-on note or GRN number.

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location

2 Supplier / Vendor (if selected)

3 Range / Collection (if selected)

4 Product Group or Supplier

5 Sales Order

6 Stock ID

Report Totals

As indicated by yellow numbered squares in the report example.

1 Matrix Totals - Supplier / Product Group or Report dependent upon choice

2 Report

Printed Fields

Fields printed on the report.

  • Selling Location

  • Supplier / Vendor (where selected)

  • Range / Collection (where selected)

  • Product Group Code & Description

  • Quantity Sold

  • Percentage of Total

  • Line Selling Value

  • Percentage of Total

Detailed Mode

  • Sales Order Number

  • Stock Detail ID

  • SKU

  • Product Description

  • Product Options (where selected)

  • Quantity Sold

  • Unit Price

  • Origin (GRN / Write-On Number) - where selected

Detail fields are shown in blue italic text.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article