Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report offers the ability to group by a time factor with a choice of subgrouping. The report is designed to show the sum of monies received (and returned) into the business within a date range and a statement of deliveries (and returns) confirmed (finalised) within the date range.
The profit achieved (current) for each item along with the gross margin percentage is displayed and highlighted dependent upon the margin threshold specified.
Green text indicates payments, Blue indicates order activities.
Crystal report name Trading Summary 3
Graphs / Charts are only displayed if requested by the operator.
The total matrix section is produced for all formats (detailed, summary and totals)
Where configured / used the report will show expected actual finance costs processed against the order which will affect the margin / profit values generated.
The profit / margin values are controlled via the MARGIN_CALCULATION application parameter.
Selection Criteria
Run time choices, user selectable.
-
Order Date Range
-
Restricted Selling Location(s)
-
Group by
-
Daily / Week / Month / Year
-
-
Subgroup
-
Branch / Salesperson / Supplier (Deliveries Only) / Product Group (Deliveries Only)
-
-
Format
-
Detailed / Summary / Totals Only
-
-
Target GM %
Profits over the specified rate are shown with a green background, yellow if less (up to 50% less) otherwise shown with a red background.
-
Show Charts
-
Yes / No
-
-
Include Allowance Lines
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Group by
2 subgroup
3 Sales Order (Detailed Only)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Subgroup
2 Group
3 Report (including matrix)
Printed Fields
Fields printed on the report
-
Group
-
Subgroup
-
Customer’s Full Name
-
Sales Order Number
-
Tender (green text) / or SKU (blue text) - Detail Only
-
Transaction Date
-
Payment Value Total
-
Customer Payment
-
Finance Payment
-
Sales Total / Adjustment
-
Delivery Value
-
Return Value
-
Profit Value
-
Profit Percentage
This Report will show the catalogue debranded supplier or the debranded supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
Files from the Confluence page
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