Purchasing · Included in Twinn Reports
Open PO Lines for Sage 100 Contractor
Purchase order line detail by job and vendor: ordered, received, canceled and remaining quantity and amount, for open lines or all lines, with part and description.
It runs in your browser against your live Sage 100 Contractor data, through the Twinn service on your own network, and exports to Excel, PDF or CSV.
Ask Twinn · Early access
Or just ask for it.
Ask Twinn, the assistant inside Twinn, runs this same report to answer questions in plain English. It tells you which report it ran, with which criteria, as of when, so the answer always matches the report.
How Ask Twinn worksWhat’s in the report
Every column, and what it means.
- Job
- Job number on the PO.
- Job Name
- Job name (a grouping level).
- Vendor
- Vendor number.
- Vendor Name
- Vendor name.
- Record#
- PO record number.
- Order#
- PO number.
- Order Date
- Order date.
- Delivery
- Delivery date.
- Status
- PO status.
- PO Type
- PO type name.
- Line
- Line number.
- Part#
- Inventory part number (blank for a non-inventory line).
- Alpha Part#
- Alpha part number.
- Description
- Line description.
- Unit
- Unit of measure.
- Phase
- Phase on the PO (0 = none).
- Cost Code
- Cost code of the line.
- Cost Type
- Cost type of the line.
- Price
- Unit price.
- Ordered Qty
- Quantity ordered.
- Received Qty
- Quantity received to date.
- Canceled Qty
- Quantity canceled.
- Remaining Qty
- Quantity still to come.
- Ordered
- Line total as ordered.
- Received
- Value received to date.
- Canceled
- Value canceled.
- Remaining
- Value still on order.
Criteria you can set
Pick these before you run it. Twinn remembers your last run.
- Lines
- Job
- Vendor
- PO type
- Cost type
- Part or description contains
- Order date from
- Order date to
How it’s calculated
The same notes Twinn shows beside the report, so anyone reading it knows what the numbers include.
- Received is Sage's 'To Date' quantity: what has come in against the line, recorded when the vendor's AP invoice is entered against the PO. Sage has no separate invoiced quantity per line.
- Remaining = Ordered − Received − Canceled, never below zero (an over-received line has nothing left). Amounts are quantity × price, before sales tax.
- 'Open lines only' = POs in status Open, Review or Dispute with something remaining. 'All lines' still leaves out void POs.
- Part matches the part number exactly, or any part of the alpha part number or description.
More Purchasing reports
See your own WIP in Twinn
Book a demo and we’ll set Twinn up on a test copy of your Sage 100 Contractor company, then walk you through your own WIP and over/under billings, and this report.
Book a demo