Originally written by John Hardwick, last updated Nov 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
Similar to the salesperson performance report, this option shows margin contribution compared to the report total collated by product group or sales department.
Crystal report name Salesperson By Group 1
Summary version omits the individual sales lines.
The report title changes commensurate with the group by selection chosen.
This report supersedes the Salesperson by Product Group report, which will not be onwards developed.
Selection Criteria
Run time choices, user selectable.
-
Restricted Selling Location
-
Transaction Date Range
-
Salesperson
-
Primary / Secondary / Line level
-
-
Include Held Orders
-
Yes / No
-
-
Format
-
Detail / Summary
-
-
Product Group(s)
-
Sales Department levels 1,2 & 3
-
Group by
-
Product Group / Sales Department 1 / Sales Dpt 2 / Sales Dpt 3 / Sales Depart 1 & 2 / Sales Dpt 1,2 & 3
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Selling Location
2 Salesperson
3 Group by selection
4 Sales Order (Detail Only)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Group By selection
2 Salesperson
3 Selling Location
4 Report
Printed Fields
Fields printed on the report.
-
Selling Location
-
Salesperson
-
Group by selection
-
Value of Services Sold
-
Value of Stock Sold
-
Special Ordered Selling Value
-
Total Sales
-
Cost of Sale
-
Discount Given
-
Margin Percentage
-
Margin Value
Detailed only
-
Sales Order Number
-
Stock Detail ID
-
SKU
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