Sales By Group

Created by Migration Bot, Modified on Fri, 23 Oct at 11:27 AM by Migration Bot

Originally written by John Hardwick, last updated Apr 29, 2024, 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 or sales department.

Crystal report name Sales by Group 1

The report title changes commensurate with the group by selection chosen.

This report supersedes the Sales by Product Group report, which will not be onwards developed.

Selection Criteria

Run time choices, user selectable.

  • Transaction Date Range

  • Restricted Selling Location(s)

  • Supplier / Vendor

  • Product Group

  • Sales Departments 1, 2 and 3

  • Group By

    • Product Group / Supplier & Product Group / Sales Department 1 / Sales Dept 2 / Sales Dept 3 / Sales Dept 1 & 2 / Sales Dept 1 2 & 3

  • Measured Goods with a specific with or all widths

  • 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 Group By selection

3 Sales Order Number

4 Stock ID

Report Totals

As indicated by yellow numbered squares in the report example.

1 Group By Selection

2 Report

Printed Fields

Fields printed on the report.

  • Selling Location

  • Group by selection

  • Quantity Sold

  • Percentage of Total

  • Line Selling Value

  • Percentage of Total

Detailed Mode

  • Sales Order Number

  • Stock Detail ID

  • SKU

  • Supplier / Vendor

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Range / Collection

  • 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