Print Report
Monthly Summary Report

Facility:

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-06-01' AND `sale_datetime` <= '2025-06-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-06-01\' AND `sale_datetime` <= \'2025-06-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-07-01' AND `sale_datetime` <= '2025-07-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-07-01\' AND `sale_datetime` <= \'2025-07-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-08-01' AND `sale_datetime` <= '2025-08-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-08-01\' AND `sale_datetime` <= \'2025-08-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-09-01' AND `sale_datetime` <= '2025-09-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-09-01\' AND `sale_datetime` <= \'2025-09-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-10-01' AND `sale_datetime` <= '2025-10-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-10-01\' AND `sale_datetime` <= \'2025-10-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-11-01' AND `sale_datetime` <= '2025-11-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-11-01\' AND `sale_datetime` <= \'2025-11-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-12-01' AND `sale_datetime` <= '2025-12-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-12-01\' AND `sale_datetime` <= \'2025-12-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-01-01' AND `sale_datetime` <= '2026-01-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-01-01\' AND `sale_datetime` <= \'2026-01-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-02-01' AND `sale_datetime` <= '2026-02-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-02-01\' AND `sale_datetime` <= \'2026-02-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-03-01' AND `sale_datetime` <= '2026-03-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-03-01\' AND `sale_datetime` <= \'2026-03-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-04-01' AND `sale_datetime` <= '2026-04-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-04-01\' AND `sale_datetime` <= \'2026-04-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-05-01' AND `sale_datetime` <= '2026-05-31')...' at line 1
Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-05-01\' AND `sale_datetime` <= \'2026-05-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'
in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744
Month Order
Jun '25
Jul '25
Aug '25
Sep '25
Oct '25
Nov '25
Dec '25
Jan '26
Feb '26
Mar '26
Apr '26
May '26
All prices are excluding GST
Print Report

Thank you for supporting SPQ - New Zealand's only specialist incontinence supplier