From 15c3a6a29a0860038ac972d3f6dd40c49f994e3f Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 10 Nov 2008 13:34:37 +0000 Subject: [PATCH] Added check for POS relations before account removal. --- gl/manage/bank_accounts.php | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/gl/manage/bank_accounts.php b/gl/manage/bank_accounts.php index 9cb56180..64cff25f 100644 --- a/gl/manage/bank_accounts.php +++ b/gl/manage/bank_accounts.php @@ -64,6 +64,14 @@ elseif( $Mode == 'Delete') $cancel_delete = 1; display_error(_("Cannot delete this bank account because transactions have been created using this account.")); } + $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_pos WHERE pos_account='$selected_id'"; + $result = db_query($sql,"check failed"); + $myrow = db_fetch_row($result); + if ($myrow[0] > 0) + { + $cancel_delete = 1; + display_error(_("Cannot delete this bank account because POS definitions have been created using this account.")); + } if (!$cancel_delete) { delete_bank_account($selected_id); -- 2.30.2