New Commission - Supplier (1214 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

Originally written by John Hardwick, last updated Apr 30, 2026, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports


This report is designed to produce a commission statement for a specified supplier (vendor).

Crystal report name New Commission - Supplier 3

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

  • Supplier

This report only includes commission payable items linked to the specified supplier and is designed to aid claim-backs from the supplier.

  • Exclude Orders Raised before Date

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article