From a39265e56d8242281a694fb619804c67388b13c5 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 2 Jun 2009 11:28:32 +0000 Subject: [PATCH] Don't delete templates --- admin/fiscalyears.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/fiscalyears.php b/admin/fiscalyears.php index f3968458..29d6d306 100644 --- a/admin/fiscalyears.php +++ b/admin/fiscalyears.php @@ -204,7 +204,7 @@ function delete_this_fiscalyear($selected_id) $ref = _("Open Balance"); $myrow = get_fiscalyear($selected_id); $to = $myrow['end']; - $sql = "SELECT order_no FROM ".TB_PREF."sales_orders WHERE ord_date <= '$to'"; + $sql = "SELECT order_no FROM ".TB_PREF."sales_orders WHERE ord_date <= '$to' AND type <> 1"; // don't take the templates $result = db_query($sql, "Could not retrieve sales orders"); while ($row = db_fetch($result)) { -- 2.30.2