2019-11-01 GnuCash IRC logs

00:38:39 *** gggg has joined #gnucash
01:21:58 *** JayC has joined #gnucash
01:21:58 *** ChanServ sets mode: +v JayC
01:26:15 *** fell has joined #gnucash
01:26:16 *** ChanServ sets mode: +o fell
01:26:17 *** fell has quit IRC
01:39:46 *** storyjesse has joined #gnucash
01:41:32 *** gggg_ has joined #gnucash
01:42:08 *** gggg_ has quit IRC
01:47:59 *** Gerd has joined #gnucash
01:52:54 *** gggg has quit IRC
02:10:29 *** Gerd has quit IRC
03:01:13 *** mauritslamers has quit IRC
03:24:35 *** ECDHE_RSA_AES256 has joined #gnucash
03:25:12 *** ecdhe has quit IRC
04:13:17 *** sbluhm has joined #gnucash
04:13:17 *** ChanServ sets mode: +v sbluhm
04:15:00 *** jralls has quit IRC
04:15:44 *** jralls has joined #gnucash
04:15:44 *** ChanServ sets mode: +o jralls
04:48:16 *** sbluhm has quit IRC
04:55:23 *** sbluhm has joined #gnucash
04:55:23 *** ChanServ sets mode: +v sbluhm
05:13:44 *** storyjesse has quit IRC
05:17:31 *** udayds has joined #gnucash
05:18:22 *** sfthex has joined #gnucash
05:18:35 *** udayds has quit IRC
05:19:23 *** sfthex has quit IRC
05:24:05 *** pohly has joined #gnucash
06:10:51 <chris> jralls: number-range - balance-forecast could have any gtk control you like, all it needs is a number input, see which one you like best
06:20:48 <chris> i'm not familiar with all gtk controls
07:02:07 *** oozer has joined #gnucash
07:21:16 *** omnireq_ has joined #gnucash
07:22:28 *** omnireq has quit IRC
07:50:48 *** fabior has joined #gnucash
08:03:36 *** fabior has quit IRC
08:29:12 *** jervin has joined #gnucash
08:34:13 *** User_ has joined #gnucash
08:37:18 *** boldstripe has joined #gnucash
08:44:32 *** jervin has quit IRC
08:45:38 *** sbluhm has quit IRC
08:54:46 *** boldstripe has quit IRC
09:25:12 *** phoenix has joined #gnucash
09:30:50 *** User_ has quit IRC
09:32:01 *** boldstripe has joined #gnucash
10:07:09 *** mauritslamers has joined #gnucash
10:09:45 *** mauritslamers has quit IRC
10:13:40 *** phoenix has quit IRC
10:23:12 *** jervin has joined #gnucash
10:24:32 *** mauritslamers has joined #gnucash
10:24:32 *** ChanServ sets mode: +v mauritslamers
10:30:17 *** mauritslamers has quit IRC
10:32:31 *** gggg has joined #gnucash
10:37:14 *** omnireq_ has quit IRC
10:38:31 *** jervin has quit IRC
10:50:42 *** ArtGravity has joined #gnucash
10:50:42 *** ChanServ sets mode: +v ArtGravity
10:54:55 *** kael has joined #gnucash
10:54:55 *** ChanServ sets mode: +v kael
10:56:58 *** mauritslamers has joined #gnucash
10:56:58 *** ChanServ sets mode: +v mauritslamers
11:05:32 *** mauritslamers has quit IRC
11:05:51 *** mauritslamers has joined #gnucash
11:05:51 *** ChanServ sets mode: +v mauritslamers
11:10:41 *** mauritslamers has quit IRC
11:13:17 *** omnireq has joined #gnucash
11:13:17 *** ChanServ sets mode: +v omnireq
11:13:59 *** kael has quit IRC
11:26:21 *** mauritslamers has joined #gnucash
11:26:22 *** ChanServ sets mode: +v mauritslamers
11:26:46 *** guak has joined #gnucash
11:36:17 *** kriesel has joined #gnucash
11:36:26 *** Jimraehl1 has joined #gnucash
11:36:41 *** mauritslamers has quit IRC
11:39:13 *** Jimraehl1 has quit IRC
11:43:07 *** kriesel has quit IRC
11:56:41 *** storyjesse has joined #gnucash
12:25:03 *** jervin has joined #gnucash
12:26:36 *** jervin has quit IRC
12:27:35 *** pohly has quit IRC
12:38:32 *** storyjesse has quit IRC
12:49:43 *** kriesel has joined #gnucash
12:56:22 *** boldstripe has quit IRC
12:57:16 *** boldstripe has joined #gnucash
13:00:07 *** kriesel has quit IRC
13:00:22 *** kriesel has joined #gnucash
13:00:36 *** kriesel has quit IRC
13:20:06 *** boldstripe has quit IRC
13:21:03 *** boldstripe has joined #gnucash
13:34:20 *** phoenix has joined #gnucash
13:35:40 *** calvinct has joined #gnucash
13:50:24 *** fabior has joined #gnucash
14:09:07 *** fabior has quit IRC
14:17:04 <jralls> karelk: How about "SELECT t.post_dat, t.description, s.value_num, s.value_denominator FROM splits as s, transactions as t, accounts as a WHERE s.account_guid = a.guid AND s.tx_guid = t.guid AND a.account_type = 'EXPENSE' AND t.post_date >= '2019-10-01 00:00:01' AND t.post_date <= '2019-10-31 23:59:59'; ? Note that value is a rational number, value_num/value_denominator. If you want to total them copy the result into a spreadsheet to convert to dec
14:17:05 <jralls> imal and sum.
14:17:30 <jralls> karelk s/t.post_dat/t.post_date/
14:20:07 <jralls> chris: OK, I think we probably want the balance forecast report reserve and target to be gnc_numerics and to have an entry that reads them.
14:21:58 *** phoenix has quit IRC
14:22:31 *** phoenix has joined #gnucash
14:33:57 *** sbluhm has joined #gnucash
14:33:58 *** ChanServ sets mode: +v sbluhm
14:48:08 *** bertbob has quit IRC
14:50:37 *** bertbob has joined #gnucash
14:50:39 *** ChanServ sets mode: +v bertbob
15:06:23 *** frakturfreak has joined #gnucash
15:06:24 *** ChanServ sets mode: +v frakturfreak
15:19:09 *** calvinct has quit IRC
15:19:37 *** gggg has quit IRC
15:38:18 *** waeking has joined #gnucash
15:38:18 *** ChanServ sets mode: +v waeking
15:40:44 *** kael has joined #gnucash
15:40:45 *** ChanServ sets mode: +v kael
15:43:40 *** User_ has joined #gnucash
15:51:13 *** User_ has quit IRC
15:59:20 *** JayC has quit IRC
16:25:14 *** jervin has joined #gnucash
16:50:21 *** sbluhm has quit IRC
16:52:11 *** sbluhm has joined #gnucash
16:52:11 *** ChanServ sets mode: +v sbluhm
16:55:11 *** sbluhm has quit IRC
16:55:13 *** kael has quit IRC
17:12:05 *** gjanssens has joined #gnucash
17:12:06 *** ChanServ sets mode: +o gjanssens
17:22:17 *** User_ has joined #gnucash
17:27:15 *** User_ has quit IRC
17:37:36 *** phoenix has quit IRC
17:39:02 <gjanssens> .
18:04:53 *** gjanssens has quit IRC
18:05:21 *** frakturfreak has quit IRC
18:19:39 <ArtGravity> Has anyone ever seen gnucash lose everything except the chart of accounts layout?
18:31:52 *** jervin has quit IRC
18:32:06 *** jervin has joined #gnucash
18:43:06 *** jervin has quit IRC
18:46:00 <ArtGravity> NM, I'm pretty sure its a mysql problem, not gnucash itself
18:53:44 *** omnireq has quit IRC
19:09:26 *** Cork has quit IRC
19:13:05 *** Cork has joined #gnucash
19:16:07 *** waeking6 has joined #gnucash
19:16:07 *** ChanServ sets mode: +v waeking6
19:17:36 *** waeking has quit IRC
19:17:37 *** waeking6 is now known as waeking
19:30:49 *** boldstripe has quit IRC
19:48:04 *** Gerd has joined #gnucash
19:51:36 *** omnireq has joined #gnucash
20:37:08 *** thechitowncubs has joined #gnucash
20:37:25 <thechitowncubs> How do you skip to the next transaction field when categorizing transactions?
20:37:30 <thechitowncubs> without the mouse
20:42:46 *** john_ has joined #gnucash
20:44:01 *** thechitowncubs has quit IRC
20:45:43 *** oozer has quit IRC
20:55:42 *** Gerd has quit IRC
21:12:31 *** john_ has quit IRC
21:15:20 *** guak has quit IRC
22:03:44 <karelk> jralls: thanks, that works. Only needed to change "s.value_denominator" to "s.value_denom"
22:21:07 *** peanutbutterandcrackers has joined #gnucash
22:21:07 *** ChanServ sets mode: +v peanutbutterandcrackers
22:22:16 <peanutbutterandcrackers> Hello there, I am quite new to guile; but I hope to create a guile extension to gnucash which would automate daily invoicing for the customers of a small business
22:22:55 <peanutbutterandcrackers> It would be much like a spreadsheet but it will work with the invoicing and payment modules of gnucash
22:23:37 <peanutbutterandcrackers> And I hope to make it something that is a 'tool' rather than a 'custom report'. A 'tool' much like 'process payment' etc.
22:24:30 <peanutbutterandcrackers> Any pointers, ideas, etc please? I am pretty new to guile and don't know much about C.
22:27:53 <peanutbutterandcrackers> A bit more explanation: My parents farm sells milk every morning and evening. Some customers pay in cash while some in credit. There are about ~30 customers. And it is really boring to go through each one of them in the customer list and add an invoice and a payment (if they made one) at the end of the day... not to mention error-prone
22:30:43 <peanutbutterandcrackers> I did write a python script to automate things but that, too, isn't the most convenient solution. The most convenient solution would be to implement a tool in gnucash much like Business->Customers->"Customer Overview" except there'll be fields there (spreadsheet-like) that will take how much a customer took. This will act as a front-end, and will trigger the necessary invoices/payments as well.
22:31:59 <peanutbutterandcrackers> I hope to write it in guile itself and have it as something accessible from the menu like Tools->Custom->"Daily Invoicing" (or something) and hide the details so that even non-technical people (my parents) can use it
22:32:59 <peanutbutterandcrackers> (The current gnucash-python requires a .ods created from a particular .odt to be exported as a .csv and called upon with a python script via the command line... it's not the most user-friendly of solutions)
22:52:56 *** ArtGravity has quit IRC
23:16:01 *** waeking5 has joined #gnucash
23:16:01 *** ChanServ sets mode: +v waeking5
23:17:34 *** waeking has quit IRC
23:17:34 *** waeking5 is now known as waeking