Average Sales Value

Created by Migration Bot, Modified on Fri, 23 Oct at 11:26 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 lists bookings made within the specified date range by product group per sales location.  The last section of the report shows by product group booking across the company.  The sales averages are calculated using the number of sales orders booked.

Crystal report name Average Sales Value 8

This report is presented in two section, initially product group breakdown by selected selling location and then as a summary a collation of sales by product group for all selected locations.

Selection Criteria

Run time choices, user selectable.

  • Date Range (sale transaction date)

  • Restricted Location(s)

  • Product Groups

  • Sales Departments 1, 2 & 3

  • Group by

    • Location / Product Group / Supplier / Sales Department 1 / Sales Dept 2 / Sales Dept 3 / Sales Dept 1 & 2 / Sales Dept 1, 2 & 3

  • Secondary Group by

    • Not Required / Salesperson / Product Group / Supplier / Sales Department 1 / Sales Dept 2 / Sales Dept 3

Print Sequence

As indicated by blue numbered squares in the report example.

1 Group By Selection

2 Secondary Group By Selection (where selected)

Report Totals

As indicated by yellow numbered squares in the report example.

1 Group By Select

2 Secondary Group By Selection

3 Report

Printed Fields

Fields printed on the report.

  • Group by Selected

When grouped by supplier this will show the catalogue supplier or the supplier name dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Secondary Group by (when selected)

  • Average Sales Value

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