"Edit exchange rate" has stopped working (2.2.9)

[Fred Bone]

On 8 February 2010 at 20:06, Adam Funk said:

> On 2010-02-08, Derek Atkins wrote:
> 
> >>> Adam Funk <a24061 at ducksburg.com> writes:
> >>>
> >>>> I opened the price editor, deleted all the entries for EUR in January
> >>>> 2010 (they all had source "user:xfer-dialog"), and closed the price
> >>>> editor.  Then I tried edited the exchange rate in the EUR100 =
> >>>> GBP89.36 withdrawal again ("to amount" 100); that created an entry in
> >>>> the price editor
> >>>>
> >>>>  EUR  GBP  20/01/20  user:xfer-dialog  0.893600
> >>>>
> >>>> but the amount in the Cash EUR account *still* shows 96.48 instead of
> >>>> 100!  I'm baffled.
> [snip]
> > Because the transaction already exists.
> >
> > Note that I said "you cannot change the amount **FROM THE EDIT EXCHANGE
> > RATE BOX**" (emphasis mine).  I did NOT say that you cannot change the
> > amount.  You can most certainly change the amount from the register.
> 
> I'm really not trying to test your patience, but I'm honestly
> convinced that the procedure I've been using successfully for several
> years stopped working after the upgrade.
> 
> How do you recommend that I keep the amount in GBP the same but change the
> amount in EUR for the same split in different registers?  I have tried
> changing the EUR96.48 to EUR100.00, but when I do that, the GBP89.36 in
> the bank account register increases proportionally (because the exchange
> rate is now, AFAICT, "locked").

IIRC it was you that said you do this in "Auto-Split" view. (I find this 
sort of thing easier in "Basic" view, as long as it's not a multi-split 
transaction.)

You can only edit the exchange rate for the split that was the "other 
end" when you entered the txn in the first place. 

Let me take you through an example from my own accounts.

On 2009-03-14 I bought EUR150 for GBP143.88. Suppose I now discover that 
I'd entered it wrong and the GBP price was actually 148.33.

I happened to enter this particular txn from the EUR-denominated account 
register, so the "primary" split is EUR-denominated.

I'll call the split belonging to the EUR-denominated account "E" and the 
one belonging to the GBP-denominated account "G". "E" is the debit split 
and "G" is the credit split for this txn (since I was buying Euros from 
my GBP bank account).

If I open the txn in the EUR-denominated account and select split E, the 
system won't let me "Edit Exchange Rate": it correctly says "The two 
currencies involved equal each other". If I select split G, then I can 
"Edit Exchange Rate". I go to the "Debit Amount" box and type "-148.33", 
hit "OK" (which returns me to the register), then hit "Enter" twice 
(which confirms the change). If I now go to the GBP-denominated account 
register, I see the new value.

Here, I again open the transaction. Once again, I cannot "Edit Exchange 
Rate" on split E. Doing so on split G, I can update the "Debit amount" 
box from its current "-150.00" to, say, "-155.00". Hit "OK", "Enter" 
twice, and I now get a EUR imbalance which shows up (in the GBP register) 
as "4.78". The primary, EUR, end is still recorded as EUR150; I haven't 
changed the GBP amount, but I've now apparently bought another 5 Euros 
(worth GBP4.78 at the current rate) which are unaccounted for.

If, however, I have the GBP account in "Basic" view, and then update the 
exchange rate, the system *will* alter the EUR value to match (and will 
not create an "Imbalance").

Does this clarify things a little?

Note, BTW, that the exchange rate is recorded with the txn; any changes 
you make to the Price Database have no effect whatsoever on existing 
txns.