Historic Order Reference Enquiry

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 is designed to act as an order lookup for orders processed on a legacy ERP system, should that system be no-longer available.

It is important that your requirements are discussed with your implementation consultant at time on migrating to SwanFRS as it is not possible to populate this report using SwanFRS.

Note, there is a variance of this report available on request (PRE FRS Customer Orders)

Crystal report name Historic Order Reference Enquiry 1

Detailed Format

See image above.

Summary Format

Selection Criteria

Run time choices.

  • Format

    • Detailed / Summary

  • Customer Surname

  • Product Range

Print Sequence

As indicated by blue numbered squares in the report example.

  • Not Applicable

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Historic Order Number

  • Invoice Number

  • Order Date

  • Order Type

  • Selling Location

  • Customer

  • Salesperson

  • Order Value

  • Order Discount

  • Order Vat

  • Brand

  • Product Range

  • Item

  • Quantity

  • Discount Total including VAT

  • Purchase Order Refrence

  • Supplier

  • Status

  • Promotion Price

  • Line Discount

  • Line VAT

  • Cost

The data fields presented require a ‘reference’ table to be populated within SwanFRS from the ‘legacy’ computer system - Fields will only contain data if populated from the legacy system

No Data presented in this enquiry is obtained from the main SwanFRS system.

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