Re: [GNC] multiple currencies in one transaction

2019-08-21 Thread Christoph R
Hi Mike, > It seems to me that the simplest solution, and one that might work reasonably > well, is to make it possible (via a view option) to switch any register into > the format used for non-currency registers where there are separate columns > for shares, price, and value for each split.

Re: [GNC] multiple currencies in one transaction

2019-08-20 Thread Fred Bone
On 20 August 2019 at 13:17, Jeff Abrahamson said: > When I said price editor, I meant the price database.  I've been > assuming that the rates there are used for proposing rates on new > transactions. They are, but mainly because there has to be *some* default value. In most cases you will want

Re: [GNC] multiple currencies in one transaction

2019-08-20 Thread Clint Chaplin
I have been following this discussion rather closely. I am American (not something to be proud of right now), but I do travel a lot on business worldwide, dealing with a lot of currencies. It'll be interesting to see how this resolves. On Tue, Aug 20, 2019 at 4:21 AM Jeff Abrahamson wrote: >

Re: [GNC] multiple currencies in one transaction

2019-08-20 Thread Jeff Abrahamson
When I said price editor, I meant the price database.  I've been assuming that the rates there are used for proposing rates on new transactions. Anyway, it sort of goes to my point that I think the documentation is less than clear for those of us who have regular transactions in multiple

Re: [GNC] multiple currencies in one transaction

2019-08-20 Thread David Carlson
I thought this thread was discussing only transactions, not reports. Jeff, the Price Editor does not come in to play in individual transactions. Transactions are self-contained with whatever exchange rates happen therein. The Price editor exists for reports that are not tied to individual

Re: [GNC] multiple currencies in one transaction

2019-08-20 Thread Jeff Abrahamson
It's not entirely unuseful that some of the discussion happens here on the user list.  User input may be of interest. I'll add only one point, which is that I think the current English language documentation doesn't explain as well as it might how to use gnucash in the presence of more than one

Re: [GNC] multiple currencies in one transaction

2019-08-19 Thread Mike Alexander
I’ve been thinking for a while about how the register could be changed to better handle multiple currency transactions with trading accounts turned on. Back when I implemented trading accounts I knew this was a problem. However at that time it was expected that the Register2 rewrite of the

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Adrien Monteleone
On second thought, a slight correction —if each account only showed amounts converted to its own currency - NONE of the splits would match any other account’s view of the transaction. The Credit of GBP from Transferwise would be a different amount in the Transferwise_CHF account and a 3rd

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Adrien Monteleone
> On Aug 16, 2019, at 11:39 AM, Jeff Abrahamson wrote: > > > 2. I've been taught in accounting that transactions must balance, and > so I was expecting to see the GBP register all in GBP, the CHF register > all in CHF, and the EUR register all in EUR. That is, if one sums the > columns of a

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread John Ralls
It's a difference in the way that the register works with or without trading accounts. If trading accounts are turned off then the register displays all splits converted to that register account's currency. If they're on then it displays each split in its own account's currency, with symbols

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Jeff Abrahamson
Thanks, that's great, I'll have a play with that after work. Two points concern me: 1.  I don't see currency symbols in my registers.  Is this a setting? 2.  I've been taught in accounting that transactions must balance, and so I was expecting to see the GBP register all in GBP, the CHF

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Adrien Monteleone
Sorry, I thought I proofed that better. Wherever you see €5.13, that should be €5.12. It really doesn’t matter, as it is just for illustration. Regards, Adrien > On Aug 16, 2019, at 11:13 AM, Adrien Monteleone > wrote: > > > The EUR 5.13 price is based on today’s rate between EUR-GBP above

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Adrien Monteleone
So the Cafe’s price was CHF 5.70? Your card was debited GBP 4.67? The Expense:Coffee account is set to EUR? First, yes, you’ll need Trading Accounts turned on. Second, open the price db and fetch rates, then check the EUR-GBP rate, you’ll need it later. (I don’t see a way around this at

Re: [GNC] multiple currencies in one transaction

2019-08-16 Thread Derek Atkins
Jeff Abrahamson writes: > Apparently the mailing list strips images, even very tiny ones. The mailing list strips HTML. If you attach an image then it'll make it through. > The first image simply showed Transferwise associating 5.70 CFH = 4.67 GBP. > > The second showed that gnucash is

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread John Ralls
The list server doesn't like inline images. It mostly works with images stuck at the end of the message. Mostly. In what account is the 2.80 debit? In which account (and so which currency) did you create the transaction? A side note, have you considered/tried enabling trading accounts? Some

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
On 15/08/2019 18:55, John Ralls wrote: >> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson wrote: >> >> Somewhat related, I thought to import historical currencies, as I'm back >> filling some data for analysis purposes. I grabbed 10 years of daily >> quotes and imported them (3600 or so rows of

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread John Ralls
> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson wrote: > > Somewhat related, I thought to import historical currencies, as I'm back > filling some data for analysis purposes. I grabbed 10 years of daily > quotes and imported them (3600 or so rows of data per currency). All ok > for GBP -

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
Apparently the mailing list strips images, even very tiny ones. The first image simply showed Transferwise associating 5.70 CFH = 4.67 GBP. The second showed that gnucash is creating a correcting split in the transaction I'd entered: 512452_Transferwise CHF    5.70 6212_cafe 

[GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
I purchased a coffee in Switzerland using my GBP-based Transferwise card.  That card could hold a CHF balance, but on that day it held only GBP.  My local currency is EUR.  So I can think of my coffee purchase as two FX transactions: funding (GBP -> CHF) and an expense (CHF -> EUR). What