Purchase Ordered Products Report

Posted November 11, 2026

Updated November 11, 2026

One line per product of each purchase order: how much was ordered, how much has arrived, how much is pending and at what cost.

Step by step

Open Orders > Purchase Ordered Products Report.
To see one product type it in Search Product and pick it. Choose the Supplier, From Date and To Date, then press Filter. A user who sees all shops also has the Business filter.
The columns are Date, Product, P. Code(SKU), Business, Supplier, P.Invoice ID, Ordered Qty, Received Qty, Pending Qty, Unit Cost, Unit Discount, Unit Tax, Unit Cost (Inc. Tax) and Line-Total.
Click a P.Invoice ID to open the purchase order.
The last row shows the totals for everything that matches the filters.
Excel and Pdf export the table. Print at the top prints the report for the chosen filters.

Print needs both From Date and To Date.
With Wholesale & Distribution on, the quantity is shown as Group Qty and Base Qty as well.
For one line per order use Purchase Order Report.