2012-08-26 GnuCash IRC logs
00:10:38 *** xnox has quit IRC
00:36:02 *** timfrost has quit IRC
00:52:36 *** jmd has joined #gnucash
00:55:55 *** jmd` has joined #gnucash
00:56:38 *** jmd has quit IRC
02:16:51 *** ErKa has quit IRC
04:04:22 *** warlord is now known as warlord-afk
04:04:56 *** Krzysiek_K has joined #gnucash
05:50:52 *** jmd has joined #gnucash
06:00:28 *** fell has joined #gnucash
06:00:29 *** gncbot sets mode: +o fell
06:17:39 *** mikee has quit IRC
07:32:47 *** mikee has joined #gnucash
07:33:10 <mikee> @op
07:33:10 <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.
07:33:51 <mikee> @op
07:33:53 *** gncbot sets mode: +o mikee
07:52:44 *** Jimraehl has joined #gnucash
08:35:43 *** arnotixe has joined #gnucash
08:42:46 *** Jimraehl has left #gnucash
08:50:50 *** warlord-afk is now known as warlord
09:07:46 *** Novacek has joined #gnucash
09:10:51 <Novacek> Hello, is there anybody willing to answer basic question about my problem with gnucash? It is about wrong summing of balances on accounts with subaccounts in generated reports. I think it is pretty serious program (for accounting SW) but I got no response at gnucash-user mailing list. Googling gave me nothing as well...
09:11:38 <Novacek> fix: *serious program* -> serious problem
09:16:58 *** Jimraehl has joined #gnucash
09:26:52 <Novacek> OK, now i read line about "don't ask to ask, just ask" ... so, my problem is: In ledger view I can see right amounts in Balance, correctly summing account with its subacounts. But in report view Balance numbers are all wrong because it doesnt sum subaccounts correctly. I can provide screenshots if requested. I have tried it with various gnucash versions.
09:30:56 <warlord> Novacek: define "all wrong". Are all accounts of the same currency?
09:31:08 <warlord> And did you send screenshots to the list?
09:32:55 <warlord> Also, which report?
10:02:15 <Novacek> all wrong could be understood from screenshot I guess: http://goo.gl/KEhu4 http://goo.gl/M2gM2 but I would be more than happy to spend any time needed to describe it if necessary...
10:05:37 *** pnema has joined #gnucash
10:07:19 <Novacek> and I am talking about report generated using "Reports" - "Account Report" from account-open subaccounts to have ledger showing account with its subaccounts (and there all balances are OK)
10:15:42 <Novacek> oh and yes, I attached same screenshots with my post to mailinglist
10:18:08 <warlord> Sorry, I must've missed the list mail.
10:18:28 <warlord> If you open up each individual account, do the balances in those accounts match up with what the report says?
10:24:03 <warlord> Internally GnuCash caches the balances, but only for the single account. In the Subaccounts view it recomputes the balances in real-time. But the report might not do that -- it might just take the actual Split Balance directly, which is why I asked the question and am waiting for your response.
10:31:30 *** Askarii has joined #gnucash
10:33:29 *** ErKa has joined #gnucash
10:39:07 <Novacek> Not sure if I fully understand (english is not my native language and this all is sometimes a little confusing)...Lets say that I have account "A" with subbacounts "AA" and "AB"... all balances from "AA" matches with "AA" report ... same for "AB"...but if I open "A" with "Open Subaccounts" then balances from ledger differs from generated ballances on report
10:41:09 <Novacek> and I forgot to say that everything is in same currency
10:45:07 <warlord> Novacek: You just answered my question: if you open a report of just AA and just AB with the same dates (and therefore same transactions), are the balances correct? You just answered that: yes, they are.
10:45:26 <warlord> ... which returns me back to my statement, that the report is using the cached Split Balance instead of computing it on the fly.
10:47:38 <warlord> So, I would recommend you file a bug report in Bugzilla
10:48:01 <warlord> I don't think there's an option to give you what you want.
10:48:10 <Novacek> OK, glad that I have answered something :) I take it that report is getting Balances in a way different from Ledger. Is there any way for me how to get report with same numbers as in ledger view?
10:48:55 <Novacek> Ah, OK... so I have to wait until someone fixes this... Strange that I am the first one who notices this behaviour.
10:48:55 <warlord> Like I said, the ledger is computing them, the report is taking the cached value. AFAIK there is no option to get the report to compute them.
10:49:12 <warlord> I doubt many people run a ledger report on "subaccounts"
10:52:08 <Novacek> Then I have to somehow get the reports with wrong numbers and process them by myself in Excel or something...I did it before but it is very time consuming. Anyway, I thank you very much for your time, at least I know that there is no mistake on my side.
10:53:53 <warlord> It should be easy, just replace the running balance with =<line_above>+<this_line>
10:54:07 <warlord> But yeah, that's unfortunately what I think you'll need to do.
10:55:49 <warlord> Another option to help you is to edit the report options and turn off "Running Balance" in the "Display" page.. Then load into Excel and re-add it.
10:57:12 <Novacek> sometimes it is quite complicated to force Excel to parse values from clipboard correctly, sometimes he decides that number with decimal point is date, no matter how cell format is defined. But those are different problems, out of topic of this chat. I will get it done somehow.
10:57:42 <Novacek> Last question - could you please fill the report to Bugzilla for me? I think that you fully understand my issue now and you will describe it much better than me... I understand that it would take some of your time, but I would be gratefull, if it is of any help to you :) If you refuse I will try to make it somehow on my own...
10:58:20 *** kpreid has quit IRC
10:58:47 *** kpreid has joined #gnucash
11:07:35 <warlord> It comes better from end users rather than from me.
11:08:14 <warlord> this way I can confirm "I see it, too"
11:12:20 <Novacek> Ah, OK, I will do my best. Thank you for your time
11:12:37 *** jmd has left #gnucash
11:14:29 <mikee> I think I see where the balances are from
11:15:01 <mikee> It's the balance of whatever account that transaction involves.
11:15:37 <mikee> Which I guess isn't what you(we)want.
11:15:38 <warlord> mikee: Yeah, it's just xaccSplitGetBalance()
11:15:45 <warlord> Right.
11:16:12 <warlord> The running balance should be computed, just like in the register. We just need to see what the register is doing and use that same API
11:16:20 <mikee> No idea how to fix it though. :)
11:17:24 <mikee> Would it be useful for Novacek to copy/paste this conversation into the bug report?
11:17:30 <warlord> Probably
11:17:35 <warlord> And attach the images.
11:37:28 <Novacek> Will do, as soon as I'll find some time to do it.
11:48:07 *** jmd` has quit IRC
11:55:00 *** jmd has joined #gnucash
11:56:29 *** jmd has quit IRC
12:22:57 *** pnema has quit IRC
13:10:26 *** sweetfancymoses has joined #gnucash
13:11:20 <sweetfancymoses> Can americans sign up for german accounts to use HBCI?
13:21:25 <fell> To use HBCI, you would need an account at a german bank. IIRC aqbanking also supports a few other european banks, but I am not shure that they offer all the features, HBCI has..
13:28:49 <fell> I am shure, you can open an account, if you registered a living place here in DE or probably somewhere else in the EU.
13:29:55 <fell> Some online banks might also offer accounts, if you are not living here, but I am not shure.
13:31:06 <fell> http://en.wikipedia.org/wiki/Central_Credit_Committee might give you an overview of there different types of gernan banks and further links.
13:34:12 *** jmd has joined #gnucash
14:06:50 <smw> sweetfancymoses, having a German account would be more... complicated then you are thinking
14:07:01 <smw> sweetfancymoses, it is not worth getting one for HBCI alone
14:07:10 <smw> although it is so damn tempting
14:07:22 * smw wishes the US had it so much
14:10:47 *** Askarii1 has joined #gnucash
14:18:34 <sweetfancymoses> thanks fell, smw
14:18:36 *** Askarii has quit IRC
14:20:08 <sweetfancymoses> Do I read correctly that in gnucash, online banking is only available to German users using HBCI?
14:21:02 <smw> Some american banks allow you to download transactions
14:21:24 <smw> but they don't allow you to initiate transactions (and whatever else HBCI can do)
14:23:57 <sweetfancymoses> that's what I thought
14:26:29 <smw> sweetfancymoses, you may want to consult people before opening up a bank account though
14:27:03 <smw> and think, do you really want your money in Euros right now? (Then again, do you want your money in dollars?)
14:27:05 <smw> lol
14:32:23 <sweetfancymoses> haha, true
14:33:01 <smw> The news about the Euro scares me right now, so does the Dollar, but I think you are better off keeping your native currency ;-)
14:33:10 * smw is not an expert of course
14:33:36 <smw> sweetfancymoses, not to mention the fact that if you get a German account, it will be difficult to use so for the most part your money will just sit there
14:33:46 <smw> what is the point of HBCI if you don't use it ;-)
15:10:24 *** Krzysiek_K has left #gnucash
15:15:45 <sweetfancymoses> smw: good point.. I pay most of my bills online, but I'm new to gnucash. Just read about it for the first time today. Didn't know if I could just use a German account to pay all my bills online. Probably more trouble than it's worth though.
15:25:25 *** Askarii1 has quit IRC
15:58:31 *** xnox has joined #gnucash
16:17:34 *** ErKa has quit IRC
16:49:51 *** jmd has joined #gnucash
17:01:23 *** jmd has quit IRC
17:01:40 *** nafg has joined #gnucash
17:39:19 *** Novacek has quit IRC
18:01:56 *** sweetfancymoses has quit IRC
18:22:20 *** fell_ has joined #gnucash
18:22:21 *** gncbot sets mode: +o fell_
18:31:30 *** fell has quit IRC
19:24:49 *** nafg has quit IRC
19:40:55 *** nafg has joined #gnucash
20:23:28 *** john has joined #gnucash
20:49:28 *** sweetfancymoses has joined #gnucash
20:51:04 *** arnotixe has quit IRC
21:05:47 *** john has quit IRC
21:18:44 *** ErKa has joined #gnucash
21:37:29 *** Askarii has joined #gnucash
22:04:18 *** pnema has joined #gnucash
22:26:19 *** Askarii has quit IRC
22:46:10 *** sweetfancymoses has left #gnucash
22:46:43 *** sweetfancymoses has joined #gnucash
23:04:28 *** pnema has quit IRC
23:06:34 *** xnox has quit IRC
23:36:26 *** nafg has quit IRC