X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=53f3facfbc9ba0c168ce77e455b75a772e94e096;hb=80dd97a37f674cc3691fa04af4c29607067566b2;hp=595639aeb1fa2627474c79feee15bf86f07418e7;hpb=43ddf1a424217b1620ac93b02b7e33a48d95140e;p=fa-stable.git diff --git a/gl/includes/db/gl_db_bank_accounts.inc b/gl/includes/db/gl_db_bank_accounts.inc index 595639ae..53f3facf 100644 --- a/gl/includes/db/gl_db_bank_accounts.inc +++ b/gl/includes/db/gl_db_bank_accounts.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ //--------------------------------------------------------------------------------------------- function add_bank_account($account_code, $account_type, $bank_account_name, $bank_name, $bank_account_number, @@ -157,12 +166,12 @@ function get_quick_entry($selected_id) function get_quick_entry_lines($qid) { $sql = "SELECT ".TB_PREF."quick_entry_lines.*, ".TB_PREF."chart_master.account_name, - ".TB_PREF."item_tax_types.name as tax_name + ".TB_PREF."tax_types.name as tax_name FROM ".TB_PREF."quick_entry_lines LEFT JOIN ".TB_PREF."chart_master ON ".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."chart_master.account_code - LEFT JOIN ".TB_PREF."item_tax_types ON - ".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."item_tax_types.id + LEFT JOIN ".TB_PREF."tax_types ON + ".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."tax_types.id WHERE qid=$qid ORDER by id";