Purchase Order List Export

Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).

Part of: Purchasing Reports

This audit replicates the content of the Purchase Order List report however the data is formatted to allow use with third party data systems, for example loading into a spreadsheet.

Selection Criteria

Run time choices, user selectable.

• Restricted Purchasing Location(s)

• Supplier / Vendor

• Sales Department Range - level 1 to 3.

• PO Created By

• Show PO Events

  • Yes / No

• Optional Manually Specified PO Pad Reference

• PO Status

  • Sent / Not Sent / Both

• Optional PO Comments Search String

• PO Status

  • All / On Order / GRN’d / Delivered

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor

2 Purchase Order Number

3 Stock / SKU / Option Combination

4 Sales Order

Report Totals

As indicated by yellow numbered squares in the report example.

• There are none

Printed Fields

Fields printed on the report.

• Supplier / Vendor

• PO Number

• PO Raised Date

• Required Date

• PO Created by

• Ordering Location

• Last Delivery Date

• Sent Indicator

• Created By

• Receiving Location

• Sales Order Number

• Customer Name

• SKU

• Range / Collection

• Model Number

• Product Description

• Product Options

• Received Date

• PO Acknowledged Indicator

• Supplier Acknowledgement

• Event Log

• Sales Department 1 to 3

Attachments (1)

image-20230119-153207.png
155 KB