Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report lists bookings made within the specified date range by product group per sales location. The last section of the report shows by product group booking across the company. The sales averages are calculated using the number of sales orders booked.
Crystal report name Average Sales Value 8
This report is presented in two section, initially product group breakdown by selected selling location and then as a summary a collation of sales by product group for all selected locations.
Selection Criteria
Run time choices, user selectable.
-
Date Range (sale transaction date)
-
Restricted Location(s)
-
Product Groups
-
Sales Departments 1, 2 & 3
-
Group by
-
Location / Product Group / Supplier / Sales Department 1 / Sales Dept 2 / Sales Dept 3 / Sales Dept 1 & 2 / Sales Dept 1, 2 & 3
-
-
Secondary Group by
-
Not Required / Salesperson / Product Group / Supplier / Sales Department 1 / Sales Dept 2 / Sales Dept 3
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Group By Selection
2 Secondary Group By Selection (where selected)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Group By Select
2 Secondary Group By Selection
3 Report
Printed Fields
Fields printed on the report.
-
Group by Selected
When grouped by supplier this will show the catalogue supplier or the supplier name dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Secondary Group by (when selected)
-
Average Sales Value
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