[GNC] Currency exchange rates inconsistencies for invoices

[John Ralls]

> On Sep 16, 2020, at 1:57 AM, Mtc Gugu via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> Hi!With the risk of repeating maybe this topic, would like to as for some help on the matter. 
> 
> Case:I'm using 3 currencies & trading accounts for a business setup. Default is SEK, but all the invoices are in USD. Gnucash 4.1.So basically I send/ receive the invoices/ bills in USD, then transfer them to SEK, sometimes with Euro conversions in-between, as my bank doesn't accept direct conversions. And all the reports needs to be in sek.
> 
> Problems:1. Though conversion rates for individual transactions are correct, the total amount in the Account pane, or in any Report, besides Transaction Report, do not tally. 
> It doesn't match neither by making the conversions at the individual level of the transactions, nor by manually updating the rates in the price db. I've tried all the 4 Price Source options in the Reports options. So, at the end of the day, I can't pull out a Report with the correct balance/ total.Any tips on how to address this issue?
> 
> 2. If an invoice is re-posted/ changed/ edited after an initial setup, it is stuck with the same exchange rate, no matter what. Even if I create a totally new invoice for the same day, it is still stuck with the same exchange rate. 
> Any idea how can the Currency Transfer (Transfer Funds) dialog box can be forced to open every time (or at least on demand) when an invoice is changed/ re-posted? Deleting the entry for the date in the Price db doesn't work.
> 
> Though I've browsed the mailing lists, still can't find a reasonable solution.
> It seems to be a Price Source issue. 
> Should mention that i don't need an average, but the exact price on the exact date. 
> 

There's a very long discussion on this topic in https://bugs.gnucash.org/show_bug.cgi?id=797796.

Regards,
John Ralls