Originally written by John Hardwick, last updated Mar 26, 2026, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
A report listing open sales orders grouped by salesperson or location, detailing the financial status of each sale. This report is designed to allow you to assess the status of sales progressing through the company at a glance.
Crystal report name Open Orders Report 34
Crystal report name Open Orders Report-Loc Restricted 4 (location restricted version)
Summary Format
See image above
-
The sales order number / pad reference background indicates order status in SwanFRS
-
Yellow - On Hold
-
Orange - Quotation
-
Green - Accepted
-
-
The Order Line status bar shows the stock status of active lines on the sales order.
-
Grey - Not yet on demand - (Generally the order has not been accepted yet).
-
Red - On purchase order - Order lines awaiting a PO or allocation from stock
-
Yellow - Order lines fulfilled by a Purchase order
-
Green - Order lines with goods in stock
-
Blue - Order lines where the goods or service has been delivered.
-
-
Red Due dates - This indicates the order is late
-
Where instructed, the report will show any unallocated funds linked to the customer’s account - red italic text
-
Pink backgrounds indicate sales with linked service calls.
Detailed Format
The detailed version of the report includes the sales order line breakdown.
-
The background colour of the Quantity field shows the order line status
-
Grey - Not yet on demand - (Generally the order has not been accepted yet).
-
Red - On purchase order - Order lines awaiting a PO or allocation from stock
-
Yellow - Order lines fulfilled by a Purchase order
-
Green - Order lines with goods in stock
-
Blue - Order lines where the goods or service has been delivered.
-
-
The Stock location shows red if the item is not fulfilled from either stock or purchase order.
-
The PO required Date shows a red background if the PO is late and the Days column shows the number of days late.
Selection Criteria
Run time choices, user selectable.
-
Orders Entered up to Date & Time
-
Restricted Location(s) - Selling Location
-
Sort
-
Location / Location (no unallocated payments) / Salesperson
-
-
Report Format
-
Detailed (Order Lines) / Summary (Order Totals)
-
-
Show Order lines with
-
On Demand Items / On Order (PO) / In Stock / Delivered
-
-
Show
-
Due Date / Order Date
-
-
Include
-
All Orders / Only Orders with Service calls / Only Orders without Service calls
-
-
Show Unallocated Funds
-
Yes / No
-
-
Include Quotes
-
Yes / No
-
-
Include Held Orders
-
Yes / No
-
-
Show Costs
-
Yes / No
-
-
Show Customers Address
-
Yes / No
-
-
Salesperson(s)
-
Contact Status
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Location or Salesperson
2 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location or Salesperson
2 Report Totals
Printed Fields
Fields printed on the report.
Summary Format
-
Sales Location or Salesperson
-
SwanFRS Sales Order Number
-
Manual Pad Reference
-
Customer’s Full Name
-
Salesperson or Selling Location
-
Order Line status bar
-
Order Due Date
-
Cost of goods in Stock
-
Costs of goods not in Stock
-
Balance Due
-
Customer’s outstanding deposit
-
Value of Approved Finance
-
Value of Deposit paid including finance
-
Value of Sales Order
-
Value of unallocated funds (where selected)
-
Customer’s Master Address (where selected).
Detailed Format
-
Supplier’s Name
-
Product Range
-
Product Group
-
Product Description
-
Line Quantity
-
Stock Holding Location
-
Selling Price
-
Lead Time
-
PO Required Date
-
Day late (for the PO)
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