2019-05-10 GnuCash IRC logs
00:15:38 *** boldstripe has quit IRC
00:16:35 *** boldstripe has joined #gnucash
00:17:49 *** badger92 has quit IRC
00:19:46 *** TheColonel has quit IRC
00:26:54 *** shoonya has quit IRC
00:42:17 *** peanutbutterandcrackers has joined #gnucash
00:42:17 *** ChanServ sets mode: +v peanutbutterandcrackers
00:45:37 <peanutbutterandcrackers> Does anyone here know how one could change the date-system in a program like GNUCash? As in, changing the date system from AD to use, say, Jewish Calender, or the Lunar calender systems from around the world. It would be preferable if this could be done in the reports, rather. Any ideas?
00:45:37 <gncbot> peanutbutterandcrackers: Sent 1 day, 12 hours, and 35 minutes ago: <fell> About https://lists.gnucash.org/logs/2019/05/07.html#T01:29:25 You should copy that text in a ReadMe file in your Repo and the ask on the Mailing lists for testers.
00:47:43 *** Mechtilde has joined #gnucash
00:49:50 <peanutbutterandcrackers> fell, Thank you. I will try to do that sometime soon. :)
00:52:24 *** Mechtilde has quit IRC
00:56:17 *** Mechtilde has joined #gnucash
01:05:28 *** fell_laptop has joined #gnucash
01:05:29 *** ChanServ sets mode: +o fell_laptop
01:07:11 *** fell has quit IRC
01:30:10 *** Mechtilde has quit IRC
02:09:28 *** peanutbutterandcrackers has quit IRC
02:16:19 *** boldstripe has quit IRC
02:17:16 *** boldstripe has joined #gnucash
02:19:14 *** peanutbutterandcrackers has joined #gnucash
02:28:28 *** peanutbutterandcrackers has quit IRC
02:50:47 *** gjanssens has joined #gnucash
02:50:47 *** ChanServ sets mode: +o gjanssens
03:08:19 *** Mechtilde has joined #gnucash
03:17:06 *** peanutbutterandcrackers has joined #gnucash
03:19:32 <gjanssens> .
03:32:41 *** Wilsona has joined #gnucash
03:32:42 *** ChanServ sets mode: +v Wilsona
03:36:51 <Wilsona> Hi All, one dude more..... Are there any option to negative quatity in the general account page?.... Now, you can check the option to display in red, but some people can not see this color
03:36:54 <Wilsona> Thanks!
04:17:02 *** boldstripe has quit IRC
04:17:59 *** boldstripe has joined #gnucash
04:34:56 *** storyjesse has quit IRC
04:46:06 *** marusich has quit IRC
04:47:21 *** peanutbutterandcrackers has quit IRC
04:50:24 *** peanutbutterandcrackers has joined #gnucash
04:55:58 *** chris has joined #gnucash
04:57:22 *** badger92 has joined #gnucash
05:25:22 *** peanutbutterandcrackers has quit IRC
05:34:21 *** peanutbutterandcrackers has joined #gnucash
05:47:40 *** peanutbutterandcrackers has quit IRC
05:48:15 *** peanutbutterandcrackers has joined #gnucash
06:01:57 *** monkeyjuice has joined #gnucash
06:02:54 *** monkeyjuice has quit IRC
06:14:23 *** oozer has joined #gnucash
06:17:43 *** boldstripe has quit IRC
06:18:38 *** boldstripe has joined #gnucash
06:35:42 *** Jimraehl1 has joined #gnucash
06:36:21 *** Jimraehl1 has left #gnucash
07:23:29 *** chris has left #gnucash
07:23:33 *** chris has joined #gnucash
07:25:34 *** peanutbutterandcrackers has quit IRC
07:33:57 *** fell_laptop is now known as fell
07:36:17 <fell> Wilsona, did you try to change the colour in CSS? https://wiki.gnucash.org/wiki/GTK3
07:41:26 <Wilsona> Any way, change the color could be rigth....
07:41:40 <Wilsona> thanks!
07:41:53 <Wilsona> I try this this afternoon.
08:15:32 *** ChanServ sets mode: +v chris
08:15:36 * chris eyes bleed looking at taxtxf.scm
08:16:59 *** jralls has joined #gnucash
08:17:54 *** ChanServ sets mode: +o jralls
08:20:03 <jralls> Wilsona: Your problem sounds like part of https://bugs.gnucash.org/show_bug.cgi?id=797134. Are you on Windows?
08:20:18 <Wilsona> yes...
08:20:36 <Wilsona> Windows 8.1 & 2008 server.
08:21:07 *** Mechtilde has quit IRC
08:21:28 <Wilsona> mmmmm
08:21:42 <jralls> Try the latest nightly from https://code.gnucash.org/builds/win32/maint
08:21:56 <Wilsona> but reading this.... i don't see nothing about negative symbol... only comm vs dot.....
08:22:53 <Wilsona> Any way... my installation is in English, and for currency to €, because since 3.4 Spanish Crash my GNU....
08:23:52 <Wilsona> Ok, any way, I goning to apply this new main.....
08:23:59 <jralls> How did you set English?
08:24:08 <Wilsona> Deafult..... ;-)
08:24:18 <Wilsona> enviroment default.
08:24:46 <Wilsona> If I apply language Spanish GNUcrash when record somwthing.....
08:24:47 <jralls> You mean for the whole computer or using c:/Program Files (x86)/gnucash/etc/gnucash/environment?
08:25:01 <Wilsona> environment file
08:25:03 <Wilsona> yeah
08:25:25 <jralls> That was part of the problem, should be fixed as well.
08:25:33 <Wilsona> I think I was speaking with you about you 3 month ago?.... perhaps?
08:25:51 <jralls> Maybe, don't remember.
08:26:01 <chris> Wilsona: the latest maint should fix a lot of language issues in Windows
08:26:33 <Wilsona> ok.... I apply now the new maint.....
08:26:39 <Wilsona> 1 minute i chek it... ;-)
08:27:02 <jralls> As for negative amounts they should have a sign or parentheses as well as being colored red.
08:28:19 <Wilsona> by default it apply negative amounts sign or parentheses?
08:29:18 <jralls> In the register, only - sign. Parentheses is an option on some reports.
08:29:49 <Wilsona> but in the account screens?
08:30:03 <jralls> That's the register.
08:30:45 <Wilsona> Labeled than "account", the principal?
08:31:00 <Wilsona> no - sing o parentheses..... :-(
08:31:11 <jralls> Sorry, what?
08:31:30 <Wilsona> jjja... sorry, I sure my english is not good.....
08:31:48 <jralls> It's better than my Spanish!
08:31:50 <Wilsona> Well...... The principal account screen is that you refer "Register"?
08:32:03 <Wilsona> where are all account tree?
08:32:20 <jralls> Ah, no, that's the Accounts page, sometimes called the chart of accounts.
08:32:27 <Wilsona> ok......
08:32:55 <Wilsona> In chart account.... it's possible see negative values?
08:33:45 <jralls> Yes, of course, if you have a negative balance in an account. There's no option for parentheses there either.
08:34:21 <warlord> note also that there is a preference as to whether to invert certain normally-negative accounts.
08:36:07 <jralls> True, though which way is inverted depends on one's point of view. For an accountant a liability or equity account should show its normal balance positive, for a programmer negative.
08:36:11 <Wilsona> Ok, but now I only can see the red color in negative values....
08:36:43 <Wilsona> Yes I now.... but the values in red color must be see with negative too? no?
08:36:51 <jralls> Do you mean that you're seeing red numbers without a - sign?
08:37:00 <Wilsona> Yes....exactly
08:38:17 <jralls> That's odd. What kind of account?
08:38:51 <Wilsona> For example, and general account results......
08:39:01 <Wilsona> with negative results.... of course....
08:39:08 <Wilsona> Year with lost....
08:39:10 <Wilsona> ;-(
08:40:01 <jralls> Sorry, don't understand. "General account results? Year with lost?"
08:40:15 <Wilsona> If you want a screenshot I do that....
08:40:21 <Wilsona> wait
08:40:25 <jralls> Please.
08:41:24 *** jervin has joined #gnucash
08:44:12 <Wilsona> Here you have a private....
08:44:24 <Wilsona> You can seed... red color but.... no negative sing....
08:45:19 <Wilsona> with the other account same.....
08:45:26 <chris> imgur.com is best for screenshots
08:45:44 <Wilsona> for example with the tax account....
08:45:49 <Wilsona> the same....
08:46:07 <Wilsona> Some tax account are positive but other and negative..... (red) but no sing....
08:47:32 *** jervin has quit IRC
08:49:29 <Wilsona> sorry.... I can see the results of the last years in a separatly accounts.
08:49:50 <Wilsona> If the year is negative, the result appears in RED......
08:50:30 <Wilsona> You know?
08:56:21 <chris> Wilsona: a screenshot would solve a lot of misunderstandings
08:56:28 <warlord> What do you mean "if the year is negative"?
08:57:54 <jralls> Wilsona, I didn't get a PM. Please put your screenshot on imgur or pastebin.
08:59:19 <Wilsona> https://drive.google.com/file/d/1pUOT2tejMC3isLO32zcEkZ4kF0jaxNMr/view?usp=sharing
08:59:30 <Wilsona> here you have.
09:00:29 <Wilsona> Can you see the screenshot now?
09:01:58 <fell> In Edit->Preferences->General:Number you can disable Display negative numbers in red',
09:02:37 <gjanssens> Is your column wide enough to display the full amount ?
09:02:54 <jralls> Yes. It appears you've created a P&L account (Resultado) with annual sub-accounts that you selected when you ran "Close book". Is that right?
09:03:10 <Wilsona> yes... but black color and no - sing....
09:03:19 <Wilsona> Yes, size perfectly.....
09:03:58 <jralls> Try dragging it wider just to be sure.
09:04:11 <jralls> GTG.
09:04:16 *** jralls has quit IRC
09:04:28 <Wilsona> Yes sure... with the size... belive me...
09:04:31 <Wilsona> ;-)
09:04:31 <chris> Wilsona: and what happens if LANG is reset to English in environment?
09:05:13 <Wilsona> Well... if in English... because it's run the default enviroment file.
09:05:47 <Wilsona> I now checking with the last main set to spanish....
09:05:49 <Wilsona> 1 minute...
09:06:57 <chris> looks like English anyway from the statusbar
09:07:24 <Wilsona> "Statusbar"? Windows?
09:11:08 <chris> I don't think we can tell from the screenshot why the red amount doesn't have negative sign. There must be something really odd in your Windows, your build, your environment, or your datafile. From all our knowledge, negative-number = red = negative-sign.
09:11:56 <Wilsona> mmm, well, but not is my computer... in the server or other terminals it's the same.
09:12:16 <Wilsona> 8.1, 2008 server... etc... etc..
09:12:59 <chris> I've used on W7 and W10 no issues
09:13:55 <chris> don't think any of the devs have 8.1 or 2008server to test
09:14:09 <Wilsona> mmm.. super... with this new maint... no problem using spanish....... !!!!!
09:14:39 <Wilsona> in my first try one record.....
09:14:42 <chris> so, perhaps when you've done enough experiments you can submit a bug report *and* the solution
09:14:48 <chris> and we'll be grateful ;)
09:14:53 *** omnireq has quit IRC
09:15:30 <chris> did the negative sign appear in latest maint?
09:17:09 <Wilsona> now with spanish: YES.
09:17:11 <Wilsona> ohhhhhh
09:17:27 <Wilsona> I looking and now, it's select local currency....
09:17:46 <Wilsona> With the default, I need to force €
09:17:58 <Wilsona> ufff... it's crazy!!!
09:18:28 <Wilsona> but now, with the new maint, change to spanish evrething is allraigth.
09:18:51 <Wilsona> I think it must be relation with the locale or force.....
09:19:01 <warlord> There COULD be a locale bug.
09:19:06 <Wilsona> but i don't know exacly.....
09:19:19 <Wilsona> I only do the change in the server......
09:19:31 <Wilsona> 1 minute... i go to change in a 8.1
09:19:36 <Wilsona> ...
09:23:18 <chris> gjanssens fell warlord any objection to merging the latest balsheet-pnl as it is? I don't think there's much to be gained by separating the (let* vars ...) into individual (define)s. in many ways using (define) will lead to more spaghetti code because (let* vars ...) are built incrementally top-to-bottom.
09:24:34 <gjanssens> chris: no objection from me, provided it produces correct results
09:26:16 <chris> ok it'll be in Reports>Experimental submenu
09:26:49 <chris> and I'll squash the whole history.
09:28:32 <gjanssens> That's fine
09:28:37 <warlord> chris, let is a perfectly reasonable scheme structure.
09:29:07 <fell> No objection here.
09:33:03 <Wilsona> And then too, if I set spanish language in enviroment file not crash when you introduce a new record.
09:33:26 <chris> balsheet-pnl: adds the moderately complicated (add-multicolumn-acct-table) function which could be reused by other reports. I will *try* convert an existing report to demonstrate code reuse; budget.scm is a good candidate.
09:33:28 <Wilsona> The version it is in the regular download have this problems.
09:33:48 <chris> Wilsona: it means the next version 3.6 due in less than 2 months will be fixed
09:34:17 <Wilsona> Super......! You are a good team! ;-)
09:35:04 <Wilsona> I sent to the team a donation for the today solution!!!!!.....
09:35:14 <Wilsona> many thanks!
09:36:12 <chris> :)
09:37:22 <warlord> Thanks, Wilsona
09:38:16 <Wilsona> No, no, thanks for you!
09:59:55 *** nimish2711 has joined #gnucash
10:17:20 *** boldstripe has quit IRC
10:26:34 <chris> sugar, distcheck seemed to work
10:39:52 *** peanutbutterandcrackers has joined #gnucash
10:43:05 *** nimish2711 has quit IRC
10:43:38 *** guak has joined #gnucash
10:48:42 *** kael has joined #gnucash
10:48:42 *** ChanServ sets mode: +v kael
10:49:25 *** nimish2711 has joined #gnucash
10:52:27 *** peanutbutterandcrackers has quit IRC
11:09:30 *** peanutbutterandcrackers has joined #gnucash
11:11:02 *** ArtGravity has joined #gnucash
11:11:02 *** ChanServ sets mode: +v ArtGravity
11:12:32 *** peanutbutterandcrackers has quit IRC
11:35:45 *** peanutbutterandcrackers has joined #gnucash
11:52:14 *** gjanssens has quit IRC
12:07:18 *** gjanssens has joined #gnucash
12:07:18 *** ChanServ sets mode: +o gjanssens
12:18:07 *** omnireq has joined #gnucash
12:45:55 *** nimish2711 has quit IRC
12:49:37 *** chris has quit IRC
12:55:30 *** peanutbutterandcrackers has quit IRC
13:16:34 *** nimish2711 has joined #gnucash
13:24:17 *** nimish2711 has quit IRC
13:27:48 *** nimish2711 has joined #gnucash
13:33:08 *** gjanssens_ has joined #gnucash
13:35:30 *** nimish2711 has quit IRC
14:17:41 *** ArtGravity has quit IRC
14:28:52 *** frakturfreak has joined #gnucash
14:28:52 *** ChanServ sets mode: +v frakturfreak
14:31:51 *** ArtGravity has joined #gnucash
14:31:51 *** ChanServ sets mode: +v ArtGravity
14:37:17 *** nimish2711 has joined #gnucash
14:38:14 *** calvinct has joined #gnucash
14:43:37 *** kael has quit IRC
14:43:39 *** kael has joined #gnucash
14:43:39 *** ChanServ sets mode: +v kael
14:45:46 *** nimish2711 has quit IRC
14:46:17 *** nimish2711 has joined #gnucash
15:17:10 *** calvinct has quit IRC
15:33:58 *** tienne has joined #gnucash
15:48:48 *** nimish2711 has quit IRC
16:15:42 *** zipppy has quit IRC
16:20:24 *** jervin has joined #gnucash
17:44:35 *** gjanssens has quit IRC
17:51:59 *** MarkFirewhal has quit IRC
17:53:41 *** MarkFirewhal has joined #gnucash
17:55:32 *** boldstripe has joined #gnucash
18:17:04 *** kael has quit IRC
18:47:25 *** Wilsona has quit IRC
18:47:42 *** Wilsona has joined #gnucash
18:47:42 *** ChanServ sets mode: +v Wilsona
18:51:10 *** kael has joined #gnucash
18:51:10 *** ChanServ sets mode: +v kael
18:51:56 *** kael has quit IRC
18:55:06 *** TheColonel has joined #gnucash
19:25:42 *** frakturfreak has quit IRC
19:39:08 *** tienne has quit IRC
19:48:19 *** guak has quit IRC
20:19:41 <CDB-Man_> [2019.05.08 06:30:04] <warlord> CDB-Man_, do you have a valid price quote in the pricedb?
20:19:42 <CDB-Man_> [2019.05.08 06:31:09] <warlord> CDB-Man_, actually, it looks like there is an invalid value in the pricedb for microsoft..
20:19:42 <CDB-Man_> warlord: yes, all the quotes are valid and only auto quotes from Finance::Quote are in the priceDB. I have 3 Microsoft GL accounts but only 1 of them throws the error, because only 1 of them has a blank $ value... that being said, manually re-typing the quote in quoteDB seems to have fixed it?
20:21:53 <CDB-Man_> warlord: I re-ran finance::quote just now by doing get quotes on the pricedb view, and it looks like that corrupted onc eof the prices again
20:21:59 *** CDB-Man_ is now known as CDB-Man
20:23:05 <CDB-Man> the only way that I'm able to isolate it... is if I run some report such as balance sheet, including each stock accoutn one at a time
20:23:12 *** jervin has quit IRC
20:23:21 <CDB-Man> since the balance sheet report (or any other report for that matter) doesnt tell me which account is giving the error
20:25:13 <CDB-Man> hmm, in the account tree view, it looks like I can use the "Present (CAD)" column to see what has no $ values assigned
20:27:56 *** peanutbutterandcrackers has joined #gnucash
20:28:43 *** boldstripe has quit IRC
20:30:09 *** boldstripe has joined #gnucash
20:34:01 <CDB-Man> warlord: microsoft currently doesnt have an issue, but VTI does, see screenshot: https://i.imgur.com/1FHAURk.png
20:34:37 <CDB-Man> if I retype the value in priceDB, it fixes the $ value from null/blank to the current value
20:35:56 <CDB-Man> despite correcting that one though, there still seems to be more hidden somewhere...
20:39:55 *** ArtGravity has quit IRC
21:00:32 <CDB-Man> so far, it seems only USD stocks have issues (my ledger is in CAD)
21:07:00 <CDB-Man> hmm, it looks like the balance seheet report fails if "show exchange rates" is checked
21:07:06 <CDB-Man> so SOMETHING has a broken FX rate
21:09:01 *** chris has joined #gnucash
21:09:01 *** ChanServ sets mode: +v chris
21:09:32 <chris> CDB-Man_ would be worth letting us know exactly which build you're running.
21:09:51 <CDB-Man> Version: 3.5
21:09:51 <CDB-Man> Build ID: 3.5+(2019-03-30)
21:09:51 <CDB-Man> Finance::Quote: 1.47
21:10:01 <chris> and tracefile
21:10:14 <CDB-Man> I was on 3.3+ befor eand same issue
21:10:22 <CDB-Man> Tracefile, where are those saved?
21:10:31 <chris> https://wiki.gnucash.org/wiki/Tracefile
21:10:48 <chris> and sorry I can't stay help gtg soon
21:10:51 <chris> file a bug
21:12:09 <CDB-Man> In srfi/srfi-1.scm:
21:12:09 <CDB-Man> 573: 3 [map #<procedure c0bf6c0 at report-utilities.scm:335:7 (pair)> (# # # ...)]
21:12:09 <CDB-Man> In commodity-utilities.scm:
21:12:09 <CDB-Man> 997: 2 [#<procedure 116cd0c0 at commodity-utilities.scm:989:10 (curr val)> # 1]
21:12:09 <CDB-Man> 848: 1 [gnc:exchange-by-pricedb-nearest # # 1577854799]
21:12:10 <CDB-Man> In unknown file:
21:12:13 <CDB-Man> ?: 0 [gnc-pricedb-convert-balance-nearest-price-t64 # 1 # ...]
21:12:15 <CDB-Man> ERROR: Throw to key `numerical-overflow' with args `("/" "Numerical overflow" #f #f)'.
21:12:31 <CDB-Man> looks like a possible backtick typo somewhere
21:14:33 *** chris has quit IRC
21:55:01 *** storyjesse has joined #gnucash
21:56:13 <CDB-Man> filed bug report: https://bugs.gnucash.org/show_bug.cgi?id=797233
22:08:22 *** alpha_ has joined #gnucash
22:09:36 *** peanutbutterandcrackers has quit IRC
22:17:11 *** alpha_ has quit IRC
22:17:20 *** alpha_ has joined #gnucash
22:20:24 *** oozer has quit IRC
22:29:53 *** boldstripe has quit IRC
22:31:20 *** boldstripe has joined #gnucash
22:55:18 *** TheColonel has quit IRC
23:00:23 *** storyjesse has quit IRC
23:01:28 *** storyjesse has joined #gnucash
23:03:28 *** CDB-Man_ has joined #gnucash
23:03:28 *** ChanServ sets mode: +v CDB-Man_
23:05:47 *** CDB-Man has quit IRC