• Registered: 07/18/2013
  • Posts: 67

Topic: Customer Detail Listing

in report Customer Detail Listing
i need add in report customer
Credit Limit:   
Payment Terms:   

in report
how this ?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Customer Detail Listing

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.

apmuthu's Website

  • Registered: 07/18/2013
  • Posts: 67

Re: Customer Detail Listing

not view this field in report

plz attach file

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Customer Detail Listing

The fields were made available for the report. You need to write the code in the place where you want it to go.

apmuthu's Website