Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report details new business booked for a selected week, showing bookings for this year and last year.
To make use of this report, the sales calendar needs to have the financial year set to the year number (I.e., 2008)
Crystal report name New Business Comparison 2
The group is derived from the first x characters of the product group code. This example uses 4 characters.
The product group title line and group totals are omitted from the report when instructed not to show.
The report uses the sales calendar to derive week numbers, the financial year should be set to CCYY (century and year – e.g., 2008)
The TY (this year) column uses the current year. LY (last year) is generated using the same week number, with the year being the current year less 1.
This report requires the Sales Calendar to be created and maintained.
Selection Criteria
Run time choices.
-
Week Number
-
Include Hold Orders
-
Yes / No
-
-
Report Group
-
Show Product Groups
-
Yes / No
-
-
Restricted selling location(s)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Group
2 Product Group (Section of Product Group Code)
3 Supplier
Report Totals
As indicated by yellow numbered squares in the report example.
1 Product Group
2 Report Group (Section of Product Group Code)
3 Report
Printed Fields
Fields printed on the report.
-
Group (Section of Product Group Code)
-
Product Group Description
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Sales This Week
-
Sales Last Year - This Week
-
Sales Year to Date
-
Sales Last Year to Date
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