Re: [GNC] Account Currency Screwed Up Again!

2020-02-12 Thread Adrien Monteleone
Sorry, I meant to include it and forgot. It is in Chapter 9: Investments, specifically: https://www.gnucash.org/docs/v3/C/gnucash-guide/invest_accounts1.html Section 9.2.2 covers the currency issues, including multi-currency, and 9.2.3 gives an example of an intricate custom tree. (not necessar

Re: [GNC] Account Currency Screwed Up Again!

2020-02-12 Thread rsbrux via gnucash-user
considerations which might move me to adopt a different structure, but I couldn't find the part of the guide you were referring to.  Can you provide a link? Date: Tue, 11 Feb 2020 14:39:01 -0600 From: Adrien Monteleone To: Gnucash Users Subject: Re: [GNC] Account Currency Screwed Up Again! Messa

Re: [GNC] Account Currency Screwed Up Again!

2020-02-11 Thread Adrien Monteleone
Thanks for the explanation. Regards, Adrien > On Feb 11, 2020 w7d42, at 1:20 PM, John Ralls wrote: > > The transaction currency in which the value field of every split is > denominated is determined by the account in whose register one creates the > transaction. If that account is in a non-cu

Re: [GNC] Account Currency Screwed Up Again!

2020-02-11 Thread John Ralls
The transaction currency in which the value field of every split is denominated is determined by the account in whose register one creates the transaction. If that account is in a non-currency commodity then the currency of first parent account denominated in a currency is used. So in rsbrux's c

Re: [GNC] Account Currency Screwed Up Again!

2020-02-11 Thread Adrien Monteleone
My understanding is that the controlling factor is the currency of the parent, not where you enter the transaction. But I could be mistaken. The tree organization is really user dependent. I think the Guide uses a slightly different organization where bank/brokerage lies below with a separate

Re: [GNC] Account Currency Screwed Up Again!

2020-02-11 Thread rsbrux via gnucash-user
s way to fix such problems. Date: Mon, 3 Feb 2020 10:31:58 -0600 From: Adrien Monteleone To: Gnucash Users Subject: Re: [GNC] Account Currency Screwed Up Again! Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net> Content-Type: text/plain; charset=utf-8 Would creating a new du

Re: [GNC] Account Currency Screwed Up Again!

2020-02-11 Thread rsbrux via gnucash-user
n Monteleone To: Gnucash Users Subject: Re: [GNC] Account Currency Screwed Up Again! Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net> Content-Type: text/plain; charset=utf-8 Would creating a new duplicate account with the proper assigned currency, then deleting the old a

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread John Ralls
ut the data structure, this looks like the easiest way to > provide a less dangerous way to fix such problems. > >> Date: Mon, 3 Feb 2020 10:31:58 -0600 >> From: Adrien Monteleone >> To: Gnucash Users >> Subject: Re: [GNC] Account Currency Screwed Up Again! >&

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread David Cousens
each transaction to change or select the > currency? From what I have learned about the data structure, this looks > like the easiest way to provide a less dangerous way to fix such problems. > > > Date: Mon, 3 Feb 2020 10:31:58 -0600 > > From: Adrien Monteleone > > To

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread Adrien Monteleone
Glad to hear you managed to fix the data, but that raises the question why retrieving prices is grabbing CHF instead of AUD. Is the parent of the affected securities set for AUD? This is usually an account representing the brokerage that handles the individual securities for you. Note, at this

Re: [GNC] Account Currency Screwed Up Again!

2020-02-10 Thread rsbrux via gnucash-user
ix such problems. Date: Mon, 3 Feb 2020 10:31:58 -0600 From: Adrien Monteleone To: Gnucash Users Subject: Re: [GNC] Account Currency Screwed Up Again! Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net> Content-Type: text/plain; charset=utf-8 Would creating a new du

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread Adrien Monteleone
Would creating a new duplicate account with the proper assigned currency, then deleting the old account and choosing to transfer all transactions to the new currency work? That would be significantly easier than manual editing. I’m not sure how the use of Trading Accounts affects this, or if it

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread David Cousens
Have you checked the default currency used Edit->Preferences, Accounts tab, Default Currency. It is normally set to locale. I guess you are in Australia so it should be AUD. If not, diid you possibly create the book originally while overseas or the locale on your computer was not set to Australia.

Re: [GNC] Account Currency Screwed Up Again!

2020-02-03 Thread rsbrux via gnucash-user
I haven't see an answer to this on the distribution list, nor on Nabble <http://gnucash.1415818.n4.nabble.com/GNC-Account-Currency-Screwed-Up-Again-td4715785.html>. Can I fix this by editing the XML file? I am using GC v2.6.19 under Ubuntu Studio 18.04.  Is there a function to

[GNC] Account Currency Screwed Up Again!

2020-01-27 Thread rsbrux via gnucash-user
Many years ago I set up in GC a bank account denominated in AUD to buy and sell securities in that currency.  While reconciling my end-of-year statements I only just noticed while attempting to enter a new price for one of the securities that all transactions in that account (not just securitie