what exchange rate gnucash uses for reports - it's not what I entered manually

321654 krok.geena at gmail.com
Mon Feb 11 12:53:29 EST 2013


> ;;    The multicurrency support has NOT been tested and IS ALPHA.  I
OK, thank you. I guess no gnucash for me.
Can someone please put this warning to gnucash homapge: gnucash can
not support multicurrency accounting.
(or something like that)

Now, how can one get of this list :)



On 2 February 2013 23:01, David T. <sunfish62 at yahoo.com> wrote:
> Replying to my own message, I see that the scm source includes a note from
> the original writer (in 2004) that:
>
> ;;    The multicurrency support has NOT been tested and IS ALPHA.  I
> ;;    really don't if I used the correct exchange functions.  Search
> ;;    code for regexp "*exchange-fn".
>
> I have no idea whether this note is still accurate.
>
> ________________________________
> From: David T. <sunfish62 at yahoo.com>
> To: 321654 <krok.geena at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Sent: Saturday, February 2, 2013 12:40 PM
> Subject: Re: what exchange rate gnucash uses for reports - it's not what I
> entered manually
>
> I will start by saying that I am not a programmer.
>
> That said, I see that you are referring to a static variable
> gnc_euro_rate_struct that appears to be the final exchange rate of
> currencies into the Euro when the Euro was installed back in 2002. See
> http://en.wikipedia.org/wiki/History_of_the_euro#Change_of_currency, where
> you will see a table that includes the Finnish Mark with the rate you
> include here.
>
> The code you are citing is C source, and so I (the non-programmer) doubt it
> is invoked in the reports, which are written separately in Scheme. I don't
> know whether this variable is available to the Scheme report writer.
>
> More likely is that because the FIM is discontinued, the final exchange rate
> of record is the last one being used. Not being at a GnuCash machine right
> now, I can't say whether it is possible to create a new price for the FIM
> using the price db. I certainly don't know how the report implements the
> price db for currencies.
>
> I would have assumed that a report that depends on fluctuating valuations of
> currencies would follow the example set by reports that track the
> fluctuating value of commodities (that is, to use entries in the price db),
> but it could be that currency rates are handled differently because of their
> ISO-ness. It wouldn't be the first time that a report writer built a report
> that omitted a particular use case.
>
> As for the adding of currencies to the definitions, for reasons that the
> developers have noted in the past, the currencies list used by GnuCash is
> based on the ISO currencies list. It is my understanding that if users
> create the additional functionality needed to accommodate other currencies,
> those changes might be integrated into GnuCash. So far, no one has submitted
> these alterations, however.
>
>
> David
>
>
>
> ________________________________
> From: 321654 <krok.geena at gmail.com>
> To: David T. <sunfish62 at yahoo.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Sent: Saturday, February 2, 2013 5:51 AM
> Subject: Re: what exchange rate gnucash uses for reports - it's not what I
> entered manually
>
> "nearest in time" setting did not help me. :(
>
> I can see the FIM exchange rate is the source code
> (src/app-utils/gnc-euro.c)
> Line 56
> { "FIM",  5.94573 },  /* finnmark */)
>
> I guess this is used but why are my manually entered rates ignored, is
> still a mystery.
>
> BTW, this all started because gnucash is now allowing users to add
> additional currencies.
> I had to use something, that is not used any more, like FIM.
>
>
>
> On 30 January 2013 01:18, David T. <sunfish62 at yahoo.com> wrote:
>> Actually, the thread you cite is an email message to the list, not a bug.
>> The official repository for GnuCash's reported bugs is Bugzilla
>> (https://bugzilla.gnome.org/browse.cgi?product=GnuCash). In the thread you
>> cite, an answer was provided by one of the developers at the time. Since
>> there was no further response from that user, it must be assumed that the
>> advice fixed his problem. I'll note that the advice given there was to
>> check
>> that the report options for prices was set to "nearest in time", which is
>> the advice provided earlier in this thread; did you try that, and did it
>> fix
>> anything?
>>
>> A search of Bugzilla for the word "exchange" turned up a number of bugs,
>> but
>> none of them appeared to address any problems with reports.
>>
>> I have seen circumstances in my own data where exchange rates have not
>> been
>> entered into the price database, thus throwing off account values
>> substantially, but I am not certain whether these omissions are due to a
>> bug
>> in GnuCash, or whether it is an artifact of importing these transactions
>> in
>> from an earlier financial package. I would have to do some testing to see
>> whether this is an issue.
>>
>> Good luck,
>> David
>>
>> ________________________________
>> From: 321654 <krok.geena at gmail.com>
>> To: gnucash-user at gnucash.org
>> Sent: Tuesday, January 29, 2013 11:38 AM
>> Subject: Re: what exchange rate gnucash uses for reports - it's not what I
>> entered manually
>>
>> Looks like this is a really old bug (Nov 29, 2005) in gnucash :(
>>
>> http://gnucash.1415818.n4.nabble.com/exchange-rate-value-for-reports-td1417095.html
>>
>> If you have any idea how to fix this, please let me know.
>>
>>
>> On 28 January 2013 22:02, wrote:
>>> On Mon, Jan 28, 2013 at 9:51 PM, Derek Atkins <derek at ihtfp.com> wrote:
>>>> Hi,
>>>>
>>>> On Mon, January 28, 2013 2:46 pm, Krokodill Geena wrote:
>>>>> I have searched here and there but I still can not figure out, where
>>>>> gnucash gets the exchange rate for the reports.
>>>>> It is obviously not the exchange rate I have entered with Tools>Price
>>>>> Editor > sect the currency, enter correct exchange rate, save (date is
>>>>> today)
>>>>> Guess what, report still show about 10 years old exchange rate. :)
>>>>> Yes, I have disabled the automatic update and this did not help me at
>>>>> all.
>>>>>
>>>>> Because there is now way to add a new currency, I had to use good old
>>>>> and so dead FIM as a "place holder" to save me from manual conversions
>>>>> (there is no FIM any more because it was wiped out by EU euphoria back
>>>>> in 2002)
>>>>>
>>>>> Yes, I have disabled the automatic update and this did not help me at
>>>>> all.
>>>>> I even attempted to use Tools > Price Editor > Remove Old.
>>>>> Nothing, still that same old rate :(
>>>>>
>>>>> Is it hardcoded somewhere? Where?
>>>>
>>>> Which report?
>>>
>>> Same with all the reports
>>>
>>> For now, I used Equity Statement For Period Covering 2013-01-01 to
>>> 2013-12-31
>>> 2013-01-01 is wrong
>>> 2013-12-31 is also wrong
>>>
>>> I made a custom report with a currency price chart, selected price
>>> database as the source.
>>> Chart shows correct exchange rates.
>>>
>>>
>>>> Have you looked in the report options to select your price source?
>>>> Most likely you will want to change the it to "nearest in time"
>>>>
>>>>> Thank you for your help
>>>>
>>>>> Please remember to CC this list on all your replies.
>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>> -derek
>>>>
>>>> --
>>>>        Derek Atkins                617-623-3745
>>>>        derek at ihtfp.com            www.ihtfp.com
>>>>        Computer and Internet Security Consultant
>>>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>


More information about the gnucash-user mailing list