Goods On Order Report (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 lists all goods on all purchase orders which have not been booked into stock. The report can show all stock or stock which is in transit or notified of receipt via EDI.  The report optionally groups by location with a sort filter by date.

Selection Criteria

Run time choices, user selectable.

• Restricted Delivery to Location(s)

• Supplier / Vendor

• Range / Collection

• Product Group

• Transit Status

  • All / On-Order Only / In Transit Only

• Group By Location

  • Yes / No

• Date Sort Sequence

  • Purchase Order Date / Acknowledged Date / EDI Invoice Date

• Purchase Order Type

  • All / Internal Orders Only / Special (back-to-back) Orders Only

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location (if selected)

2 Supplier

3 Date (as per selection)

4 Purchase Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Purchase Order Number

2 Supplier / Vendor

3 Product Group

4 Report

Printed Fields

Fields printed on the report.

• Ordering Location

• Supplier / Vendor

• Purchase Order Number

• Date Raised

• Sent to Supplier Indicator

• Stock / Inventory ID

• SKU

• Product Description

• PO Item Cost

• Acknowledged Cost

• Acknowledgment Date

• Quantity

• Line Cost

• Internal Order Reference (where applicable)

• Sales Order Number (where applicable)

Product Group Summary, showing Quantities Ordered by Location and Report

Attachments (1)

image-20230519-122635.png
52.3 KB