...sorry, accidentally didn't reply to all, so I'm forwarding my reply to the list....
----- Original message ----- From: Scott Ellsworth <sc...@fastmail.us> To: john <jra...@ceridwen.us> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account Date: Sunday, July 23, 2023 17:10 *Hi John,* ----- Original message ----- From: john <jra...@ceridwen.us> To: Scott Ellsworth <sc...@fastmail.us> Cc: GnuCash user forum <gnucash-user@gnucash.org> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account Date: Sunday, July 23, 2023 02:17 *Thank you for your help. **I've used Gnucash for over 15 years, but suddenly I'm running into my ignorance about some features:* The simple solution is to fix that split and remove or fix the 0 price entries in the pricedb. *I never even knew about the Price Database before. In there I saw one item for every day, and I see a non-zero price for only one day, the 20th. When I went to the dong account just now, went into every split of every transaction, and clicked Edit Exchange Rate on each one, I only found one that was blank. I don't think I've solved the problem by entering the rate for that transaction, because I still see the Account Summary telling me that my ₫2,394,000.00 is worth $0.00 after refreshing it, when I know that it's actually worth about $101.* ** You should check your other VND transactions to make sure that there aren't any other 0-price splits. There's only one set of prices for any particular commodity pair so you'd have to make a new book to see different price behavior. *I think I have this covered now based on what I said above, but the problem remains. Looking at the Price Database again now, I still see a non-zero price only for one day in spite of the correction I made.* The more complicated problem is how did that 0-price split get created and why did that become the price for the day instead of one of the others. Would you be willing to post a transaction report of the VND account with Display optiions set to show date, date entered, accounts, shares, and prices with one line per split? Leave off description, memo, and account to keep confidential what you spent the money on, that's irrelevant here. *I'll be happy to do this, but I haven't figured out how to add those columns to the register view.* *Be Well,*** * *** *Scott*** <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> On Jul 22, 2023, at 01:34, Scott Ellsworth <sc...@fastmail.us> wrote: > > Hi John, > > Every transaction is big enough to equal more than one cent. And the dong > cash register starts with an ATM withdrawal of 2 million dong. > > In the Price Database, which I was not familiar with before, I see three > entries, two of which are at zero value. The Account Summary now shows > "₫540,780.00 $0.00" but the transactions do usually have dollar equivalent > values: When I look at my Food account I see that the most recent > transactions were worth $1.18, $0.25, and $38.53. But I notice one > transaction from the 19th, a split transaction where the Food component came > out to zero and the number fields are simply blank on that line, not with > zeroes shown. The other parts of the transaction were $6.19 spent from > Assets:Cash:vn dong balanced against $3.18 spent on Expenses:Health, so the > transaction obviously does not balance. When I go to the blank line for > Expenses:Food and click on Jump, nothing happens. But when I go to the > Cash:vn dong account and find that transaction, I see an amount for the food > component, 549,000 dong, which was missing in the Food account. > > This is confusing. I hope my file is not corrupted, since my financial data > is important to me. And it's strange that even after I created a second dong > cash account to test, the new account had the same exact problems. > > Be Well, > > Scott > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > ----- Original message ----- > From: john <jra...@ceridwen.us> > To: Scott Ellsworth <sc...@fastmail.us> > Cc: GnuCash user forum <gnucash-user@gnucash.org> > Subject: Re: [GNC] strange lack of exchange rates in a new currency cash > account > Date: Friday, July 21, 2023 23:24 > > Scott, > > Did you perhaps get the balance to 2M VND in small increments so that the > USD value of every transaction rounded to $0.00? That would have prevented > the price from being recorded, resulting in the symptoms you describe. If > you've been trying to use VND for several days you can look at the price > database entries to see if any of the earlier transactions recorded prices. > > Regards, > John Ralls > > > On Jul 21, 2023, at 01:14, Scott Ellsworth <sc...@fastmail.us> wrote: > > > > Another strange thing: It might be starting to work normally now: I just > > entered a couple of transactions and accidentally entered the exchange rate > > as 23,600 instead of 1/23,6000. Now it's starting to show the dollar > > equivalent on the Account Summary, even after I went back and corrected the > > exchange rate on those two transactions. I'm not sure if it's fixed, but at > > least for right now it appears to be working normally again. > > > > Be Well, > > > > Scott > > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > > > ----- Original message ----- > > From: Scott Ellsworth <sc...@fastmail.us> > > To: gnucash-user@gnucash.org > > Subject: strange lack of exchange rates in a new currency cash account > > Date: Friday, July 21, 2023 15:06 > > > > Dear fellow Gnucash users, > > > > I have a strange problem with a new currency account that I just added the > > other day: I created a cash account for Vietnamese dong (VND), and somehow > > it's not working with exchange rates. The two strange things I'm noticing > > are: > > 1. Every time I create a new transaction in this account, I have to type in > > an exchange rate manually. (With other cash accounts (other than USD, my > > default currency) an exchange rate always is remembered from earlier > > transactions.) > > 2. On my Account Summary report, I see the new account, which I've named > > "vn dong" and placed under Assets > Cash, and the number of dong that I > > have in cash, but the US dollar equivalent always shows up as zero. (I use > > "Cash" as a placeholder account, under which I have all my cash currencies > > including US dollars, euros, Japanese yen, etc.) Right now, for example, it > > shows "₫2,080,870.00 $0.00" but in dollars that should be about $88. > > > > I thought maybe the new account was somehow corrupted, so I tried creating > > a new one from scratch, but the same problem occurred again. > > > > The one thing that is different about this currency compared to all others > > for which I have cash accounts is that it's very tiny: It's about 23,600 > > dong per US dollar. Is Gnucash not able to handle such extreme exchange > > rates? > > > > Be Well, > > > > Scott > > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. Be Well, Scott <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
