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 colour.
Crystal report name Sales by Colour 3
This report produces data for measured goods only
The summary version only shows details to colour level
Detailed without options collates by colour omitting the options grouping
Selection Criteria
Run time choices, user selectable.
-
Transaction Date Range
-
Group by Supplier & Range
-
Yes / No
-
-
Group by Product Group
-
Yes / No
-
-
Enter Carpet Width
-
Enter Product Group
-
Enter Colour
-
Run Mode
-
Summary / Detail with Options / Detail without Options
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Supplier / Vendor (if selected)
2 Range / Collection (if selected)
3 Product Group or Supplier
4 Colour
5 Options (if selected)
6 Sales Order
7 Stock / Inventory ID
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none.
Printed Fields
Fields printed on the report.
-
Selling Location
-
Supplier / Vendor
-
Range / Collection
-
Product Group
-
Colour Group
-
Option Colour
-
Number of Orders
-
Quantity Sold
-
Sales Order Number
-
Stock / Inventory 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)
-
Supplier’s Model Reference
-
Product Description, including options (where selected)
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