New Business Comparison

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 details new business booked for a selected week, showing bookings for this year and last year.

 To make use of this report, the sales calendar needs to have the financial year set to the year number (I.e., 2008)

Crystal report name New Business Comparison 2

The group is derived from the first x characters of the product group code.  This example uses 4 characters.

The product group title line and group totals are omitted from the report when instructed not to show.

The report uses the sales calendar to derive week numbers, the financial year should be set to CCYY (century and year – e.g., 2008)

The TY (this year) column uses the current year. LY (last year) is generated using the same week number, with the year being the current year less 1.

This report requires the Sales Calendar to be created and maintained.

Selection Criteria

Run time choices.

  • Week Number

  • Include Hold Orders

    • Yes / No

  • Report Group

  • Show Product Groups

    • Yes / No

  • Restricted selling location(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Group

2 Product Group (Section of Product Group Code)

3 Supplier

Report Totals

As indicated by yellow numbered squares in the report example.

1 Product Group

2 Report Group (Section of Product Group Code)

3 Report

Printed Fields

Fields printed on the report.

  • Group (Section of Product Group Code)

  • Product Group Description

  • Supplier / Vendor

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

  • Sales This Week

  • Sales Last Year - This Week

  • Sales Year to Date

  • Sales Last Year to Date

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