Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Purchasing Reports
This report produces an export file which may be used to feed the Xero accounting product.
Crystal report name PO Extract to Xero 1
Not all fields are displayed – the complete list is detailed below
Selection Criteria
Run time choices, user selectable.
-
Date Range
-
Restricted Purchase Ordering Location(s)
-
Supplier(s)
-
PO Status
-
Sent / Not Sent / Both
-
-
Order Status
-
All / On Order / GRN’d / Delivered
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Purchase Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none
Printed Fields
Fields printed on the report.
-
Purchase Order Number
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Sales Order Number
-
Date Raised
-
Account Type (This field is blank)
-
Supplier’s Reference / Model Number
-
Account Code (This field is blank)
-
Quantity
-
Price
-
Tax %
-
Discount Rate (This field is blank)
-
Line Total
-
Tracking #1 (This field is blank)
-
Tracking #2 (This field is blank)
-
Delivery Address (This field is blank)
-
Delivery Date (This field is blank)
-
Delivery Instructions (This field is blank)
-
Delivery Attention (This field is blank)
-
Delivery Telephone (This field is blank)
-
Currency Code (This field is blank)
-
Currency Rate (This field is blank)
-
Status (This field is blank)
-
Expected Arrival Date (This field is blank)
-
Set To Contact (This field is blank)
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