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
Feedback sent
We appreciate your effort and will try to fix the article