Re: Customer Detail Listing

null@example.com (apmuthu) — Sat, 08 Dec 2018 15:03:18 +0000

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

Re: Customer Detail Listing

null@example.com (almohasb) — Sat, 08 Dec 2018 14:47:00 +0000

not view this field in report

plz attach file

Re: Customer Detail Listing

null@example.com (apmuthu) — Fri, 07 Dec 2018 15:35:31 +0000

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.

Customer Detail Listing

null@example.com (almohasb) — Thu, 06 Dec 2018 10:32:25 +0000

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

in report
how this ?

FrontAccounting forum — Customer Detail Listing

Re: Customer Detail Listing

Re: Customer Detail Listing

Re: Customer Detail Listing

Customer Detail Listing