Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
The report details sale, VAT and costs incurred for a user specified week with a year to date (selected week) shown alongside, broken down by supplier within product group within location.
Crystal report name Profit Report 12
Selection Criteria
Run time choices, user selectable.
-
Week Number Range
-
Financial Year
-
Restricted Selling Location(s)
-
Group By Location
-
Yes / No
-
-
Include Salesperson
-
Yes / No
-
-
Report Detail
-
Sales Order - Supplier - Product Group / Supplier - Product Group / Product Group
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location (where selected)
2 Salesperson (where selected)
3 Product Group
4 Supplier (where selected)
5 Sales Order Number (where selected)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Supplier (where selected)
2 Product Group
3 Salesperson (where selected)
4 Location (where selected)
5 Report
Printed Fields
Fields printed on the report.
-
Trading Location
-
Salesperson
-
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 Order Number (Shown in blue)
-
Cumulative to Selected Week
-
Sales Ex Tax / VAT
-
Cost
-
Current Profit Value
-
Current Margin (Percentage)
-
-
Year to Date
-
Sales Ex Tax / VAT
-
Cost
-
Current Profit Value
-
Current Margin (Percentage)
-
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