Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report produces a list of turnover, sales and profit comparing sales of a range of weeks against year to date values.
Crystal report name Supplier Turnover and Profit 1
Other reports are available.
-
Supplier Turnover and Profit PG 1 - offering analysis by Supplier and Product Group
-
Supplier Turnover and Profit SKU 1 - offering analysis by Supplier / Range and SKU
This report requires the Sales Calendar to be set up to generate data.
See Sales Calendar
Selection Criteria
Run time choices, user selectable.
-
Week Number Range
-
Show Product Groups
-
Yes / No
-
-
Show This Year Only
-
Yes / No
-
Selecting No to this year only produces a comparison line below each grouping showing values for last year for the same week.
Print Sequence
As indicated by blue numbered squares in the report example.
1 Supplier / Vendor
2 Product Group (Where selected)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Supplier / Vendor
2 Report
Printed Fields
Fields printed on the report.
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Product Group Description (where selected)
-
Week Range for the specified Financial Year
-
Turnover
-
Sales Ex Tax / VAT
-
Cost
-
Current Profit (Ex Tax / VAT)
-
Current Margin (Percentage)
-
Values Repeated for the same period for the previous Financial Year if selected.
-
Year to Date for the specified Financial Year
-
Turnover
-
Sales Ex Tax / VAT
-
Cost
-
Current Profit (Ex Tax / VAT)
-
Current Margin (Percentage)
-
Values Repeated for the same period for the previous Financial Year if 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