FrontAccounting forum — about currency exchange !

Re: about currency exchange !

null@example.com (apmuthu) — Wed, 04 Feb 2015 18:00:35 +0000

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;

Re: about currency exchange !

null@example.com (waleedaz) — Wed, 04 Feb 2015 12:26:24 +0000

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

Re: about currency exchange !

null@example.com (joe) — Wed, 04 Feb 2015 09:13:12 +0000

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

/Joe

about currency exchange !

null@example.com (waleedaz) — Wed, 04 Feb 2015 08:30:49 +0000

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