2020-01-27 GnuCash IRC logs
00:09:37 *** Gerd has joined #gnucash
00:32:34 *** Gerd has quit IRC
00:52:15 *** Han has joined #gnucash
00:53:06 *** Han__ has quit IRC
01:02:06 *** Mechtilde has joined #gnucash
01:05:13 *** Mechtilde has quit IRC
01:07:38 *** fell has joined #gnucash
01:07:38 *** ChanServ sets mode: +o fell
01:07:54 *** Gerd has joined #gnucash
01:08:10 *** Mechtilde has joined #gnucash
01:09:55 *** fell_laptop has joined #gnucash
01:09:56 *** ChanServ sets mode: +o fell_laptop
01:12:08 *** fell has quit IRC
01:24:22 *** Han has quit IRC
01:30:24 *** Gerd has quit IRC
02:01:29 *** Mechtilde has quit IRC
02:11:32 *** bertbob has quit IRC
02:12:26 *** storyjesse has joined #gnucash
02:14:14 *** bertbob has joined #gnucash
02:14:14 *** ChanServ sets mode: +v bertbob
02:22:23 *** FH_thecat has quit IRC
02:23:39 *** fell has joined #gnucash
02:23:40 *** fell_laptop has quit IRC
02:23:40 *** ChanServ sets mode: +o fell
02:26:04 *** FH_thecat has joined #gnucash
02:53:16 *** sbluhm has joined #gnucash
02:53:17 *** ChanServ sets mode: +v sbluhm
02:58:56 *** crparis has quit IRC
03:01:51 *** christopher has joined #gnucash
03:04:12 *** daudi has joined #gnucash
03:06:26 *** christopher has quit IRC
03:07:19 *** christopher has joined #gnucash
03:16:56 *** Mechtilde has joined #gnucash
03:28:00 *** Han has joined #gnucash
03:33:26 *** daudi has quit IRC
03:34:47 *** Han has quit IRC
03:37:15 *** daudi has joined #gnucash
03:49:01 *** daudi has quit IRC
03:55:27 *** sbluhm has quit IRC
03:55:46 *** sbluhm has joined #gnucash
03:55:46 *** ChanServ sets mode: +v sbluhm
03:56:20 *** daudi has joined #gnucash
03:57:09 <sbluhm> Is there a way to do a "global" account call to download all transactions from all accounts at the same time and ideally in the same list? At the moment, I have to go through all accounts every day and manually pick up the online transactions
03:57:09 <gncbot> sbluhm: Sent 3 weeks, 3 days, and 15 hours ago: <jralls> Thanks, fixed.
03:59:22 *** daudi has quit IRC
04:05:49 *** daudi has joined #gnucash
04:39:16 *** sbluhm has quit IRC
04:56:13 *** User__ has joined #gnucash
04:56:16 *** sbluhm has joined #gnucash
04:56:16 *** ChanServ sets mode: +v sbluhm
05:03:46 *** sbluhm has quit IRC
05:14:08 *** gjanssens has joined #gnucash
05:14:08 *** ChanServ sets mode: +o gjanssens
05:14:20 <gjanssens> .
05:14:20 <gncbot> gjanssens: Sent 7 hours and 17 minutes ago: <chris> from your book I'm still not sure why the lot e27485ddcdeb12b319f42fcda28a6cc4 cannot find its invoice 3a3e5bccd3cdf767b3221b1f428b017b from gncInvoiceGetInvoiceFromLot -- if this is solved then a section goes away
05:14:21 <gncbot> gjanssens: Sent 7 hours and 13 minutes ago: <chris> I'll be able to fix lot-split->posting-split
05:14:22 <gncbot> gjanssens: Sent 6 hours and 47 minutes ago: <chris> found it. look at e27485ddcdeb12b319f42fcda28a6cc4 in .xac - has no gncOwner section !!!
05:14:23 <gncbot> gjanssens: Sent 6 hours and 27 minutes ago: <chris> I'd class it an engine/book bug... to work around it in new-owner-report.scm doesn't seem right
05:14:24 <gncbot> gjanssens: Sent 5 hours and 25 minutes ago: <chris> so, as soon as gncInvoiceGetInvoiceFromLot manages to retrieve invoice-guid from the lot, new-owner-report.scm can work again without the Link payment details :)
05:20:56 *** sbluhm has joined #gnucash
05:20:57 *** ChanServ sets mode: +v sbluhm
05:22:25 <chris> .
05:24:08 <chris> gncInvoiceGetInvoiceFromLot or FromTxn both cannot find it\
05:32:14 <gjanssens> Interesting observation. Let me check...
05:34:33 <chris> https://pastebin.com/raw/RLcnL0vS will show results. vendor-report adfisc, and narrow the date down to 12-08-11
05:36:15 <gjanssens> However that's still weird. Lots with an invoice normally never have an Owner section. Owners are set for lots that don't have invoices.
05:41:57 <chris> it's an engine error right?
05:42:02 <gjanssens> No
05:42:17 <gjanssens> You're looking at the wrong lot
05:42:55 <gjanssens> The lot that's printed by your pk commands and not having an invoice is not e27485ddcdeb12b319f42fcda28a6cc4
05:43:23 * gjanssens is looking further
05:44:33 <gjanssens> Lot e27485ddcdeb12b319f42fcda28a6cc4 is the lot for bill 000007 and it does have an invoice (namely Bill 000007)
05:46:28 *** Jimraehl1 has joined #gnucash
05:47:53 <gjanssens> chris: can I make pk print the lot guid as well ?
05:48:22 <chris> gjanssens: frustratingly, no! gnc-lot-get-guid does not wor from guile
05:52:00 <gjanssens> Ok, I'll add it...
05:55:50 <gjanssens> See https://github.com/gjanssens/gnucash/tree/newvendor
05:56:15 <gjanssens> Where do I add the guile function to print the lot guid now (using gncLotReturnGUID) ?
05:57:20 *** User__ has quit IRC
05:57:21 <chris> (gnc:pk lot (gncLotReturnGUID lot))
05:59:20 <gjanssens> Ok. So the lot containing Bill 00007 is never processed.
05:59:30 <chris> gncInvoiceGetInvoiceFromTxn should also find it, but doesn't.
05:59:35 <gjanssens> You only process the other lot 8a8a2ec5f7f372f9706aa90fe663892f
06:00:34 <gjanssens> That's the lot containing the other split of the lot link transaction, and which is being "overpaid" with the 150 payment.
06:01:19 <gjanssens> So the question is why is lot e27485ddcdeb12b319f42fcda28a6cc4 not being parsed via lot-split->posting-split
06:02:08 <gjanssens> Or in other words why is your original detection algorythm for splits not detecting the bill's apar split at 12/08/11 ?
06:02:34 <chris> well as I mentioned above gncInvoiceGetInvoiceFromLot, and gncInvoiceGetInvoiceFromTxn both return null
06:03:37 <gjanssens> I don't know yet about gncInvoiceGetInvoiceFromTxn, but I'm sure you aren't querying the correct lot in the call to gncInvoiceGetInvoiceFromLot
06:04:13 <gjanssens> In your code you get the lot by calling xaccSplitGetLot on a split
06:04:16 *** KevinDB has quit IRC
06:04:25 <gjanssens> Where does *that* split come from ?
06:04:46 <gjanssens> But first tell me what's wrong with the report that you're digging into this ?
06:05:22 <chris> ok you're right the wrong lot is being queried
06:05:38 *** KevinDB has joined #gnucash
06:05:39 *** ChanServ sets mode: +v KevinDB
06:07:25 <gjanssens> So what is wrong with the report according to you ? It looks ok to me now ?
06:08:01 <gjanssens> (Hmm, I'm still looking at your yesterday's edition, I may have to pull first)
06:09:37 <chris> LHS Bills/Invoices should have RHS Payment or Credit Note. RHS should never have Link. Links are meant to be processed invisibly to find the corresponding Document.
06:10:03 <gjanssens> Ok. True that's the normal case.
06:10:10 <chris> Your Bug797596sample shows how Bill/CN are married up
06:10:32 <chris> No idea how/why LHS Bill 00007 doesn't show RHS CN
06:10:46 <chris> No idea how/why LHS Bill 00007 doesn't show RHS CN, but shows LINK only
06:11:18 <gjanssens> The link appears because it's in a construct that doesn't happen anymore with today's gnucash, but did happen when lots were first introduced
06:11:36 <chris> ah...
06:11:45 <gjanssens> It will not show CN because there *is* no CN for this particular bill (or not any more)
06:12:11 <gjanssens> As it's old style, I agree you don't have to write special report code to cater for it.
06:12:47 <chris> Ok...
06:13:23 <gjanssens> Here's where it is different:
06:13:27 <chris> my vision was that LHS Bill 0007 shows RHS Payment 150EUR, LHS Payment 150EUR shows RHS Bill0007 and Pre-Payment 29EUR
06:14:10 <gjanssens> I understand, but I believe that's very hard to do, particulary as there's an added indirection.
06:14:18 <gjanssens> Let me explain
06:14:42 <gjanssens> It starts with bill 00007, which is in lot e27485ddcdeb12b319f42fcda28a6cc4
06:16:00 <gjanssens> At some point in the past this bill was offset by a Credit note, resulting in the creation of the lot link transaction between the bill's and the cn's lots
06:16:28 <gjanssens> That Credit note has gone by now. I must have unposted it or reused it for something else. I can't remember.
06:16:50 <gjanssens> Older versions of GnuCash didn't clean up the lot link transactions.
06:17:33 <gjanssens> So you could end up with the Bill's lot still being balanced (one split from the Bill, one from the LL transaction that was lingering)
06:18:59 <gjanssens> After unposting the CN, the *other* split of the lotlink (the one originally in the CN lot) would end up in a separate lot. GnuCash would interpret that leg as a prepayment.
06:20:22 <gjanssens> No, not a prepayment really, it's money due, but there is no document linked to that lot so it would be seen as a negative payment (weird stuff...)
06:20:47 <gjanssens> As if the vendor had borrowed you money you had to repay.
06:21:29 <chris> Ok. This old style LINK txn must be processed separately because otherwise it won't show the row at all. So I'll leave it as it is, showing RHS LINKs, and annotate as comments in code to this log.
06:21:43 <gjanssens> Again, I don't see why
06:22:24 <gjanssens> Imagine the following very similar scenario:
06:23:27 <gjanssens> Starting from the posted bill, I overpay it (bill=121, I pay 130)
06:23:41 <gjanssens> That will create a prepayment lot of 9.
06:24:50 <gjanssens> Hang on, I'll make the scenario in a book for you to play with. That'll be easier than writing it all down
06:25:31 <chris> :)
06:31:52 <chris> I'll have a look in bugzilla. Meanwhile I've annotated in my updated branch to illustrate the algorithm with reasonable results.
06:33:45 <chris> gtg now!
06:34:10 *** Han has joined #gnucash
06:48:12 <chris> "Or in other words why is your original detection algorythm for splits not detecting the bill's apar split at 12/08/11" maybe because this APAR split has a lot with no owner
06:52:26 *** Han has quit IRC
07:45:29 <chris> gjanssens: I know why Bill 00007 is not processed. It's lot attached to split 0794283 which is a TXN-TYPE-LINK rather than TXN-TYPE-INVOICE
07:55:22 <chris> the main loop skips them by default - search "not an invoice/payment. skip transaction."
08:01:51 <chris> perhaps I'll rewrite scheme into simple english, and you can compare with your view how they should be processed instead.
08:03:36 <gjanssens> I'm not following really: with your most recent code Bill 000007 is presented LHS. So what do you mean it's not processed ?
08:03:49 <gjanssens> *how*
08:09:39 <chris> ok I'm very confused
08:10:24 <chris> even if the report now runs satisfactorily, I think it has more hacks than it should
08:11:05 <gjanssens> The key difference between a payment and a lot link transaction is that the sum of the APAR splits is non-zero for payment transactions and 0 for lot link splits.
08:11:21 <gjanssens> LHS you present amounts as the sum of the APAR splits.
08:12:03 <gjanssens> Adding lot link transactions LHS doesn't add much, so there's no need to try and do so
08:12:32 <gjanssens> Everything it links (that is the two lots) will eventually show up in different ways
08:13:07 <gjanssens> You will encounter the other splits in the lot link as some point, which will in turn lead to transactions that are worth showing
08:14:16 <gjanssens> So LHS it's perfectly fine to skip over lot link transactions.
08:15:09 <gjanssens> RHS they will appear either in the form of a corresponding credit note/bill or as a payment split (for lots that don't have an invoice)
08:15:44 <gjanssens> Perhaps indeed it would be useful if you transcribe the report logic in plain English for me to review
08:16:07 <gjanssens> Because I'm having difficulty understanding the parts you find hacks.
08:16:22 <gjanssens> Perhaps you *are* doing more complicated things than are needed.
08:16:44 <chris> Ok my main concerns are from make-invoice->payments-table, the code converting LHS invoice/bill into RHS payments-list
08:17:25 <chris> I'll summarise into bug report.
08:18:49 <gjanssens> Ok
08:34:12 <warlord> .
08:34:30 *** KaiForce has joined #gnucash
08:36:08 <gjanssens> chris: I have added more info to bug 797596
08:36:28 <gjanssens> You may have to reload the report before you can add your own comment.
08:37:36 <chris> haha mid-air bug report collision
08:37:51 <chris> I used the term "Pre-Payment" to reuse a string
08:38:11 <chris> sign-reversal issues? yes no doubt there are
08:38:52 <chris> some #t must be changed to #f.... no big deal
08:39:16 <gjanssens> :)
08:44:01 *** chris has quit IRC
08:46:27 *** chris has joined #gnucash
08:46:27 *** ChanServ sets mode: +v chris
08:48:49 <chris> gtg dinner
08:53:52 *** chris_ has joined #gnucash
08:53:52 *** chris has quit IRC
09:35:30 *** chris_ has quit IRC
10:06:11 *** Han has joined #gnucash
10:16:28 *** Han has quit IRC
10:20:46 *** omnireq has quit IRC
10:20:51 *** jervin has joined #gnucash
10:22:01 *** omnireq has joined #gnucash
10:22:01 *** ChanServ sets mode: +v omnireq
10:22:47 *** omnireq has quit IRC
10:32:07 *** Mechtilde has quit IRC
10:38:14 *** jervin has quit IRC
10:58:48 *** keiffer has joined #gnucash
11:04:14 *** omnireq has joined #gnucash
11:04:14 *** ChanServ sets mode: +v omnireq
11:10:54 *** MarkFirewhal has joined #gnucash
11:20:00 *** storyjesse has quit IRC
11:24:39 *** warlord has quit IRC
11:25:54 *** bertbob has quit IRC
11:26:24 *** warlord has joined #gnucash
11:33:10 *** warlord has quit IRC
11:34:32 *** warlord has joined #gnucash
11:38:52 *** jervin has joined #gnucash
11:43:19 *** jervin has quit IRC
11:46:40 *** warlord has quit IRC
11:51:10 *** warlord has joined #gnucash
11:52:20 *** Agfarmer18 has joined #gnucash
11:58:48 *** Agfarmer18 has quit IRC
12:08:55 *** kael has joined #gnucash
12:08:55 *** ChanServ sets mode: +v kael
12:31:27 *** kael has quit IRC
12:32:25 *** kael has joined #gnucash
12:32:25 *** ChanServ sets mode: +v kael
12:33:47 *** Mechtilde has joined #gnucash
12:36:12 *** Gerd has joined #gnucash
12:36:22 *** mauritslamers_ has joined #gnucash
12:36:22 *** ChanServ sets mode: +v mauritslamers_
12:36:55 *** maschinenhans has joined #gnucash
12:37:03 *** mauritslamers has quit IRC
12:37:03 *** mauritslamers_ is now known as mauritslamers
12:37:35 *** guak has joined #gnucash
12:54:46 *** calvinct has joined #gnucash
13:03:39 *** calvinct has quit IRC
13:06:41 *** sbluhm has quit IRC
13:07:45 *** immae has quit IRC
13:23:42 *** homdefer has joined #gnucash
13:24:08 *** homdefer has quit IRC
13:39:02 *** fiddlerwoaroof has quit IRC
14:16:06 *** Gerd has quit IRC
14:19:22 *** sbluhm has joined #gnucash
14:19:22 *** ChanServ sets mode: +v sbluhm
14:32:19 *** frakturfreak has joined #gnucash
14:32:19 *** ChanServ sets mode: +v frakturfreak
15:22:49 *** daudi has quit IRC
15:26:04 *** daudi has joined #gnucash
15:31:26 *** calvinct has joined #gnucash
15:32:35 *** daudi has quit IRC
15:34:14 *** daudi has joined #gnucash
15:45:00 *** daudi has quit IRC
15:46:14 *** daudi has joined #gnucash
15:49:28 *** calvinct has quit IRC
15:50:47 *** Mechtilde has quit IRC
15:54:41 *** keiffer has quit IRC
16:09:44 *** immae has joined #gnucash
16:10:36 *** immae has joined #gnucash
16:26:52 *** sbluhm has quit IRC
16:44:34 <jralls> gjanssens, chris, I just finished hiding the template and implementation classes and pushed to my github repo.
16:47:01 *** bertbob has joined #gnucash
16:47:01 *** ChanServ sets mode: +v bertbob
16:49:49 <gjanssens> Nice :)
16:50:03 <gjanssens> I'll try to review somewhere this week.
16:51:01 *** jralls has quit IRC
16:51:10 *** jralls has joined #gnucash
16:55:30 *** gjanssens has quit IRC
17:02:39 *** frakturfreak has quit IRC
17:17:02 *** oozer has joined #gnucash
17:19:30 *** mauritslamers has quit IRC
17:19:53 *** mauritslamers has joined #gnucash
17:19:53 *** ChanServ sets mode: +v mauritslamers
17:29:27 *** daudi has quit IRC
17:32:25 *** immae has quit IRC
17:38:13 *** omnireq has quit IRC
17:38:23 *** omnireq has joined #gnucash
17:38:23 *** ChanServ sets mode: +v omnireq
17:42:08 *** immae has joined #gnucash
17:49:31 *** mauritslamers has quit IRC
17:49:43 *** mauritslamers has joined #gnucash
17:49:43 *** ChanServ sets mode: +v mauritslamers
18:10:08 *** ChanServ sets mode: +o jralls
18:11:52 *** maschinenhans has quit IRC
18:17:29 *** jralls has quit IRC
18:27:34 *** User__ has joined #gnucash
18:40:04 *** kael has quit IRC
18:58:12 *** jralls has joined #gnucash
19:00:36 *** ChanServ sets mode: +o jralls
19:04:01 *** o01eg has quit IRC
19:04:13 *** o01eg has joined #gnucash
19:06:30 *** omnireq has quit IRC
19:28:40 *** User__ has quit IRC
20:14:16 *** omnireq has joined #gnucash
20:45:27 *** oozer has quit IRC
20:48:11 *** jervin has joined #gnucash
21:12:50 *** mishehu has quit IRC
21:13:23 *** mishehu has joined #gnucash
21:43:48 *** jervin has quit IRC
22:16:57 *** jervin has joined #gnucash
22:33:24 *** jervin has quit IRC
22:37:52 *** Gerd has joined #gnucash
22:41:14 *** guak has quit IRC
23:00:47 *** Gerd has quit IRC
23:32:07 *** nick_ has joined #gnucash
23:40:18 *** Mechtilde has joined #gnucash