You need to alter the reporting/rep103.php file.
Lines 30 to 53 in it:
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";
may be replaced with:
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";
The necessary fields will now be available for placement as needed in the report.