Purchase orders by month · Report library | HiScale Advanced Reports, native NetSuite reporting

Screenshot of the Purchase orders by month report in HiScale Advanced Reports, filled with fictional sample data — Sample preview, fictional dataYour own figures appear after import.

About this report

Purchase orders by order date for the last 24 months, leaving out orders rejected by the supervisor. Each row gives the order count, distinct vendors, and the order value before tax in base currency. Average order is recalculated from the totals at any grain.

Group by Quarter or Year to follow purchasing volume. Vendors shows for months only, because it is a distinct count.

Sample preview

Fictional figures in the shape you will see. Yours come from your account.

Month	Orders	Vendors	Amount	Average order
2026-06	36	14	198,300	5,508.33
2026-07	38	15	212,400	5,589.47
2026-08	44	17	256,100	5,820.45
2026-09	29	12	174,980	6,033.79

The SuiteQL

This is the query each report runs. Read it, copy it, or change it after import.

Purchase orders by month

SELECT TO_CHAR(t.trandate, 'YYYY-MM') AS period,
       COUNT(DISTINCT t.id) AS orders,
       COUNT(DISTINCT t.entity) AS vendors,
       SUM(tl.foreignamount * t.exchangerate) AS amount,
       SUM(tl.foreignamount * t.exchangerate) / COUNT(DISTINCT t.id) AS avg_order
  FROM transaction t
  JOIN transactionline tl ON tl.transaction = t.id
 WHERE t.type = 'PurchOrd'
   AND t.status NOT IN ('PurchOrd:C', 'C')
   AND tl.mainline = 'F'
   AND tl.taxline = 'F'
   AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -23)
 GROUP BY TO_CHAR(t.trandate, 'YYYY-MM')
 ORDER BY period