2017-10-18 GnuCash IRC logs

01:01:38 *** Mechtilde has joined #gnucash
01:12:20 *** Mechtilde has quit IRC
01:13:50 *** fell has quit IRC
01:14:56 *** fell has joined #gnucash
02:42:33 *** gjanssens has joined #gnucash
02:42:33 *** ChanServ sets mode: +o gjanssens
02:42:47 <gjanssens> .
02:42:47 <gncbot> gjanssens: Sent 9 hours and 30 minutes ago: <warlord> <sefnot> '44464ab1b91ff1f930f48fe6b81ee760', 'WÄHRUNG', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
02:42:48 <gncbot> gjanssens: Sent 9 hours and 29 minutes ago: <warlord> <sefnot> '152fea8aea8fbe8290df4d158315e0bb', 'CURRENCY', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
02:42:49 <gncbot> gjanssens: Sent 9 hours and 29 minutes ago: <warlord> --- why would the DB have two EUR currencies, with the namespace in German?
02:48:35 *** jonas has quit IRC
02:54:07 *** Mechtilde has joined #gnucash
02:57:23 *** fabior has joined #gnucash
02:59:18 *** GabrieleV has quit IRC
03:01:39 *** GabrieleV has joined #gnucash
03:04:19 *** jonas has joined #gnucash
03:11:05 *** jonas has quit IRC
03:15:09 *** mrklintscher1117 has joined #gnucash
03:16:16 *** mrklintscher1116 has quit IRC
03:19:47 *** mrklintscher1117 has quit IRC
03:36:27 *** mrklintscher1117 has joined #gnucash
04:22:41 <sefnot> How can I mark three invoices as paid when I have Paid in advance to the vendor?
04:58:59 <gjanssens> sefnot: via menu Business->Vendor->Process Payment
04:59:12 <gjanssens> Select the appropriate vendor and A/P account
04:59:32 <gjanssens> In the list of documents that appears select the prepayment *and* the three invoices
04:59:54 <gjanssens> The amount due will change to the difference between all the selected documents.
05:00:41 <gjanssens> Adjust that amount if you are adding another payment or the prepayment should not fully be used for these 3 invoices.
05:13:55 *** manj-gnome has joined #gnucash
05:15:59 <gjanssens> sefnot: as for your double currency issue, jralls' analysis is mostly correct.
05:16:57 <gjanssens> I don't think a change in locale would be necessary to trigger this bug though. Simply upgrading from 2.6.15 to 2.6.16 while using the German or the Finnish translation would be sufficient to trigger it.
05:17:47 <gjanssens> I'm also not 100% sure the INSERT statement you posted here proves the issue was introduced in 2.6.15 already.
05:30:32 <gjanssens> The date is a transaction date, not an entry date as far as I understand. For automatically retrieved quotes that would be the same, but for prices generated while entering a transaction, the date is the transaction's posted date.
05:30:49 *** Mechtilde has quit IRC
05:31:19 <gjanssens> So it may well be this price entry was entered in gnucash 2.6.16 for a transaction dated 2017-03-30
05:32:20 <gjanssens> Our job is the same though: find and fix all wrong uses of the currencies in the translated "WÄHRUNG" namespace
06:04:52 *** jonas has joined #gnucash
06:21:29 <gjanssens> warlord: have you changed ssh host keys on code ? I'm getting a warning when trying to push to gnucash-htdocs (haven't tried the other repos ATM)
06:28:02 *** gjanssens has quit IRC
06:30:58 *** gjanssens has joined #gnucash
06:30:58 *** ChanServ sets mode: +o gjanssens
06:31:55 *** pilotauto has quit IRC
06:33:27 *** Mechtilde has joined #gnucash
06:35:29 *** Jimraehl1 has joined #gnucash
06:36:44 <sefnot> gjanssens: Thanks for the tip. Can I assign a bank transaction to an invoice after importing it with HBCI? Currently I do Business>Vendor>Process Payment Select the invoice, pay it. Then delete the now duplicate imported transaction.
06:37:12 *** Jimraehl1 has quit IRC
06:38:44 *** gncbot sets mode: +o fell
06:44:23 <fell> gjanssens: I hope, you were talking about charmaps, not currencies.
06:44:59 <fell> Translated currencies we are getting from iso..
06:47:14 <fell> Perhaps we should do some msgcat for borrowed code, but that should be formalized for a. existing po's and b. new po's.
06:48:56 *** fabior has quit IRC
06:50:11 <gjanssens> fell: yes I was talking about charmaps... I'm mixing up things
06:50:47 <gjanssens> sefnot: you can. Select the transaction in your bank account and the right-click->Assign as payment...
06:54:15 <sefnot> gjanssens: Am I doing it wrong? I can only assign it to customers and not a vendor.
06:59:55 <gjanssens> sefnot: is this a transaction between bank and A/R or bank and A/P ?
07:02:15 <sefnot> A/R
07:02:37 <gjanssens> That's the reason.
07:03:01 <gjanssens> If the transaction has a leg in A/R gnucash assumes it's a customer related transaction
07:03:55 <gjanssens> You can easily correct the transaction manually by changing AR to AP and then gnucash will propose a vendor payment when you click Assign as payment...
07:04:07 <sefnot> I found the problem, I didn't assign it to A/P...
07:04:44 <sefnot> Sorry A/R and A/P was a translation mix up on my part.. I have everything in german where it is Förderungen and Verbindlichkeiten
07:05:07 <gjanssens> No problem
07:05:23 <gjanssens> Glad you found it
07:05:33 <sefnot> Me too, thanks.
07:19:05 <warlord> gjanssens: no, I have not.
07:19:13 <fell> Da sind keine "Förderungen" in den SKRs ;-)
07:34:19 *** User has joined #gnucash
07:34:25 <fell> Warlord, I am waiting minutes for submits to the wiki.
07:36:06 <sefnot> fell 1400?
07:36:28 <fell> Which SKR?
07:36:31 <sefnot> 03
07:37:16 <fell> <act:name>1400 Ford. a. Lieferungen und Leistungen</act:name>
07:37:35 <sefnot> Oh I see.
07:37:40 <sefnot> ,)
07:38:01 <sefnot> ;)
07:39:40 <fell> BTW you should change "Bank" and "Postbank" to type "Bank". Fix isin my queue.
07:40:25 <sefnot> No wonder I have no profit this year!
07:40:46 <fell> You will get more appropriate actions in the transactions then.
07:41:28 <sefnot> I've been subsidising all my clients.
07:41:55 <fell> ;-)
07:44:41 <sefnot> So is best practice to just add an entry for tax in the invoice? I never get the right tax amount.
07:44:44 <fell> gjanssens: is there some reason, in imp-exp placeholders were named "Place_holder"?
07:46:21 <fell> Manchmal hilft es den stückpreis um bis zu 0,5 runter oder 0,49 rauf zu setzen
07:46:29 <fell> Cent
07:47:48 <gjanssens> sefnot: I usually add a single correcting entry to invoices if I have a rounding error. That will fix the transactions when posted. The only minor issue with this is that the tax amount at the bottom of your invoice window is not right as it doesn't know the correction is actually tax related. In the future I hope to improve this, but there's much on my list :(
07:48:48 <gjanssens> Another option I sometimes use is to enter the lines with tax included (and marking the lines as such). In that direction there are usually fewer rounding issues.
07:49:17 <sefnot> fell: That's what I've been doing, works most of the time.
07:49:46 <gjanssens> fell: No idea about the "Place_holder" choice of name. Did I do that ?
07:49:54 <gjanssens> Anyway, I've got to reboot
07:49:57 <gjanssens> BRB
07:50:03 *** gjanssens has quit IRC
07:54:20 *** User has quit IRC
07:55:58 *** mrklintscher1117 has quit IRC
07:56:45 *** gjanssens has joined #gnucash
07:56:45 *** ChanServ sets mode: +o gjanssens
07:58:46 <sefnot> I have an invoice with prices at 3 decimal places which is causing the subtotal to be 3 cents short.
07:59:34 <sefnot> When I enter the lines as tax included.
08:00:10 <gjanssens> sefnot: in that case you still need an adjustment line unfortunately
08:00:35 <gjanssens> If only the tax amount is wrong, you can make the adjustment line non-tax related
08:00:56 <gjanssens> Otherwise try to make it tax related and see if the tax amount is correct.
08:01:16 *** rickoehn has joined #gnucash
08:01:20 <sefnot> When tax excluded Total is 4 cents off and subtotal is 1 cent off.
08:01:22 *** Mechtilde has quit IRC
08:01:51 <gjanssens> Unfortunately due to different rounding conventions used it's not always possible to have gnucash calculate the proper amounts automatically.
08:02:26 <fell> I would create a spreadsheet to find the places, where 19% get wrong rounding ...
08:02:37 *** mrklintscher1117 has joined #gnucash
08:04:18 <sefnot> My suggestion would be to not attempt to automatically calculate the tax.. and allow it to be entered manually.
08:04:51 <gjanssens> warlord: contrary to jralls I do have an IPv6 network configured and I'm indeed experiencing a serious delay in connecting to code
08:05:19 <gjanssens> Can it be I get this ssh host key change error because I'm coming over an ipv6 network ?
08:05:40 *** mrklintscher1117 has quit IRC
08:06:47 <gjanssens> Oh, it looks like I still have your old host key associated with the IPv4 address on my known-hosts
08:11:33 <gjanssens> warlord: yep removing the old key fixed the ssh warning. The slow access time remains.
08:12:11 * gjanssens is curious how IPv6 access works if you disabled your IPv6 network ?
08:12:28 <gjanssens> Do you still have a slow hurricane electric tunnel or something similar ?
08:13:36 <fell> IIRC some IPv6 over IPV4 will be done.
08:14:50 <fell> I remember when there was the suggestion to disable IPv6 in KDE because it was very slow.
08:15:19 <fell> if the other side only offered IPv4.
08:23:44 *** mrklintscher1117 has joined #gnucash
08:27:24 *** mrklintscher1118 has joined #gnucash
08:30:02 *** mrklintscher1117 has quit IRC
08:47:28 <gjanssens> fell: indeed some IPv6 over IPv4 will be done. My curiosity was about how exactly that was done
08:47:56 *** fekepp has joined #gnucash
08:48:09 <gjanssens> Whether it needs something on warlord's side or whether this is something inherent to the IPv6 protocol
08:48:26 <gjanssens> My IPv6 knowledge is still limited currently :)
08:50:11 <fell> I can only imagine: If the highway is closed, redirect the traffic over other streets.
08:52:03 <fell> About goffice [https://github.com/Gnucash/gnucash/commit/d858c7d] can you pull the po files, too?
08:52:40 <fell> Then we could d some msgcat instead of retranslating thc charmap names.
08:54:19 <fell> or perhaps use dgettext instead of gettext()
08:54:22 <gjanssens> fell: good idea. I'll put it on my list for when I have some time available again for gnucash
08:54:50 <gjanssens> I have a couple of very busy weeks ahead of me outside the project...
08:55:30 <fell> I was only shocked, when I saw yesterday the new po files.
08:56:00 <fell> But currently there is still enough work for me on maint.
08:56:32 <gjanssens> Shocked by all the new untranslated country names you mean ?
08:57:44 <fell> yep
08:59:00 <gjanssens> dgettext would be very nice, but ISTR I couldn't get that to work on Windows (or I misunderstood how it should be done).
08:59:20 <gjanssens> My last attempt to get the iso currencies translated on that platform failed with gnucash crashing.
08:59:29 <fell> and each language has a bunch of encodings
08:59:32 <gjanssens> Maybe it's time to revisit that part then as well :)
09:01:15 *** zeus has joined #gnucash
09:10:12 <warlord> gjanssens: the IPv6 tunnel (via Hurricane Electric) is currently turned off.. Turning it on caused my AT&T modem to go wonky and cause significant packet delays.
09:10:37 <gjanssens> Interesting, so how does IPv6 traffic reach you ?
09:11:28 <gjanssens> When Or doesn't it and is my initial IPv6 connection timing out after which the system automatically retries IPv4?
09:12:17 <gjanssens> No idea how this works
09:12:35 <gjanssens> I can't ping your IPv6 address indeed, only IPv4 works
09:13:48 <warlord> gjanssens: it's not reaching me. That's the point.
09:14:04 <warlord> IPv6 will get as far as my router but my router will drop the traffic.
09:14:17 <warlord> the problem with the modem appears to be upstream IPv6 traffic.
09:14:21 <gjanssens> Ok
09:14:42 <warlord> I need to set up my laptop to act as my router, unplug the router, plug in the laptop, and verify that that's the case.
09:15:00 <gjanssens> So I'm trying to understand that I can run a git push to code without changing anything here and a ping doesn't work
09:15:08 <warlord> But the delay is that your TCP connection first tries to connect to the v6 address, and then it has to wait for that to timeout before it falls back to ipv4.
09:15:45 <warlord> You can still run a git push to code, but it will delay because it's trying to connect to the ipv6 address first.
09:15:54 <gjanssens> Right, that's the part I was wondering about. So it's my system that transparently does the second attempt.
09:16:05 <warlord> you could PROBABLY fix that by putting the ipv4 address into your ~/.ssh/config file:
09:16:09 <gjanssens> Second attempt over IPv4
09:16:18 <warlord> Host code.gnucash.org
09:16:25 <warlord> Hostname 204.107.200.65
09:16:36 <warlord> *that* should force v4.
09:17:21 *** mrklintscher1118 has quit IRC
09:17:34 <warlord> I dont know how long it will take until I can fix v6.
09:17:51 <warlord> It's more important to me to have a viable v4 network then a broken v4/v6 network.
09:19:55 <gjanssens> Of course! I was merely taking the opportunity to learn more about how all these pieces fit together
09:22:09 <warlord> *nods*
09:22:38 <manj-gnome> hello :-) is there any big reason to not use the 2.7a yet besides the 2 known problems?+
09:22:51 *** manj-gnome is now known as chr
09:23:22 <gjanssens> I found a more elegant addition to the .ssh/config file to force IPv4:
09:23:23 <gjanssens> AddressFamily inet
09:24:12 <gjanssens> The other possible values are inet6 or all
09:24:19 <gjanssens> (the latter is default)
09:24:45 <warlord> But do you want to change it to v4 for all your connections?
09:25:04 <gjanssens> It's a per host change :)
09:25:35 <warlord> Ah, okay. Then yes, that works.
09:25:36 <gjanssens> I've only added it for host code.gnucash.org
09:25:46 <warlord> And is the delay gone now?
09:26:13 <gjanssens> chr: the major reason is all the *unknown* issues which surely are there :D
09:26:17 <gjanssens> warlord: yes
09:26:32 <warlord> Nice.
09:27:20 <gjanssens> This takes the pressure of your back allowing you to debug at your own pace :)
09:28:10 <gjanssens> If it looks like it will take a fair amount of time, I'd suggest to temporarily remove the AAAA record from dns
09:28:29 <gjanssens> and perhaps any IPv6 related other records like MX records
09:28:53 <gjanssens> Depending on how much complaints we get about slow connections of course.
09:29:06 <gjanssens> It looks like IPv6 is still pretty uncommon
09:32:19 <warlord> Maybe..
09:32:30 <warlord> Would need to work with Linas.
09:35:08 <gjanssens> Who is very busy with other things. I understand.
09:37:13 *** fabior has joined #gnucash
09:38:31 <warlord> I'm sure.
09:42:15 *** Mechtilde has joined #gnucash
09:53:41 *** kael has joined #gnucash
10:13:22 *** mikee_ has joined #gnucash
10:14:09 *** mikee has quit IRC
10:15:05 *** mikee has joined #gnucash
10:15:07 *** kael has quit IRC
10:15:54 *** kael has joined #gnucash
10:16:37 *** mikee_ has quit IRC
10:18:38 *** kael has quit IRC
10:18:53 *** KaiForce has joined #gnucash
10:57:01 *** mikee_ has joined #gnucash
10:58:39 *** mikee has quit IRC
11:06:20 *** Mechtilde has quit IRC
11:14:20 *** chr has quit IRC
11:16:29 *** fekepp has quit IRC
11:16:35 *** Chris has quit IRC
12:09:34 *** mikee_ is now known as mikee
12:09:51 <mikee> @op
12:09:51 <gncbot> mikee: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
12:10:29 <mikee> @op
12:10:30 *** gncbot sets mode: +o mikee
12:29:10 *** Mechtilde has joined #gnucash
12:57:58 *** mpiechotka has joined #gnucash
13:01:35 *** mpiechotka has quit IRC
13:05:44 *** User has joined #gnucash
13:14:23 *** fabior has quit IRC
13:15:47 *** fabior has joined #gnucash
13:39:35 *** mpiechotka has joined #gnucash
13:48:29 *** fabior has quit IRC
13:53:19 *** phebus has joined #gnucash
14:11:23 *** frakturfreak has joined #gnucash
14:30:21 *** Mechtilde has quit IRC
14:32:28 *** Mechtilde has joined #gnucash
14:36:53 *** Mechtilde has quit IRC
15:26:08 *** zeus has quit IRC
15:43:43 *** fabior has joined #gnucash
15:54:18 *** zeus has joined #gnucash
16:04:52 *** tuxd00d has quit IRC
16:07:33 *** karelk has joined #gnucash
16:44:45 *** zeus has quit IRC
16:54:40 *** frakturfreak has quit IRC
17:04:38 *** gjanssens has quit IRC
17:30:41 *** fabior has quit IRC
17:47:49 *** pilotauto has joined #gnucash
17:49:41 *** rickoehn has quit IRC
18:04:46 *** mrklintscher1118 has joined #gnucash
18:10:56 *** mrklintscher1118 has quit IRC
18:11:28 *** jquin has quit IRC
18:16:54 *** mrklintscher1118 has joined #gnucash
18:19:56 *** pilotauto has quit IRC
18:22:50 *** pilotauto has joined #gnucash
18:27:05 *** User has quit IRC
18:27:19 *** jquin has joined #gnucash
19:35:04 *** tuxd00d has joined #gnucash
20:15:20 *** tuxd00d has quit IRC
20:32:02 *** User has joined #gnucash
20:38:06 *** mpiechotka has quit IRC
20:38:51 *** mpiechotka has joined #gnucash
20:49:43 *** tuxd00d has joined #gnucash
20:58:33 *** fbruetting has joined #gnucash
21:03:11 *** User has quit IRC
21:09:20 *** fbruetting has quit IRC
21:14:10 *** fbruetting has joined #gnucash
21:26:34 *** fbruetting has quit IRC
21:37:40 *** tuxd00d has quit IRC
21:41:00 *** jquin has quit IRC
21:44:28 *** mpiechotka has quit IRC
22:13:45 *** mpiechotka has joined #gnucash
22:16:29 *** mpiechotka_ has joined #gnucash
22:16:53 *** mpiechotka has quit IRC
22:42:08 *** mpiechotka has joined #gnucash
22:44:30 *** mpiechotka_ has quit IRC
23:43:35 *** xmaka has quit IRC
23:50:04 *** xmaka has joined #gnucash
23:59:28 *** storyjesse has joined #gnucash