Three currency transaction?

Stephen J. Gowdy gowdy at slac.stanford.edu
Fri Nov 18 11:16:23 EST 2005


Hi Derek,
	I used the UK Credit card in GBP to enter it. Here is the xml for
it if that helps any;

<gnc:transaction version="2.0.0">
  <trn:id type="guid">ff41cc22df30a4e3534b29109b34f7a5</trn:id>
  <trn:currency>
    <cmdty:space>ISO4217</cmdty:space>
    <cmdty:id>GBP</cmdty:id>
  </trn:currency>
  <trn:date-posted>
    <ts:date>2005-07-10 00:00:00 -0700</ts:date>
  </trn:date-posted>
  <trn:date-entered>
    <ts:date>2005-11-13 20:36:46 -0800</ts:date>
  </trn:date-entered>
  <trn:description>Rotonda</trn:description>
  <trn:splits>
    <trn:split>
      <split:id type="guid">c6c7f2fbd9974b8e16ce873335b1fbd4</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>991/100</split:value>
      <split:quantity>1400/100</split:quantity>
      <split:account
type="guid">35f26b37201b8b0c19eb154136cac189</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">ba031c691bc2d757e5de77a719f6a488</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>-991/100</split:value>
      <split:quantity>-991/100</split:quantity>
      <split:account
type="guid">b60a55e7293de9c707a65c7a08619372</split:account>
    </trn:split>
  </trn:splits>
</gnc:transaction>

	I was about to enter a new transaction in the Currency:Euros
account to transfer the value to an Expense account and I noticed the
amount listed there was a GBP number and not as I expected a USD amount
(and that was also why exchange rate was the GBP->EUR instead of the
USD->EUR one). I thought perhaps I should create a Currency:Eur-GBP
account which was "trading" Euros but with a base currency of GBP but I
don't see a way to do that.
	To be clear, I'm talking about two different transactions with two
currencies involved in each one. One is EUR<->GBP and the other EUR<->USD.

						regards,

						Stephen.

On Thu, 17 Nov 2005, Derek Atkins wrote:

> There are some "known bugs" in tri-currency transactions..  Getting
> all the corner cases right is... challenging.  So, unfortunately,
> there isn't a good answer for you right now.
>
> What I /can/ say is that whenever you are looking at an account,
> the values are ALL in the CURRENT currency, not the currency of
> the split.  So if you open up the GBP account, all values will
> be shown in GBP.
>
> I'll also note that Currency Accounts are... deprecated.
> At the same time, there's a major question about how you entered
> the transaction.  Which account did you use to enter it?  And
> what is your current locale (LANG)?
>
> -derek
>
> "Stephen J. Gowdy" <gowdy at slac.stanford.edu> writes:
>
> > Hi All,
> > 	I'm guessing this is unusual and that is why it doesn't seem to
> > work. I have a UK credit card (GBP) that I used in Italy (EUR) and my
> > expense accounts (and my default currency) are in USD. I have a Currency
> > account in EUR which is how I usually deal with foreign transactions with
> > my US cards (so I can express the EUR value somewhere).
> > 	So I posted a transaction for 14 EURs to my UK credit card. THe
> > card was debited GBP 9.91. The line in the Credit Card Account is;
> >
> > 10/7/2005 Rotunda	Currency:Euros 		9.91 <balance>
> >
> > then in the Currency:Euros account;
> >
> > 10/7/2005 Rotunda	Li..:Credit..  14.00 .707   9.91 <balance>
> >
> > So it is assuming that the 9.91 was in Dollars, even though the
> > Li..:Credit..:MBNA has a GBP currency.
> > 	Is there some way this is suppose to work?
> >
> > 						regards,
> >
> > 						Stephen.
>
>

--
 /------------------------------------+-------------------------\
|Stephen J. Gowdy                     | SLAC, MailStop 34,       |
|http://www.slac.stanford.edu/~gowdy/ | 2575 Sand Hill Road,     |
|http://calendar.yahoo.com/gowdy      | Menlo Park CA 94025, USA |
|EMail: gowdy at slac.stanford.edu       | Tel: +1 650 926 3144     |
 \------------------------------------+-------------------------/


More information about the gnucash-user mailing list