2019-12-11 GnuCash IRC logs
00:14:08 *** Gerd has joined #gnucash
00:17:49 *** Mechtilde has joined #gnucash
00:21:02 *** Mechtilde has quit IRC
00:22:54 *** Mechtilde has joined #gnucash
00:25:56 *** Mechtilde has quit IRC
00:33:21 *** jack has joined #gnucash
00:34:01 <jack> Hi
00:34:51 <jack> Error while generating counsomer Report
00:35:13 <jack> that too for a only one particular customer
00:35:19 <jack> kindly help
00:35:48 <jack> An error occurred while running the report.
00:35:52 *** Mechtilde has joined #gnucash
00:38:54 *** Mechtilde has quit IRC
00:40:20 <warlord> jack, anything on the terminal or in the gnucash.trace file?
00:41:06 <jack> gnucash.trace file i hope
00:41:53 *** Gerd has quit IRC
00:44:05 *** jack has quit IRC
00:45:40 *** FH_thecat has joined #gnucash
00:50:55 *** Mechtilde has joined #gnucash
00:52:34 *** frakturfreak has quit IRC
00:53:57 *** Mechtilde has quit IRC
00:55:17 *** jack has joined #gnucash
00:57:40 <jack> Error while generating customer report
00:58:09 <jack> An error occurred while running the report.
00:58:21 <jack> kindly help
00:58:46 <warlord> jack, that's not enough information. is there something in the terminal or trace file?
00:59:15 <jack> idont know
00:59:23 <jack> what is trace file
00:59:36 <jack> or terminal
01:00:28 <jack> i get an error message screen while try to generate report for a particular customer
01:02:27 *** Mechtilde has joined #gnucash
01:05:28 *** Mechtilde has quit IRC
01:11:08 <warlord> See https://wiki.gnucash.org/wiki/Trace_file
01:11:25 *** Mechtilde has joined #gnucash
01:23:44 <jack> OK Thank u
01:23:55 <jack> searching for trace files
01:34:57 <jack> now i got the trace file
01:35:08 <jack> what should i do now
01:59:46 *** Mechtilde has quit IRC
02:09:53 *** pohly has joined #gnucash
03:21:42 *** sbluhm has joined #gnucash
03:21:42 *** ChanServ sets mode: +v sbluhm
03:38:50 *** gjanssens has joined #gnucash
03:38:50 *** ChanServ sets mode: +o gjanssens
03:46:50 *** Mechtilde has joined #gnucash
03:55:01 *** storyjesse has joined #gnucash
04:24:11 *** phoenix has joined #gnucash
04:27:58 *** phoenix_ has joined #gnucash
04:28:13 *** phoenix has quit IRC
04:29:18 *** phoenix_ is now known as phoenix
04:46:46 *** lmat has quit IRC
04:54:07 *** Gerd has joined #gnucash
05:05:33 *** phoenix has quit IRC
05:23:37 *** Mechtilde has quit IRC
05:35:59 *** chris has joined #gnucash
05:35:59 *** ChanServ sets mode: +v chris
05:37:44 <chris> warlord - rethinking the detection of overpayment. new-owner-report and new-aging currently flawed.
05:38:21 <chris> I think it's best to calculate: from payment split, gather the split's transaction's APAR splitlist
05:38:59 <chris> then each APAR split's lot is analysed. if the lot balance is negative, or lot-count-splits = 1, then this is obligatorily an overpayment.
05:39:07 <chris> good?
05:39:28 <chris> because lots shouldn't have negative balance.
05:40:09 <chris> brb 1h
05:40:28 *** chris has quit IRC
05:50:03 *** Gerd has quit IRC
05:51:13 *** storyjesse has quit IRC
05:52:21 *** storyjesse has joined #gnucash
05:54:05 *** lmat has joined #gnucash
06:01:48 *** nick_ has quit IRC
06:21:50 *** chris has joined #gnucash
06:21:50 *** ChanServ sets mode: +v chris
06:27:30 *** Mechtilde has joined #gnucash
06:34:04 *** Jimraehl1 has joined #gnucash
06:36:49 *** Jimraehl1 has quit IRC
06:38:06 *** jack has quit IRC
06:47:53 <chris> basically using gnc-lot to search invoice->payments and payment->invoices is very straightforward...
07:31:31 <gjanssens> chris: welcome in the business logic
07:32:47 *** puck has quit IRC
07:34:52 *** puck has joined #gnucash
07:38:02 *** puck has quit IRC
07:40:15 *** puck has joined #gnucash
07:42:57 *** User__ has joined #gnucash
07:43:23 <chris> yes -- new-business-reports don't currently use gnc-lot API as much as they should
07:43:54 <chris> now I know that the gnc-lot API is very reliable I will probably rewrite some functions but will first try design tests
07:45:20 <chris> but first I need to confirm my observation that "lot-balance = negative" is a good way, not necessarily 100% intended, to detect that a payment-split is unattached
08:02:15 *** maschinenhans has joined #gnucash
08:12:15 <gjanssens> I think the only reliable way is to get the payment's lot and check whether the lot has an invoice attached to it
08:13:32 <gjanssens> There's no convenience function for this, you'll have to use the equivalent of the C function qof_instance_get (QOF_INSTANCE (lot), "invoice", &guid, NULL) instead or add a convenience function.
08:14:12 *** maschinenhans has quit IRC
08:16:00 <chris> or (gncInvoiceGetInvoiceFromLot lot)
08:16:25 <chris> ... is exactly what you wrote from memory
08:16:53 <chris> :-o
08:18:38 <gjanssens> Right! I couldn't find it from my memory :(
08:21:12 *** fell has joined #gnucash
08:21:12 *** ChanServ sets mode: +o fell
08:26:48 <chris> thanks gjanssens that did it
08:28:52 <gjanssens> You're welcome
08:29:34 <gjanssens> The reason negative lot balance is not reliable is because you can also have refunds (reverse payments) and credit notes (reverse invoices)
08:30:28 <gjanssens> If you have entered a refund for a customer without having a related credit note (yet) the lot balance will be positive.
08:31:48 <chris> I'll try finalise and test more combinations of business txns over next few days... it may not be completely ready for 3.8 because I'll be spending xmas in
08:32:00 <chris> (drumroll) .cx :-)
08:35:11 <gjanssens> Had to look that country code up. Hilarious :D
08:46:40 *** jervin has joined #gnucash
08:57:42 *** jervin has quit IRC
09:05:06 *** oozer has joined #gnucash
09:23:34 *** oozer has quit IRC
09:29:03 *** User__ has quit IRC
09:31:36 *** Gerd has joined #gnucash
10:12:28 *** Gerd has quit IRC
10:31:43 *** omnireq has quit IRC
10:31:55 *** storyjesse has quit IRC
10:35:01 *** kael has joined #gnucash
10:35:02 *** ChanServ sets mode: +v kael
10:41:57 *** sbluhm has quit IRC
10:43:04 *** waeking has quit IRC
10:44:09 *** waeking has joined #gnucash
10:44:09 *** ChanServ sets mode: +v waeking
10:53:41 *** waeking has quit IRC
10:54:14 *** waeking has joined #gnucash
10:54:14 *** ChanServ sets mode: +v waeking
10:58:00 *** Gerd has joined #gnucash
11:11:04 *** waeking has quit IRC
11:13:29 *** waeking has joined #gnucash
11:13:29 *** ChanServ sets mode: +v waeking
11:15:06 *** Mechtilde has quit IRC
11:19:55 *** omnireq has joined #gnucash
11:29:24 *** guak has joined #gnucash
11:29:45 *** omnireq has quit IRC
11:32:01 *** kael1 has joined #gnucash
11:32:01 *** kael has quit IRC
11:32:02 *** ChanServ sets mode: +v kael1
11:32:02 *** kael1 is now known as kael
11:33:19 *** TownsendHardware has joined #gnucash
11:35:01 *** kael has quit IRC
12:29:24 *** kael has joined #gnucash
12:29:25 *** ChanServ sets mode: +v kael
12:29:31 *** Han has joined #gnucash
12:32:51 *** kael has quit IRC
12:33:22 *** User has joined #gnucash
12:47:51 *** Mechtilde has joined #gnucash
13:00:00 *** pohly has quit IRC
13:00:17 *** User has quit IRC
13:03:39 *** oozer has joined #gnucash
13:34:08 *** pohly has joined #gnucash
13:39:31 *** pohly has quit IRC
13:50:21 *** monkeyjuice has joined #gnucash
13:51:28 *** omnireq has joined #gnucash
13:51:28 *** ChanServ sets mode: +v omnireq
13:58:39 *** sbluhm has joined #gnucash
13:58:39 *** ChanServ sets mode: +v sbluhm
14:02:01 *** calvinct has joined #gnucash
14:03:13 *** Han_ has joined #gnucash
14:04:24 *** Gerd has quit IRC
14:04:28 *** Han has quit IRC
14:10:49 *** guak has quit IRC
14:11:02 *** Han_ has quit IRC
14:13:47 *** guak has joined #gnucash
14:18:34 *** frakturfreak has joined #gnucash
14:21:47 *** omnireq has quit IRC
14:24:57 *** kael has joined #gnucash
14:24:58 *** ChanServ sets mode: +v kael
14:27:20 *** FH_thecat has quit IRC
14:53:15 *** waeking has quit IRC
14:53:47 *** waeking has joined #gnucash
14:53:47 *** ChanServ sets mode: +v waeking
15:10:18 *** fell has quit IRC
15:16:15 *** gjanssens has quit IRC
15:18:52 *** oozer has quit IRC
15:27:36 *** oozer has joined #gnucash
15:36:08 *** waeking has quit IRC
15:37:29 *** waeking has joined #gnucash
15:37:29 *** ChanServ sets mode: +v waeking
15:56:24 *** sbluhm has quit IRC
15:57:02 *** sbluhm has joined #gnucash
16:02:33 *** fell has joined #gnucash
16:02:33 *** ChanServ sets mode: +o fell
16:11:44 *** calvinct has quit IRC
16:18:28 *** Gerd has joined #gnucash
16:30:03 *** waeking has quit IRC
16:30:38 *** waeking has joined #gnucash
16:30:38 *** ChanServ sets mode: +v waeking
16:40:45 *** kael has quit IRC
16:46:06 *** Mechtilde has quit IRC
16:52:37 *** waeking has quit IRC
16:53:42 *** waeking has joined #gnucash
16:53:42 *** ChanServ sets mode: +v waeking
17:06:01 *** frakturfreak has quit IRC
17:11:13 *** kael has joined #gnucash
17:11:13 *** ChanServ sets mode: +v kael
17:14:17 *** nick_ has joined #gnucash
17:14:25 *** nick_ is now known as nick
17:17:55 *** nick is now known as ngner
17:24:18 *** calvinct has joined #gnucash
17:31:09 *** calvinct has quit IRC
17:50:57 *** oliver has quit IRC
17:52:40 *** oliver has joined #gnucash
17:57:03 *** sbluhm has quit IRC
17:58:18 *** Gerd has quit IRC
18:24:28 *** kael has quit IRC
18:34:48 *** ngner has quit IRC
18:34:50 *** ngner has joined #gnucash
19:02:58 <chris> do we want the budget report to display and sort by account codes to complete 797489?
19:21:00 *** ngner has quit IRC
19:35:46 <fell> Chris, how about sorting by clicking column headers?
19:36:44 <fell> Yes, at least for business account templates sorting by account numbers is common.
19:41:41 *** jervin has joined #gnucash
19:48:14 *** jervin has quit IRC
19:48:29 *** jervin has joined #gnucash
19:51:34 *** alecostabr has joined #gnucash
20:04:43 *** jervin has quit IRC
20:16:29 *** omnireq has joined #gnucash
21:03:06 *** alecostabr has quit IRC
21:22:40 *** User has joined #gnucash
21:25:35 *** jervin has joined #gnucash
21:31:22 *** User has quit IRC
21:45:10 *** oozer has quit IRC
21:45:59 *** asdf has joined #gnucash
21:47:00 <asdf> android 2.4.0
21:47:33 *** guak has quit IRC
21:47:50 <asdf> new to GnuCash, should I just use the desktop version?
21:51:24 *** omnireq has quit IRC
21:51:31 *** asdf has quit IRC
22:17:22 *** asdf has joined #gnucash
22:43:08 *** oliver has quit IRC
22:44:51 *** oliver has joined #gnucash
22:46:32 <asdf> ok, after trying it out some more... the android version is broken in some spectacularly stupid fashion.
22:48:51 <asdf> it changed my values or something, numbers from nowhere
22:53:45 *** fell has quit IRC