- $sql = "SELECT ".TB_PREF."sales_orders.*, ".TB_PREF."debtors_master.name, ".TB_PREF."debtors_master.curr_code, ".TB_PREF."locations.location_name,
- ".TB_PREF."debtors_master.payment_terms, ".TB_PREF."debtors_master.discount, ".TB_PREF."sales_types.sales_type, ".TB_PREF."shippers.shipper_name,
- ".TB_PREF."tax_groups.name AS tax_group_name , ".TB_PREF."tax_groups.id AS tax_group_id
- FROM ".TB_PREF."sales_orders, ".TB_PREF."debtors_master, ".TB_PREF."sales_types, ".TB_PREF."tax_groups, ".TB_PREF."cust_branch, ".TB_PREF."locations, ".TB_PREF."shippers
- WHERE ".TB_PREF."sales_orders.order_type=".TB_PREF."sales_types.id
- AND ".TB_PREF."cust_branch.branch_code = ".TB_PREF."sales_orders.branch_code
- AND ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
- AND ".TB_PREF."sales_orders.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."locations.loc_code = ".TB_PREF."sales_orders.from_stk_loc
- AND ".TB_PREF."shippers.shipper_id = ".TB_PREF."sales_orders.ship_via
- AND ".TB_PREF."sales_orders.order_no = " . $order_no;
-
+ $sql = "SELECT ".TB_PREF."sales_orders.*, "
+ .TB_PREF."debtors_master.name, "
+ .TB_PREF."debtors_master.curr_code, "
+ .TB_PREF."locations.location_name, "
+ .TB_PREF."debtors_master.payment_terms, "
+ .TB_PREF."debtors_master.discount, "
+ .TB_PREF."sales_types.sales_type, "
+ .TB_PREF."sales_types.id AS sales_type_id, "
+ .TB_PREF."sales_types.tax_included, "
+ .TB_PREF."shippers.shipper_name, "
+ .TB_PREF."tax_groups.name AS tax_group_name , "
+ .TB_PREF."tax_groups.id AS tax_group_id
+ FROM ".TB_PREF."sales_orders, "
+ .TB_PREF."debtors_master, "
+ .TB_PREF."sales_types, "
+ .TB_PREF."tax_groups, "
+ .TB_PREF."cust_branch, "
+ .TB_PREF."locations, "
+ .TB_PREF."shippers
+ WHERE ".TB_PREF."sales_orders.order_type=".TB_PREF."sales_types.id
+ AND ".TB_PREF."cust_branch.branch_code = ".TB_PREF."sales_orders.branch_code
+ AND ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
+ AND ".TB_PREF."sales_orders.debtor_no = ".TB_PREF."debtors_master.debtor_no
+ AND ".TB_PREF."locations.loc_code = ".TB_PREF."sales_orders.from_stk_loc
+ AND ".TB_PREF."shippers.shipper_id = ".TB_PREF."sales_orders.ship_via
+ AND ".TB_PREF."sales_orders.order_no = " . $order_no ;