Search options (Page 168 of 247)

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.

What platform are you using FA on - Linux or Windows?
What browser and version are your trying it out on?
MSIE versions <= 8 are not suitable for FA.

After you are done, please provide feedback as to how we can improve the information in the wiki (maybe a new page is needed) to help others in future.

The Supplier Reference is from the Supplier's actual invoice document received from them bearing their reference number for interfacing with them. In case you are sequentially providing it on their behalf to suit your internal references then it can be what you will - it hopefully allows blank as well.

The issue has been fixed in the core itself and the changes have been bundled and attached to the release announcement post. Just overwrite your FA v2.3.24 files with them.

644 is a subset of 666 - check if the ownerships changed.

@joe: should we introduce the leading "\0" stripping out in the core? Will it affect any End of Field character for VARCHARS for buffer overflow exploits?

Wow! So cheques in your country's accounting are treated as multiple time transferable negotiable instruments much like cash!

Sorry, FA does not cater to this, though you may put in whatever you want in the memo field and hope the cheques you issue of take in are their final resting place - you will not be informed by your vendors that they have passed on your cheque to their vendors.... and you in your turn will not inform your customers that their cheques have been passed on to your vendors!

Furthermore, your bank statement may not have much written in it's description field for you to reconcile multiple cheques with same value and date....

Endorsing someone's cheques to another is generally infrequent and is accomodated using Journal transfer entries but in your case it seems to be the order of the day!

Good Luck.

Post the cheque payment entries as on the date of the cheque / date of proposed submission to bank but make the entry now itself on getting the physical cheque. If any reference to the current date is needed, it may be put into the memo field for the transaction.

The actual date of encashment taken from the banker's statement can be entered into the bank reconciliation page at Banking and General Ledger => Reconcile Bank Account.

See if the new report version posted in this post suits you.

First, your theme is most welcome as there are many users for the RTL languages in FA. I have attached your screenshot here as well.

Yes, you are right about choosing 2014 as the active accounting year and entering the Journal entries as a single Journal Voucher - but in your case, you would then have to input all data from 2015-01-01 onwards and not from May 1st onwards.

Alternatively, just take a trial balance as of 2015-04-30 in your old system and keep all the account codes for them in your new CoA in FA handy (make new accounts and assign the appropriate account as a bank account) and make all entries as of 2015-04-30 in FA in the Banking and General Ledger => Journal Entry screen.

As for Bank Account, please note that a GL Account first needs to be made and then assigned as a bank account in the Banking and General Ledger => Bank Accounts screen.

To create a new GL Account, use the Banking and General Ledger => GL Accounts screen.