Search options (Page 167 of 247)

Which versions of FA and extension are you using?
Use FireFox Browser and not MSIE.
Check the error.log  to locate the line number that causes the fault.

You need to install the module from within the default company and then activate it for the target company and possibly enable permissions for the user to access it's functionality before you can start using it. Search the forums and read the wiki for more info.

Copy the rep304.php into company/#/reporting/rep304 and edit it there - # is your company number. It will override the original report file of the same name.

The selections in one screen are the ones which get processed. Selections in the second screen must be done separately. You can try to increase the number of entries on each screen as stated in this thread, if you want all in one go.

This is so that you have all links available after the transaction and you can choose what you want.

The php closing tag issue generally comes up on PHP 5.4 onwards.
The include_once should have no effect and is needed to enforce authority to download only if logged in.
If the generated file is good, then the browser transfer may be the issue. Check the apache error logs for any clues.

If the autoupdate is enabled, then what you state is acceptable as a current exchange rate would have been acquired. If not, only an older exchange rate would be available and may be used for the current transaction as would obtain if it is withing a few days of no significant change.

If the date_ >= $date is used, then the Order by Desc should be Order by Asc. Should there be a dictate to use the old exchange rate if autoupdate is disabled with an option to update for that specific time alone as well otherwise?

Thanks for the policy decision - any rationale?

The function get_exchange_rate_from_to() calls the following functions in the same file includes/banking.inc:
1. get_exchange_rate_to_home_currency($from_curr_code, $date_)
2. get_exchange_rate_from_home_currency($currency_code, $date_)
The first one is the arithmetic inverse of the second one.

All currency exchange rates in FA are relative to the home currency.

The sql used in the second function (lines 91, 92)  is:

SELECT rate_buy, max(date_) as date_ FROM ".TB_PREF."exchange_rates WHERE curr_code = ".db_escape($currency_code)."
                AND date_ <= '$date' GROUP BY rate_buy ORDER BY date_ Desc LIMIT 1

The date_ <= $date is key to the record being pulled out.
Should it not be for all future transactions by making it date_ >= $date ?

After all, when we get an exchange rate from a provider (YAHOO, ECB, BLOOMBERG, GOOGLE, etc) it should be for all future transactions till the next one is obtained and not for all past transactions.

@joe: your take?

The recommended FA server versions for FA v2.3 are PHP 5.3+, MySQL 5 to 5.1 and Apache 2.2.x
The latest version of FA is v2.3.24 with many bugs squashed since your version which was released on 2013-.02-14. The date shown in your install is based on the file creation date of the CHANGELOG.php file.

MS Internet Explorer <= v8.0 is now not supported by FA. Use some of the later versions of FireFox. Chrome has it's quirks and politico-commercial slants.

Does your install have much data?
What CoA (chart) are you using?
Which extensions are you using?
Any customisations?

Actually, the Zoho looks simple enough but what happens to the figures if they are not balanced? Multiple submissions and JS error popups I guess.

The Journal Voucher mode makes sure the credits and debits are balanced and also allows you to have more than one opening balance for one account which is useful if you want to reconcile entries of the previous period.

If the trial balance is really big, it can span multiple Journal Vouchers by consolidating unallocated balances to a temporary Suspense Account from which the contras are made in subsequent JVs.

After all FA is designed and used primarily by Accountants (CPAs) and professional bookkeepers and not for simple income and expense tallying.

The Zoho screenshot is attached for reference towards any UI tweaking. Thanks for your valuable input.