Purchase Order Report

Posted November 11, 2026

Updated November 11, 2026

One line per purchase order in a date range, with how much has arrived, the amounts, what you paid and what is due.

Step by step

Open Orders > Purchase Order Report.
Click Filter Options, 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, P.Invoice ID (the purchase order number), Business, Supplier, Ordered Qty, Received Qty, Pending Qty, Net total Amt, Order Discount, Order Tax, Total Ordered Amount, Paid and Due.
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.
Pending Qty is what the supplier still has to deliver; receive it with Purchase Order to Invoice.
Paid is the advance and the payments made against the order.