Originally written by John Hardwick, last updated Mar 26, 2026, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This report is designed to calculate commission payable to sales staff.
Crystal report name New Commission - General 5
This report requires the commission system to be configured. For details, see New Commission System
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Date Control
-
Transaction Date / Date first fully paid and delivered / First fully paid date / First fully Delivered date
-
-
Format
-
Order Line Details / Order Totals / Salesperson Totals
-
-
Restricted Selling Location(s)
-
Salesperson
-
Exclude Orders Raised before Date
-
Payment Bonus Control
-
Exclude ‘On Hold’ Orders / Ignore Held Status
-
-
Payment Bonus Control 2
-
Exclude ‘Cancelled’ Orders / Ignore Cancelled Status
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Selling Location
2 Salesperson
3 Sales Order Number (not Salesperson Summary mode)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Order Totals (not salesperson summary mode)
2 Salesperson
Printed Fields
Fields printed on the report.
Details shown in Order Total and Order Line Detail Format
-
Order Number
-
Sold From Location
-
Split Sale Indicator
-
Customer’s Null Name
-
First Fully Paid Date
-
First Fully Delivered Date
-
Booked Quantity
-
Booked Value
-
Booked Commission
-
Spiff Units
-
Spiff Bonus
-
Delivered Quantity
-
Delivered Value
-
Delivered Commission
-
Split Payment Percentage
Additional information shown in Order Detail Only
-
SKU
-
Product Description & Options
-
Product Group
-
Transaction Date
Details shown in all formats.
-
Sales Location
-
Salesperson
-
Total Booked Sales
-
Total Delivered Sales
-
Commission Threshold
-
Number of Spiffs
-
Commission Payable Booked
-
Commission Payable Delivered
-
Volume Bonus
-
Spiff Value
-
Payment Bonus
-
Total Commission Payable.
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