Purchase Order Extract to Xero

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

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

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