1 Reply by yudhiapr

(6 replies, posted in Reporting)

thank you for your great application and your quick response joe and the others FA guru's ... wink

Go to forum: Reporting

2 Reply by yudhiapr

(6 replies, posted in Reporting)

dear FA guru ..

i've adding function get_branch_contact() by myself on top of rep103.php bellow

function get_branch_contacts($branch_code = 0) {
    $sql = "SELECT ".TB_PREF."cust_branch.*
    FROM ".TB_PREF."cust_branch
    WHERE ".TB_PREF."cust_branch.branch_code = ".$branch_code;
   
    return db_query($sql,"No transactions were returned");
   
}

please correct me if i'm wrong, it's running well on my machine .. wink

thanks aniway for your re-code on rep103.php wink

Go to forum: Reporting

3 Reply by yudhiapr

(6 replies, posted in Reporting)

thank you joe for your response ...
but maybe you forgotted to include function get_branch_contact() instead ya ? wink

i'm looking for that function bro ..

thanks aniway. wink

Go to forum: Reporting

4 Topic by yudhiapr

(6 replies, posted in Reporting)

Dear FA guru ...

i have problem when reporting to excel format, especially when reporting to Sales -> Customer -> Customer Detail Listing (rep103.php)

it produce report correctly when format is exported to PDF, but it generate error when produce XLS format. there are error window dialog said 'File error: data may have  been lost'. with OK button in bottom.

if i click OK button, then report sometime appear, and sometime not appear in some computer.
when report appear, it just 'show' first row every record. it contain 'customer name', 'price list type', 'customer branch name', and 'customer address'

it does not 'show' second row above, for example 'phone number', 'fax number'.

could you help me please.

i use front accounting 2.2.11 on windows (XAMPP) environtment.

Go to forum: Reporting