Search options (Page 27 of 46)

@anoopmb - I have tested your auto complete.  Its working well. You have done a  great job. There is one suggestion from my side.
When It comes with large list of options in select. Like more than 1000 items in the list. It will freeze the system for a while and will go on.

So if possible rewrite it to perform Ajax call and get results from server. By default you can show 20, items in the list. Rest should not be added to the list. When user start typing the related items should show here.

When you see an error . Copy the error to here. We will assist you further . If possible enable Debugging mode and get us the proper error msg from our system

Exchange-rates.org is absolutely fine one.  It supports major 30 currencies in the world. But we have FA users from many small countries. We need to look up them as well.

So what I am suggesting is to adapt one more exchange rate provider. https://currencylayer.com or fixer.io to work on 168 currencies. They allow 1000 request per month for free of cost .  I hope that's more than enough for them. Because we keep existing exchange rates for next requests. So let's provide them one more as well. Also we can provide them functionality to go premium to get extra. But that's their choice. Hope Joe and janusz will think of it..

You might require a server with 8gm ram, and 512gb SSD and Intel Xeon E3 Processor or more than that.

Basically you need server  like Dell flagship or ibm series  to handle 100  concurrent users

If you have cpanel. Take backup from cpanel->backups.

If it's direct and Raw server. You can use MySQL dump for this

@apmuthu, its a mandatory parameter to get_balance function.  so he has to add it without checking whether the account code null or not.

@poncho - I clarified his doubts. Actually, he missed to configure the Sales Types either included or not for the tax .

And other facts,that he set as per my article. FrontAccounting Working with Taxes

 SELECT SUM(amount), account_name FROM 0_gl_trans, 0_chart_master WHERE 0_gl_trans.account=0_chart_master.account_code GROUP BY account 

hope this query satisfy your needs.

@emiangel839 - Regarding your comment on my site. here I answered you with the query. 

 $today = Today();
    $begin = begin_fiscalyear();
    $begin1 = date2sql($begin);
    $today1 = date2sql($today);
    $sql = "SELECT SUM(amount) AS total, c.class_name, c.ctype FROM
        ".TB_PREF."gl_trans,".TB_PREF."chart_master AS a, ".TB_PREF."chart_types AS t, 
        ".TB_PREF."chart_class AS c WHERE
        account = a.account_code AND a.account_type = t.id AND t.class_id = c.cid AND c.cid=1 
        AND IF(c.ctype > 3, tran_date >= '$begin1', tran_date >= '0000-00-00') 
        AND tran_date <= '$today1'  ORDER BY c.cid"; 
    $result = db_query($sql, "Transactions could not be calculated");

hope it helps you

@poncho -  If you are really interested to bring the custom fields. We have to make changes in the core to allow it to add additional fields.  Instead of making it as extension.  Try to make it within core. and get the difference of file with help of git difference. So it would be added to the core in next release of FA2.5.

Hope it sounds good. Also @joe waiting to hear your thoughts before he start working inside core.

we are ready to make this one.