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
Feedback sent
We appreciate your effort and will try to fix the article