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
Feedback sent
We appreciate your effort and will try to fix the article