2020-01-24 GnuCash IRC logs
00:03:06 *** Gerd has quit IRC
00:15:12 *** omnireq_ has quit IRC
00:15:23 *** omnireq_ has joined #gnucash
00:28:29 *** Gerd has joined #gnucash
00:29:16 *** jervin has quit IRC
00:36:12 *** omnireq_ has quit IRC
00:36:25 *** omnireq_ has joined #gnucash
00:54:37 *** Gerd has quit IRC
00:57:42 *** omnireq_ has quit IRC
00:58:02 *** omnireq_ has joined #gnucash
01:00:31 *** jervin has joined #gnucash
01:02:17 *** jervin has quit IRC
01:06:26 *** jervin has joined #gnucash
01:19:12 *** omnireq_ has quit IRC
01:19:24 *** omnireq_ has joined #gnucash
01:21:45 *** Han has quit IRC
01:46:34 *** jervin has quit IRC
01:50:59 *** Mechtilde has quit IRC
01:53:26 *** sbluhm has joined #gnucash
01:57:11 *** sbluhm has quit IRC
02:00:42 *** omnireq_ has quit IRC
02:00:53 *** omnireq_ has joined #gnucash
02:03:10 *** sbluhm has joined #gnucash
02:03:10 *** ChanServ sets mode: +v sbluhm
02:40:14 *** FH_thecat has quit IRC
02:42:12 *** omnireq_ has quit IRC
02:42:23 *** omnireq_ has joined #gnucash
02:53:22 *** daudi has joined #gnucash
03:23:42 *** omnireq_ has quit IRC
03:23:53 *** omnireq_ has joined #gnucash
04:05:42 *** omnireq_ has quit IRC
04:07:10 *** omnireq_ has joined #gnucash
05:14:57 *** jralls_ has joined #gnucash
05:15:55 *** jralls has quit IRC
05:32:52 *** gjanssens has joined #gnucash
05:32:52 *** ChanServ sets mode: +o gjanssens
05:32:57 <gjanssens> .
05:35:40 *** User__ has joined #gnucash
05:49:36 <chris> gjanssens: https://imgur.com/a/PuzzMvc
05:50:13 <chris> now will try splitting LHS payments
05:52:49 <chris> hmm if LHS is a payment, whereby non-APAR splits are of different signs, the splits should be on different columns :-(
05:53:13 *** User__ has quit IRC
05:54:59 <gjanssens> mta's case looks very clear now. The report shows clearly there's an odd payment construct for bill 674 and how all of the other payments got assigned.
05:55:02 <gjanssens> Thanks for that
05:58:21 <chris> now you'll need to construct a book where the payment includes lot-link and awkward payments, and tell me how the rpeort shoudl look :)
06:00:56 <chris> it seems that you have a much better knowledge of the schema, whereas I am better at trial-and-error until it works :)
06:22:13 <chris> gjanssens: problem: if we want to split LHS payments, eg. (80+20) in your test book, I presume we want to show $80 and $20 in their *original* currency, which means they could be EUR50+GBP30 payments into a USD APAR account. so, the debit/credit LHS amounts would NOT cleanly be summable.
06:37:35 <gjanssens> Hmm, that's more tricky indeed :(
06:38:07 <gjanssens> How do you deal with that now ? LHS only uses APAR account details ?
06:38:26 <chris> yes, and RHS invoice->payments will show orig-currency details.
06:38:33 <gjanssens> On the other hand one can already have multiple APAR accounts in different currencies and you present them all at once.
06:38:42 <gjanssens> How do you deal with those ?
06:39:20 <chris> no. the new-owner-report will deal each APAR account separately, each its own table and aging-list
06:39:37 <gjanssens> Oh. That's probably for the best
06:43:21 * gjanssens is pondering...
06:44:51 <gjanssens> Going with the LHS=transactions, RHS= splits, perhaps as a first implementation only split the amounts RHS and keep LHS as sums.
06:45:51 <gjanssens> That means in case of >1 non-APAR split LHS and RHS don't exactly show the same total representation
06:46:08 <gjanssens> But they don't now either.
06:46:57 <gjanssens> By representing the split RHS we still gain a little more detail compared to the current state.
06:47:56 <gjanssens> And we can use the other payment details (date, reference, description) to find a LHS payment's use RHS.
06:48:15 <chris> perhaps Ill merge changes so far then for more widespread testing
06:54:45 <gjanssens> Ok
06:59:13 * chris will still await guidance on complex lot-link txns
07:01:09 * chris and still not 100% sure on 'transfer-split' concept for LHS invoice -> RHS payments amount splits
07:10:05 <chris> so, when it's merged please scrutinise all split html targets and suggest improvements
07:37:11 *** storyjesse has joined #gnucash
07:54:42 *** puck has quit IRC
08:03:19 *** puck has joined #gnucash
08:21:02 *** Farelli_ has quit IRC
08:21:10 *** Farelli_ has joined #gnucash
08:23:42 *** fell has joined #gnucash
08:23:42 *** ChanServ sets mode: +o fell
08:27:12 *** omnireq_ has quit IRC
08:27:23 *** omnireq_ has joined #gnucash
08:28:30 <chris> gjanssens: see https://imgur.com/a/PuzzMvc again
08:34:20 *** parsnip has quit IRC
08:34:28 *** parsnip has joined #gnucash
08:38:25 *** sbluhm has quit IRC
08:46:15 *** immae has quit IRC
08:51:08 <chris> gjanssens: see https://imgur.com/a/PuzzMvc again
08:51:10 <chris> oops
08:51:58 *** immae has joined #gnucash
08:54:01 <gjanssens> chris: that looks very good
08:58:37 <gjanssens> chris: try pasting this in a file and open it in a browser: https://paste.centos.org/view/9173ce17
08:59:03 <gjanssens> The move your mouse cursor over LHS bill 0000002 or the "Adf" payment
08:59:54 <gjanssens> It's about 10 lines of javascript and requires a specific class to be added to each table cell.
09:03:31 <chris> nice. instead of hover, is click-to-toggle possible? because I'd hate scrolling and losing the highlights.
09:03:57 *** dellie__ has joined #gnucash
09:03:58 *** delli3_ has quit IRC
09:05:16 <gjanssens> Yes that should also be possible
09:08:08 <gjanssens> https://paste.centos.org/view/e04b5898
09:08:25 <gjanssens> I have also toned down the highlight color to a neutral light grey
09:08:59 <gjanssens> And I agree using clicks is better considering the overviews can be long.
09:09:55 <gjanssens> The class to add to each td to highlight is 'txn-<guid>', so the guid of the current split's transaction prefixed with 'txn-'
09:11:08 <gjanssens> In addition it requires the inclusion of jquery. I believe we ship a version with gnucash used by charts
09:11:27 * chris was hoping to nuke jquery...
09:11:50 <gjanssens> I thought you wanted to nuke jqplot.
09:11:59 <gjanssens> Isn't chartjs based on jquery as well ?
09:12:02 <chris> a combination of hover and click would be even better
09:12:11 <chris> chartjs? didn't think so
09:12:21 <gjanssens> It's javascript at least
09:12:45 <gjanssens> The code can no doubt be written in javascript as well, but it will be longer
09:13:26 <chris> true. anyway the seed is planted.
09:14:00 *** phoenix has joined #gnucash
09:18:13 *** phoenix has quit IRC
09:32:49 <chris> hmm RHS invoice's "Amount" is designed to be a transfer. but when invoice has multi-entries, not accumulate-splits, and tax, causes a multisplit with 1 APAR, N incomes, and M tax. which one should be the target? or should all splits be included?
09:41:58 <gjanssens> That would be way too much detail IMO. I think that's why I suggested to always use APAR RHS for invoices.
09:48:12 *** omnireq_ has quit IRC
09:49:39 *** omnireq_ has joined #gnucash
09:54:38 <chris> agree.
09:57:13 <chris> will push that change soon. you'll see small misalignment RHS amount bills vs payments. I don't know how to fix this yet.
09:57:38 <chris> once I get some idea how to render lot-links, there will be no more "transfer split" confusion.
09:57:58 <gjanssens> Pure javascript version: https://paste.centos.org/view/145033f1
09:59:23 <chris> \o/
10:01:18 <chris> gtg now
10:05:41 <chris> now I read javascript and my brain tries to optimize into car/cdr to avoid list[n]... :-/
10:09:54 *** jchonig has quit IRC
10:10:02 *** jchonig has joined #gnucash
10:10:23 <gjanssens> chris: for whey you're back: https://paste.centos.org/view/a287c1c4
10:10:40 <gjanssens> No more list[n] stuff but still plenty of for loops :(
10:11:33 <gjanssens> Also this version will remove highlights of all tds before setting a new one to avoid highlighting multiple payments or bills at once.
10:12:35 <gjanssens> Personally I don't really mind about using jquery. It does allow to eliminate the for loops, has many convenience functions and offers better browser support.
10:13:03 <gjanssens> GnuCash itself is based on webkit, but reports can be exported.
10:13:26 <gjanssens> Regardless, pick your favourite and go with that :)
10:26:13 *** fell has quit IRC
10:26:22 *** fell has joined #gnucash
10:26:22 *** ChanServ sets mode: +o fell
10:27:06 *** omnireq_ has quit IRC
10:40:45 *** sbluhm has joined #gnucash
10:40:45 *** ChanServ sets mode: +v sbluhm
10:55:20 *** bertbob has quit IRC
11:00:33 *** bertbob has joined #gnucash
11:00:35 *** ChanServ sets mode: +v bertbob
11:01:28 *** omnireq has joined #gnucash
11:01:28 *** ChanServ sets mode: +v omnireq
11:05:30 *** sbluhm has quit IRC
11:05:38 *** jervin has joined #gnucash
11:07:55 *** Gerd has joined #gnucash
11:10:23 *** fell has quit IRC
11:26:27 *** jervin has quit IRC
11:28:38 *** sbluhm has joined #gnucash
11:46:41 *** jervin has joined #gnucash
11:47:24 *** storyjesse has quit IRC
11:57:53 *** fell has joined #gnucash
11:57:53 *** ChanServ sets mode: +o fell
12:00:07 *** sbluhm has quit IRC
12:06:39 *** Mechtilde has joined #gnucash
12:17:35 *** calvinct has joined #gnucash
12:22:22 *** guak has joined #gnucash
12:28:56 *** calvinct has quit IRC
12:29:06 *** calvinct has joined #gnucash
12:36:11 *** calvinct has quit IRC
12:36:19 *** calvinct has joined #gnucash
12:43:51 *** mauritslamers has joined #gnucash
12:43:51 *** ChanServ sets mode: +v mauritslamers
13:47:41 *** jralls_ is now known as jralls
13:48:02 *** ChanServ sets mode: +o jralls
13:50:19 *** Han has joined #gnucash
14:03:20 *** sbluhm has joined #gnucash
14:03:20 *** ChanServ sets mode: +v sbluhm
14:16:22 *** calvinct has quit IRC
14:29:51 *** frakturfreak has joined #gnucash
14:53:50 *** Gerd has quit IRC
15:09:47 *** Mechtilde has quit IRC
15:30:48 *** Aussie_matt has joined #gnucash
15:40:57 *** daudi has quit IRC
15:44:26 *** KevinDB has quit IRC
15:45:54 *** KevinDB has joined #gnucash
15:45:54 *** ChanServ sets mode: +v KevinDB
15:55:50 *** sbluhm has quit IRC
15:55:51 *** mauritslamers has quit IRC
15:55:51 *** guak has quit IRC
15:55:51 *** dellie__ has quit IRC
15:55:51 *** immae has quit IRC
15:55:51 *** parsnip has quit IRC
15:55:51 *** puck has quit IRC
15:55:51 *** gjanssens has quit IRC
15:55:51 *** o01eg has quit IRC
15:55:51 *** akv has quit IRC
15:55:51 *** lmat has quit IRC
15:55:51 *** KaiForce has quit IRC
15:55:51 *** peter-butler[m] has quit IRC
15:55:51 *** redarrow has quit IRC
15:55:54 *** lmat has joined #gnucash
15:55:57 *** guak has joined #gnucash
15:55:57 *** akv has joined #gnucash
15:55:58 *** parsnip has joined #gnucash
15:56:02 *** immae has joined #gnucash
15:56:03 *** o01eg has joined #gnucash
15:56:04 *** redarrow has joined #gnucash
15:56:07 *** dellie__ has joined #gnucash
15:56:08 *** sbluhm has joined #gnucash
15:56:08 *** ChanServ sets mode: +v sbluhm
15:56:08 *** gjanssens has joined #gnucash
15:56:08 *** ChanServ sets mode: +o gjanssens
15:56:13 *** KaiForce has joined #gnucash
15:56:35 *** mauritslamers has joined #gnucash
15:56:35 *** ChanServ sets mode: +v mauritslamers
15:57:57 *** puck has joined #gnucash
16:01:06 *** peter-butler[m] has joined #gnucash
16:04:58 <warlord> jralls, gjanssens, fell --- I've got a date for my machine-room move. Feb 1. I just sent email about it.
16:08:22 <gjanssens> warlord: good!
16:09:34 *** gjanssens has quit IRC
16:37:47 *** Aussie_matt has quit IRC
16:46:16 *** Han has quit IRC
16:47:27 *** oozer has joined #gnucash
17:29:08 *** sbluhm has quit IRC
17:33:48 *** frakturfreak has quit IRC
17:39:50 *** jervin has joined #gnucash
17:40:29 <jralls> warlord: \o/. I saw the email, I don't have any concerns about the date.
18:21:26 *** lmat has quit IRC
18:37:44 *** KaiForce has quit IRC
19:07:44 *** omnireq has quit IRC
19:24:31 *** lmat has joined #gnucash
19:43:09 *** User__ has joined #gnucash
20:01:51 *** Guest15 has joined #gnucash
20:02:24 <Guest15> how do I add product to the inventory screen in gnucash 3.7
20:02:45 <Guest15> It keeps asking to select a security but won't show anything for that drop down
20:16:26 *** Gerd has joined #gnucash
20:18:15 <Guest15> i am currently installing gnucash 3.8 to see if that makes any difference for entering inventory in
20:18:17 *** omnireq has joined #gnucash
20:31:16 *** oozer has quit IRC
20:38:56 *** Gerd has quit IRC
20:44:43 *** guak has quit IRC
20:56:10 *** warlord has quit IRC
21:17:27 *** warlord has joined #gnucash
21:18:24 *** jervin has joined #gnucash
21:23:03 *** Guest15 has quit IRC
22:12:46 *** User__ has quit IRC
22:16:05 *** Gerd has joined #gnucash
22:26:06 *** jervin has quit IRC
22:26:17 *** jervin has joined #gnucash
22:33:36 *** mauritslamers has quit IRC
22:33:55 *** mauritslamers has joined #gnucash
22:33:55 *** ChanServ sets mode: +v mauritslamers
22:38:35 *** Gerd has quit IRC
22:42:05 <chris> warlord: good luck with move... hopefully everything goes well
22:58:59 *** omnireq_ has joined #gnucash
23:00:11 *** omnireq has quit IRC
23:00:49 *** jervin has quit IRC
23:14:46 *** omnireq_ has quit IRC
23:14:58 *** omnireq_ has joined #gnucash
23:33:35 *** mauritslamers has quit IRC
23:33:47 *** mauritslamers has joined #gnucash
23:33:48 *** ChanServ sets mode: +v mauritslamers
23:41:55 *** Gerd has joined #gnucash