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

Topic: Exchange Rate Buy / Sell Fields

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 ?

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Exchange Rate Buy / Sell Fields

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

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

Re: Exchange Rate Buy / Sell Fields

Thanks Janusz, wikied it.

apmuthu's Website