[GNC] Account Hirarchy with different currencies cause online quotes to fail in some cases

John Ralls jralls at ceridwen.us
Fri Aug 9 16:45:07 EDT 2019


Ove,

Your book currency is the currency set on the invisible Root account, set in the New Account Hierarchy Assistant (or not if you didn't use that assistant to set up your book). The only way to see it once you've finished the assistant is to look in the file. The Default Currency preference is used mostly for creating new accounts.

Regards,
John Ralls

> On Aug 9, 2019, at 10:49 AM, Ove Grunnér <write2ove at gmail.com> wrote:
> 
> Hi Frank, Thanks for looking at this.
> 
> The book currency in my GnuCash setup is Euro. (I referred to it as Base Currency earlier on), That is configured under Edit/Preferences/Account/Default Currency
> it is set to: Locale EUR (Euro)
> my Report Currency specified under Edit/Preferences/Reports/Default Report Currency is set to: Chose Swedish Krona (SEK)
> 
> When I look at my Swedish investments (that includes American Shares) I want to see them summed up in SEK
> When I look at all my investments I want to see them summed up in Euro.
> 
> If I look under accounts, I can see the totals of each sub Account in the currency I have set for that individual account, but the Swedish umbrella accounts do not include the USD sub account totals
> The same is true for a report, I can see the currency for each account, and an additional column with my Report Currency specified.
> The report works fine when looking at it using Euro as reporting currency, but not in SEK.
> 
> My problem seem to be that I am not able to automatically fetch all 3 exchange rates (EUR/USD, EUR/SEK, SEK/USD)
> I only get (EUR/USD, EUR/SEK)
> As such the SEK account does not add up the USD amounts from the USD sub account.
> If I manually add the SEK/USD exchange rate it all works.
> 
> I have tried selecting EUR, SEK & USD in the Security Editor, and also just SEK & USD.
> but in both cases I only get the two exchange rates and GnuCash does not seem to calculate the third based on the two it has.
> 
> Am I missing something?
> 
> Thanks Ove.
> 
> 
> 
> On Wed, 7 Aug 2019 at 19:39, Frank H. Ellenberger <frank.h.ellenberger at gmail.com> wrote:
> Am Mi., 7. Aug. 2019 um 19:34 Uhr schrieb Ove Grunnér <write2ove at gmail.com>:
> >
> > No Problem, John, thanks for helping,
> >
> > Anyone else got this working somehow?
> >
> > br Ove.
> 
> The answer would depend on your book cuurrency, which I could not find
> in your description. Then I would assume, the report currency and what
> you want to see are the same?
> 
> Then it is obvisious, you should fetch the rates between your book
> currency and the foreign currencies...
> 
> Regards
> Frank



More information about the gnucash-user mailing list