FrontAccounting forum — Exchange Rate Buy / Sell Fields

Re: Exchange Rate Buy / Sell Fields

null@example.com (apmuthu) — Thu, 18 Oct 2012 11:50:05 +0000

Thanks Janusz, wikied it.

Re: Exchange Rate Buy / Sell Fields

null@example.com (itronics) — Wed, 17 Oct 2012 17:13:03 +0000

When auto_update field is set for currency, exchange rate is retrieved automatically from remote service and stored in exchange_rates table. Otherwise user have to set the rate manualy before first transaction using the currency on date.
Currently only rate_buy is used in FA, rate_sell is obsolete (may be used in future).

I'm not sure why some fields are named 'date_' instead of simply 'date'. Looks weird, but do not hurt.
There is no documentation to sys_prefs, but of them are set in admin/gl_setup.php and admin/company_preferences.php, so you can guess their usage looking into legends on Company Setup and System and GL Setup pages.
Janusz

Exchange Rate Buy / Sell Fields

null@example.com (apmuthu) — Wed, 17 Oct 2012 14:38:34 +0000

Clarifications on currency fields:

currencies.auto_update -> what is it's purpose?

exchange_rates.rate_buy
exchange_rates.rate_sell
Both the above fields are populated with the same value obtained from the web rate service provider into a common form field. Which is the actual field used in FA for computation? What happens if the rates are different or need to be set different - any form is available in FA for it?

There are many fields named `date_` -> expect it is by design.

Any exhaustive set of sys_prefs ?