From 8333e3e6b2b09fb6d72d3605275a8212bd71de84 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 13 Jan 2018 14:14:24 +0100 Subject: [PATCH 1/1] Fixed printing sequences of Sales Invoices. --- reporting/rep107.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/reporting/rep107.php b/reporting/rep107.php index 7982f8a1..580e3abe 100644 --- a/reporting/rep107.php +++ b/reporting/rep107.php @@ -36,8 +36,7 @@ function get_invoice_range($from, $to) LEFT JOIN ".TB_PREF."voided voided ON trans.type=voided.type AND trans.trans_no=voided.id WHERE trans.type=".ST_SALESINVOICE ." AND ISNULL(voided.id)" - ." AND trans.reference>=".db_escape(get_reference(ST_SALESINVOICE, $from)) - ." AND trans.reference<=".db_escape(get_reference(ST_SALESINVOICE, $to)) + ." AND trans.trans_no BETWEEN ".db_escape($from)." AND ".db_escape($to) ." ORDER BY trans.tran_date, trans.$ref"; return db_query($sql, "Cant retrieve invoice range"); -- 2.30.2