2017-10-17 GnuCash IRC logs
00:12:31 *** ArtGravity has quit IRC
00:34:02 *** g5pw has quit IRC
00:34:12 *** g5pw has joined #gnucash
01:01:40 *** Mechtilde has joined #gnucash
01:02:52 *** Cuare has quit IRC
01:12:09 *** storyjesse has quit IRC
01:15:01 *** fell has quit IRC
01:15:50 *** fell has joined #gnucash
01:39:22 *** gncbot sets mode: +o fell
01:55:57 *** Mechtilde has quit IRC
02:12:21 *** fekepp has joined #gnucash
02:12:49 *** jotrago has quit IRC
02:14:57 *** fekepp has quit IRC
02:57:15 *** GabrieleV has quit IRC
02:58:14 *** jotrago has joined #gnucash
03:00:39 *** GabrieleV has joined #gnucash
03:08:41 *** mrklintscher1115 has joined #gnucash
03:09:47 *** mrklintscher1114 has quit IRC
03:11:47 *** mrklintscher1115 has quit IRC
03:28:31 *** mrklintscher1115 has joined #gnucash
03:32:41 *** fabior has joined #gnucash
03:39:50 *** jchonig has quit IRC
03:41:35 *** jchonig has joined #gnucash
04:02:49 *** Derperperd has quit IRC
04:09:01 *** Derperperd has joined #gnucash
04:13:32 *** gjanssens has joined #gnucash
04:13:32 *** ChanServ sets mode: +o gjanssens
04:13:38 <gjanssens> .
04:17:41 *** pilotauto has quit IRC
04:52:01 *** Skewsy has quit IRC
05:52:28 *** Mechtilde has joined #gnucash
06:23:11 <fell> Can anybody tell me, where to find <object class="GtkSpinButton" id="pref/general.register/key-length">
06:23:57 <fell> I would expect in edit->preferences->General, but can not see it.
06:28:05 <fell> or in register-defaults as the previous element.
06:30:17 <fell> OK, found it: #ifndef REGISTER2_ENABLED
06:30:42 <warlord> Good News --- I tracked down the trigger for my network issues. Bad News -- it's my v6 tunnel. I turned off the v6 tunnel overnight and my issues went away. So now I need to figure out why my modem doesn't like my v6 tunnel.
06:32:23 *** jotrago has quit IRC
06:44:00 *** jotrago has joined #gnucash
06:49:34 *** jotrago has quit IRC
06:49:55 *** jotrago has joined #gnucash
07:42:16 *** User has joined #gnucash
07:54:09 *** mikee has joined #gnucash
07:55:08 *** sefnot has joined #gnucash
07:55:36 *** mikee_ has quit IRC
07:57:18 *** fabior has quit IRC
07:59:06 <sefnot> Gnucash rounds the tax incorrectly on my invoice. Is there a workaround/solution? Subtotal 354.30 Total 421.62 19% Sales tax 67.32; Gnucash calculates 354.30 421.61 67.31 One cent less.
08:00:29 *** rickoehn has joined #gnucash
08:37:03 <mikee> sefnot: Tax in you invoice is calculated per line, not on the total, which can lead to the error. I have had similar issues.
08:38:02 <mikee> I do the tax as a separate item, usually.
08:39:50 <mikee> Also some electronic components I buy are priced to 3 decimal places, which is also an problem, for bill tracking.
08:43:46 <fell> The problem is well known: https://bugzilla.gnome.org/show_bug.cgi?id=502853
08:45:20 <fell> and bug 504954
09:48:25 *** fabior has joined #gnucash
10:09:24 *** jotrago has quit IRC
10:10:43 *** Mechtilde has quit IRC
10:34:26 *** User has quit IRC
10:55:19 *** jotrago has joined #gnucash
10:58:37 *** ArtGravity has joined #gnucash
11:25:41 *** fekepp has joined #gnucash
11:45:15 <jralls> warlord: Sorry, I was AFK making and eating dinner last night. Interesting that it seems to be the IPv6 tunnel given that flooding you with IPv4 traffic seemed to trigger the problem.
11:46:10 <jralls> Or was that IPv4 to the other end of the tunnel then IPv6 to the Edgerouter?
11:51:11 <warlord> The ipv4 flood was something completely different.. And I *THINK* I fixed that.
11:51:25 <warlord> (I turned on "flood protection" in the Arris.
11:52:44 <warlord> Since I've turned off ipv6 I've had a working network. I turned it back on this morning and immediately saw the issue; turned it back off and the issue went away. But I've gone 12 hours with a clean network since I turned it off.
11:57:37 <jralls> Very good. I'm in the Win32 VM right now to send the 2.7.0 setup.exe to code (I forgot to tell it the hostname when I fired off the build last night.) It's quite responsive, a huge improvement.
11:58:12 <sefnot> mikee: Ok thanks for the tip.
12:02:24 <sefnot> fell: bug is from 2007, maybe next decade there will be some progress.
12:03:05 <warlord> jralls: I'm sure, because your packets aren't being delayed ~400ms
12:03:55 <jralls> Heh, 400-2000ms.
12:04:28 <jralls> But I imagine you'd like to have your IPv6 back. Have you talked to AT&T support about it?
12:07:24 *** fekepp has quit IRC
12:07:30 *** fekepp has joined #gnucash
12:09:32 <warlord> Not yet. I want to be able to reproduce the problem using my laptop alone, first.
12:10:31 *** Mechtilde has joined #gnucash
12:10:51 <warlord> But it's clearly an upstream issue. you could ping6 to my machines right now and, while the packets will reach my router, they wont get further.
12:11:12 <warlord> But an mtr outbound *seemed* to be sufficient to instigate it.
12:13:47 <jralls> The ping6 will reach the Arris or the Edgerouter?
12:18:00 <warlord> Edgerouter
12:18:34 <warlord> But wont get past that. You'll probably not get responses past there.
12:19:02 *** fekepp has quit IRC
12:20:08 <jralls> I don't have IPv6 set up at all on my network, so it won't even get out of the box.
12:21:28 <warlord> Ah.
12:21:53 <warlord> Anyways, I'm sure that there is incoming ipv6 because www, smtp, etc will all find the AAAA and try that first.
12:22:18 *** Cuare has joined #gnucash
12:25:53 <jralls> fell: Can you grab https://sourceforge.net/projects/gnucash/files/gnucash%20%28unstable%29/2.7.0/gnucash-2.7.0.tar.bz2/download and check that gnucash.pot is OK? I made it with cmake on an F25 VM that claims it's upgraded to F26.
12:28:13 <fell> I will
12:35:11 <fell> We have a new section
12:35:13 <fell> #: ../borrowed/goffice/go-charmap-sel.c:70
12:35:13 <fell> msgid "Arabic"
12:35:16 <fell> ...
12:38:54 *** sefnot has quit IRC
12:39:24 <fell> and
12:39:25 <fell> #. http://developer.gnome.org/doc/API/2.0/glib/glib-Commandline-option-parser.html
12:39:26 <fell> #: ../gnucash/gnucash-bin.c:130
12:39:28 <fell> msgid "GSETTINGSPREFIX"
12:39:33 <fell> ...
12:39:51 *** mrklintscher1115 has quit IRC
12:41:04 <fell> the latter seems to be nice, but for the former I would expect the translation somewhere else.
12:43:37 *** sefnot has joined #gnucash
12:49:39 *** fbruetting has joined #gnucash
12:50:44 <fell> jralls, to answer, what you intended to ask, the section with +msgctxt "Daily" is included.
12:53:37 <jralls> fell: Good, thanks.
12:56:18 <jralls> fell, gjanssens: GSETTINGSPREFIX looks like an identifier that shouldn't be localized. IIUC we're using GUI elements from GOffice in lieu of depending on the whole huge thing. If it has strings that need localizing then they'll show up in gnucash.pot.
12:59:10 *** fbruetting has quit IRC
12:59:28 *** fbruetting has joined #gnucash
13:00:36 *** KaiForce has joined #gnucash
13:02:40 <fell> But the names of all charmaps?
13:03:42 *** fbruetting has quit IRC
13:04:08 <jralls> I suppose (not having time to look right now) that there's a selection list of charmaps for importing CSVs. Since it's presented to the user it needs to be localized.
13:05:52 *** mrklintscher1115 has joined #gnucash
13:08:50 *** fabior has quit IRC
13:09:28 *** fbruetting has joined #gnucash
13:13:41 *** fbruetting has quit IRC
13:14:01 *** fbruetting has joined #gnucash
13:22:57 *** mpiechotka has joined #gnucash
13:23:13 *** fabior has joined #gnucash
13:24:30 *** mpiechotka has quit IRC
13:44:18 *** Trel has quit IRC
13:47:45 *** Trel has joined #gnucash
13:54:10 *** fbruetting has quit IRC
13:54:28 *** fbruetting has joined #gnucash
13:58:41 *** fbruetting has quit IRC
14:00:54 *** User has joined #gnucash
14:01:20 *** fbruetting has joined #gnucash
14:09:48 *** fabior has quit IRC
14:12:33 *** Cuare has quit IRC
14:17:55 <sefnot> I am unable to post my invoice. The dialog "Do you really want to post your invoice?" last field "Post to account" is greyed out instead of the expected account receivables account. I have only the option to create a new account receivables account.
14:19:58 *** frakturfreak has joined #gnucash
14:21:15 *** fbruetting has quit IRC
14:21:33 *** fbruetting has joined #gnucash
14:25:46 *** fbruetting has quit IRC
14:26:04 *** fbruetting has joined #gnucash
14:29:13 <sefnot> Another solution for adjusting the total tax in an invoice: Adjust item price from ie. 24.55 to 24.545 or 24.5549 depending if you want to round up or down. You will have to do this line for line until you find the offending item.
14:31:12 *** mrklintscher1116 has joined #gnucash
14:33:02 *** mrklintscher1115 has quit IRC
14:36:42 <sefnot> The account-type of the Account receivables account had somehow changed. As well as it being marked as a placeholder account. After changing this I can now post my invoice.
14:49:56 <sefnot> *Scratches head* Still can't post invoice to child account skr03 1600 Verbindlichkeiten aus Lieferungen und Leistungen
14:51:15 *** fbruetting has quit IRC
14:51:35 *** fbruetting has joined #gnucash
14:55:08 <sefnot> Perhaps there is a corruption in sql database?
14:55:46 *** fbruetting has quit IRC
14:56:05 *** fbruetting has joined #gnucash
14:56:52 *** fabior has joined #gnucash
14:59:24 <sefnot> Creating a new child A/R account allows me to post the invoice. However I still can't post the invoice into my old A/R account
15:00:01 <warlord> seanh: did you try to turn off the placeholder flag?
15:00:16 <warlord> Do the currencies match?
15:02:59 <sefnot> Currencies are in Euros. But I am prompted with every transaction to book euro to euros with exchange rate.
15:03:43 <fell> Somehow you scewed up your currencies.
15:03:44 <sefnot> I've tried toggling the place holder flag, and moving the account around with no luck.
15:04:46 <fell> check Language settings, Prefences, account currency ...
15:04:50 <warlord> Yeah, that implies your currencies are messed up..
15:05:03 <warlord> Which is also why it wont let you use the old A/R account
15:05:09 <sefnot> I think it's a known bug introduced in 2.6.16 https://bugzilla.gnome.org/show_bug.cgi?id=781634
15:05:51 <sefnot> I'm on 2.6.18
15:06:25 <sefnot> It was working before though even with the messed up currencies.
15:07:08 <warlord> Define "before"?
15:08:40 *** Mechtilde has quit IRC
15:09:58 <sefnot> I will try to reboot ...
15:12:30 *** sefnot1 has joined #gnucash
15:12:52 *** Mechtilde has joined #gnucash
15:14:54 <sefnot1> before was today before rebuilding gnucash. I was hoping it would solve the currency problem because the bug was marked as resolved.
15:15:08 *** sefnot has quit IRC
15:15:53 *** sefnot1 is now known as sefnot
15:19:01 <sefnot> I can post the invoice into the new empty account of type A/R... but not into the old account of type A/R with all my existing transactions.
15:19:07 *** Mechtilde has quit IRC
15:26:27 <sefnot> I do think the currency is not related to me not being able to post.
15:27:51 <sefnot> Same problem . https://lists.gnucash.org/pipermail/gnucash-user/2004-March/009768.html
15:27:57 <sefnot> but from 2004
15:34:48 <sefnot> The accounts and Supplier all have euro as currency.
15:35:22 <sefnot> http://gnucash.1415818.n4.nabble.com/Can-t-post-invoice-td2541753.html
15:35:38 *** Mechtilde has joined #gnucash
15:36:16 *** KaiForce has quit IRC
15:44:04 <sefnot> ok interesting.... it appear I can post to an old account with an existing supplier.. But with my new supplier I cannot.... eventhough currency is set as euro.
15:44:24 <warlord> Are you sure the currency of the new supplier is Euro?
15:44:37 *** Mechtilde has quit IRC
15:45:08 <sefnot> Also the old supplier can't post the invoice into the new account that I made that works with the new supplier...
15:47:08 <sefnot> Suppliers are all set to Euro. and both accounts are set to type A/R
15:49:02 <sefnot> and both a/r accounts have euro as currency
15:50:44 <sefnot> Creating a new supplier I cannot post to old A/R account
15:50:58 <warlord> This behavior seems to imply that they are not the same.
15:52:18 <sefnot> I'm thinking to try and build gnucash again?
15:53:27 <warlord> I doubt that's the problem
15:54:00 <sefnot> existing suppliers can post into existing account only.. new suppliers can post into new account only
15:54:16 <sefnot> everything set too euro... with edit account and edit supplier
15:54:39 * warlord wonders if somehow you have 2 EUR currencies in your data file, somehow?
15:55:33 <sefnot> currencies are sorted alphabetically.. and there is only one EUR entry...
15:56:06 <sefnot> and euro has always been the default selected..
15:56:23 <sefnot> usually I don't touch the euro field.
15:56:27 <sefnot> currency field
15:59:05 <warlord> The requirements for posting is Customer Invoice -> A/Receivable, Vendor Bill/Employee Voucher -> A/Payable... And the Invoice/Bill/Voucher currency Owner Currency == account currency
16:02:25 *** frakturfreak has quit IRC
16:06:29 <sefnot> According to the User interface these conditions are met. I can't find a difference from the old owner to the new owner. My backend is SQL
16:12:37 *** tuxd00d has quit IRC
16:15:54 <sefnot> warlord: the currencies are different in the sql db
16:17:50 <sefnot> the old ones are 44464ab1b91ff1f930f48fe6b81ee760
16:17:59 <sefnot> the new ones are 152fea8aea8fbe8290df4d158315e0bb
16:18:08 <warlord> And there's the problem :)
16:18:33 <sefnot> How do I have two eur currencies????
16:18:41 <warlord> *that* is the question
16:18:52 <gjanssens> jralls, fell: the GSETTINGSPREFIX string is only used in documentation as an indicator to the user. It's part of the way GOptions work. I don't have time now to look more into this.
16:19:38 <gjanssens> And yes, all the currency names get in our gnucash.pot because we have ripped a piece of code from goffice instead of depending on it.
16:20:02 <sefnot> should I proceed to update old account and old vendors to new currency in sql as a workaround?
16:20:12 <gjanssens> I was hoping to import the translations as well (with some scripting voodoo) but haven't gotten around to that yet.
16:20:48 <warlord> sefnot: I dont know. I'm not sure how you could even have multiple currency entries for the same currency!
16:22:55 <sefnot> It would be nice to avoid any unintended consequences.
16:23:05 *** jchonig has quit IRC
16:24:23 <warlord> Indeed.
16:24:47 *** gjanssens has quit IRC
16:44:22 *** fabior has quit IRC
16:49:34 <sefnot> '44464ab1b91ff1f930f48fe6b81ee760', 'WÄHRUNG', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
16:49:36 <sefnot> '152fea8aea8fbe8290df4d158315e0bb', 'CURRENCY', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
16:49:50 <sefnot> so I have english euros and german euros in my db
16:59:04 <sefnot> As far as I understand I need to change somehow to german euro. Maybe in gnucash settings?
16:59:08 <sefnot> file
17:01:25 *** fbruetting has quit IRC
17:11:48 <warlord> That looks like a MAJOR bug!
17:12:22 <warlord> @tell gjanssens <sefnot> '44464ab1b91ff1f930f48fe6b81ee760', 'WÄHRUNG', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
17:12:22 <warlord> <sefnot> '152fea8aea8fbe8290df4d158315e0bb', 'CURRENCY', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
17:12:22 <gncbot> warlord: The operation succeeded.
17:12:47 <warlord> (hopefully gncbot got both lines)
17:13:04 <warlord> @tell gjanssens <sefnot> '152fea8aea8fbe8290df4d158315e0bb', 'CURRENCY', 'EUR', 'Euro', '978', 100, 1, 'currency', ''
17:13:04 <gncbot> warlord: The operation succeeded.
17:13:09 <warlord> just in case
17:13:32 <warlord> @tell gjanssens --- why would the DB have two EUR currencies, with the namespace in German?
17:13:32 <gncbot> warlord: The operation succeeded.
17:14:49 <jralls> Looks to me like 781634 tripped you up. Let's reopen that.
17:17:14 <sefnot> crap, not going to make it to revenue agency tomorrow.
17:17:55 <jralls> warlord: sefnot reffed bug 781634 earlier. In working it gjanssens discovered that the category CURRENCY was marked for translation, but that only German and Finnish had msgstrs for it. I think he took off the translation mark, but there's a lot of discussion about changing the namespace to ISO4217 too, so I'm not sure.
17:18:38 <jralls> Another possible cause would be if sefnot generated transactions with different locale settings, one German, one not.
17:20:27 <jralls> sefnot: I suggest that you first backup your database then try an update query to replace all instances of 44464ab1b91ff1f930f48fe6b81ee760 with 152fea8aea8fbe8290df4d158315e0bb and delete the WÄHRUNG row in the commodities table.
17:21:53 <jralls> You might want to clear out all of the price table entries that set a rate between the two while you're at it.
17:22:33 <sefnot> Ok that was an open question for me if I could clear the price table
17:25:13 <jralls> You don't want to completely empty it, just do a delete query where either commodity_guid or currency_guid is 44464ab1b91ff1f930f48fe6b81ee760.
17:27:40 *** chf has quit IRC
17:34:57 <jralls> warlord: I need to replace code:public_html/win32/releases/gnucash-setup-2.7.0.exe. Would you please delete it for me?
17:38:17 *** chf has joined #gnucash
17:42:15 *** pilotauto has joined #gnucash
17:51:01 <sefnot> jralls: At first glance, everything appears to be working now.
17:51:29 <jralls> Good. You're date with the tax man is saved! ;-)
17:51:53 <jralls> Do you think that you might have run GnuCash with different locale settings at some point?
18:00:18 <sefnot> According to the DB the currency switched from 44464ab1b91ff1f930f48fe6b81ee760 to 152fea8aea8fbe8290df4d158315e0bb after I updated to 2.16.18 3a9fbb8+ today. And the DB had older entries of 152fea8aea8fbe8290df4d158315e0bb.
18:04:06 <jralls> What version were you running before today?
18:08:46 <sefnot> [2017-06-02 20:59] [ALPM] upgraded gnucash (2.6.16-1 -> 2.6.16-2)
18:09:39 <sefnot> [2017-10-17 18:19] [ALPM] upgraded gnucash (2.6.16-2 -> 2.6.18-3)
18:19:22 <sefnot> # 2017-03-10T20:45:51 CET locale-gen
18:19:58 <sefnot> March 10th was the last time I changed locales.. before installing gnucash
18:20:57 <sefnot> [2017-03-19 21:08] [ALPM] installed gnucash (2.6.15-1)
18:21:00 *** rickoehn has quit IRC
18:21:01 <sefnot> First install of gnucash
18:23:23 <jralls> Can you query your backup database to see the date range of the transactions with the 444... currency?
18:25:16 <jralls> I'm interested in date-entered, not date-posted.
18:26:32 *** bertbob has quit IRC
18:27:47 *** ArtGravity has quit IRC
18:27:54 <sefnot> I don't have useful data as I've just migrated to gnucash in the last week or so. Took me a four months to read the damn handbook.
18:28:21 *** ArtGravity has joined #gnucash
18:32:12 <jralls> Hmm. That's disturbing, it means that transactions were created with both currencies under 2.6.16 in a single locale.
18:33:34 <jralls> Did you create the database under 2.6.15?
18:33:40 <sefnot> jralls: no 2.6.16 only has the german currency
18:34:22 <sefnot> yes the database was created with 2.6.15 orignally and it had english euro variant.
18:34:50 *** bertbob has joined #gnucash
18:43:03 <sefnot> INSERT INTO prices VALUES '152fea8aea8fbe8290df4d158315e0bb', '44464ab1b91ff1f930f48fe6b81ee760', '2017-03-30 22:00:00',
18:43:29 <sefnot> here an old entry showing that I had two currencies in 2.6.15 already..
18:43:51 *** Chris has joined #gnucash
18:49:24 <jralls> Interesting indeed.
18:54:20 <sefnot> Perhaps I did change language of gnucash shortly after install.. I don't know.
18:55:52 <sefnot> Although shouldn't I be able to change language as I please?
18:56:18 <sefnot> For example, tomorrow I feel like changing the interface to french....
18:57:56 <jralls> You should. That's the focus of bug 781634, that changing the language changes the actual namespace instead of changing what's presented to the user.
19:01:31 <sefnot> So perhaps the bug is solved in 2.6.18 but I was infected since atleast 2.6.15... and db had to be manually fixed.
19:03:07 <jralls> It's partly fixed in 2.6.18. The fix seems not to have included a scrub function to fix any databases that had been messed up by the bug.
19:03:41 <jralls> Since you've done that fix by hand you should be OK in future.
19:03:49 *** ArtGravity has quit IRC
19:04:21 *** ArtGravity has joined #gnucash
19:27:24 *** ArtGravity has quit IRC
19:31:06 <warlord> jralls: 2.7.0 or 2.7.0-1?
19:31:31 <jralls> Both, unfortunately.
19:31:51 <warlord> rm'd
19:31:58 *** tuxd00d has joined #gnucash
19:32:56 <jralls> Thnaks
19:33:00 <warlord> np
19:38:58 *** tuxd00d has quit IRC
21:15:27 *** mdf has joined #gnucash
22:16:43 *** User has quit IRC
22:44:51 *** tuxd00d has joined #gnucash
22:47:11 *** tuxd00d has quit IRC
22:56:33 *** tuxd00d has joined #gnucash
23:25:28 *** tuxd00d has quit IRC
23:25:51 *** tuxd00d has joined #gnucash
23:39:38 *** jquin has joined #gnucash