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 time, I don’t think you can have mixed currency accounts in one brokerage parent. You’ll have to create separate brokerage parent accounts for each currency. Regards, Adrien > On Feb 10, 2020 w7d41, at 7:21 AM, rsbrux via gnucash-user > <gnucash-user@gnucash.org> wrote: > > Many thanks to both of you for your suggestions! > > @Adrien, > > The accounts in question already had the correct currency (AUD) assigned. > The accounts in question are a foreign currency account in AUD, three > accounts for AUD-denominated securities (which I bought/sold in the > above-mentioned foreign currency account), various expense accounts in AUD > and an income account in AUD for interest. The transactions between the > foreign currency account and the expense accounts were recoreded in AUD as > expected. All other transactions were recorded with CHF exchange rates, > although no currency conversions were called for. The prices of two of the > three securities were also recorded in CHF. SInce the GC UI shows all > accounts in AUD (except for the securities accounts, which IIRC, do not have > a currency) it was unclear to me which account(s) I should duplicate. > > @David, > > My default currency is CHF; I live in Switzerland. Trading accounts are > turned on. I have tried to fix this in the XML based on the information you > provided. I tried to look up more information about the file structure, but > the guide <https://www.gnucash.org/viewdoc.phtml?rev=2.6&lang=C&doc=guide> > wasn't much help, and the wiki <https://wiki.gnucash.org/wiki/> appears to be > down. > > IAC, I edited the price records for the two securities which had incorrect > price currencies, as well as all transactions which refenenced any of the > three securities accounts, changing the currencies from CHF to AUD. This > appears to have fixed the problems, but I am keeping a couple of pre-edit > backups, as you recommend. > > Am I the only one to encounter problems like this? > > SInce the problem seems to have been with the (implicitly determined) > currencies of the prices and the transactions, would it be possible to add an > option to the price editor dialog for each price and to the exchange rate > editor for 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. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
