function get_customer_details_for_report($area=0, $salesid=0)
{
    $sql = "SELECT debtor.debtor_no,
            debtor.name,
            debtor.address,
            debtor.curr_code,
            debtor.dimension_id,
            debtor.dimension2_id,
            debtor.notes,
            pricelist.sales_type,
            branch.branch_code,
            branch.br_name,
            branch.br_address,
            branch.br_post_address,
            branch.area,
            branch.salesman,
            area.description,
            salesman.salesman_name
        FROM ".TB_PREF."debtors_master debtor
        INNER JOIN ".TB_PREF."cust_branch branch ON debtor.debtor_no=branch.debtor_no
        INNER JOIN ".TB_PREF."sales_types pricelist    ON debtor.sales_type=pricelist.id
        INNER JOIN ".TB_PREF."areas area ON branch.area = area.area_code
        INNER JOIN ".TB_PREF."salesman salesman    ON branch.salesman=salesman.salesman_code
        WHERE debtor.inactive = 0";

function get_customer_details_for_report($area=0, $salesid=0)
{
    $sql = "SELECT debtor.debtor_no,
            debtor.name,
            debtor.address,
            debtor.curr_code,
            debtor.dimension_id,
            debtor.dimension2_id,
            pt.terms,
            debtor.credit_limit,
            debtor.notes,
            pricelist.sales_type,
            branch.branch_code,
            branch.br_name,
            branch.br_address,
            branch.br_post_address,
            branch.area,
            branch.salesman,
            area.description,
            salesman.salesman_name
        FROM ".TB_PREF."debtors_master debtor
        INNER JOIN ".TB_PREF."cust_branch branch ON debtor.debtor_no=branch.debtor_no
        INNER JOIN ".TB_PREF."sales_types pricelist    ON debtor.sales_type=pricelist.id
        INNER JOIN ".TB_PREF."areas area ON branch.area = area.area_code
        INNER JOIN ".TB_PREF."salesman salesman    ON branch.salesman=salesman.salesman_code
        INNER JOIN ".TB_PREF."payment_terms pt ON debtor.payment_terms=pt.terms_indicator
        WHERE debtor.inactive = 0";