2018-11-18 GnuCash IRC logs

01:01:03 *** Inge- has joined #gnucash
01:27:24 *** boldstripe has quit IRC
02:29:15 *** jralls has joined #gnucash
02:30:28 *** jralls_ has joined #gnucash
02:30:28 *** jralls has quit IRC
08:46:45 *** gncbot has joined #gnucash
08:47:04 *** ChanServ sets mode: +qo warlord warlord
08:47:05 *** warlord sets mode: +o gncbot
09:20:39 *** shoonya has quit IRC
10:10:24 *** Agfarmer18 has joined #gnucash
10:14:03 <warlord> .
10:34:43 *** Mechtilde has quit IRC
10:35:57 *** storyjesse has quit IRC
10:49:54 *** badger92 has quit IRC
11:15:13 *** boldstripe has joined #gnucash
11:17:26 *** fell has joined #gnucash
11:28:22 *** Agfarmer18 has quit IRC
11:40:29 *** RASSRQ has joined #gnucash
12:23:27 *** User_ has quit IRC
12:28:09 *** RASSRQ has quit IRC
12:43:30 *** badger92 has joined #gnucash
12:54:00 *** boldstripe_ has joined #gnucash
12:56:09 *** boldstripe has quit IRC
12:56:09 *** boldstripe_ is now known as boldstripe
12:57:36 *** boldstripe has quit IRC
13:01:22 *** boldstripe has joined #gnucash
13:04:43 *** boldstripe has quit IRC
13:10:17 *** oozer has quit IRC
13:44:01 *** CDB-Away has joined #gnucash
13:45:36 *** oozer has joined #gnucash
13:49:05 *** CDB-Away has quit IRC
13:49:25 *** CDB-Away has joined #gnucash
14:01:28 *** fell has quit IRC
14:12:35 *** fabior has quit IRC
14:45:12 *** frakturfreak has joined #gnucash
15:41:38 *** gour_ has quit IRC
15:42:14 *** boldstripe has joined #gnucash
15:44:15 *** boldstripe has quit IRC
15:51:07 *** boldstripe has joined #gnucash
15:53:02 *** boldstripe has quit IRC
15:53:06 *** RASSRQ has joined #gnucash
16:22:53 *** boldstripe has joined #gnucash
16:31:32 *** Mechtilde has joined #gnucash
16:38:48 *** frakturfreak has quit IRC
17:00:45 *** Mechtilde has quit IRC
17:18:29 *** RASSRQ has quit IRC
17:25:56 *** gjanssens has quit IRC
17:59:22 *** yegor has joined #gnucash
18:01:21 *** O01eg has quit IRC
18:03:14 <yegor> Hi! For one of my income accounts GnuCash shows on the Accounts page a total of 0,01 USD (which is correct) and a total (EUR) of 0.28 EUR (which is not). However, in the prices editor I do not see any conversion rate for USD/EUR pair close to 28. How do I debug this?
18:03:57 <yegor> (The income account itself is in USD.)
18:47:39 <jralls> yegor: Do you have a lot of USD/EUR transactions?
18:48:20 <yegor> It depends on the definition of "a lot". :) But I have 1-2 per month.
18:50:08 <yegor> This particular account has a single transaction, actually, an income of 0,01 USD.
18:57:11 <warlord> yegor: why not just account for it completely in your home currency?
18:59:40 <yegor> warlord: Well, it's an income that comes to a USD asset account, so this is why the income account is in USD.
19:00:16 <warlord> I was just in Europe this week for work, and while I have a good dozen transactions in EUR, I account for them all in USD (my home currency). I put the EUR amount in the description and then use the estimated (and the actual) USD amount in the transactions.
19:01:38 <warlord> Oh, I missed that. Sorry. In what way is it reporting the EUR amount; is this a report or a CoA Coliumn? (and if the CoA, which column?)
19:04:44 <jralls> By CoA warlord means on the Accounts page.
19:04:57 <yegor> I am talking about the Accounts page/tab, Total and Total (EUR) columns.
19:05:16 <warlord> Yeah, CoA == Chart of Accounts
19:05:49 <warlord> jralls: do you recall how the Total in Report Currency column obtains its exchange rates?
19:06:00 <warlord> I thought it was "most recent"
19:06:19 <jralls> Not offhand, but that's the way I'd write it.
19:06:32 <warlord> So it surprises me that there is not a priceDB entry of 28:1
19:07:25 <jralls> Right. yegor, what are the most recent USD->EUR and EUR->USD prices?
19:08:25 <jralls> (There should only be one or the other, but there might be some price-setting code that doesn't check for "the other direction" before creating a new price.)
19:10:14 <warlord> sorry, gotta run. Good luck, yegor.
19:11:07 <yegor> So, in Price Database/Currencies/EUR the latest entry is from 27.10.2018 and says EUR 1,140771 USD (Source: Finance::Quote). In Price Database/Currencies/USD the latest entry says USD costs 0,854590 EUR (also from Finance::Quote).
19:11:33 <yegor> The latter entry is from 30.06.2018.
19:13:25 <jralls> Is this the only account with the weird rate between USD and EUR?
19:13:50 *** RASSRQ has joined #gnucash
19:15:26 <yegor> jrails: Excellent question. Yes. Two other functions show sensible totals in USD and EUR.
19:15:42 <yegor> *two other accounts (it's late, I write nonsense)
19:16:45 <jralls> ;-) Early for me, I'm in Japan ATM. OK, so let's look at that single transaction. Is it USD->USD?
19:17:08 <jralls> Are there only three accounts?
19:18:12 <yegor> Yes, it is USD income account -> USD asset account. There are four USD accounts (and lots of EUR accounts). Three have non-zero totals.
19:18:58 <yegor> The transaction in the account in question was pretty long time ago, in February 2018, if this helps.
19:20:54 *** boldstripe has quit IRC
19:21:32 <jralls> I suppose that you've already checked the USD and EUR prices around that date...
19:21:41 <yegor> In the income report is also shows as 0.28 EUR (if I select the nearest date conversion rate in the report settings), if this helps.
19:22:05 <yegor> Yes, I checked, nothing suspicious.
19:22:53 <yegor> And I think the problem appeared a month ago or so. The totals were correct before that.
19:23:07 <jralls> On the income report does the price change if you switch the price source to most recent?
19:23:38 *** CDB-Man has joined #gnucash
19:23:51 <jralls> What about account parentage? Are both USD accounts parented to USD all the way to the top level?
19:24:39 *** CDB-Away_ has joined #gnucash
19:25:16 <jralls> IOW something like Income-USD:stock-dividends-USD as opposed to Income-EUR:stock-dividends-USD?
19:25:29 *** CDB-Away has quit IRC
19:26:16 *** CDB-Man_ has quit IRC
19:27:37 <yegor> Hmm. "Nearest in time" leads to the bar being at around 0.34 EUR, "Most recent" — 0.28 EUR.
19:27:58 <yegor> No, all USD accounts are parented to EUR accounts.
19:28:31 <yegor> The latter, Income-EUR:Dividends-EUR:Dividends-of-one-particular-stock-USD.
19:29:03 <jralls> And the asset account?
19:30:21 <yegor> The asset account is also parented to a EUR account. The balance is currently zero there, but if I add a fake transaction there, the total change as expected: ratio of EUR and USD totals is correct.
19:35:31 <yegor> If I move this transaction, say, from Februrary to September, the total in EUR is still screwed.
19:36:07 <jralls> Yeah, that doesn't surprise me.
19:38:10 *** RASSRQ has quit IRC
19:42:12 <yegor> If I create a new Income-EUR:Dividends-EUR:Testtesttest-USD account and record a 0,01 USD transaction, the EUR total is again 0,28.
19:43:24 <yegor> If Y move this testtesttest-USD account to the top level, the total is still 0,01 USD and 0,28 EUR.
19:43:29 <yegor> *If I move
19:43:42 <jralls> Curiouser and curiouser. What if you make a $1,00 transaction? Does it come out as €28,00?
19:44:43 <yegor> Nope. $1 is 0.88 EUR.
19:44:55 <yegor> Integer overflow somewhere?
19:45:50 <jralls> Possible. Play with different amounts and see where it goes weird.
19:46:50 <yegor> 0.02 and 0.03 USD are converted to EUR correctly. Only 0.01 goes wrong.
19:53:08 <yegor> So, I guess, I should file a bug? Remove all accounts and attach the .gnucash file?
19:53:23 <yegor> (All but testtesttest-USD)
19:55:00 <jralls> Yes, please. Or better yet make a new book.
19:55:25 <jralls> Oh, do you use trading accounts?
19:56:17 <yegor> I do not use trading accounts. I'll check if I can reproduce the problem with a new book: maybe the concrete conversion rates matter.
19:56:59 <jralls> Could be; that will be useful to know.
19:59:40 <yegor> Yeah, they do matter: simply creating a new book with a USD account, recording there a 0,01 USD transaction and getting quotes from Finance::Quote does not reproduce the problem.
20:00:56 <jralls> OK. We'll see shortly if the stripped-down tree reproduces as well.
20:06:40 *** puck has quit IRC
20:11:21 <yegor> Killing all accounts but testtesttest and imbalance-usd preserves the problem. Removing all but one security type also preserves the problem. However, when I remove one particular security, the problem goes away.
20:17:38 <yegor> Apparently, gnucash manages somehow to use a price for a security nominated in EUR to compute a EUR total for a USD account.
20:23:16 <jralls> OK, that's *really* interesting. Is that security the one that sourced the dividend income? Do you have a split to it in the txn so that the Advanced Portfolio Report can see it?
20:24:15 <yegor> No, it's an unrelated security, not the one that resulted the dividend income.
20:26:06 <jralls> Wow. Well, file a bug with the stripped-down book. This is going to be an interesting debug session...
20:26:10 <yegor> Advanced Portfolio report is empty in the minimal example: I do not have any transactions with securities anymore.
20:27:40 <yegor> Ok, I'm ready with producing a minimal example, I'll finish making a bugzilla account now and submit a problem report soon. Thank you for help. :)
20:43:43 *** storyjesse has joined #gnucash
20:48:22 <yegor> jrails: Done: https://bugs.gnucash.org/show_bug.cgi?id=796949 Thanks again, have a good day. :)
20:48:49 <yegor> *jralls
20:49:07 <yegor> And I'll go get some sleep. Bye!
20:51:49 *** yegor has quit IRC
21:01:11 *** bertbob has quit IRC
21:03:51 *** bertbob has joined #gnucash
21:21:37 *** oblique has joined #gnucash
21:24:07 *** RASSRQ has joined #gnucash
21:24:30 *** jralls has quit IRC
21:28:18 *** oozer has quit IRC
21:44:22 *** RASSRQ has quit IRC
22:05:37 *** feepk17 has joined #gnucash
22:19:44 *** Aussie_matt has joined #gnucash
22:21:39 *** Kryo has joined #gnucash
22:42:15 *** O01eg has joined #gnucash
23:07:47 *** bendem has joined #gnucash