- // we need a distinct here so that it only returns 1 line - because there can be multiple moves
- // per item (for assemblies, etc)
- $sql = "SELECT DISTINCT ".TB_PREF."debtor_trans.*,
- ".TB_PREF."cust_branch.default_location, ".TB_PREF."cust_branch.default_ship_via,
- ".TB_PREF."debtors_master.name, ".TB_PREF."debtors_master.curr_code,
- ".TB_PREF."tax_groups.name AS tax_group_name, ".TB_PREF."tax_groups.id AS tax_group_id,
- ".TB_PREF."sales_orders.from_stk_loc
- FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master, ".TB_PREF."cust_branch, ".TB_PREF."tax_groups, ".TB_PREF."sales_orders
- WHERE ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."debtor_trans.branch_code = ".TB_PREF."cust_branch.branch_code
- AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."cust_branch.debtor_no
- AND ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
- AND ".TB_PREF."debtor_trans.trans_no = " . $_GET['InvoiceNumber'] . "
- AND ".TB_PREF."debtor_trans.type=10
- AND ".TB_PREF."sales_orders.order_no=".TB_PREF."debtor_trans.order_";
-
- $result = db_query($sql,"The invoice details cannot be retrieved");
-
- if (db_num_rows($result) == 1)
- {