Open Actions

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

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


This report lists all open orders and actions relating to those orders.

The report is grouped by salesperson and groups orders into those with and without services. The report uses the product grouping of items sold per location to analyse the source of business.  The report offers a user specified date range.

Crystal report name Open Actions Report 2

Dates are shown with a red background if they are overdue, with the number of dates after the date.

The order line status replicates the colours used in SwanFRS. The numbers in the coloured section within the Stock Status block show the number of units in each state.

The report groups by ‘General Actions’ and then ‘Service Actions'

Selection Criteria

Run time choices.

  • Sales up to Date

  • Deliveries up to Date

This is not a date range - two separate cut off dates.

  • Salesperson(s)

  • Restricted Sales Location(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Salesperson

2 Service / Sales

3 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.

  • Salesperson

  • Sales Order Number

  • Sales Order Date

  • Promised Date - Shown with a red background if historic date

  • Days Overdue - Shown with a red background

  • Acknowledgement Date

  • Acknowledged Days Late

  • Full Customer Name

  • Number of Stock Items per Status

    • Not On Demand - Grey

    • On Demand - Red

    • On Order - Yellow

    • In Stock - Green

    • Delivered - Blue

  • Value to Deliver

  • Contact Status

  • Linked Service Number

  • Next Open (Outstanding) Service Event

  • Event Owner

  • Event Due Date

  • Open Actions

    • Sales Order Number

    • Full Customer Name

    • Action Person

    • Action Type

    • Due Date

    • Action Indicator / Days Overdue

    • Notes

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