-//---------------------------------------------------------------------------------------------
-$sql = "SELECT ".TB_PREF."debtor_trans.trans_no, "
- .TB_PREF."debtors_master.curr_code, "
- .TB_PREF."debtors_master.name, "
- .TB_PREF."cust_branch.br_name, "
- .TB_PREF."debtor_trans.reference, "
- .TB_PREF."debtor_trans.tran_date, "
- .TB_PREF."debtor_trans.due_date, "
- .TB_PREF."sales_orders.customer_ref, "
- .TB_PREF."sales_orders.deliver_to, ";
-
-$sql .= " Sum(".TB_PREF."debtor_trans_details.quantity-"
- .TB_PREF."debtor_trans_details.qty_done) AS Outstanding, ";
-
-$sql .= " Sum(".TB_PREF."debtor_trans_details.qty_done) AS Done, ";
-
-$sql .= "(ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue";
-$sql .=" FROM "
- .TB_PREF."sales_orders, "
- .TB_PREF."debtor_trans, "
- .TB_PREF."debtor_trans_details, "
- .TB_PREF."debtors_master, "
- .TB_PREF."cust_branch
- WHERE "
- .TB_PREF."sales_orders.order_no = ".TB_PREF."debtor_trans.order_ AND "
- .TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."debtor_trans.type = 13
- AND ".TB_PREF."debtor_trans_details.debtor_trans_no = ".TB_PREF."debtor_trans.trans_no
- AND ".TB_PREF."debtor_trans_details.debtor_trans_type = ".TB_PREF."debtor_trans.type
- 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 ";
-
- if ($_POST['OutstandingOnly'] == true) {
- $sql .= " AND ".TB_PREF."debtor_trans_details.qty_done < ".TB_PREF."debtor_trans_details.quantity ";
- }
-
-//figure out the sql required from the inputs available
-if (isset($_POST['DeliveryNumber']) && $_POST['DeliveryNumber'] != "")