Sales Order Audit (1214 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 11:27 AM by Migration Bot

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.

image-20251028-101510.pngimage-20251028-101539.png

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article