Purchase Order Chase Export (1200 onwards)

Originally written by John Hardwick, last updated Feb 02, 2026, on the Swan Retail knowledge base (FRS).

Part of: Purchasing Reports

This report replicates the Purchase Order Chase with the output formatted to allow importing into a spreadsheet routine such as Excel.

The output is formulated for extraction and therefore certain columns may not display (to screen) accurately.

Selection Criteria

Run time choices, user selectable.

• Selection Type

  • Days Before PO / Acknowledgement / Days Before Expected Supplier Delivery / Days Before Confirmed Delivery / Days Overdue (Confirmed Delivery)

• Number of Days

• Supplier(s)

• Restricted Purchase Ordering Location(s)

• Origin

  • Both / Back-to-back (Special Order) / Internal Order Only

• Include

  • All Stock / Display Stock Only

• PO Status

  • Not Sent / Sent / Send & Not Acknowledged / Sent & Booked In / All POs

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.

• Not Applicable

Printed Fields

Fields printed on the report.

• Purchase Ordering Location

• Supplier / Vendor

• Purchase Order Number

• Purchase Order Pad Reference

• Sales Order Number

• SKU

• Range / Collection

• Supplier’s Reference Number / Model

• Product Description & Options

• Quantity Ordered

• Date Raised

• Date Sent to Supplier

• Anticipated GRN Date

• Confirmed Delivery Date

• Estimated Delivery Date

• Current Status

• Delivery Status

• Source

• Display Item

• Line Cost

• Primary Salesperson

• Acknowledgement Reference

• Purchase Order Cost

• Acknowledged Cost

Attachments (1)

image-20230612-121121.png
21 KB