Supplier Turnover and Profit

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

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

Part of: Financial Reports


This report produces a list of turnover, sales and profit comparing sales of a range of weeks against year to date values.  

Crystal report name Supplier Turnover and Profit 1

Other reports are available.

  • Supplier Turnover and Profit PG 1 - offering analysis by Supplier and Product Group

  • Supplier Turnover and Profit SKU 1 - offering analysis by Supplier / Range and SKU

This report requires the Sales Calendar to be set up to generate data.

Selection Criteria

Run time choices, user selectable.

  • Week Number Range

  • Show Product Groups

    • Yes / No

  • Show This Year Only

    • Yes / No

Selecting No to this year only produces a comparison line below each grouping showing values for last year for the same week.

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor

2 Product Group (Where selected)

Report Totals

As indicated by yellow numbered squares in the report example.

1 Supplier / Vendor

2 Report

Printed Fields

Fields printed on the report.

  • Supplier / Vendor

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Product Group Description (where selected)

  • Week Range for the specified Financial Year

    • Turnover

    • Sales Ex Tax / VAT

    • Cost

    • Current Profit (Ex Tax / VAT)

    • Current Margin (Percentage)

Values Repeated for the same period for the previous Financial Year if selected.

  • Year to Date for the specified Financial Year

    • Turnover

    • Sales Ex Tax / VAT

    • Cost

    • Current Profit (Ex Tax / VAT)

    • Current Margin (Percentage)

Values Repeated for the same period for the previous Financial Year if selected.

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