".TB_PREF."debtors_master.curr_code,
".TB_PREF."debtors_master.dimension_id,
".TB_PREF."debtors_master.dimension2_id,
".TB_PREF."debtors_master.curr_code,
".TB_PREF."debtors_master.dimension_id,
".TB_PREF."debtors_master.dimension2_id,
".TB_PREF."sales_types.sales_type,
".TB_PREF."cust_branch.branch_code,
".TB_PREF."cust_branch.br_name,
".TB_PREF."cust_branch.br_address,
".TB_PREF."cust_branch.br_post_address,
".TB_PREF."sales_types.sales_type,
".TB_PREF."cust_branch.branch_code,
".TB_PREF."cust_branch.br_name,
".TB_PREF."cust_branch.br_address,
".TB_PREF."cust_branch.br_post_address,
".TB_PREF."cust_branch.area,
".TB_PREF."cust_branch.salesman,
".TB_PREF."areas.description,
".TB_PREF."cust_branch.area,
".TB_PREF."cust_branch.salesman,
".TB_PREF."areas.description,
INNER JOIN ".TB_PREF."areas
ON ".TB_PREF."cust_branch.area = ".TB_PREF."areas.area_code
INNER JOIN ".TB_PREF."salesman
INNER JOIN ".TB_PREF."areas
ON ".TB_PREF."cust_branch.area = ".TB_PREF."areas.area_code
INNER JOIN ".TB_PREF."salesman
$sql .= " ORDER BY description,
".TB_PREF."salesman.salesman_name,
".TB_PREF."debtors_master.debtor_no,
$sql .= " ORDER BY description,
".TB_PREF."salesman.salesman_name,
".TB_PREF."debtors_master.debtor_no,
$dim = get_dimension($myrow['dimension2_id']);
$rep->TextCol(1, 2, _('Dimension') . " 2: " . $dim['name']);
}
$dim = get_dimension($myrow['dimension2_id']);
$rep->TextCol(1, 2, _('Dimension') . " 2: " . $dim['name']);
}