Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report provides an analysis of orders placed because of inviting customers to an event (interaction) with the option of filtering orders placed within several days of the event occurring.
Crystal report name Orders Placed Following An Interaction 1
This report offers a detailed and summary format.
Detailed Format
See image above.
Transactions with a margin below the stipulated threshold are highlighted with a pink background and red text.
This report uses the Delivery Group checkbox set against the SKUs as defined with Set Up Product Groups to establish if the order line is an item or a delivery charge.
Selection Criteria
Run time choices, user selectable.
-
Restricted Ordering Location(s)
-
Interaction (Promotional Event)
Uses the interaction date to calculate which orders were placed within the stipulated number of days.
-
Date
-
Order / Booked
-
-
Include Held Orders
-
Yes / No
-
-
Format
-
Detailed / Summary
-
-
Highlight Margins Below X%
-
Include Quotations
-
Yes / No
-
-
Days before and After the Interactions Event Date
Print Sequence
As indicated by blue numbered squares in the report example.
1 Interaction
2 Location
3 Date
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location
2 Business Area
3 Report Total
Printed Fields
Fields printed on the report.
-
Interaction
-
Selling Location
-
Order Date
-
Booked (Keyed) Date
-
Interaction Date
-
Days (Before or After the Interaction date the order was processed)
-
Primary Salesperson
-
Order Number
-
Customer ID
-
Order Value
-
Order Value Ex Tax
-
Cost of Order
-
MRP
-
Gross Profit Value
-
Gross Profit Percentage
-
Number of Orders Raised
-
Number of Customers.
Summary Format
Selection Criteria
As per detailed format.
Print Sequence
As indicated by blue numbered squares in the report example.
1 Business Area
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location
2 Business Area
3 Report Total
Printed Fields
Fields printed on the report.
-
Interaction
-
Selling Location
-
Number of Orders
-
Number of Customers
-
Order Value
-
Order Value Ex Tax
-
Cost of Order
-
MRP
-
Gross Profit Value
-
Gross Profit Percentage
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