• From: Palestine, Gaza
  • Registered: 05/05/2014
  • Posts: 24

Topic: about currency exchange !

hi all
i need to be sure about currency exchange ?
if i set currency exchange  in as example 1/1/2015
is this will be valid for all period to next currency exchange date or should i  set currency exchange day per day

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: about currency exchange !

No, the value entered will be valid until Another date is set.

/Joe

  • From: Palestine, Gaza
  • Registered: 05/05/2014
  • Posts: 24

Re: about currency exchange !

thank you for reply

i have data for 1 year
so i should enter the value of the exch. rate a lot
i need a way more than this manual way

4 Reply by apmuthu (edited by apmuthu 02/04/2015 06:02:28 pm)

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

Re: about currency exchange !

The #_exchange_rates table uses only the rate_buy field as the exchange rate in FA v2.3. The rate_sell field is populated with the same value using line 74 in gl/includes/db/gl_db_rates.inc:

        add_exchange_rate($curr_code, $date_, $ex_rate, $ex_rate);

You might want to directly populate the said table from your records - either a CSV import or using INSERT sql statements generated in a spreadsheet.

The structure of the said table is listed here for reference:

CREATE TABLE `0_exchange_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `curr_code` char(3) NOT NULL DEFAULT '',
  `rate_buy` double NOT NULL DEFAULT '0',
  `rate_sell` double NOT NULL DEFAULT '0',
  `date_` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `curr_code` (`curr_code`,`date_`)
) ENGINE=MyISAM;

apmuthu's Website