I am newbie in frontaccounting. I am using frontaccounting Version 2.4.8. I have few salesman. Different salesman have different customer. I need salesman wise (filter as salesman) Customer Balances, Aged Customer Analysis, Customer Detail Listing, Sales Summary Report, Order Status Listing separately.

It shall be GROUP BY ".TB_PREF."debtors_master.debtor_no

    $sql .= " ORDER BY name";

with

    $sql .= " GROUP BY debtors_master.debtor_no ORDER BY name";

http://prntscr.com/dyra0n

You can check the screen shot

DATABASE ERROR : The customers could not be retrieved
error code : 1054
error message : Unknown column 'debtors_master.debtor_no' in 'field list'
sql that failed was : SELECT debtors_master.debtor_no, debtors_master.name, debtors_master.curr_code FROM 1_debtors_master INNER JOIN 1_cust_branch ON debtors_master.debtor_no=cust_branch.debtor_no INNER JOIN 1_areas ON cust_branch.area = areas.area_code INNER JOIN 1_salesman ON cust_branch.salesman=salesman.salesman_code WHERE salesman.salesman_code='1' ORDER BY name

function sales_areas_list($name, $selected_id=null)
{
    $sql = "SELECT area_code, description, inactive FROM ".TB_PREF."areas";
    return combo_input($name, $selected_id, $sql, 'area_code', 'description', array());
}

should be made to match it's peers (function sales_persons_list) as:

function sales_areas_list($name, $selected_id=null, $spec_opt=false)
{
    $opt = array();
    if ($spec_opt !== false)
        $opt = array('order'=>array('description'), 'spec_option' => $spec_opt, 'spec_id' => ALL_NUMERIC);
    $sql = "SELECT area_code, description, inactive FROM ".TB_PREF."areas";
    return combo_input($name, $selected_id, $sql, 'area_code', 'description', $opt);
}

and the lines in reporting/includes/reports_classes.inc:

                case 'AREAS':
                    return sales_areas_list($name);

should be changed to:

                case 'AREAS':
                    return sales_areas_list($name, null, _("No Sales Area Filter"));

and the string added to the empty.po for translations.

The "AREAS" is used only in the rep103.php as of now.
The "SALESTYPES" is used only in rep104.php and will need similar changes.

In @dz's post no. 6 in this thread, please correct the function invocation "zone_cells" to be "zone_list_cells" to match the "function zone_row" definition above it.

You are right however for this report only zone_list function is used.

Is there any log where I can keep checking for any modifications in Master Files or I can Subscribe to changes notifications?