Sales Orders (most recent first)

Custom SQL query returning 1,000 rows (hide)

SELECT
  so.num            AS "Order #",
  so.dateIssued     AS "Date Issued",
  customer.name     AS "Customer",
  so.customerPO     AS "Customer PO",
  so.statusId       AS "Status",
  so.totalPrice     AS "Total",
  so.salesman       AS "Salesman",
  so.note           AS "Notes",
  so.id             AS "Internal ID"
FROM so
LEFT JOIN customer ON so.customerId = customer.id
ORDER BY so.dateIssued DESC, so.id DESC
LIMIT 1000

Edit SQL