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

Topic: function

i need add function in print report Customer Balances

i need add combo box contain in print report branches customer to print customer by branch in report

how this

Thanks

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

Re: function

The Customer Balances Report (rep101.php) screenshot is here.

Note that the Customer Ledger Account is just one debtor_no in the debtor_master table. Only the debtor_trans table has the branch_code as well.

The $sql variable will need the trans.branch_code field in it in the function get_transactions() in the rep101.php file for your need to be addressed.

@joe: want to include the Customer Branch filter in the rep101.php?

apmuthu's Website

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: function

Yes please this is needed.

www.boxygen.pk

boxygen's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: function

No plans for including branches in the Customer Balance.

It should be an extension or maybe a company report.

Joe

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

Re: function

It might be useful to include in a landscape report in rep101.php itself. Any reason not to include it in the core? The portrait mode does not have enough space in it - maybe just a branch_code number alone may suffice in it.

apmuthu's Website

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

Re: function

how it work this report
can you please help to custom report print customer balance formatting by Branch

Thanks