Booked Sales Movement

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

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


This report is designed to show differences between the original booking value for sales order generated within a specified week to its current order values.  I.e., pipeline movement.

Crystal report name Booked Sales Movement 2

Green backgrounds indicate an increase in the order’s booked value, red indicates a reduction.

Drill Down Feature

Whilst viewing in the browser, by clicking when the cursor is on the ‘day’ row, creates a secondary display page showing the details manufacturing that day’s totals.

Selection Criteria

Run time choices, user selectable.

  • Restricted Location(s) - Selling Location

  • Financial Year

  • Week Range within Financial Year

  • Show

    • Location / Day / Week

    • Location / Week

    • Location

  • New Page per Location

    • Yes / No

  • Include Quotations

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Sales Location

2 Week (if selected)

3 Day (if selected)

Report Totals

As indicated by yellow numbered squares in the report example.

1 Day (if selected)

2 Week (if selected)

3 Location

4 Report Totals

Printed Fields

Fields printed on the report.

  • Sales Location

  • Financial Year (in heading)

  • Week Number

  • Day of the Week

  • Date

  • Number of Orders Booked

  • Number of Orders Changed

  • Booked Value

  • Current Value

  • Movement between Booked and Current

  • Percentage Variance

Drill Down

  • Sales Order Number

  • Sales Order Date

  • Customer Surname

  • Primary Salesperson

  • Booked Value

  • Current Value

  • Movement between Booked and Current

  • Percentage Variance

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