[GNC] strange lack of exchange rates in a new currency cash account

[john]

Scott,

The simple solution is to fix that split and remove or fix the 0 price entries in the pricedb. 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.

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.

Regards,
John Ralls



> On Jul 22, 2023, at 01:34, Scott Ellsworth <scott at 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 <jralls at ceridwen.us <mailto:jralls at ceridwen.us>>
> To: Scott Ellsworth <scott at fastmail.us <mailto:scott at fastmail.us>>
> Cc: GnuCash user forum <gnucash-user at gnucash.org <mailto:gnucash-user at 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 <scott at fastmail.us <mailto:scott at 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 <scott at fastmail.us <mailto:scott at fastmail.us>>
> > To: gnucash-user at gnucash.org <mailto:gnucash-user at 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 at gnucash.org <mailto:gnucash-user at 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.