Three trading accounts in one transaction

[Anton Lindström]

Den Mon, 04 Aug 2014 19:12:28 +0100
skrev Re: Three trading accounts in one transaction:

> --On August 4, 2014 at 7:10:12 PM +0200 Anton Lindström 
> <anton at antonanton.com> wrote:
> 
> > Thanks for the suggestion, I think it would work. I do wish I didn't
> > need to do that extra step where I buy currency separately. I still
> > want the commission in the same transaction as the stock purchase
> > (for the report to know it's a commission) so I would have to
> > calculate what the commission would be in CAD. In any case it would
> > be a bit more manual work.
> 
> I don't think you need to use multiple transactions.  If you are 
> careful to set the correct exchange rate or price for all splits that 
> are not in the transaction's currency then it should work ok.

After reading through the discussion in the link below and
fiddling around I think the problem is that I am in a commodity account,
entering a stock purchase, and if I try to set the exchange rate it
says that this register doesn't support editing exchange rates.

There are two currencies and one commodity involved, so I can set the
price of the commodity in the currency it's denominated in, but I can't
set the exchange rate between this currency and the other currency (the
one of the brokerage account).

The workaround I've found is to save the transaction anyway, which makes
gnucash assume an exchange rate of 1:1 and create an imbalance-split,
then open up the same transaction from the brokerage account,
manually calculate the exchange rate and set it there, then I'm able to
get rid of the imbalance.

Unfortunately the Advanced Portfolio report (if that's the English
name?) doesn't deal with this the way I'd like but that's another
issue. :-)

> Version 2.4 didn't detect certain unbalanced transactions that 2.6 
> rejects.  I suspect that if you look at one of the transactions like 
> this that you entered in 2.4 you'll see that 2.6 thinks it is 
> unbalanced.  There is a discussion of this change in bug 732058.  See 
> comment 20, <https://bugzilla.gnome.org/show_bug.cgi?id=732058#c20>, 
> for details of what constitutes a balanced transaction.
> 
>              Mike

Thanks for the link, very useful.

Best regards,
Anton