2021-11-23 GnuCash IRC logs

00:09:51 *** frakturfreak1 has joined #gnucash
00:16:59 *** jchonig has quit IRC
00:18:06 *** jchonig has joined #gnucash
00:43:50 *** frakturfreak1 has quit IRC
00:57:27 *** jeff has joined #gnucash
00:58:06 *** frakturfreak1 has joined #gnucash
01:01:31 *** jeff has left #gnucash
01:01:45 *** jeff has joined #gnucash
01:02:31 *** jeff has joined #gnucash
01:03:31 *** jeff has quit IRC
01:04:27 *** Jeff999 has joined #gnucash
01:06:57 *** David has quit IRC
01:07:05 *** David has joined #gnucash
01:24:04 *** frakturfreak1 has quit IRC
01:25:43 *** Jeff999 has quit IRC
01:26:16 *** Jeff999 has joined #gnucash
01:30:02 *** jervin has quit IRC
01:33:30 *** sbluhm has joined #gnucash
01:38:07 *** frakturfreak1 has joined #gnucash
01:46:44 *** jervin has joined #gnucash
01:54:45 *** Jeff999 has quit IRC
01:55:18 *** Jeff999 has joined #gnucash
01:58:47 *** fell has quit IRC
02:00:06 *** fell has joined #gnucash
02:00:07 *** ChanServ sets mode: +o fell
02:44:13 *** Hamaryns has joined #gnucash
02:44:14 *** ChanServ sets mode: +v Hamaryns
02:45:11 *** jervin has quit IRC
03:09:46 *** Hamaryns has quit IRC
03:11:54 <chris> jralls: https://wingolog.org/archives/2008/11/02/guile-bar-mitzvah -- Search for para starting "So it turns out" for background wrt set! -- this is why I removed most traces of it from code...
03:28:25 *** bertbob has quit IRC
03:35:37 *** gjanssens has joined #gnucash
03:35:37 *** ChanServ sets mode: +o gjanssens
03:42:21 <gjanssens> .
03:42:37 *** bertbob has joined #gnucash
03:42:37 *** ChanServ sets mode: +v bertbob
04:10:05 *** Hamaryns has joined #gnucash
04:10:06 *** ChanServ sets mode: +v Hamaryns
04:14:01 *** David has quit IRC
04:14:09 *** David has joined #gnucash
04:25:01 *** jchonig has quit IRC
04:26:08 *** jchonig has joined #gnucash
05:39:51 *** Aussie_matt has joined #gnucash
05:54:18 *** Bambuzel1 has joined #gnucash
05:54:18 *** ChanServ sets mode: +v Bambuzel1
05:54:27 *** Bambuzel2 has joined #gnucash
05:54:27 *** ChanServ sets mode: +v Bambuzel2
05:57:34 <chris> warlord / gjanssens any views on restricting APAR register to enforce readonly? identical to placeholder?
05:58:43 <chris> this inhibits access doclinks which isn't ideal
06:03:19 *** Aussie_matt has quit IRC
06:09:16 <gjanssens> chris: there are transactions that can currently only be modeled by directly manipulating the AR/AP registers. So enforcing read only would be preventing such transactions from being entered correctly
06:10:28 <gjanssens> What would be a good change IMO is to make them read-only by default and require an extra step (a button to click or a menu item to select) to make them editable (for the duration of the current session)
06:10:43 <gjanssens> Or until the register is closed again.
06:11:50 <gjanssens> Clicking the button or selecting the menu item can then pop up a warning to inform the user changing these registers directly is not recommended and done "At Your Own Risk"
06:12:18 <chris> and "there are transactions that can currently only be modeled by directly manipulating the AR/AP registers." contravenes warlord's law of APAR tampering!
06:12:28 <gjanssens> I would even consider the same for placeholder accounts as that would allow users a way to clean up if they made a mistake.
06:13:26 <gjanssens> I know, yet I have been in that very situation in the past... My memory is unfortunately vague on what the situation was back then.
06:14:53 *** User has joined #gnucash
06:15:13 <chris> meanwhile I'm tempted to make new-owner-report wash over these P->I issues and handle them transparently. It'll assume TXN_TYPE_INVOICE & invoice=null to mean a payment.
06:15:56 *** David has quit IRC
06:16:04 *** David has joined #gnucash
06:27:12 <chris> also a non-P and non-I denoted by "?" transaction may also have been modified into P or I by clicking on the ?
06:28:57 <fell> ArtGravity, file a bug with the details.
06:39:06 *** Hamaryns has quit IRC
06:42:17 *** Hamaryns has joined #gnucash
06:42:17 *** ChanServ sets mode: +v Hamaryns
06:58:36 *** Hamaryns has quit IRC
08:01:28 <warlord> chris, there are valid reasons to edit APAR, like editing the auto-split transactions that move value from one lot to another.
08:02:56 <warlord> My rule is that one should not EDIT APAR. *deleting items* from APAR is allowed (and in some cases necessary)
08:23:40 *** addi has joined #gnucash
08:54:22 *** Jimraehl1 has joined #gnucash
08:54:49 *** Jimraehl1 has quit IRC
09:19:29 *** ekleog has quit IRC
09:22:10 *** ekleog has joined #gnucash
10:09:40 *** Bambuzel2 has quit IRC
10:09:48 *** Bambuzel1 has quit IRC
10:36:31 *** sbluhm has quit IRC
10:42:20 <chris> modifying new-owner-report is too difficult.
10:43:21 *** sbluhm has joined #gnucash
10:43:54 <chris> I think these Txn-Type-Invoice with txn->Invoice=NULL should be scrubbed into Txn-Type-Payment
10:52:03 *** Mechtilde has joined #gnucash
10:56:07 *** Mechtilde has quit IRC
10:56:49 *** jervin has joined #gnucash
10:56:57 *** jchonig has quit IRC
10:57:08 *** jchonig has joined #gnucash
10:57:51 *** Mechtilde has joined #gnucash
11:20:57 *** Bambuzel has joined #gnucash
11:20:57 *** ChanServ sets mode: +v Bambuzel
11:21:10 *** Bambuzel has quit IRC
11:28:36 *** mat has joined #gnucash
11:39:54 *** jcarl43 has joined #gnucash
11:39:55 *** ChanServ sets mode: +v jcarl43
11:58:51 <gjanssens> chris: I don't think that's sufficient. If they don't have an invoice, they should have an owner. If they don't, they're invalid business transactions and should be marked Txn-Type-None
11:59:49 *** bertbob has quit IRC
12:00:11 <gjanssens> Other than that, yes scrubbing can be used to ease the situation. At the very minimum it should reset the transaction into a state that can be fixed (meaning either Txn-Type-Payment or Txn-Type-None)
12:00:34 <gjanssens> And it's probably all we really can do.
12:02:31 *** bertbob has joined #gnucash
12:02:31 *** ChanServ sets mode: +v bertbob
12:08:57 *** andreas^ has joined #gnucash
12:08:57 *** ChanServ sets mode: +v andreas^
12:09:36 *** sbluhm has quit IRC
12:11:24 <andreas^> .
12:15:57 <andreas^> I'm not sure what to do anymore.
12:20:50 <andreas^> about this problem. gnucash doesn't save preferences, changing them dirties the book and when I open gnucash no splash screen is displayed and the last opened book is not opened.
12:23:00 <andreas^> even if I just go into preferences and close, the empty book is dirtied.
12:29:44 *** jervin has quit IRC
12:39:20 *** kcin has joined #gnucash
12:46:47 *** fredrik_ has joined #gnucash
12:50:23 *** ChanServ sets mode: +v fredrik_
12:51:12 *** guak has joined #gnucash
12:56:33 <fredrik_> rHello, I am trying to automatically fetch prices to my GnuCash database. Preferably with docker/kubernetes. What is the correct way of connecting to my database using gnucash-cli? Gnucash-cli -Q get.. and then what
12:59:09 <andreas^> even if I just go into preferences and close, the empty book is dirtied.
13:40:39 *** sbluhm has joined #gnucash
13:44:30 *** andreas^ has quit IRC
13:47:43 *** Pegasus_RPG has joined #gnucash
14:45:07 *** jralls has quit IRC
14:47:55 *** jralls has joined #gnucash
14:47:55 *** ChanServ sets mode: +o jralls
15:10:53 *** gjanssens has quit IRC
15:12:45 *** frakturfreak1 has quit IRC
15:25:27 *** frakturfreak1 has joined #gnucash
15:35:01 <jralls> chris, wingo has let his SSL cert expire. As for set! what he says there is also true of cons and append.
15:46:38 *** sbluhm has quit IRC
15:48:23 <jralls> fredrik_ Then the path to your GnuCash data file or the url (starting with mysql: or postgreql: and including the database credentials) if you're using a database server.
15:49:44 <fredrik_> how shoudl i write the url? postgres:ip:port/database/user/pwd? - i dont use standard port
15:54:51 <fredrik_> postgres://user:password@ip-address:port/database did the trick! thanks so much. i just need to dockerise it and get it in my cluster somehow
16:20:37 *** fredrik_ has quit IRC
16:54:14 *** fredrik_ has joined #gnucash
16:55:45 *** ChanServ sets mode: +v fredrik_
16:59:45 *** Jeff999 has quit IRC
17:00:42 *** Jeff999 has joined #gnucash
17:01:18 *** ChanServ sets mode: +v Jeff999
17:03:38 *** Jeff999 has left #gnucash
17:03:45 *** Jeff999 has joined #gnucash
17:03:45 *** ChanServ sets mode: +v Jeff999
17:04:22 <Jeff999> Hi All, hopefully a simple question around Australian GST recording. Following info in Alternate Australian GST setup, what you do with the left over Cents when reporting GST. Examples all use whole dollars. What if I collected 180.30 GST and Paid 120.15 GST, I pay the ATO $60, but I then have $0.15 left over. Do I zero the GST account somehow, so it always shows a new running total? Or just leave it to accumilate? Thanks
17:14:40 *** kcin has quit IRC
17:19:43 *** jcarl43 has quit IRC
17:20:24 *** jcarl43 has joined #gnucash
17:20:24 *** ChanServ sets mode: +v jcarl43
17:47:44 *** storyjesse has joined #gnucash
18:09:27 <fredrik_> is there a way of installing just gnucash-cli? I want to use it in a container. to run docker-cli -Q get command
18:14:17 <fell> Jeff999: In DE I would move it profit:extraordinary:tax rounding
18:50:44 <Jeff999> fell: Thanks, that makes sense. just now stuggling with the amounts seem to be going the wrong way. Just trying to get my head around basic Double Entry accounting. Thanks.
18:52:35 *** guak has quit IRC
18:54:18 *** guak has joined #gnucash
18:58:04 *** User has quit IRC
19:02:53 *** guak has quit IRC
19:02:57 *** guak has joined #gnucash
19:10:59 <jralls> frederik_, Probably not, and certainly not easily.
19:16:24 <jralls> frederick, but you could try building -DWITH_AQBANKING=NO -DWITH_OFX=NO -DWITH_PYTHON=NO. That will leave off some shared libraries.
19:16:46 *** guak1 has joined #gnucash
19:17:11 *** guak has quit IRC
19:17:11 *** guak1 is now known as guak
19:19:21 <fredrik_> i have now a docker image with debian, and installed gnucash 4.4 - it ALMOST works. it just wants my alphavantage key. is there a way to set it from cli?
19:23:25 <jralls> Just set it in the environment: export ALPHAVANTAGE_AKI_KEY=12345678
19:23:35 <jralls> s/AKI/API
19:34:12 <fredrik_> Thank you very much!
19:36:42 <jralls> You're very welcome!
19:47:23 *** jcarl43 has quit IRC
19:51:23 *** guak1 has joined #gnucash
19:51:49 *** guak has quit IRC
19:51:49 *** guak1 is now known as guak
19:58:37 *** jonp has joined #gnucash
19:59:11 *** Guest62 has quit IRC
20:03:06 *** fredrik_ has quit IRC
20:10:31 *** swift110 has joined #gnucash
21:00:21 *** guak has quit IRC
23:05:29 *** PowaBanga has quit IRC
23:06:20 *** Pegasus_RPG has quit IRC
23:13:26 *** storyjesse has quit IRC
23:23:22 *** storyjesse has joined #gnucash
23:37:34 *** PowaBanga has joined #gnucash