Sales By Price Band

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


This report is designed to sow sales of measured goods broken out by price band (controlled via Set Up Price Bands)

Crystal report name Sales by Price Band 3

This report produces data for measured goods only

This report requires price banding to be setup

The summary version only shows details to colour level

Detailed without options collates by colour omitting the options grouping

Selection Criteria

Run time choices, user selectable.

  • Transaction Date & Time Range

  • Group by Supplier & Range

    • Yes / No

  • Group by Product Group

    • Yes / No

  • Enter Carpet Width

  • Enter Product Group

  • Enter Colour

  • Run Mode

    • Summary / Detail with Options / Detail without Options

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor (if selected)

2 Range / Collection (if selected)

3 Product Group or Supplier

4 Colour

5 Options (if selected)

6 Sales Order

7 Stock / Inventory ID

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Selling Location

  • Supplier / Vendor

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

  • Range / Collection

  • Product Group

  • Colour Group

  • Option Colour

  • Number of Orders

  • Quantity Sold

  • Sales Order Number

  • Stock / Inventory ID

  • SKU

  • Supplier / Vendor

  • Supplier’s Model Reference

  • Product Description, including options (where 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