Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report uses the product grouping of items sold per location to analyse the source of business. The report offers a user specified date range.
Crystal report name New Business Source 4
The ‘product grouping’ used in this report is a simple check on the first character of the product groups used on the sales order.
If the product group begins with a B the group is Beds, otherwise the group is flooring.
The Pre-set option may not be suitable for your company, it is therefore recommended product group option be chosen when operating this report.
Selection Criteria
Run time choices.
-
Sales Order Date Range
-
Restricted Selling Location(s)
-
Grouping
-
Product Group / Pre-set
-
The pre-set option has hardcoded groupings of Flooring (PG of A,E,F or M) and Beds (PG of B)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Selling Location
2 Product Group
3 Source of Business
Report Totals
As indicated by yellow numbered squares in the report example.
1 Product Group
2 Location
3 Report
Printed Fields
Fields printed on the report.
-
Selling Location
-
Product Group Description
-
Number of New Orders
-
Transaction Value - Sum of Sales Order 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