[GNC] Import transactions with expenses in a different currency

[andrepd]

In the latest version of gnucash (4.1) I noticed that, when importing
transactions in .ofx/.csv to a GBP bank account, and matching transactions
to expense accounts in EUR, I get the following error message:

> The account 'Electronics' has a different commodity from the one required,
> Pound Sterling. Please choose a different account.

Now, I haven't seen that error message before, when importing my
transactions, so I'm assuming this behaviour changed recently. However, I
also realised that when I was importing transactions like this in the past
(when that message didn't appear), that the exchange rate used was always
1GBP -> 1EUR! This is also not good for me. 

So I have two questions:

* How do I import transactions where the debits and credits are in different
currencies (in this example, I have a debit from a GBP bank account and a
credit to an EUR expense account)? This should ideally use the correct
exchange rate from the price database. 

* How do I fix the exchange rates for the previous transactions, without
going manually through *thousands* of transactions and going `right click >
edit exchange rate > paste > OK`? I have the correct exchange rates, for the
period where the transactions took place, entered in the price database, so
I'd like to use the "most-recent-at-transaction-date" exchange rate. I don't
see how I can do this for all transactions, and doing so manually would take
upwards of 8 or 9 hours I reckon. Perhaps I could use a python script to do
it (or even edit the database manually, I don't know)?

Thanks for the help. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html