2023-01-07 GnuCash IRC logs
00:02:21 *** palerider has joined #gnucash
00:02:47 *** palerider has left #gnucash
01:10:12 *** fell has quit IRC
01:11:32 *** fell has joined #gnucash
01:11:32 *** ChanServ sets mode: +o fell
01:21:16 *** NoobAlice has quit IRC
03:32:49 *** sunyibo has joined #gnucash
03:32:49 *** ChanServ sets mode: +v sunyibo
04:16:21 *** bertbob has quit IRC
04:19:13 *** bertbob has joined #gnucash
04:19:13 *** ChanServ sets mode: +v bertbob
04:30:30 *** gandalf has joined #gnucash
04:34:54 *** gandalf1 has joined #gnucash
04:35:00 *** gandalf has quit IRC
04:35:01 *** gandalf1 is now known as gandalf
04:41:51 *** puck has quit IRC
04:41:58 *** puck has joined #gnucash
09:29:53 *** gandalf1 has joined #gnucash
09:30:41 *** gandalf has quit IRC
09:30:41 *** gandalf1 is now known as gandalf
09:33:14 *** gandalf1 has joined #gnucash
09:33:41 *** gandalf has quit IRC
09:33:41 *** gandalf1 is now known as gandalf
10:26:44 *** chris has quit IRC
10:28:15 *** gandalf has quit IRC
10:32:30 *** gandalf has joined #gnucash
10:56:59 *** gandalf has quit IRC
10:58:33 *** gandalf has joined #gnucash
13:29:21 *** palerider has joined #gnucash
13:29:49 *** palerider has left #gnucash
13:38:28 *** bertbob has quit IRC
14:12:46 *** bertbob has joined #gnucash
14:12:47 *** ChanServ sets mode: +v bertbob
14:25:32 *** bertbob has quit IRC
14:32:08 *** bertbob has joined #gnucash
14:32:08 *** ChanServ sets mode: +v bertbob
15:57:27 *** NoobAlice has joined #gnucash
16:15:24 <jralls> @tell chris You've got 4 reports in Experimental, one enabled only by --extra, that have been there since 3.x. It's time to either kill them or make them mainstream for 5.0.
16:15:24 <gncbot> jralls: The operation succeeded.
16:28:54 *** undoingtech has joined #gnucash
16:34:29 *** ChanServ sets mode: +v undoingtech
16:39:31 *** undoingtech has left #gnucash
16:41:33 *** undoingtech has joined #gnucash
16:41:33 *** ChanServ sets mode: +v undoingtech
17:21:40 *** gandalf has quit IRC
17:22:16 *** bertbob has quit IRC
17:31:49 <CDB-Man> @tell chris are you sure? in row 14 of the Excel, column E has stock account DR > 0 which is the stock $ value, but column D is nil so still stock zero amount. jralls these are often automatically reinvested units in mutual funds / ETFs, the jargon may be different per country, but fundamentally that's the transaction. notional distrubition could have a language swap if we have a better idea for words, but the substance of the transaction is reinvested
17:31:49 <gncbot> CDB-Man: The operation succeeded.
17:31:49 <CDB-Man> distribution
17:32:55 <CDB-Man> @tell chris and jralls -- where sometimes the reinvested distribution is on the dividend account, and other times its on the capital gain account, depending on the substance of the distribution. in any country other than the US, a common reason for cap gain notional distribution is annual rebalancing for FX hedging against US dollar investments
17:32:55 <gncbot> CDB-Man: The operation succeeded.
17:35:02 *** bertbob has joined #gnucash
17:35:02 *** ChanServ sets mode: +v bertbob
17:35:50 *** chicco has joined #gnucash
17:36:36 *** chicco has quit IRC
18:28:10 <AdrienM> Please don't kill the Multi-Column experimental reports! What's keeping them there anyway?
19:05:27 <jralls> CDB-Man, thanks.
19:41:20 *** chris has joined #gnucash
19:41:21 *** ChanServ sets mode: +v chris
19:41:26 *** gncbot sets mode: +o chris
19:42:23 <chris> jralls adrienM the multicol reports have an outstanding annoying bug: the currency conversion into report currency isn't 100% identical to the non-multicol counterparts;
19:42:46 <chris> the conversion at report date is OK, the conversion at previous dates isn't
19:43:09 <AdrienM> Ah, I forgot about that.
19:44:19 <jralls> chris, is there a reason that that isn't done by some function that every report calls?
19:44:29 <AdrienM> I wonder if that's related in any way to the issue with multi-currency budget reports? (that is a multi-column report and seems to treat the columns differently)
19:45:00 <chris> AdrienM no the budget is in its own class of bugginess
19:45:09 <AdrienM> Roger that.
19:45:38 <chris> cdb-man in your v03.06 row 14 - I guess an example transaction will have fees=$0, stock-value=Dr $100, capgains=Cr $100...
19:45:44 <jralls> Yeah, I'd rip it out if there weren't so many users valiantly struggling to use it.
19:46:40 <chris> CDB-Man: (1) in Row14 I guess the capgains will never have a Debit value
19:47:18 <CDB-Man> right, it wouldnt make sense to distribute a cap loss
19:47:21 <chris> (2) in a regular SELL the capgains is "self-balancing" i.e. it generates two opposing-sign splits
19:47:23 <CDB-Man> well, i've yet to see that anyways
19:47:48 <CDB-Man> row 14 is still self balancing
19:48:12 <CDB-Man> DR Stock $95, DR fees expense $5, CR capgain $100 as an example
19:48:28 <CDB-Man> (i dont expect a fee 99% of the time, including for completeness)
19:48:51 <CDB-Man> row 29, the signs reverse since it's all shorts, but otherwise same principle
19:50:20 <chris> By "self-balancing" I meant that the user can input Any value and the splits will self balance; e.g. in a regular sell, you could have Stock=Cr $100, Cash=Dr $99, Fee=Dr $1, Capgains=Cr $1000000000
19:51:54 <chris> So, to implement ND(Capgain) we'll need to modify the capgains splits logic
19:51:58 <CDB-Man> ah, i see what you mean
19:52:35 <CDB-Man> you're saying this in the context of acb report, right?
19:53:36 <chris> No; in the assistant itself: https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome/assistant-stock-transaction.cpp#L1126
19:53:38 <CDB-Man> because from a binary truth table perspective, you will see ND(cg) is the only example where # shares transacted is zero, but the CG account is impacted
19:54:13 <CDB-Man> wait, stock assistant the CG is a manually entered amount
19:54:42 <chris> see the dividend will call create_split only once; the capgain will call create_split twice
19:54:43 <CDB-Man> if you've selected NDCG from the dropdown, would it be simpler to then just use a stripped down function?
19:55:06 <chris> I just wished to confirm the exact intent before the modification of capgains logic
19:56:10 <CDB-Man> i am not sure i understand the stricture of the current logic (i am not familiar enough with cpp syntax to read it), and I am not sure what you need clarity on right now
19:56:50 <chris> No worries I think all's ok now.
19:57:06 <CDB-Man> the intent of NDCG is CR CG = DR Stock (+ DR fee), basically a cap gain that directly increases your cost basis
19:57:14 <CDB-Man> less any fees that for most instances wont happen
19:57:17 *** ChanServ sets mode: +v NoobAlice
19:57:21 <NoobAlice> Here's another vote in favor of keeping the multi-column income statement and balance sheet reports! :) From the first time I saw them, they have become my most-used reports.
19:57:38 <CDB-Man> i also use multicol BS and IS all the time
19:57:56 <CDB-Man> i have had no complaints in FX thus far
19:58:05 <CDB-Man> after we had fixed the wobble i identified a year ago
19:58:32 <chris> jralls: calling case-exchange-fn currency conversion logic every column would lead to a bad O(N^2) - I'd need to deconstruct the case-exchange-fn to optimise it for multicol reports
19:59:06 <chris> CDB-man you're the one who identified that the fx conversion in multicol was incorrect except for the latest column!
19:59:17 <CDB-Man> and we fixed it i thought
19:59:27 <CDB-Man> im quite sure we fixed it
19:59:55 <CDB-Man> i remember you being "surprised but not surprised" when I told you how I found out -- I make it a point to always run F::Q on Dec 31
20:00:19 <jralls> chris, or cache it for multi-column. But regardless slow is better than broken.
20:00:22 <CDB-Man> on both Dec 31 and Jan 01
20:01:25 <chris> IIRC the last fx fix was - Multicol IS reports should use current period *end* date price rather than next period start date
20:02:21 <CDB-Man> yes. if I am showing 3 I/S for Dec 31, each yar should use the period end rate, ie the rate on Dec 31
20:07:32 <chris> jralls: we could move multicol reports out of experimental for 5.x, there's still a fx warning in the footer. i'll try fix when i can.
20:09:33 <chris> the IFRS report could move into A&L
20:11:14 *** dadwadw has joined #gnucash
20:12:23 <chris> ok gtg soon
20:13:01 <jralls> chris, there's 3 months to release 5.x, so getting those into the next beta in regular menus will help with testing.
21:30:38 *** undoingtech has quit IRC
23:14:30 *** dadwadw has quit IRC
23:15:35 *** dadwadw has joined #gnucash