2020-06-25 GnuCash IRC logs

00:14:09 *** dtux has quit IRC
00:14:35 *** dtux has joined #gnucash
00:24:37 *** Mechtilde has joined #gnucash
00:30:11 *** jralls_laptop has joined #gnucash
00:42:35 *** jervin has quit IRC
01:26:12 *** sbluhm has joined #gnucash
01:29:00 *** tomjebo has joined #gnucash
01:32:02 *** dtux has quit IRC
01:42:48 *** tomjebo has quit IRC
01:43:54 *** o01eg has joined #gnucash
01:45:14 *** Simon has quit IRC
01:47:38 *** Simon has joined #gnucash
01:47:38 *** ChanServ sets mode: +v Simon
02:03:53 *** CDB-Work has quit IRC
02:07:45 *** Mechtilde has quit IRC
02:11:10 *** dtux has joined #gnucash
02:13:41 *** David has quit IRC
02:13:45 *** David has joined #gnucash
02:29:51 *** chris1 has quit IRC
02:54:19 *** gjanssens has joined #gnucash
02:54:20 *** ChanServ sets mode: +o gjanssens
02:58:43 <gjanssens> .
02:58:43 <gncbot> gjanssens: Sent 4 hours and 13 minutes ago: <chris> re:guile-3 add (gnc:pk 'not-record: obj) in html-document#L309 - looks like monetary-objects are not recognized as records anymore.
03:11:47 <gjanssens> chris: I have added the output of a test run with gnc:pk in the PR
03:16:12 *** suukim has joined #gnucash
03:16:50 *** Mechtilde has joined #gnucash
03:43:35 *** Mechtilde has quit IRC
03:57:53 *** Mechtilde has joined #gnucash
04:15:26 *** fell has joined #gnucash
04:15:26 *** ChanServ sets mode: +o fell
04:27:03 *** dtux has quit IRC
05:03:21 *** User has joined #gnucash
05:09:30 *** Hamaryns has joined #gnucash
05:09:30 *** ChanServ sets mode: +v Hamaryns
05:26:57 *** Aussie_matt has quit IRC
05:35:00 *** Hamaryns has quit IRC
05:38:56 *** flips has quit IRC
05:45:55 *** Hamaryns has joined #gnucash
05:45:55 *** ChanServ sets mode: +v Hamaryns
06:08:20 <Hamaryns> hi all, just installed 3.10 via flatpak in Linux Mint, but it cannot find my external usb hard drive, even though I can see it in the file manager. Any idea?
06:08:20 <gncbot> Hamaryns: Sent 21 weeks, 1 day, 2 hours, and 15 minutes ago: <sbluhm> before I switched to libdbd, I used Gnucash (v2) exclusively via cifs and never had any significant issues (apart from the general performance back then). So it definetely used to work.
06:33:49 *** cryptoasker has joined #gnucash
06:34:41 <cryptoasker> Hello. I spent some time trying to configuring gnucash to fetch cryptocurrencies prices, but with no luck
06:34:56 <cryptoasker> i followed the suggestion on reddit https://www.reddit.com/r/GnuCash/comments/eixe0e/gnucash_to_include_cryptocurrency_assets/fcu2hnk/
06:35:34 <cryptoasker> But after installing everything, i don't seem to be able to fetch crypto prices
06:37:37 <cryptoasker> the security editor only allow me to add AMEX, EUREX etc, but nothing more. I correctly added my API key and installed Finance::Quote, but i'm stuck there. Any hint of what i am doing wrong?
06:38:51 <cryptoasker> If i try `gnc-fq-dump -v alphavantage BTC` i get This stock quote cannot be used by GnuCash! but i can retrieve the BTC price using the browser and my API key just fine
06:44:19 *** Hamaryns has quit IRC
07:08:08 <cryptoasker> Doesn't matter what i do, but i don't seem to be able to fetch any stock, only currencies ;/
07:13:19 <cryptoasker> Ok, i managed to have `gnc-fq-dump` showing the BTC price, but i still cannot get gnucash to work with cryptocurrencies
07:39:41 *** nspain has joined #gnucash
07:50:35 <gjanssens> @tell Hamaryns Flatpak limits the file system locations you are allowed to access by default. The way to work around this is to call 'sudo flatpak override org.gnucash.GnuCash --filesystem=<path-to-your-usb>'.
07:50:35 <gncbot> gjanssens: The operation succeeded.
07:53:59 *** Hamaryns has joined #gnucash
07:53:59 *** ChanServ sets mode: +v Hamaryns
07:57:38 *** cryptoasker has quit IRC
08:15:40 *** sbluhm has quit IRC
08:16:28 *** sbluhm has joined #gnucash
08:16:28 *** ChanServ sets mode: +v sbluhm
08:17:09 *** sbluhm has quit IRC
08:18:07 *** sbluhm has joined #gnucash
08:18:07 *** ChanServ sets mode: +v sbluhm
08:29:50 *** flips has joined #gnucash
08:29:51 *** ChanServ sets mode: +v flips
08:49:54 *** Jimraehl1 has joined #gnucash
08:52:17 *** Jimraehl1 has left #gnucash
09:22:48 *** Hamaryns has quit IRC
09:48:02 *** dean has joined #gnucash
09:48:14 *** Hamaryns has joined #gnucash
09:48:14 *** ChanServ sets mode: +v Hamaryns
10:00:07 *** sbluhm has quit IRC
10:02:15 *** Mechtilde has quit IRC
10:17:05 *** Mechtilde has joined #gnucash
10:20:17 *** Mechtilde has quit IRC
10:28:05 *** Mechtilde has joined #gnucash
10:39:19 *** Hamaryns has quit IRC
10:43:58 *** sbluhm has joined #gnucash
10:50:19 *** ArtGravity has joined #gnucash
10:50:19 *** ChanServ sets mode: +v ArtGravity
10:57:47 *** kael has joined #gnucash
10:57:47 *** ChanServ sets mode: +v kael
11:12:30 *** storyjesse has quit IRC
11:13:12 *** storyjesse has joined #gnucash
11:18:47 *** Mechtilde has quit IRC
11:23:05 *** omnireq has joined #gnucash
11:26:00 *** guak has joined #gnucash
11:31:21 *** dean has quit IRC
11:35:58 *** dtux has joined #gnucash
11:41:14 *** Agfarmer18 has joined #gnucash
11:51:12 *** TownsendHardware has joined #gnucash
11:55:01 *** angel has joined #gnucash
12:13:10 *** guak has quit IRC
12:13:58 *** guak has joined #gnucash
12:20:56 *** Agfarmer18 has quit IRC
12:27:55 *** suukim has quit IRC
12:28:48 *** angel has quit IRC
12:40:28 *** storyjesse has quit IRC
12:52:46 *** CDB-Work has joined #gnucash
12:52:46 *** ChanServ sets mode: +v CDB-Work
12:54:28 *** sbluhm has quit IRC
12:54:53 <jralls> cryptotasker: Alphavantage has different APIs for government currencies and cryptocurrencies. AFAIK Finance::Quote does not have code to query the latter.
12:56:48 <jralls> FH_thecat: No, you can't remove columns from the register display, nor is it likely that we'll change that any time soon. You can resize the column to 1 px so that it doesn't take up screen space but that won't do anything for tabbing except make the cursor disappear, which you might find confusing.
13:01:29 *** User has quit IRC
13:17:59 *** Mechtilde has joined #gnucash
13:20:25 *** Hamaryns has joined #gnucash
13:20:25 *** ChanServ sets mode: +v Hamaryns
13:34:15 *** Agfarmer18 has joined #gnucash
13:34:59 *** sbluhm has joined #gnucash
13:34:59 *** ChanServ sets mode: +v sbluhm
13:44:24 *** Hamaryns has quit IRC
13:46:07 *** Agfarmer18 has quit IRC
13:51:28 *** Mechtilde has quit IRC
14:05:12 *** Mechtilde has joined #gnucash
14:06:26 *** dtux has quit IRC
14:07:13 *** dtux has joined #gnucash
14:33:02 *** frakturfreak has joined #gnucash
14:34:37 *** ramontjunior has quit IRC
14:35:33 *** David has quit IRC
14:35:37 *** David has joined #gnucash
14:36:59 *** Hamaryns has joined #gnucash
14:36:59 *** ChanServ sets mode: +v Hamaryns
14:50:56 *** Hamaryns has quit IRC
15:07:53 *** keiffer has quit IRC
15:25:59 *** Mechtilde has quit IRC
15:30:12 *** User has joined #gnucash
15:34:13 <jralls> warlord gjanssens fell What's the URL for the beta website?
15:35:51 <warlord> Hmm....
15:36:28 <jralls> Uh-oh.
15:39:24 <warlord> I am trying to find the code that pushes that.
15:39:50 <warlord> Ah, try www.gnucash.org/beta ?
15:40:08 <warlord> Nope, that's not it.
15:40:14 <warlord> it's possible that there is none?
15:40:19 <warlord> Or we need to ask linas
15:42:06 <jralls> Maybe it's in the gitorious scripts.
15:47:06 <warlord> I looked; all it does is contact www.gnucash.org to pull the update.
15:47:07 <jralls> warlord, gitolite's post-receive hook calls $HOME/bin/update-website-beta but that script isn't in the gitolite repo nor the gnucash-htdocs one.
15:47:31 <warlord> right; because it's a port-knocker on Linas; having that visible would be a "security threat"
15:49:22 <jralls> So it would, but it's not. Only you can see the script. But the port-knocker is better because linas can reconfigure his server without having to worry about externals.
15:50:11 <warlord> he and I just need to agree on the "knock" ;)
15:50:57 <jralls> Found it in the wiki. You were close, it's https://www.gnucash.org/beta/. The trailing slash apparently matters.
15:52:06 <warlord> Ah, so it doesn.
15:52:08 <warlord> does
16:10:45 *** psmst has quit IRC
16:16:16 *** psmst has joined #gnucash
16:30:21 *** Agfarmer18 has joined #gnucash
16:31:29 <jralls> fell, gjanssens, I'm inclined to drop Russian from the docs for 4.0. The translator only got through the first three chapters before losing interest.
16:34:19 *** Agfarmer18 has quit IRC
16:47:33 *** kael has quit IRC
16:49:31 *** kael has joined #gnucash
16:49:31 *** ChanServ sets mode: +v kael
16:51:14 <gjanssens> jralls: ok with me.
16:52:23 *** gjanssens has quit IRC
16:53:14 <jralls> gjanssens, I've written a new-features segment to be a bit less stilted than the release notes, intended for the web site. Do you think it would work better on the home page or the features page?
16:56:50 *** User has quit IRC
17:04:48 *** lmat has quit IRC
17:05:41 *** frakturfreak has quit IRC
17:27:02 *** cira has joined #gnucash
17:27:02 *** ChanServ sets mode: +v cira
17:48:20 *** sbluhm has quit IRC
17:58:47 *** jervin has joined #gnucash
18:09:16 <cira> hello. I've been playing with the Trading accounts in 3.906
18:13:33 <cira> I create a trading account with a custom currency, then create a transaction depositing an amount in the new currency.
18:15:16 <cira> GnuCash adds balancing entries from the Trading hierarchy, and I add a credit to finish balancing the transaction.
18:16:18 <cira> I look at the transaction and it seems balanced, but every split has the little square with the x in it.
18:16:30 *** kael has quit IRC
18:16:33 *** kael has joined #gnucash
18:16:33 *** ChanServ sets mode: +v kael
18:16:38 *** jervin has quit IRC
18:17:40 <cira> After exploring the issue, I see it's not a new behavior. At least back to 3.5 has the same behavior.
18:18:16 <jralls> cira, when you're in split view it's up to you to get the transaction to balance in the currency of the account in which you created the transaction. That may mean adjusting the exchange rate on multiple splits.
18:18:43 <cira> So I guess it's not a 4.0 release stopper.
18:18:59 <jralls> Be especially careful with exchange rates vs. amounts and values. If you use an exchange rate you may get rounding in values that lead to an imbalance.
18:20:20 <cira> I'll try taking out the commodity rounding.
18:21:26 <jralls> The best practice is to enter the amount rather than the price in the transfer dialog. That allows GnuCash to calculate the price/exchange rate exactly.
18:22:23 <cira> I set the price using the Price Database.
18:22:39 <jralls> One more thing: If you must enter price, enter it as a fraction (e.g. 13/31) instead of a decimal.
18:22:57 <cira> oh, didn't try that yet.
18:23:03 <jralls> You mean via quote retrieval?
18:23:46 <cira> no, I'm experimenting using GnuCash to keep inventory/orders.
18:24:23 <jralls> There's an issue with decimal numbers on computers: Because computers work in base 2 there are many fractions that cannot be represented exactly with decimals.
18:27:45 <jralls> GnuCash isn't designed for inventory management.
18:34:29 *** kael has quit IRC
18:45:17 <cira> true, but I'm attempting to treat it the same as trading for a currency.
18:45:57 <cira> perhaps an image will reveal what I'm doing wrong. https://pasteboard.co/JeMIAUm.png
18:49:00 <cira> humm. If I turn off 'trading accounts' in File->Properties, the out-of-balance indicator goes away.
18:49:45 <jralls> Just about everything. You need to spend some time with an accountant.
18:52:33 *** Aussie_matt has joined #gnucash
18:56:16 <jralls> From the using GnuCash perspective you should use Tools>Security Editor to create commodities for the tiles and use account type STOCK for the accounts denominated in tiles. Those will be Asset accounts: Another thing GnuCash doesn't handle well is barter.
18:56:45 <jralls> So no tile-denominated Income, Expense, Liability, or Equity.
19:02:46 <jralls> In the transaction at hand, right click on each of the splits denominated in tiles and pick Edit exchange rate from the context menu. Make sure that the amount field is exactly $160.00 in each. If it isn't select the radio button to the left and enter that, then click OK.
19:03:47 <jralls> Removing Trading Accounts changes the balancing process and makes it more forgiving.
19:21:39 <cira> ok. 'tile' = 'custom security' (as apposed to a national currency) Using a stock account does not auto-fill the current price from the price-database, instead it over writes it, so values must be entered everytime, and correctly. (error prone) Using a trading account, GnuCash correctly auto-fills the current price.
19:23:05 *** nspain has quit IRC
19:26:57 <jralls> cira: OK.
19:28:07 *** dtux has quit IRC
19:29:01 <jralls> @tell gjanssens fell, warlord, I've got a draft of the 4.0 new features on https://www.gnucash.org/beta, stealing liberally from the main features page styling. I decided it's too big to just go on the main page, but maybe that's because I included too much.
19:29:01 <gncbot> jralls: The operation succeeded.
20:17:39 *** cira has quit IRC
20:22:48 *** lmat has joined #gnucash
20:35:59 *** guak has quit IRC
20:44:29 *** cira has joined #gnucash
20:59:14 *** ArtGravity has quit IRC
21:02:48 *** ChanServ sets mode: +v cira
21:03:28 *** fell has quit IRC
21:06:17 *** dtux has joined #gnucash
21:20:50 *** jost has quit IRC
21:34:50 *** jost has joined #gnucash
21:40:52 *** omnireq has joined #gnucash
21:50:50 *** dtux has quit IRC
21:53:24 *** cira has quit IRC
22:09:10 *** Agfarmer18 has joined #gnucash
22:10:56 *** Agfarmer18 has quit IRC