- // we need a distinct here so that it only returns 1 line - becuase there can be mutliple 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)
- {
-
- $myrow = db_fetch($result);
-
- $_SESSION['Items']->customer_id = $myrow["debtor_no"];
- $_SESSION['Items']->customer_name = $myrow["name"];
- $_SESSION['Items']->cust_ref = $myrow["reference"];
- $_SESSION['Items']->Branch = $myrow["branch_code"];
- $_SESSION['Items']->customer_currency = $myrow["curr_code"];
-
- $_SESSION['Items']->Comments = "";
- $_SESSION['Items']->default_sales_type =$myrow["tpe"];
- $_SESSION['Items']->Location = $myrow["from_stk_loc"];
-
- $_SESSION['Items']->tax_group_name = $myrow["tax_group_name"];
- $_SESSION['Items']->tax_group_id = $myrow["tax_group_id"];
-
- $_SESSION['Items']->delivery_date = sql2date($myrow["tran_date"]);
- $_SESSION['Items']->freight_cost = $myrow["ov_freight"];