Purchase Orders (most recent first)

Custom SQL query returning 1,000 rows (hide)

SELECT
  po.num               AS "PO #",
  po.dateIssued        AS "Date Issued",
  vendor.name          AS "Vendor",
  po.vendorContact     AS "Vendor Contact",
  po.statusId          AS "Status",
  po.totalIncludesTax  AS "Total (incl. Tax)",
  po.buyer             AS "Buyer",
  po.note              AS "Notes",
  po.id                AS "Internal ID"
FROM po
LEFT JOIN vendor ON po.vendorId = vendor.id
ORDER BY po.dateIssued DESC, po.id DESC
LIMIT 1000

Edit SQL