[GNC] Exchange Rate to Price Database issue with low transactions amounts

[Jim DeLaHunt]

Bo:

On 2025-02-11 04:30, Bo Buckley wrote:
> Dear John,
>
> Thanks for your time again. I uploaded the video, test.gnucash and the 
> test.csv file used to import the example transactions to my Network 
> Accesible Storage. You should have public access here:
>
> https://gofile.me/7Ad2L/z8EsrYEzD

I was able to watch your "output.mp4" video. Good idea to post it! It 
was more informative than I expected.

I have three observations from watching the video:

1. Your interaction appears to be: a) Transfer Funds dialogue appears, 
b) you type in an exchange rate of 0.0066, c) you press the OK button on 
the Transfer Funds dialogue.

2. At the moment between b) and c), there is a difference between the 
value in the Exchange Rate field, and the equation just to its right. 
e.g. at 0'49" in the video, the Exchange Rate field reads "0.0066", and 
the equation reads "1 JPY = 0.009091 USD". This is an interesting 
contradiction. I would expect the value in the Exchange Rate field to 
replace the previous value in the equation.

3. The result of importing the transactions e.g. at 0'56" in the video 
is that the charges to the Expenses:Bank Service Charge account are 
whole numbers of USD.  It as if the arithmetic did not realise that the 
minimum increment for USD is 0.01, and treated it as 1.

This might well be evidence of a bug in this part of GnuCash, I'm not 
sure. It is possible, for example, that when the CSV import kicks off a 
Transfer Funds dialogue for one transaction, it mistakenly labels the 
minimum increment of USD with the minimum increment for JPY.  For a lot 
of currencies, the minimum increment in both currencies will be the 
same, 0.01, so I can imagine this getting overlooked.

But one workaround which might be interesting for you to try is to spend 
a little more time interacting with the Transfer Funds dialogue. After 
b), you enter an exchange rate in the Exchange Rate field, press tab to 
move focus out of that field. See if the exchange rate in the equation 
to the right updates with the Exchange Rate you supplied.

Another thing to try is to click the radio button by Debit Amount in the 
Transfer Funds dialogue, then in that field, enter a formula of <yen 
charge as a positive number> * 0.0066 . I expect Gnucash can calculate a 
USD debit amount and put it in that field.  If the amount is a whole 
number of dollars, that is further evidence of a bug.

A workaround is not as good as a bug fix, but you can take advantage of 
it faster, while you wait for a bug fix.

Thank you for diligently collecting evidence and for your clear 
explanations. I hope this helps,
      —Jim DeLaHunt