Originally written by John Hardwick, last updated Mar 26, 2026, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report can operate as a stand-a-lone report or plugged in to the RPT_SO_HISTORY report which is produced when the Print Audit is selected from the side panel when viewing the sales order detail.
Crystal report name Sales Order Audit 13
When run from the menu the report requests the sales order number, when selected from the side panel the sales order number is sent to the report from the application.
The report is split into the following sections.
|
Section |
Details |
|---|---|
|
Sales Order Details |
Sales Order number, dates, created |
|
Header Activity |
Information about the order header / status changes of the order. |
|
Order Comments |
Notes and comments added to the order during its life cycle. This includes appointment notes where operational |
|
Order Line Details |
An audit of who did what when for the order lines. Via this section, it is possible to see when an item was added, how the price changed etc. |
|
Activity Sequence |
A summarised chronological event list and the impact actions have had on the orders financials |
|
Scheduling |
Where the order has a delivery schedule, this section shows the run numbers and outcomes of the delivery. |
|
Grouping |
Where active, this section lists order lines by their ‘group narratives’. |
|
Appointments History |
An audit log of appointments (visits) to the customer. |
Selection Criteria
Run time choices.
-
Sales Order Number (only requested when run from the menu, when run from the side panel the order number is automatically sent to the report.)
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none.
Printed Fields
Fields printed on the report.
Sales Order Number in the header bar
Section 1 (Order Details)
-
Order Creation Date
-
First Fully Paid Date
-
First Fully Delivered Date
-
Sales Order Location
-
Date Created
-
Operator who Entered the Order.
Section 2 (Header Activity)
-
Amendment / Action Date & Time Stamp
-
Operator
-
Action or Event
Section 3 (Order Comments)
-
Message State (Traffic light / Blue background)
-
Event Type
-
Event Owner
-
Date Created
-
Date Due for Closure / Closed
-
Action Owner
-
Event Narrative / Text
Section 4 (Order Line Changes)
-
Stock / Inventory ID (barcode)
-
SKU
-
Supplier / Vendor
-
Range / Collection
-
Product Description
-
Model / Suppliers Stock Reference
-
Options
-
Quantity
-
Original Price
-
Final Price
-
Discount
-
Operator applying the change
-
Actual date of change
-
Working date of change
-
Reason for the change
Section 5 (Activity Sequence)
-
Transaction Date & Time
-
Stock / Inventory ID
-
SKU or Payment Indicator
-
Product Description / Payment reference
-
Value Ex Tax
-
Running Total
-
Value Inc Tax
-
Running Total
-
Payments
Section 6 (Scheduling Activity)
-
Activity date
-
Operator
-
Delivery Run Number
-
Scheduled Date
-
Route Name
-
Departing Location
-
SKU scheduled (removed from schedule)
-
Model Number / Suppliers Stock Reference
-
Product Description
-
Status indicator
-
Amendment / Process indicator
-
Amendment / Delivery Operator
-
Section 7 (Group Narrative)
-
SKU
-
Stock ID
-
Group Description
-
Date Created (or Amended)
-
Operator
Section 8 (Appointments)
-
Date
-
Time
-
Duration
-
Agent
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