2007-06-17 GnuCash IRC logs
00:09:48 *** wizkid239 has joined #gnucash
00:15:59 *** wizkid238 has quit IRC
00:33:19 *** Wilddev has joined #gnucash
00:33:19 *** gncbot sets mode: +o Wilddev
00:33:29 <Wilddev> hiya
00:44:23 *** andi5 has quit IRC
00:48:58 *** chintan has joined #gnucash
00:50:56 *** Search4Lancer has quit IRC
00:56:59 *** chintan has left #gnucash
01:40:33 *** Wilddev has quit IRC
02:27:20 <dacc> anyone awake?
02:45:01 *** roxy_ has joined #gnucash
03:50:51 *** johnf has joined #gnucash
03:51:53 <johnf> is it possible using scheme to create a report that shows everything in my bank account for a quarter but only if is taxable?
04:52:02 *** nomeata has joined #gnucash
05:10:48 *** nomeata has quit IRC
05:17:19 *** nomeata has joined #gnucash
06:07:21 *** Zoolooc has joined #gnucash
06:47:59 *** nomeata has quit IRC
06:51:55 *** Def has quit IRC
06:56:57 *** nomeata has joined #gnucash
07:10:13 *** johng has joined #gnucash
07:12:00 *** ErKa has joined #gnucash
07:18:28 <johng> Been using 1v6x on Ubuntu for some time now, and recently checked out the site and saw the new version 2 updates, and the release of a Windows version.
07:19:45 <johng> Been checking for upgrade or release notes in case there are any issues with upgrading. My questions are 1: can I upgrade directly to version 2 on Linux and are there any data file issues?
07:20:47 <johng> Question 2: if I have my datafiles on a common Fat32 partition can I access them from either Windows or Linux (not simultaneously)? are the data files completely interchangeable between Windows and linux?
07:22:06 *** {EyeGuy} has joined #gnucash
07:26:24 <{EyeGuy}> hey guys, gnucash keeps telling me that it could not reserve /home/my username/filename. I open it anyway, do some work and then it crashes on me. How do I fix the reservation thingy?
07:41:18 *** _gunni_ has joined #gnucash
07:53:37 *** Zoolooc_ has joined #gnucash
07:55:38 *** nomeata has quit IRC
08:01:53 *** Zoolooc has quit IRC
08:09:05 *** johng has quit IRC
08:09:26 *** twunder has joined #gnucash
08:12:26 *** johng has joined #gnucash
08:14:32 *** IanL has joined #gnucash
08:20:41 *** johng has left #gnucash
08:49:48 *** andi5 has joined #gnucash
08:49:48 *** gncbot sets mode: +o andi5
08:53:24 <andi5> {EyeGuy}: what version of gnucash is this? the reservation thingy here simply means that gnucash died, so it did not remove the lock file it created when opening the data file ..... a http://wiki.gnucash.org/wiki/Stack_Trace would be nice as well (pastebin it)
09:01:46 *** twunder has quit IRC
09:16:43 *** motin has joined #gnucash
09:17:39 *** twunder has joined #gnucash
09:34:58 *** roxy_ has quit IRC
10:30:00 *** ErKa has quit IRC
10:40:01 *** twunder has quit IRC
10:52:55 *** BlackBsd has joined #GnuCash
11:07:37 *** yesudeep has joined #gnucash
11:08:15 *** Demitar has quit IRC
11:21:25 *** nomeata has joined #gnucash
11:35:14 *** nomeata has quit IRC
11:35:15 *** BlackBsd has quit IRC
11:35:50 *** yesudeep has quit IRC
11:41:30 *** _gunni_ has quit IRC
12:37:16 *** twunder has joined #gnucash
12:38:43 *** _gunni_ has joined #gnucash
12:59:14 *** twunder has quit IRC
13:09:21 *** jamesthomas has joined #gnucash
13:09:51 *** Zoolooc__ has joined #gnucash
13:13:48 <jamesthomas> Hi. can anyone answer a basic question on split transactions?
13:14:27 <andi5> quote from the topic: """Don't meta-ask, just ask"""
13:15:52 <jamesthomas> I'm trying to add a Split transaction to show VAT for purchases I have made. can you talk me through this?
13:19:12 *** Zoolooc_ has quit IRC
13:19:52 <jamesthomas> I have a sub account in Expenses for Petrol, and want to show VAT in the split transaction but not sure what figures to put in each box
13:31:50 <andi5> jamesthomas: did you read http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_use_GnuCash_to_calculate_VAT.3F
13:31:52 <andi5> ?
13:43:08 <jamesthomas> yes I did. It didnt really help. For now I just want to show VAT as a sub account (Expenses: Taxes: VAT)
13:43:25 <jamesthomas> I'm a newbie at accounting
13:44:44 <jamesthomas> To enter a sPlit transaction, should i enter the description and esxpense and then hit split?
13:45:51 <jamesthomas> I have a bill for £20.01, where £17.03 is excluding VAT
13:47:41 <jsled> jamesthomas: you can hit "Split" whenever.
13:47:53 <jsled> All it does is toggle the "Split view" of the current transaction.
13:48:33 <jamesthomas> In the top line the total expense is 20.03.
13:49:53 <jamesthomas> i mean 20.01
13:52:11 <jsled> jamesthomas: what account's register are you viewing?
13:53:16 <jamesthomas> expenses:vehicles:petrol
13:53:40 <jsled> This is a bill you paid ... like at the gas pump?
13:53:48 <jamesthomas> yes
13:53:49 <jsled> It's usually easier to enter transactions from Asset accounts ...
13:53:58 <jsled> Did you pay with a card, or cash, or...?
13:54:03 <jamesthomas> card
13:54:17 <jsled> So, open the register for the card's account.
13:54:19 <jamesthomas> debit card
13:54:36 <jamesthomas> ok
13:54:50 <jsled> jamesthomas: have you read the gnucash tutorial and concepts guide? In the Help menu?
13:55:27 <jamesthomas> yes. couldnt understand everything
13:55:49 <jsled> Section 4.2.2 is your friend, but I'll say...
13:55:54 <jamesthomas> My bills paid I have been entering from the expenses register
13:56:15 <jsled> It's generally easier to enter from the Asset accounts, for a couple of reasons...
13:56:26 <jsled> 1/ you know how much you paid, but the expense portion can be variable.
13:56:54 <jsled> 2/ If you have a single payment/transaction that touches multiple Expense accounts, it's a bit easier to enter it from the "fixed" perspective of the payment/asset account.
13:57:13 <jamesthomas> I see, thanks
13:57:17 <jsled> In nay case, the key thing with split transactions is that the left and right columns must equal eachother.
13:57:26 <jamesthomas> I dont need to go back and re enter all though do I?
13:57:29 <jsled> All splits in every transaction sum to zero.
13:58:06 <jsled> So, if you pay out 21.01, and the actual expense is 17.03, then you also need a 3.98 split so everything balances.
13:58:47 <jsled> So, 1 "withdrawl" split from Assets:Debit (21.01) and 2 "expense" splits to Expenses:Vehicle:Petrol (17.03) and Expenses:Taxes:VAT (3.98)
13:59:02 <jsled> jamesthomas: no, you don't need to ... unless you want to change them.
13:59:52 <jsled> While it's a little easier (for me, at least) to reason about entering transactions from the Asset account's register, they're identical no matter where you enter them from.
14:00:06 <jsled> (unless you're going multi-currency or something...)
14:00:09 *** IanL has quit IRC
14:00:33 <jamesthomas> thats good to know
14:00:42 <jsled> In fact, you can enter transactions from anywhere, really, using the "advanced" register views like auto-split and transaction-journal...
14:01:13 <jsled> (Or even Basic, after you've pressed the Split button to get the "expanded" view)
14:02:24 *** nomeata has joined #gnucash
14:04:08 <jamesthomas> After I split, I'm entering the figure in the "decrease" box yes?
14:05:07 <jamesthomas> It added an imbalance of 40.02 ??
14:09:34 <jsled> well, then, you entered it on the wrong side.
14:10:22 <jamesthomas> I have Increase Decrease Balance
14:10:40 <jsled> For an asset account?
14:11:14 <jamesthomas> yes
14:11:17 <jsled> I guess so ... checking accounts have "deposit" and "widthdrawl" columns, anyways.
14:11:30 <jsled> But it doesn't matter...
14:11:39 <jsled> Given that you paid out money, this would be a "decrease", right?
14:12:03 <jsled> (in the right-hand column)
14:12:15 <jamesthomas> exactly
14:12:29 <jamesthomas> where I put it
14:13:06 <jsled> Okay. So the other two value have to both be in the left-hand column, and must sum to the same amount as the right-hand column.
14:17:46 <jamesthomas> What I need is Assets:Debit to show 20.01 Expenses:vehicles:petrol to show 17.03 and expenses:tax:VAT to show 2.98
14:18:09 <jamesthomas> like you said but its adding them all together
14:18:24 <jamesthomas> and putting in an imbalance
14:19:19 <jsled> If you put the 20.01 in the right hand column ("decrease") and the other two in the left column ("increase"), it shouldn't add the imbalance split.
14:20:35 <jsled> (though you might need to remove the existing imbalance split by deleting (the contents of) all the fields and clicking on another split.
14:21:09 <jamesthomas> bloody hell yes
14:22:07 <jamesthomas> that worked.
14:22:56 <jamesthomas> thankyou
14:23:23 <jsled> you're welcome.
14:24:57 *** twunder has joined #gnucash
14:25:45 <jamesthomas> CanI add a column in Asset account to show a cash payment?
14:26:13 <jamesthomas> I havnt seperated my accounting for using a debit card, cheque, cash
14:26:44 <jsled> No. But there's an 'Action' column that you might be able to use for such.
14:26:54 *** Demitar has joined #gnucash
14:27:19 <jsled> Another way to do it would be to make Cash a separate account.
14:27:43 <jsled> {Assets:Cash} or whatever.
14:28:08 <jamesthomas> I see
14:29:00 <jamesthomas> thanks for your help jsled. How do I show transfers from my business account to my personal account?
14:29:31 <jsled> Each set of accounts would be a separate datafile.
14:29:47 <jsled> Depending on how the transfer is made, it might be an Expense in one set of books, and Income in the other.
14:31:43 <jamesthomas> To show that i have transferred say £100 from my Asset:business register to my Asset:personal
14:33:27 <jsled> If you want to model it that way, I suppose you could just do that.
14:33:36 <jsled> But, IANAA. TINAA.
14:33:54 <jamesthomas> ?
14:34:27 <jsled> I Am Not An Accountant. This Is Not Accounting Advice.
14:34:38 <jamesthomas> ahhh
14:34:45 <jamesthomas> pretty good so far
14:35:39 <jsled> In any case, I've gotta go AFK. Should be back later, and slow in the mean time.
14:36:41 <jamesthomas> thanks again, I have some accounting to do now!!!
14:37:50 *** jamesthomas has left #gnucash
14:37:54 *** roxy_ has joined #gnucash
14:55:15 *** rhowe has quit IRC
14:55:19 *** rhowe has joined #gnucash
14:59:53 *** Demitar has quit IRC
15:10:01 *** sjc has joined #gnucash
15:22:12 *** twunder has quit IRC
16:10:19 *** andi5 has quit IRC
16:46:54 *** nomeata has quit IRC
17:01:54 *** nomeata has joined #gnucash
17:37:54 *** Demitar has joined #gnucash
18:00:21 *** roxy_ has quit IRC
18:02:23 *** nomeata has quit IRC
18:19:40 *** ErKa has joined #gnucash
18:54:11 *** ErKa has quit IRC
18:54:21 *** Esaj has quit IRC
19:04:32 *** Esaj has joined #gnucash
19:07:08 *** Demitar has quit IRC
19:13:29 *** Demitar has joined #gnucash
19:27:19 *** funky3k has joined #gnucash
19:29:21 <funky3k> hello, I installed v2.1.3 for windows, spent hours setting it up and saved before exiting. Now when I try to start gnucash it says the files are locked. If I try to open the files gnucash crashes. Any ideas? I really like the program otherwise.
19:32:45 <funky3k> I also tried removing the lock file. Same result just without the lock file prompt.
19:54:08 *** _gunni_ has quit IRC
20:03:24 *** sjc has quit IRC
20:16:48 *** ScislaC has joined #gnucash
20:18:51 <ScislaC> I'm running Ubuntu Gutsy and was going to compile Gnucash 2.1.4 and configure complained about SLIB, which I have installed.
20:18:57 <ScislaC> Any thoughts?
20:19:45 <ScislaC> I last compiled GnuCash 2.1.2, but that was on Feisty. So if anything I just have potentially newer libraries.
20:20:09 <jsled> ScislaC: The reqs haven't changed much btwn 2.0.x and 2.1.4 ... maybe install (or "build-dep" or something) the 2.0.x package first?
20:20:18 *** zombor has joined #gnucash
20:20:26 <ScislaC> jsled: will give that a shot
20:20:53 <zombor> how can I print things in just B&W? I don't see any print options like that in the print window
20:22:51 <ScislaC> jsled: it didn't lose anything when I dist-upgraded to Gutsy, and it has all it needs already... maybe my guile libs are conflicting somehow, I'll post back later either way.
20:34:29 <ScislaC> nope... no go, too weird
20:44:01 *** johnf has quit IRC
20:44:01 *** Hydroxide has quit IRC
20:44:01 *** Hydroxide has joined #gnucash
20:44:14 *** dacc has quit IRC
20:44:19 *** dacc has joined #gnucash
20:46:03 *** wizkid239 has quit IRC
20:50:16 *** wizkid238 has joined #gnucash
20:58:32 *** jakin has joined #gnucash
21:25:22 *** motin has quit IRC
21:27:56 *** spiritraveller has joined #gnucash
21:46:28 *** zarchne has joined #gnucash
21:51:04 *** Esaj has quit IRC
21:57:16 <funky3k> anyone have any ideas on my crashing issue from before? anything I can do to debug it?
21:59:15 *** Esaj has joined #gnucash
22:02:52 *** andi5 has joined #gnucash
22:02:52 *** gncbot sets mode: +o andi5
22:03:31 <lasindi> funky3k: Sorry, I don't know anything about the Windows version, but if you really want to debug it, you could try getting gdb set up and getting a backtrace. ...
22:03:46 <lasindi> That might take longer than just recreating the file though.... :-p
22:03:48 <andi5> that will probably not help very much
22:04:02 <andi5> funky3k: are you ready to try a few things?
22:04:08 <funky3k> sure thing
22:04:16 <funky3k> was going to recreate it all, but figured I'd check here first
22:04:35 <andi5> funky3k: first step: open explorer, find your home directory, something like c:\documents and settings\$user
22:04:49 <funky3k> I'm there
22:05:02 <andi5> funky3k: kill all running instances of gconfd-2.exe .... rename .gconf to something else, restart gnucash
22:05:10 <andi5> oh, and .gconfd too
22:06:46 <funky3k> well cool, it starts up now
22:06:54 <andi5> and it loads your data file?
22:07:19 <funky3k> no :/ just the regular app, one sec, trying to load it
22:07:36 <andi5> Q: did you change the "default currency" setting in the preferences dialog?
22:07:43 <andi5> ah, right... we disabled the history, i am sorry
22:07:45 <funky3k> nope
22:08:10 <funky3k> doh
22:08:26 <andi5> crash?
22:08:27 <funky3k> tried to open my old file, got the lock message, gnucash then crashed
22:08:52 <andi5> ok.... checkout ~\Local Settings\Temp\gnucash.trace.ABCDEF files
22:09:10 <andi5> then paste the newest ones to http://pastebin.ca
22:09:29 <andi5> it may or may not help us
22:09:37 <funky3k> will do
22:09:47 <andi5> (you can also send me your data file if you want to)
22:11:13 <funky3k> http://pastebin.ca/573261
22:11:17 <funky3k> looks halfway useful
22:12:25 <andi5> ah... may you open your data file in your editor?
22:12:34 <funky3k> sure, one sec
22:12:46 <andi5> it may look weird... you will have to gunzip it then first (get 7zip)
22:14:35 <funky3k> jedit seems to open it ok
22:14:45 <funky3k> xml?
22:14:57 <andi5> great... you added scheduled transactions, did not you?
22:15:04 <funky3k> yep, sure did
22:15:23 <andi5> what version of gnucash did you start with?
22:15:47 <funky3k> I imported a data file from ing direct, created a bunch of accounts, assigned all the transactions, then created a mortgage and car loan with the scheduled transactions module
22:15:50 <funky3k> v2.1.3
22:16:09 <funky3k> the latest windows release from what I saw
22:16:15 *** twunder has joined #gnucash
22:16:32 <andi5> search for <fs:ui_type>once</fs:ui_type> ... are there any?
22:16:56 <funky3k> there's one entry
22:17:13 <andi5> does http://bugzilla.gnome.org/show_bug.cgi?id=443941#c6 do the trick then?
22:18:14 <funky3k> which date is that supposed to be?
22:18:18 <andi5> funky3k: what is "ing direct", btw?
22:18:42 <andi5> well.... whatever you chose for that sx
22:19:03 <funky3k> ING is the banking company, ING Direct is thier online bank with checking and savings, 4% interest on checking
22:19:06 <andi5> funky3k: did you use the mortgage druid or the sx editor?
22:19:14 <funky3k> the druid I think
22:19:25 <andi5> ok, so you did not import scheduled transactions anywhere?
22:19:30 <funky3k> (www.ingdirect.com)
22:19:34 <funky3k> I don't think so
22:19:50 <andi5> the sx editor is the only possible source of that crappy xml output
22:20:19 <funky3k> ah, so the date is the day it is supposed to post the transaction? wasn't sure if it was maybe the first date or something
22:20:22 <andi5> do you remember such a scheduled transaction at all?
22:20:52 <funky3k> sec, looking over the xml format
22:21:07 <funky3k> I don't think it had actual posted any transactions yet
22:21:10 <andi5> well, that is a scheduled transaction that generates only one txn at one specific date (i.e. "once")
22:21:11 <funky3k> actually*
22:21:24 <funky3k> ah, hmm
22:21:33 <funky3k> I don't think I asked it to post only once
22:21:47 <funky3k> maybe once per month, but not just once
22:22:05 <andi5> jsled: go read that, it may help us :-) ... gnc v2.1.3 still does weird things :-D
22:22:34 <andi5> did you save the file and reload it?
22:22:38 <funky3k> can I just delete that "once" entry, up to sx:freqspec?
22:22:45 <funky3k> I'm still not sure which date to use there
22:22:50 <andi5> put any
22:22:58 <funky3k> k
22:23:02 <andi5> then try to load the file and check whether there is some bogus sx
22:23:20 <funky3k> put the first of next month, saving and opening, sec
22:24:02 <funky3k> huzzah!
22:24:06 <funky3k> it opened, checking it out
22:25:04 <andi5> damn, i really should make it non-crashy, at least :-)
22:25:13 <funky3k> haha
22:25:29 <funky3k> just port it to java then :0
22:25:43 <andi5> did you say anything?
22:25:56 <funky3k> <-- java programmer, sorry!
22:26:22 *** Zoolooc_ has joined #gnucash
22:26:23 <funky3k> thanks for the help, still looking, might have more info for you in a min
22:26:50 <andi5> oh, one minute is ok.... please keep in mind that it is 4:26am here :-)
22:27:32 <funky3k> yeesh, yeah, no worries, everything looks good. I'm not seeing my car payments that I setup, but I can do that again
22:28:05 <andi5> hm... how many sx do you have?
22:28:34 <andi5> i mean, ... is one missing and one bogus there?
22:28:46 <funky3k> 2 I thought, but when I went to sxe I see only one
22:28:55 <funky3k> the mortgage one
22:29:08 <funky3k> I'm pretty sure I had set both up though
22:29:27 <funky3k> let me see if the name is in the save file at all
22:29:51 <funky3k> nope, nothing
22:30:00 <andi5> hm
22:31:01 <funky3k> I think the car payment was the last sx that I setup before saving
22:31:03 <andi5> i have no clue, but i suppose your car payments have been messed somehow
22:31:27 <funky3k> it's not a big deal, the accounts and initial data were the important things
22:31:48 <funky3k> do you know what triggered the bad xml data? (so I can try not to do it again)
22:32:15 <andi5> i would rather like you did it again and told us what you did :-)
22:32:28 <funky3k> haha, will do
22:32:42 <andi5> please comment to the bug i pasted above
22:32:57 <andi5> i mean new information, of course :)
22:33:04 <funky3k> if I find anything I will
22:33:06 <funky3k> hehe yep
22:33:20 <funky3k> thanks again for the help, get some sleep!
22:33:35 <andi5> no problem, happy beta-testing :-) see you
22:33:52 *** andi5 has quit IRC
22:35:48 *** Zoolooc__ has quit IRC
22:48:32 *** funky3k has quit IRC
22:53:02 *** twunder has quit IRC
23:35:12 *** Esaj has quit IRC