+ $sql1 .= " WHERE `$st[1]`=".db_escape($trans_type);
+
+ // check also in voided transactions (some transactions like location transfer are removed completely)
+ $sql2 = "SELECT MAX(`id`) as last_no FROM ".TB_PREF."voided WHERE `type`=".db_escape($trans_type);