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