Scott, I don't know what's going on and I can't replicate it. I created a VND account in a test book and created the following transactions (This is a Transaction report with one line per split set on the Display tab. I've also turned off Force prices to decimal in Preferences>Numbers, Date, Time.):
Date Account Shares Price Debit Credit 01/01/2023 VND Cash 2,000,000.00 $0.0000425 ₫2,000,000 Checking Account -85.00 $1.0000 $85.00 07/23/2023 VND Cash -49,530.00 ₫1.00 ₫49,530 Books 2.09 ₫23,698 + 118/209 $2.09 07/25/2023 VND Cash -136,000.00 ₫1.00 ₫136,000 Groceries 5.68 ₫23,943 + 47/71 $5.68 I entered the price three different ways: For the first I started in the USD-denominated Checking Account register, entered 85.00 in the register's Credit field and 2000000 in the Debit Amount field of the transfer dialog. The other two I started in the VND Cash register and put values in the price field; as a rational number for the first and a decimal number (editing the one the Transfer dialog presented; that was before I changed the Force prices to decimal preference. The book does not have Trading accounts enabled. GnuCash is v5.3. Regards, John Ralls > On Jul 25, 2023, at 00:57, Scott Ellsworth <sc...@fastmail.us> wrote: > > Hi John, > > Another update about the strange behavior: Just now I came back from shopping > and recorded three transactions. When inputting the first transaction, the > exchange rate was still in place from yesterday. For the second and third > transactions, the exchange rate was blank both times and I had to input it > manually. This time I tried entering "0.00004237" instead of the fraction. > But now the Account Summary again shows that my dong cash has zero value. > > Be Well, > > Scott > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > ----- Original message ----- > From: Scott Ellsworth <sc...@fastmail.us <mailto:sc...@fastmail.us>> > To: john <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> > Cc: GnuCash user forum <gnucash-user@gnucash.org > <mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] strange lack of exchange rates in a new currency cash > account > Date: Tuesday, July 25, 2023 09:15 > > Hi John, > > As you're looking around in there to see what's happening, it might be useful > if I summarize a couple of key points (though perhaps you've already gathered > this from our discussion): I was consistently seeing the total value of my > dong cash at zero value, apparently because I had entered the actual amount > received from ATM withdrawals, and because I had written exchange rates for > transactions every time with fractions. But at the same time, all > transactions except one visit to a grocery store showed normal values in > dollars on my income statement and expense bar chart, reflecting my actual > local expenses in Vietnam so far. In that one problematic transaction, I saw > a zero value (or actually a missing number) for the dollar value of the food > component in the split transaction. I corrected that after I discovered it. > > Be Well, > > Scott > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > ----- Original message ----- > From: Scott Ellsworth <sc...@fastmail.us <mailto:sc...@fastmail.us>> > To: john <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> > Cc: GnuCash user forum <gnucash-user@gnucash.org > <mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] strange lack of exchange rates in a new currency cash > account > Date: Tuesday, July 25, 2023 08:34 > > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> > > ----- Original message ----- > From: john <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> > To: Scott Ellsworth <sc...@fastmail.us <mailto:sc...@fastmail.us>> > Cc: GnuCash user forum <gnucash-user@gnucash.org > <mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] strange lack of exchange rates in a new currency cash > account > Date: Tuesday, July 25, 2023 00:38 > > Your issues with the transfer dialog seem strange. I just tried a 2,000,000 > transfer with a rate of 1/23600 in the dialog and got a value of 84.75. The > decimal display on the right of the rate entry is 0.000042, but that's just > because that display is limited to 6 decimal digits; GnuCash actually stores > the number as 1/23600. i'll have to probe that some more to figure out what's > going on. > I should mention that when doing ATM withdrawals I've always entered the > actual amount I received instead of the exchange rate, since that keeps it > accurate. I've done ATM withdrawals this way in ten other currencies so far > in the past couple years, and have never had problems. but the Vietnamese > dong is a very small unit of currency. I suppose if I had to enter the > exchange rate instead, I'd have to calculate it pretty precisely and then > watch carefully for discrepancies in the final amount. I'll probably try that > for now. > > In the report the 0 or 1 prices in the transaction report are due to > transaction currency: Notice that it's either $0.00 or ₫1.00. The latter > transactions were started in the VND account so the transaction currency is > VND, hence the price of ₫1.00. The $0.00 is a display issue: The default > price display is 2 more digits than the currency's smallest fraction, .00 for > both USD and VND, so .0000, and 1/23600 rounded to 4 places is 0. > Okay, I overlooked that. So basically, $0.00 is for converting dollars to > dong, while ₫1.00 is for my transactions in dong with no currency conversion. > > Be Well, > > Scott > > >> On Jul 23, 2023, at 22:02, Scott Ellsworth <sc...@fastmail.us> wrote: >> >> Hi John, >> ----- Original message ----- >> From: john <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> >> To: Scott Ellsworth <sc...@fastmail.us <mailto:sc...@fastmail.us>> >> Cc: GnuCash user forum <gnucash-user@gnucash.org >> <mailto:gnucash-user@gnucash.org>> >> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash >> account >> Date: Monday, July 24, 2023 02:09 >> > On Jul 23, 2023, at 03:11, Scott Ellsworth <sc...@fastmail.us >> > <mailto:sc...@fastmail.us>> wrote: >> It works off the latest price in the pricedb. If that's 0 then so will be >> the home-currency values on the accounts page and in the summary bar. >> Editing transactions won't change an entry in the pricedb. Only creating a >> transaction will, and then only if there isn't already a corresponding price >> for that day. That means that if you create the first transaction of the day >> with a zero price and immediately correct it you still have a 0 price in the >> pricedb that you have to manually fix or delete. >> Okay, that's good to know. I went into the Price Database and created a >> price entry for dong for today. I had not made any transactions before that >> today. When I went over to the Account Summary and refreshed the page, for >> the very first time so far it showed a non-zero value for my total dong >> cash: ₫1,232,000.00 $52.20. And when I created a test transaction, it >> showed an exchange rate waiting for me for only the second time I've seen so >> far. >> >> Not in the register view, in Transaction report options on the Display page, >> but in light of your other answers I think that it's not necessary. >> Okay, I did that report and I'm sending a screenshot here. This might be a >> useful result, because it looks like it's showing an exchange rate of either >> 1 or 0 throughout. I don't understand that. >> >> So far, it seems like I can enter an exchange rate in the Price Database but >> it hasn't taken my exchange rates that I enter into the register manually >> (which I always do because the exchange rate is blank). I have a hypothesis >> about this: I normally type "1/23600" in the exchange rate field for >> transactions. Perhaps the program automatically truncates the calculated >> values to four decimal places. When I added a price for today in the Price >> Database I tried typing it instead as "0.00004237" just in case it might >> make a difference. I think it still truncated it to six decimals, so >> "0.000042," but at least that registers as a normal exchange rate, even if >> it's less exact. So when I add money to my dong cash account by doing an ATM >> withdrawal, those exchange rates are calculating automatically because I >> always input the exact number of dong that I received. Maybe it calculated >> and truncated from that as well, giving me zeroes all the time. >> >> But the Transaction Report with binary exchange rates is still confusing to >> me. >> >> Let me know what you suggest. >> >> Kind Regards, >> >> Scott >> >> > >> > *Be Well,*** >> > * *** >> > *Scott*** >> > <<<< Scott Ellsworth || +1 (775) 386-2519 >>>> >> > On Jul 22, 2023, at 01:34, Scott Ellsworth <sc...@fastmail.us >> > <mailto: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 <mailto:jra...@ceridwen.us>> >> >> To: Scott Ellsworth <sc...@fastmail.us <mailto:sc...@fastmail.us>> >> >> Cc: GnuCash user forum <gnucash-user@gnucash.org >> >> <mailto: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 >> >>> <mailto: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 <mailto:sc...@fastmail.us>> >> >>> To: gnucash-user@gnucash.org <mailto: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 <mailto: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 <mailto: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. >> >> >> >> >> >> <Screenshot from 2023-07-24 11-27-56.png> _______________________________________________ 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.