Trading Summary

Created by Migration Bot, Modified on Fri, 23 Oct at 11:27 AM by Migration Bot

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

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