2007-05-12 GnuCash IRC logs

00:06:37 *** nbinont_ has joined #gnucash
00:15:39 *** nbinont has quit IRC
00:24:09 *** Demitar has joined #gnucash
03:20:59 *** jakin has quit IRC
03:33:15 *** Pepe66 has joined #gnucash
04:41:58 *** andi5 has joined #gnucash
04:41:59 *** gncbot sets mode: +o andi5
05:18:32 *** vinci has joined #gnucash
05:28:10 *** Rol1 has joined #gnucash
05:29:45 *** Hydroxide has joined #gnucash
05:30:32 <Hydroxide> for some reason, my gnucash account file has gotten out of balance, such that the trial balance has mismatched debits and credits, and the accounting equation doesn't hold true. Looking at transactions in the general ledger, I'm not seeing what's wrong. how can I fix this?
05:37:52 *** warlord-afk is now known as warlord
05:38:09 <warlord> Hydroxide: do you have any sales of a non-locale commodity?
05:43:15 <Hydroxide> warlord: you mean things like securities?
05:43:28 <Hydroxide> warlord: or only securities denominated in a foreign currency?
05:43:36 <warlord> yes
05:43:41 <warlord> any/all of the above
05:44:02 <Hydroxide> I do have securities, yes, though I don't think any sales specifically (only acquisitions and changes in value)
05:44:15 <Hydroxide> they're all denominated in my local currency though
05:44:33 <warlord> doesn't matter how they're denominated.
05:44:37 <Hydroxide> ok
05:44:40 <warlord> what do you mean by "changes in value"..
05:44:40 <Hydroxide> how do I fix this then?
05:44:47 <Hydroxide> just normal market fluctuations
05:44:54 <warlord> recorded how?
05:44:56 <Hydroxide> through the quotes system
05:44:58 <Hydroxide> not otherwise
05:45:03 <Hydroxide> price editor, etc
05:45:17 <warlord> so you've never sold a security? never transfered one security to another?
05:45:19 <Hydroxide> I also have some reinvestments, but I recorded that in the way mentioned in the gnucash concepts guide
05:45:40 <Hydroxide> ah, I may have transfered one to another, that's true
05:45:42 <warlord> reinvestments should be fine.
05:46:09 <warlord> you probably didn't account for the captial change during the transfer.
05:46:16 <warlord> anyways, I really need to go to bed.
05:46:20 <warlord> (it's almost 3am)
05:46:47 <Hydroxide> yes, I have it's 5:46 am here :)
05:47:11 <warlord> So are you just waking up on the east coast? Or are you still awake?
05:47:12 <Hydroxide> but, actually, it doesn't look like I did any of these transfers since I started using Gnucash
05:47:19 <Hydroxide> still awake :) going to bed shortly
05:48:15 <Hydroxide> so, no transfers even, though there was a transfer of securities from one account to another without selling them
05:48:44 <warlord> Have you ever crashed and run the "Log Replay"?
05:48:45 <Hydroxide> oh, and $1.62 of sales which isn't nearly enough to explain the difference
05:48:53 <Hydroxide> I've never explicitly run the log replay
05:48:56 <Hydroxide> it's possible it ran implicitly
05:49:09 <Hydroxide> I can't remember it crashing, though it's possible I'm forgetting one or at most two occurrences
05:49:36 <warlord> Another thing to try: run the Check&Repair function and then rerun the report.
05:49:40 <Hydroxide> what I have done is looked over the general journal, and I don't see any mismatched transactions
05:49:43 <Hydroxide> I've tried check&repair
05:49:47 <Hydroxide> didn't help
05:50:44 <warlord> It's not a question of mismatched transactions per se.
05:51:00 <warlord> Generally this type of problem happens when you go between different commodities.
05:51:07 <Hydroxide> well, the debits don't equal the credits
05:51:22 <Hydroxide> isn't that mismatched transactions?
05:51:28 <warlord> For example, I buy 10 shares of X for $100, then sell them for $200. You need to account for that extra $100 of income.
05:51:49 <warlord> In this case each transaction is completely balanced.
05:51:55 <warlord> BUT the combination of the accounts are not.
05:52:29 <Hydroxide> true.
05:53:02 <Hydroxide> well, the total amount of securities I've sold since I started using Gnucash was $1.62
05:53:07 <Hydroxide> and the difference is much larger than that
05:53:13 <Hydroxide> so that's not the explanation
05:53:50 <warlord> It's not the value of the sale.. It's the difference between the purchase and the sale.
05:54:00 <warlord> How much is the report out of balance?
05:54:08 <Hydroxide> hundreds of dollars
05:54:10 <warlord> (also, I should note that I've never actually USED the Trial Balance report)
05:54:22 <Hydroxide> about $724
05:54:37 <Hydroxide> well, all it does is add up all the debits in one column and all the credits in the other column, and gives you totals
05:54:49 <Hydroxide> but other reports like the balance sheet also do not balance
05:55:13 <Hydroxide> i.e., assets does not equal liabilities plus equity
05:55:17 <Hydroxide> in the balance sheet
05:55:44 <warlord> How much is the balance sheet off?
05:55:53 <Hydroxide> actually, same amount
05:56:25 <Hydroxide> $724.46
05:56:41 <Hydroxide> for both, to the penny
05:57:02 <warlord> Well, that's certainly interesting.
05:57:08 <warlord> What happens if you change the report date?
05:57:24 <warlord> go back a year..
05:57:31 <warlord> is it still out of balance?
05:58:06 <Hydroxide> I've only been using it since March 10 :)
05:59:28 <warlord> Okay, what's the oldest transaction you entered?
06:00:00 <Hydroxide> from January
06:00:32 <Hydroxide> I do note that the further back into the past I move the date of the trial balance, the smaller the difference gets
06:01:33 <Hydroxide> ok, I found the first day where they differ
06:03:25 <Hydroxide> there were some non-taxable mutual fund distributions (i.e. return of capital) which were reinvested into the fund
06:03:28 <Hydroxide> on that day
06:03:39 <Hydroxide> I followed the instructions I saw on gnucash mailing lists for recording that
06:03:59 <Hydroxide> that was the only unusual thing about that day
06:04:08 <warlord> I bet those transactions are wrong.
06:04:25 <Hydroxide> very likely. still have to figure out how.
06:05:30 <warlord> I'm afraid I can't answer that now. Send it to the list?
06:05:32 <warlord> I need to sleep.
06:05:34 <warlord> good night.
06:05:36 *** warlord is now known as warlord-afk
06:05:53 <Hydroxide> 'night, thanks for the help
06:48:46 *** andi5 has quit IRC
06:51:52 *** Zoolooc__ has joined #gnucash
07:01:11 *** Zoolooc_ has quit IRC
07:40:44 *** Zoolooc_ has joined #gnucash
07:43:59 *** Rich has joined #gnucash
07:48:09 *** trixpan has joined #GnuCash
07:48:21 <trixpan> hello
07:49:52 *** Zoolooc__ has quit IRC
07:50:56 *** trixpan has left #GnuCash
08:00:48 *** ErKa has joined #gnucash
08:21:51 *** Rol1 has quit IRC
09:15:17 *** BlackBsd has joined #GnuCash
09:58:30 *** tpfennig_ has joined #gnucash
10:06:38 *** vinci has quit IRC
10:32:58 *** hampton has left #gnucash
10:34:23 *** hampto1 has joined #gnucash
11:30:32 *** malikeye_ has joined #gnucash
11:35:54 *** warlord-afk is now known as warlord
11:36:29 *** malikeye has quit IRC
12:28:47 *** ErKa has quit IRC
12:31:13 *** bonez39 has quit IRC
12:34:21 *** warlord is now known as warlord-afk
12:50:02 *** hampto1 is now known as hampton
12:50:08 <hampton> @op
12:50:08 *** gncbot sets mode: +o hampton
13:03:47 *** motin_ has joined #gnucash
13:05:06 <tedcx> looks like link rot in the Custom Report Hello, World online link "You can learn more about writing scheme using this online book ."
13:07:02 *** motin_ has quit IRC
13:07:29 <jsled> tedcx: probably.
13:10:55 <tedcx> looks like http://www.scheme.com/csug7/ would do
13:16:49 <jsled> Hmm. That's a different scheme, and it looks like they explicitly have changed syntax.
13:16:57 <tedcx> Yes
13:17:34 <jsled> So, we probably shouldn't point people at it.
13:17:49 <tedcx> jsled: Or warn them
13:18:30 <jsled> Uh, the link in the report works for me... http://www.scheme.com/tspl2d/index.html
13:19:46 <jsled> Ah, I see. The links are fine. The report HTML widget is broke.
13:20:09 <jsled> Which makes sense, since we never did fix the HTTP handling.
13:21:10 <tedcx> jsled: created blank areas in the report window here. the toolbar still responds but the www.gnucash.org link doesn't respond to a button click now. have to kill the window
13:21:20 <jsled> Aye; when clicked:
13:21:20 <jsled> * 13:21:12 CRIT <gnc.gui> we've not supported network requests for years
13:21:36 * jsled nods.
13:21:57 <jsled> And we removed the forward/back navigation controls, which would probably get you back from never-never land.
13:22:00 * jsled removes the hyperlinks.
13:22:22 <jsled> Oh, no, the navigation is still there. It just doesn't work in this case.
13:23:06 <tedcx> jsled:http://www.scheme.com/tspl2d/index.html does work from a browser. perhaps just remove the link and provide the http: address
13:23:17 <jsled> yup.
13:24:02 <tedcx> is there a switch to not print the report warnings?
13:24:13 <jsled> I don't know what you mean.
13:25:10 <tedcx> The Tax Report includes warning messages which are fine, but should be ignored for a final report
13:28:39 <jsled> what kind of warning messages?
13:30:28 <tedcx> jsled: There are duplicate TXF codes types of messsages
14:44:36 *** fred has joined #gnucash
14:46:51 *** andi5 has joined #gnucash
14:46:51 *** gncbot sets mode: +o andi5
14:47:15 <fred> Aha! i finally found where to type... Hello world.
14:47:24 *** andi5 is now known as andi5|afc
14:51:28 <fred> i'm trying to set up a new set of books. Just got elected treasurer of my local church group. We basically have contributions and they must be "distributed" into several accounts, which are then sent or spent. A couple of accounts are: Bahai Center, Secretary, Teaching/Proclamation. i don't know if these accounts need to appear twice -- once as Income and then as Expenses or just once under??
14:52:17 *** Zoolooc__ has joined #gnucash
14:55:20 <fred> BTW, this is my first time using Chat. If i make a mistake, please correct me. Thank you.
15:01:31 *** Zoolooc_ has quit IRC
15:01:33 <nbinont_> Hi fred!
15:04:07 *** warlord-afk has quit IRC
15:05:01 <fred> Uh, hi nbinot!
15:06:07 *** tpfennig has joined #gnucash
15:06:35 <nbinont_> you have an income account where the money "comes from". This money can go to any of your asset accounts (your: Bahai Center, Secretary, Teaching/Proclamation ...these look like funding accounts). When money is "spent" to would go out to an expense account.
15:07:08 <nbinont_> each trasaction would be entered once, but will appear as a trasfer of money from one account to another.
15:08:14 <nbinont_> the docs http://svn.gnucash.org/docs/guide/index.html have a couple sections on this: http://svn.gnucash.org/docs/guide/chapter_accts.html and http://svn.gnucash.org/docs/guide/chapter_txns.html The last link may be more helpful
15:08:58 <fred> Thansk! nbinot! i'll check out those docs and get back if i have any questions. You've been very helpful. Have a great day! :)
15:09:35 *** fred has left #gnucash
15:15:40 *** Zoolooc_ has joined #gnucash
15:24:42 *** Zoolooc__ has quit IRC
15:41:30 *** Zoolooc__ has joined #gnucash
15:51:13 *** Zoolooc_ has quit IRC
15:56:16 *** cstim has joined #gnucash
15:56:17 *** gncbot sets mode: +o cstim
15:56:20 *** cstim has quit IRC
16:20:43 *** mcepl has joined #gnucash
16:32:27 *** andi5|afc is now known as andi5
16:47:13 *** sjc has joined #gnucash
16:48:05 *** cortana has quit IRC
17:10:09 *** cortana has joined #gnucash
17:13:36 <andi5> nbinont_: are you around?
17:15:18 <nbinont_> andi5: yes
17:15:54 <andi5> nbinont_: i just checked ftp://ftp.gnome.org/pub/gnome/binaries/win32.... they have some updates... especially gconf 2.14 -> gconf 2.18....
17:16:11 <andi5> now i wonder whether we should make the jump... .in case yes, then when? :)
17:17:31 <andi5> there are other updates as well, e.g. libgnome{,ui}, but i could imagine that there is not much news for win32 in them
17:18:25 <andi5> nbinont_: have you ever experienced problems with gconf?
17:19:18 <nbinont_> andi5: if we plan to update them before 2.2.0 I think we better do it soon.
17:20:40 <nbinont_> andi5: I had to rebuild it once or twice, but haven't noticed any problems
17:21:43 <andi5> i mean whether you had problems with gconfd-2 or gnucash starting up, popping up error dialogs or just taking very long
17:22:26 <nbinont_> andi5: no. nothing out of the ordinary
17:22:29 <andi5> i think i will not make any version update unless i know that it fixes a given bug....
17:22:56 <nbinont_> ok
17:23:01 <andi5> in the end, gconf 2.18 has the same dependency on orbit2
17:24:02 <andi5> nbinont_: have you tried reset.sh, btw?
17:24:20 <andi5> i have pimped it up a bit (after i ignored it for quite a while)
17:25:31 <nbinont_> with regards to the rebuilding libraries...If I understand it correctly, they need to be rebuilt when (a ) the version changes , or (b ) a library that the library depends on has a version change. Is this right or am I missing something
17:26:31 <andi5> maybe (c) the default setting for BUILD_WITH_XYZ changes
17:26:57 <andi5> this was the case with build_with_qt (or so)
17:27:46 <andi5> nbinont_: ahh... i definitely could add info like "this will require a rebuild of xyz" in the commit log
17:27:56 <nbinont_> no, I haven't been using reset.sh. I should start using it. (*checks script*)...hmm...seems to be nicer now
17:30:54 *** mcepl has quit IRC
17:32:04 <nbinont_> I like the commit log note...lets do that
17:32:25 <andi5> ok
17:32:54 <andi5> [ot] nice, gconf-editor.exe is back up and running
17:33:42 <andi5> seems like just building it is more helpful than whining about having to use gconftool-2 in cmd.exe....
17:43:39 *** malikeye_ has quit IRC
17:46:40 <nbinont_> For the libraries...I was thinking we could write the setup filename to a text file whenever we install a package. We can then add a check to make sure the version is correct by reading the text file and comparing the stored name it to the filename that we would download (in addition to the existing checks). If the version is wrong, we wipe it out, remove the setup filename from the text file, rebuild and write th
17:47:19 <nbinont_> btw...we could easily build a older version this way too...as it would detect the incorrect versions
17:49:21 <andi5> would that require a complete rebuild each time a commit has been made?
17:51:21 <andi5> say, revs 16080 to 16100 only require gnucash to be rebuild (maybe even only re-installed), ... you will not want to rebuild aqbanking then, right? ... i am sorry, i do not yet fully understand
17:51:43 <nbinont_> no, I was trying to get around that.
17:53:47 <nbinont_> the general idea is to keep track of which packages are installed (including their versions) - we currently make sure that the package is there (by verifying the files we need or that the directory is there), but not the versions.
17:54:06 <nbinont_> I assume we can distingush the versions by the downloaded filename
17:54:41 <nbinont_> so we store the downloaded filename to a text file whenever install.sh installs a package
17:54:52 <andi5> nbinont_: i guess my point of view is that it is much easier if we two agree what needs to be rebuild ;-)
17:56:48 <nbinont_> yes, that would work too - I fully agree, but I was trying to think of a method of letting install.sh do some of the bookkeeping in the future (maybe I should just do a patch to illistrate)
17:58:09 <andi5> nbinont_: feel free to do it ... experience has showed that if someone really tries to improve install.sh, he usually boosts its usefulness :)
17:59:56 <nbinont_> :)
18:03:12 <nbinont_> andi5: do you see any other reason to rebuild a library other than a BUILD_WITH_XYZ flag change && version change && dependency library rebuild ?
18:05:00 <andi5> no, not right now
18:05:39 <andi5> but once i see it i will cry out loud, put my finger on it and say "did not i tell you?" ;-)
18:05:52 <nbinont_> lol
18:11:56 <nbinont_> wonder where wilddev is...2.1.2 is today, right?
18:12:12 <andi5> i think so
18:12:23 <andi5> has anyone fixed make distcheck? ;-)
18:13:08 <nbinont_> don't know
18:17:58 <andi5> can somebody confirm that gnc_gconf_get_string always returns a valid UTF-8 string unless NULL?
18:19:06 *** Pepe66 has quit IRC
18:24:34 *** Hydroxide has quit IRC
18:24:34 *** motin has quit IRC
18:24:34 *** wizkid238_ has quit IRC
18:24:34 *** grandcanuck has quit IRC
18:24:34 *** tedcx has quit IRC
18:24:34 *** Def has quit IRC
18:24:34 *** Possum has quit IRC
18:24:34 *** nathan has quit IRC
18:24:34 *** rhowe has quit IRC
18:24:34 *** mishehu has quit IRC
18:25:48 *** Hydroxide has joined #gnucash
18:25:48 *** motin has joined #gnucash
18:25:48 *** wizkid238_ has joined #gnucash
18:25:48 *** rhowe has joined #gnucash
18:25:48 *** grandcanuck has joined #gnucash
18:25:48 *** tedcx has joined #gnucash
18:25:48 *** Def has joined #gnucash
18:25:48 *** Possum has joined #gnucash
18:25:48 *** mishehu has joined #gnucash
18:25:48 *** nathan has joined #gnucash
18:30:51 *** nbinont_ has quit IRC
18:30:59 *** nbinont has joined #gnucash
19:01:56 <andi5> Q: if gnucash fails to load the last used file, should it fallback and try the others?
19:51:16 *** tpfennig has quit IRC
20:07:13 *** sjc has quit IRC
20:14:54 <andi5> looks like no 2.1.2 today? ... well, we will see ... g'night
20:15:33 *** andi5 has quit IRC
20:28:44 *** nbinont has quit IRC
21:24:17 *** Zoolooc_ has joined #gnucash
21:30:20 *** tpfennig_ has quit IRC
21:33:24 *** Zoolooc__ has quit IRC
22:40:02 *** conrad has quit IRC
22:40:57 *** Zoolooc__ has joined #gnucash
22:50:17 *** Zoolooc_ has quit IRC
22:56:08 *** Zoolooc_ has joined #gnucash
23:05:21 *** Zoolooc__ has quit IRC
23:15:05 *** hampton has quit IRC
23:16:04 *** hampton has joined #gnucash
23:16:04 *** gncbot sets mode: +o hampton
23:37:58 *** motin has quit IRC