Detail Purchase Order Report

Lists every Purchase Order transaction line by line, with its header details (date, branch, status, who created and approved it) and each product with quantity, prices, discounts and amounts.

Menu: Reports › Transaction Detail Reports › Detail Purchase Order Report

Required permission

Reports › Detail Purchase Order Report › View

What it's for

Use it when the transaction list isn't enough: to filter and export lines by product, brand, category, customer, supplier or status, for example for reconciliation, audits or analysis in Excel. Filter by any header field or product with Filters and Filter By Product. See Purchase Order for the transaction itself.

Example

The buyer lists all purchase order lines to Metro Foods this quarter with Remaining Inbound Qty above zero, to discuss late deliveries with the supplier.

Filters

Click Filters to narrow the report. You can filter by:

Supplier, Default Supplier, Remaining Qty, Adjustment Amount, Net Total Amount, Downpayment, Remaining Payment Amount, Transaction Status, Deliver To, Requesting Branch, Request Location, Deliver Until, Payment Method, Term, Remaining Inbound Qty, Remaining Inbound Amount.

Columns

Column	What it shows
Approval Status	Draft, For Approval, Approved or Declined.
Transaction Date and Time	The transaction's date and time.
Sheet No.	The transaction's sheet number; click it to open the transaction.
Created From	The branch where the transaction was created.
Created For	The branch the transaction is for (whose stock or money it affects).
For Location	The branch location whose stock the transaction affects.
Remarks	The transaction's remarks.
Request by	The person who requested the transaction.
Created by	User who created the transaction.
Created Date	When the transaction was created.
Audit By	User who approved (audited) the transaction.
Audit Date	When the transaction was approved.
Modified by	User who last changed the transaction.
Last Modified	When the transaction was last changed.
Deleted	Whether the transaction has been deleted.
Product Tags	The product's tags.
Product Name	The product name.
Product Description	The product's description.
Qty	Quantity on the line.
UOM	The unit of measure used on the line.
Unit Specs	The unit used on the line and how many default units it holds.
Weight	Weight of the quantity on the line, from the unit's weight on the product.
Inspect Qty	Quantity checked in inspection mode.
Total Qty	Total quantity, in default units.
O. Price	Original price: the price before the line's discounts.
Price	Price per unit on the transaction line, after line discounts.
Discount 1	First discount on the line, in %.
Discount 2	Second discount on the line, in %, applied after the first.
Discount 3	Third discount on the line, in %.
Discount 4	Fourth discount on the line, in %.
Disc/Adj	Discount or adjustment type used on the line.
Cost	The product's cost on the line.
Amount	Line amount: quantity × price.
Remaining Qty	Quantity on the line not yet received, delivered or imported into the next transaction.
Detail Remarks	The remarks on the product line.
Transaction Date	The transaction's date.
Transaction Time	The transaction's time.
Supplier	The product's default supplier.
Default Supplier	The product's default supplier (ticked on its Supplier tab).
Adjustment Amount	Amount added or taken off the whole transaction.
Net Total Amount	Total amount after the transaction's discounts.
Down Payment	Down payment made on the transaction.
Remaining Payment Amount	Amount not yet paid.
Transaction Status	Complete, Incomplete, Excess or No Delivery: how much of the transaction has been received or delivered through the transactions made from it.
Deliver To	The branch or address the goods go to.
Requesting Branch	The branch that asked for the goods.
Request Location	The location that asked for the goods.
Payment Method	How the amount was paid.
Term	Payment term, in days.
Remaining Inbound Qty	Quantity not yet received on a purchase inbound.
Remaining Inbound Amount	Value of the quantity not yet received.

Also shows: Barcode, Stock No., Chinese Name, Brand, Category, Deliver Until.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.