2018-10-28 GnuCash IRC logs

00:08:13 *** Agfarmer18 has quit IRC
02:05:18 *** bertbob has quit IRC
02:06:41 *** bertbob has joined #gnucash
02:22:42 *** Mechtilde has joined #gnucash
02:43:17 *** frakturfreak has quit IRC
02:47:18 *** gour has joined #gnucash
02:57:48 *** frakturfreak has joined #gnucash
03:37:29 <chris> something happened to latest win32 nightly... the max/min/restore buttons now follow GTK3
03:46:37 *** shebang has joined #gnucash
04:04:39 *** mwe1 has joined #gnucash
04:34:11 *** jotrago has quit IRC
04:36:17 *** jotrago has joined #gnucash
04:43:39 *** kurufu has joined #gnucash
05:58:34 *** fabior has joined #gnucash
06:09:01 *** fell has joined #gnucash
06:29:34 *** gjanssens has joined #gnucash
06:29:34 *** ChanServ sets mode: +o gjanssens
06:30:40 <gjanssens> .
06:35:45 *** colona has joined #gnucash
06:40:41 *** Guest3045 has joined #gnucash
07:13:12 <gnomey> i have a simple cross-currency transaction with an FX rate applied. No issue there. Then I later decide to add a split to account for the conversion fee (euro asset to euro expense account). GNU Cash is forcing me to give an exchange rate for the Euro-to-Euro part of the split.
07:14:02 <gnomey> how can I tell GC there is no exchange rate? I could say the FX rate is 1:1, but I think there will be data corruption if I do that.
07:46:28 *** gour_ has joined #gnucash
07:48:39 *** gour has quit IRC
07:52:55 *** oozer has joined #gnucash
07:57:59 *** fabior has quit IRC
08:01:30 *** FoxT has quit IRC
08:03:28 *** chf has quit IRC
08:05:45 *** chf has joined #gnucash
08:06:21 *** boldstripe has quit IRC
08:07:56 *** FoxT has joined #gnucash
08:08:42 *** boldstripe has joined #gnucash
08:36:39 *** tlaxkit has joined #gnucash
09:28:20 *** fekepp has quit IRC
09:31:42 <warlord> gnomey: it's asking you that because the transaction currency isn't EUR. So you need to give it the proper exchange rate between the transaction currency and the fee account (EUR, I gather)
09:40:15 *** StarFire has joined #gnucash
09:40:50 *** StarFire has left #gnucash
09:46:25 *** O01eg has quit IRC
10:02:46 *** hiberno has joined #gnucash
10:40:32 *** User_ has joined #gnucash
10:45:37 *** fabior has joined #gnucash
10:54:08 *** User_ has quit IRC
11:00:35 <fell> gnomey: ... or start the transaction from an EUR account.
11:08:18 *** boldstripe has quit IRC
11:24:49 *** danderss1n has joined #gnucash
12:14:23 *** fabior has quit IRC
12:32:17 *** boldstripe has joined #gnucash
12:37:49 *** unlobito has joined #gnucash
12:42:46 *** msekar has joined #gnucash
12:45:11 *** fekepp has joined #gnucash
13:20:21 *** alhariel has joined #gnucash
13:28:04 *** ncv has quit IRC
13:57:42 <gnomey> warlord: when you say "the transaction currency", that sounds a bit off b/c there are multiple currencies for the transaction, one of which is EUR. Then after I read fell's comment, I wonder if by *the* txn currency is actually a thing, based on which register the transaction is entered in.
14:00:43 <gnomey> fell: will try your suggestion.. but it's a bit backwards. E.g. when I use a euro credit card in Sweden, I know the transaction costs "500 kronas", for example, but I don't immediately know the euros. So it makes sense to enter the transaction in the swedish expense account, as the amount in kronas is known and in concrete. The EUR amount will be adjusted later
14:04:23 <jralls> gnomey: You got it in one: The transaction currency is set by the register you start in and it's the currency used to balance the transaction. So you're creating a transaction with SKR as its currency and all of the EUR splits need to be converted to SKR. That would be both splits for the conversion fee since both are in EUR.
14:05:23 <gnomey> ok, thanks
14:41:09 <gnomey> so apparently I need to start the txn in the register of the bank acct, enter any bogus amount, and save then. Then jump to the other acct, change the amount to the correct amount, and use the default fx rate (until I find out what it is later). I can then add a fee as well that is based in the same currency as the bank acct. So seems to work.
15:07:13 <jralls> You can save the "jump to another account" step by setting the correct amount in SKR (instead of an exchange rate) in the transfer dialog when you first create the transaction.
15:10:52 <gnomey> do you mean by choosing "edit exchange rate" and then using the "to amount" field?
15:11:24 <gnomey> i agree, but then I lose the advantage of gnucash estimating the FX rate based on the past, which it does pretty well
15:21:57 *** k1804 has joined #gnucash
15:25:10 <jralls> Are you creating the original transaction in split view? If so then yes, you can do that with edit exchange rate. If you create it in basic view then the transfer dialog will come up automatically.
15:27:06 <k1804> Yesterday I complained that the lock was not clearing on the database and I found the reason, me. I did not follow MySQL 5.7 Schema Object Names (ref 9.2) and placed a hypen in the name. I appologize for your time spent on my error. Cheers
15:28:10 <jralls> k1804: Ah, I saw your note earlier and wondered about the root cause. Thanks for following up.
15:29:25 <gnomey> jralls: i'm in the basic ledger view, and no dialog appears unless I use control-t to ask for it. Otherwise i fill fields directly in the register and use /tab/
15:30:20 <gnomey> maybe the fastest way is to control-t initially, and then split it and add the fee.
15:30:55 <jralls> That's strange. It should trigger when you tab out of the debit or credit field.
15:31:49 <gnomey> it's an asset account with increase/decrease fields.. when I tab from those, that's the end of the entry so it just gets committed
15:34:16 <gnomey> i see a preference "tab order includes Transfer on Memorized Transactions", which is unticked. I wonder if that's the behavior you're talking about
15:35:02 <jralls> You're using "user friendly" field labels, but the fields are the same: increase = debit, decrease = credit. Are you using trading accounts? That changes the behavior but I don't remember exactly what.
15:35:45 <jralls> No, that enables/disables skipping the transfer account when it autofills the description.
15:36:55 <gnomey> i have brokerage accounts and lots of stocks, but they aren't involved in the situation at hand
15:40:44 <jralls> I know. Currency is a subset of commodity. The transaction currency must be a currency, but account commodity need not be.
15:43:15 <jralls> When in basic view, when you have a transfer account with a different currency/commodity from that of the register's account GnuCash should pop up the transfer dialog to get an exchange rate/price when you tab out of the field with the amount of the transaction (the debit/increase or credit/decrease field)
15:45:06 *** inflex has joined #gnucash
15:52:06 *** al has joined #gnucash
15:53:43 *** k1804 has quit IRC
16:04:12 *** fekepp has quit IRC
16:04:38 *** fekepp has joined #gnucash
16:09:08 *** fekepp has quit IRC
16:11:09 *** al has quit IRC
16:29:02 <frakturfreak> gnomey: If you’re still there, my solution for your problem is to nether use foreign currency income/expense accounts and instead route those transactions through liability and asset accounts.
16:41:58 *** Mechtilde has quit IRC
16:42:57 *** Cheffheid has joined #gnucash
17:13:03 *** da-x_ has joined #gnucash
17:29:12 *** frakturfreak has quit IRC
17:43:26 *** frakturfreak has joined #gnucash
17:45:59 *** Aussie_matt has joined #gnucash
17:49:32 <gnomey> frakturfreak: thanks for the suggestion, but that sounds very different from what i've done over the years. My liability accounts are generally just loans and credit cards. I don't know exactly what you're proposing, but I probably don't want to have too many different approaches going on in my books
17:51:43 *** gjanssens has quit IRC
18:03:03 <frakturfreak> For me it also helps with the fact that my work flow involves updating quotes daily and using the trading accounts, so obviously if I were using foreign currency expense accounts I would have unrealized gains otherwise
18:06:28 *** boldstripe_ has joined #gnucash
18:06:43 *** boldstripe has quit IRC
18:06:43 *** boldstripe_ is now known as boldstripe
18:08:12 *** bertbob has quit IRC
18:10:52 <frakturfreak> https://imgur.com/a/CqCixm5 something like this
18:11:05 <frakturfreak> obviously the second transaction there was created first
18:12:30 <frakturfreak> So I’ve created a liability account in PLN and the expense account in EUR. I enter the amount in the liability account in PLN, get prompted for the exchange rate and select one.
18:12:58 <frakturfreak> Afterwards I create a transaction that pays the liability in full with cash
18:13:36 <frakturfreak> afterwards I go to my cash account, change the amount in this account to the real amount I’ve paid and what’s left over to be balanced goes to a fees account.
18:14:37 <frakturfreak> My trading accounts are balanced and there are no unrealized gains if I’m updating the quotes.
18:23:56 *** bertbob has joined #gnucash
18:27:12 *** gour_ has quit IRC
18:48:53 *** bertbob has quit IRC
18:50:05 *** lukasdboer has joined #gnucash
19:04:15 *** msekar has quit IRC
19:04:24 *** bertbob has joined #gnucash
19:11:06 *** FalconSpy has joined #gnucash
19:15:53 *** Unhammer has quit IRC
19:20:44 *** Unhammer has joined #gnucash
19:42:37 *** boldstripe_ has joined #gnucash
19:42:52 *** boldstripe has quit IRC
19:42:53 *** boldstripe_ is now known as boldstripe
19:44:04 *** sjl has joined #gnucash
19:58:02 *** tlaxkit has quit IRC
20:04:06 *** bertbob has quit IRC
20:15:21 *** bertman has joined #gnucash
20:18:00 *** bertbob has joined #gnucash
20:20:24 *** msekar has joined #gnucash
20:23:08 *** CDB-Man_ has joined #gnucash
20:24:11 *** CDB-Away_ has joined #gnucash
20:24:47 *** CDB-Away has quit IRC
20:25:28 *** CDB-Man has quit IRC
20:26:09 *** woodcruft has joined #gnucash
21:23:38 *** sixwheeledbeast has quit IRC
21:25:14 *** sixwheeledbeast has joined #gnucash
21:56:15 *** storyjesse has joined #gnucash
22:02:56 *** oozer has quit IRC
22:18:09 *** msekar has quit IRC
22:20:09 *** boldstripe has quit IRC
22:21:09 *** boldstripe has joined #gnucash
22:39:08 *** Bugson has joined #gnucash
22:56:11 *** flynux has joined #gnucash
23:17:53 *** msekar has joined #gnucash
23:24:16 *** msekar has quit IRC
23:34:34 *** msekar has joined #gnucash
23:41:57 *** fell has quit IRC
23:43:07 *** msekar has quit IRC