Monthly Summary Report

Facility:

Month Order
Mar '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-03-01' AND sale_datetime <= '2025-03-31') ORD...' 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-03-01\' AND sale_datetime <= \'2025-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
Apr '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-04-01' AND sale_datetime <= '2025-04-31') ORD...' 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-04-01\' AND sale_datetime <= \'2025-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
May '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-05-01' AND sale_datetime <= '2025-05-31') ORD...' 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-05-01\' AND sale_datetime <= \'2025-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
Jun '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-06-01' AND sale_datetime <= '2025-06-31') ORD...' 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
Jul '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-07-01' AND sale_datetime <= '2025-07-31') ORD...' 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
Aug '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-08-01' AND sale_datetime <= '2025-08-31') ORD...' 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
Sep '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-09-01' AND sale_datetime <= '2025-09-31') ORD...' 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
Oct '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-10-01' AND sale_datetime <= '2025-10-31') ORD...' 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
Nov '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-11-01' AND sale_datetime <= '2025-11-31') ORD...' 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
Dec '25
Exception: Syntax error near: 'NULL AND sale_datetime >= '2025-12-01' AND sale_datetime <= '2025-12-31') ORD...' 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
Jan '26
Exception: Syntax error near: 'NULL AND sale_datetime >= '2026-01-01' AND sale_datetime <= '2026-01-31') ORD...' 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
Feb '26
Exception: Syntax error near: 'NULL AND sale_datetime >= '2026-02-01' AND sale_datetime <= '2026-02-31') ORD...' 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
All prices are excluding GST