Originally written by John Hardwick, last updated Nov 14, 2023, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report is designed to present a list of bookings / cancellations by location showing cost, selling and margin obtained.
Crystal report name Orders Booked Analysis 9
This report offers a detailed and summary format. The summary mode omits the order detail producing location totals at the lowest level.
Transactions with a margin below the stipulated threshold are highlighted with a pink background and red text.
Where selected, expected (displayed with an E) or actual (A) costs are including in the margin/profit calculation. If excluded finance costs will show but will be omitted from the margin calculations.
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)
-
Date Format
-
Booked / Keyed / Transaction
-
-
Date Range
-
Format
-
Detailed / Summary
-
-
Include Held Orders
-
Yes / No
-
-
Include Quotes
-
Yes / No
-
-
Include Expected / Actual Finance Costs in Margin
-
Yes / No
-
-
Highlight Margins Below X%
Print Sequence
As indicated by blue numbered squares in the report example.
1 Business Area
2 Location
3 Sales Order Number (detail only)
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.
-
Business Area Code and Description
-
Selling Location
-
Sales Order Number (detailed only)
-
Primary Salesperson (detailed only)
-
Sales Order Date (detailed only)
-
Booked Date (detailed only)
-
Transaction Date (detailed only)
-
Order Status (detailed only)
-
Full Customer’s Name (detailed only)
-
Goods Value
-
Goods Value Ex Tax
-
Delivery Charges
-
Delivery Charges Ex Tax
-
Order Total
-
Order Total Ex Tax
-
Tax
-
Order Cost to Retailer
-
Finance Cost (expect or actual)
-
MRP
-
Gross Profit (Percentage)
-
Number of Sales Orders
-
Number of Customers
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