2008-06-10 GnuCash IRC logs

01:15:23 *** mrwilloby has quit IRC
01:15:43 *** ErKa has joined #gnucash
01:27:45 *** Phil has joined #gnucash
01:30:03 *** Phil is now known as BygByte
01:34:52 <BygByte> Hello! Can >>Cannot modify or delete this transaction. This transaction is marked read-only with the comment: 'Transaction Voided'<< be removed? Thnx
03:11:47 *** StocksR has joined #gnucash
04:10:01 *** nodje has quit IRC
04:41:28 *** kielein has joined #gnucash
05:06:38 *** ErKa has quit IRC
05:25:44 *** ErKa has joined #gnucash
06:48:41 *** ErKa has quit IRC
07:40:38 *** basanta has joined #gnucash
07:43:42 *** basanta has quit IRC
07:47:50 *** nodje has joined #gnucash
07:51:14 *** nodje has quit IRC
08:17:01 *** ErKa has joined #gnucash
08:35:36 *** warlord-afk is now known as warlord
08:36:02 <warlord> BygByte: You would have to un-void the transaction in order to remove it.
09:16:54 <BygByte> warlord: These entries allow NO editing in any field. They are the result of importing from Quicken. Each entry has "QIF" beneath the Transfer field and the letter "v" in the R field. I can easily hide the Unspecified account, but that disturbs my o/c personality...
09:17:58 <warlord> I was gonna ask how you created them.
09:18:11 <warlord> "Unspecified" means that you didn't set the GnuCash account in the payee/memo mapping during import.
09:24:35 <warlord> So why are you trying to delete these imported transactions?
09:24:45 <warlord> .. if you didn't want them, then why did you import them?
10:13:10 <BygByte> I'm a GnuCash newbie. I imported 18 files with no other quirks, nor did I see any reference during mapping. On the Quicken side, the Payee was **VOID**, marked as Reconciled, with $0.00 in the Payment and Deposit fields, but they can still be edited or deleted at any time. It may be an undocumented feature...
10:25:38 *** warlord2 has joined #gnucash
10:26:53 <warlord2> BygByte: it could be an undocumented feature. Void TXNs are uneditable in GnuCash.
10:27:09 <warlord2> And the most certainly *IS* a way to specify the account in the importer.. You double-click on it to select it.
10:30:52 *** CosmicRay has joined #gnucash
10:31:57 *** warlord has quit IRC
10:32:00 *** warlord2 is now known as warlord
10:32:01 <warlord> @op
10:32:01 *** gncbot sets mode: +o warlord
10:33:04 <CosmicRay> hi everyone. I am moving gnucash from one machine to another. I copied my gnucash data file to the exact same path on the destination machine, and copied ~/.gnucash over as well. when I run gnucash on the new box, it opens up the data file OK, but it thinks that it has to create every scheduled transaction going back to at least March, even though those were already created in the data file. how do I fix that?
10:33:46 <warlord> Are you sure it created those SXes before?
10:33:56 <CosmicRay> yes
10:34:04 <warlord> Hmm.. jsled?
10:34:22 <CosmicRay> what does jsled mean?
10:34:27 <jsled> me! :)
10:34:33 <CosmicRay> oh :-)
10:34:45 <jsled> That's weird. Your system date wasn't totally wrong on either box, right?
10:34:52 <CosmicRay> nope, they are both synced with ntp
10:34:57 <jsled> And you're sure you got the correct datafile? What's the filename?
10:35:19 <CosmicRay> Yes, I got the correct datafile though I may not have preserved its timestamp, if that could potentially be the issue
10:35:25 <jsled> naw.
10:35:28 <CosmicRay> I copied it with scp which would have given it a newer timestamp
10:35:34 <CosmicRay> where is the date of last run stored?
10:35:38 <jsled> We don't use th file timestamp for anything.
10:35:47 <jsled> The last-created date is stored in the SX structure in the datafile.
10:35:56 <jsled> You should be able to open the file and see it, if you like.
10:36:10 <CosmicRay> <sx:start>
10:36:10 <CosmicRay> <gdate>2007-03-01</gdate>
10:36:10 <CosmicRay> </sx:start>
10:36:10 <CosmicRay> <sx:last>
10:36:10 <CosmicRay> <gdate>2008-06-01</gdate>
10:36:11 <CosmicRay> </sx:last>
10:36:16 <CosmicRay> I'd buy June 1 as the date of last run
10:36:27 <jsled> So, wtf?
10:36:45 <CosmicRay> the march 1 date is what it appears to have been using
10:36:59 <CosmicRay> let me look at the other sx sections...
10:37:01 <jsled> Did you change gnucas version?
10:37:32 <CosmicRay> I don't *think* so, but it is possible there was a minor version upgrade
10:37:35 <CosmicRay> hrm this is weird
10:37:39 <CosmicRay> <sx:start>
10:37:39 <CosmicRay> <gdate>2008-05-16</gdate>
10:37:39 <CosmicRay> </sx:start>
10:37:40 <CosmicRay> <sx:last>
10:37:40 <CosmicRay> <gdate>2008-06-13</gdate>
10:37:41 <CosmicRay> </sx:last>
10:37:43 <CosmicRay> an sx:last in the future
10:37:57 <jsled> Is that SX setup to create in advance or anything?
10:37:58 <CosmicRay> the new pc is running 2.2.4
10:38:02 <CosmicRay> yes
10:38:10 <CosmicRay> I have everything set up to go in 15 days in advance, I believe.
10:38:30 <jsled> Ah, then that could make sense; it's the last creation date, not last interrogated/processed date.
10:38:40 <CosmicRay> oic
10:39:00 <CosmicRay> the sx:last looks reasonable for all transactions
10:47:50 <jsled> CosmicRay: is there any "temporal state" associated with the transactions?
10:48:01 <CosmicRay> what should I look for in the data file?
10:48:13 <CosmicRay> the word "temporal" doesn't occur with it, in any case
10:48:14 *** warlord has quit IRC
10:48:33 <jsled> Uh ... "deferredInstance"
10:48:34 <jsled> ?
10:48:47 <CosmicRay> nope, doesn't occur anywhere
10:49:00 <jsled> When you do the SinceLastRun dialog, what state are the historical instances in?
10:49:17 <CosmicRay> let me run it again...
10:49:46 <CosmicRay> It shows "Created" for them all
10:50:10 <CosmicRay> It's creating them as far back as 3/26 for some, most are from 4/1
10:50:16 <jsled> Oh? That means they were auto-create transactions.
10:50:16 *** warlord has joined #gnucash
10:50:16 *** gncbot sets mode: +o warlord
10:50:29 <CosmicRay> yes.
10:50:32 <jsled> If you click the "Review" checkbox and Ok, does it actually create them as such?
10:50:43 <jsled> And then, I presume, you don't save your file?
10:50:49 <CosmicRay> yes
10:50:50 <CosmicRay> correct
10:53:38 <CosmicRay> hrm. I'm looking back at the register and there are other things that are missing. it appears that the file last used is stored in gconf instead of in .gnucash. It is possible that I have the wrong one after all. I really apologize for that.
10:54:00 <jsled> Oh, no problem. The titlebar should tell you which file was opened.
10:54:15 <jsled> And, yes, the file history is stored in gconf
10:54:15 <CosmicRay> is there a scenario where gnucash would create a copy of my file with a _2 appended at the end?
10:54:23 <jsled> *just* a "_2"? No.
10:54:28 <CosmicRay> hrm.
10:54:40 <jsled> We create ${basefilename}.{timestamp}.xac and .log files.
10:54:50 <jsled> But that timestamp is a bunch of numbers.
10:54:58 <CosmicRay> weird. I certainly don't remember doing that, but the file in ~/.gnucash/books that ends with _2 has a more recent timestamp
10:55:30 <CosmicRay> different bookguid though, so maybe that's what it's about.
10:55:31 <jsled> Your datafile isn't in ~/.gnucash/books/, is it?
10:55:36 <CosmicRay> nono
10:55:54 <CosmicRay> I'm not *that* nuts
10:56:05 <jsled> I could see the metadata maintained in ~/.gnucash/books/ would use a "_2" suffix to discriminate between books with the same basename.
10:56:14 <CosmicRay> yeah, that could make sense.
10:56:57 <CosmicRay> ah, so here is what was happening.
10:57:09 <CosmicRay> I had an older copy of the data file in a different directory on this new PC.
10:57:12 <CosmicRay> it had the same name.
10:57:17 <CosmicRay> this location was stored in gconf.
10:57:35 <CosmicRay> so when I opened gnucash, it loaded that old file, but because it had the same name, the titlebar looked correct.
10:57:51 <jsled> awesome.
10:58:12 <CosmicRay> definitely egg on my face for thinking copying .gnucash would get everything.
10:58:19 <CosmicRay> keep forgetting about that registry-lite that is gconf ;-)
10:58:38 <warlord> Heh
10:58:42 <warlord> Glad you got it working
10:58:57 <CosmicRay> thanks everyone for your help, even though I goofed ;-)
10:59:06 <CosmicRay> yep it is working correctly now.
10:59:07 <warlord> glad you got it working
11:00:08 <CosmicRay> a grep -ri DataFileName .[a-zA-Z]* gave me the clue
11:08:44 *** ErKa has quit IRC
11:09:05 *** StocksR has quit IRC
11:13:06 *** vico has joined #gnucash
11:22:34 <vico> Hi! I just installed GNUCash 2.4 on OpenSUSE 10.3. I am trying to continue using the same file I used for the last year with Ubuntu. I went to File->New File; File->File Open and navigated to the previously created file. Everything seems to be upto date. There is an issue though - at the bottom of the page where you have 'Grand Total: Assets: Profits:' I have all zeros. The next line down is all zeros too. The third line actually lists the
11:22:34 <vico> proper numbers with currency identification. I have a feeling this has something to do with the new file defaulting to USD (I am in Canada). Changing default currency to CAD under preferences does not seem to change anything. Is there a way get rid of the 'all-zeros' lines? When I generate reports I have zeros in the main column as well. I need to fix this somehow. Thank you!
11:23:50 <warlord> Change your computer's locale environment to en_CA
11:40:16 <vico> Thank you for the tip! I am currently trying to find where this variable is set. If you know where to find it, pls let me know!
11:42:57 <warlord> I dont do SuSE
11:43:42 <vico> Thank you anyway - I'll keep looking
11:46:47 <warlord> My first guess would be a system configuration screen?
11:54:02 <vico> Changing that did not help...Chaning 'Default Currency' in the Preferences of GNUCash did not work either. What did seem to work was changing the currency of the reports. Now those zero lines vanished. The only difference is that now I have 'CAD' in front of every amount, but that is probably because the 'Locale' is still US.
11:55:27 <vico> I'm not sure where exactly that is set yet...but other than that, it seems to work. Thank you for your help!
11:55:35 <warlord> Did you logout and login again after changing the system setting?
11:57:30 <vico> No I didn't...there was a dialog that popped up saying that changed settings will apply to 'all newly started apps'
11:57:39 <vico> So I closed GNUCash and opened it again
11:58:54 <warlord> how did you start gnucash?
11:59:12 <vico> through the start menu
12:00:09 <warlord> Well, start a new terminal and run "locale" and see what it says.
12:00:27 <warlord> Usually the locale setting doesn't take effect until your next login
12:01:44 <vico> yes...all of them are 'en_US.UTF-8'
12:01:50 <vico> learned something new today!
12:02:00 <vico> That's the case with linux :)
12:02:51 <warlord> there ya go
12:03:50 <vico> what is the distro of your choice?
12:05:10 <warlord> I use Fedora
12:07:25 *** CosmicRay has quit IRC
12:09:09 <vico> I never tried Fedora...what do you see as the main advantage over other distros you tried (I am guessing you've tried a few)
12:09:30 *** Pepe66 has joined #gnucash
12:12:29 <warlord> I haven't tried others. I've been a Red Hat user since RHL 3. Before that I used Slackware.
12:15:08 <vico> slackware is neat - gives a wierd sense of satisfaction for accomplishing a task commonly done through GUI via command line. lol
12:18:36 <warlord> It has ZERO package management
12:18:59 <warlord> The number of Clusers who come in here asking for help....
12:19:04 <warlord> On Fedora: yum install gnucash
12:19:13 <warlord> On Debian/Ubunutu: apt-get install gnucash
12:19:15 <warlord> You're DONE.
12:19:48 <jsled> It has package management … just incomplete packaging.
12:21:12 <vico> I'll have to agree with jsled...it has 'package management' just no dependency checking. But either way...it can be difficult to use...I installed it on an old box to learn more about linux itslef
12:21:46 <vico> but for every day use I lean towards more 'newbie' friendly distros
12:22:21 <warlord> Right
12:22:27 <vico> warlord, what is your role with gnucash?
12:23:27 <warlord> jsled: would you like to answer that for vico?
12:24:38 <jsled> uh, sure. Warlord added the business-accounting features, provides hosting for everything but www.gnucash.org, and has been one of and/or the lead maintainer for a number of years.
12:24:52 <jsled> warlord: fair enough?
12:26:11 <warlord> yeah.
12:26:13 <warlord> that works for me.
12:27:19 <vico> Wow! Well done on the business side of things...GNUcash seems by far the best financial software I've seen on linux! And if it wasn't for it, I would not be able to spend as much time in the linux environment (which at this point is all the time unless I need Adobe Flash/Illustrator/Photoshop)
12:28:53 <warlord> :)
12:30:41 <vico> how many people work practically full time on developping/maintaining gnucash?
12:32:03 <jsled> 0
12:32:43 <jsled> AFAIK, everyone who's contributing stuff is doing so in their odd free/personal time.
12:33:43 <vico> that is something that is truly fascinating about the linux community
12:34:38 <vico> There is so much great work being done 'in spare time'
12:35:54 <vico> are you in school? or working?
12:36:40 <jsled> I'm out of school, for many years, now.
12:37:08 <warlord> same here.
12:38:52 <vico> so I guess working then...are you both in the US?
12:39:08 <jsled> aye.
12:39:43 <vico> where in the US, if you don't mind?
12:40:45 <jsled> I'm in new england; in Vermont, in fact. Where are you located, vico?
12:42:13 <jsled> Saskatchewan?
12:42:16 <vico> lol
12:42:19 <vico> pretty close
12:42:29 <jsled> http://www.geoiptool.com/en/?IP=64.59.181.169
12:42:30 <vico> in in bloody cold Winnipeg, Manitoba
12:42:45 <jsled> Ah, that's what "wp" is in dx1ms-g15.wp.shawcable.net
12:43:36 <vico> I guess
12:43:37 <vico> lol
12:43:49 <vico> the shaw server is actually in Calgary
12:43:58 <vico> or gets routed through there
12:44:22 *** ErKa has joined #gnucash
12:44:33 *** BygByte has quit IRC
12:46:59 <vico> I am trying to figure out the best way to move to the US. Can't stand the -30 (Celcius) winters anymore
12:48:17 <warlord> It's 37C here today.
12:48:34 <vico> and where are you?
12:51:03 <warlord> Boston
12:51:24 <warlord> actually, it's only 28C right now.
12:51:29 <warlord> I think the 37C was yesterday.
12:51:46 <vico> that is HOT
12:52:19 <vico> We you bit by a "Beat LA" bug?
12:52:34 <warlord> Hahah.. Me personally> Nah.
12:53:31 <vico> are you by any chance watching the Euro?
12:53:49 *** BrianHV has quit IRC
12:55:30 <warlord> no. but I should. I'll be in Europe next month.
12:56:14 <vico> Russia and Spain are having a pretty good game right now
12:56:46 <vico> where in Europe?
12:59:12 <warlord> Germany and Ireland
13:00:25 <vico> nice places
13:00:58 <vico> like the rest of europe - so much stuff to see there
13:03:02 <warlord> Yeah
13:11:01 *** Rolf has joined #gnucash
13:19:38 <vico> i g2g...thank you for your help - it has been a pleasure chatting off-topic
13:19:48 <warlord> Enjoy
13:19:48 *** vico has left #gnucash
13:28:30 *** ErKa has quit IRC
14:12:00 *** cortana has joined #gnucash
14:12:34 *** |gunni| has joined #gnucash
14:36:18 *** sjc has joined #gnucash
14:58:09 *** donfede has joined #gnucash
15:00:34 *** benoitg has quit IRC
15:26:44 *** Aubrey has joined #gnucash
15:29:13 <Aubrey> Hi everyone
15:29:56 <Aubrey> First time I'm here. I have a quick question I'm hoping someone can help me with.
15:30:48 <Aubrey> I'm running Gnucash for my business and have messed up my reconciliation starting balance. Is there any way of correcting this?
15:31:13 <warlord> messed up how?
15:31:27 <warlord> Generally you can safely ignore the starting balance; it's the ending balance that needs to be correct.
15:33:46 <Aubrey> Well, I had to correct some figures and had to unreconcile some transactions. The problem is that the "Finish" button is greyed out until the balance of the recon is R0.00 which it won't be if the starting balance is incorrect.
15:37:51 <warlord> As long as the ENDING balance is correct then you just re-reconcile those other txns too and it all works out.
15:41:55 <Aubrey> I was under that impression too. However when I tick the problem transaction, I still don't get back to zero. Perhaps I need to look at it again and double check what the heck I'm doing - preferably not after I worked a 14 hr day. Thanks very much - I thought I wasn't going crazy!
15:43:31 <warlord> Well, if you change reconciled transactions then yes, that WILL unreconcile them.. But that begs the question: why are you changing them? And how are you changing them?
15:43:47 <warlord> If you're JUST changing accounts, then it should re-reconcile just fine.
15:44:10 <warlord> However if you changed the amounts, then that could throw it all off, and begs the question why you changed the values.
15:46:38 <Aubrey> Had to sort out some errors regarding payments on customers accounts. Had to delete the transactions and then reprocess them. But the amounts are (should be) the same. Hmmm... maybe need to double check that.
15:49:00 <warlord> USUALLY it's human error. ;)
15:50:38 <Aubrey> Yep - have to agree (specially when doing the accounts at 22h00!) Thanks for the pointers - will follow up on these. Cheers for now.
15:51:09 <warlord> good luck
15:52:06 *** Aubrey has quit IRC
16:10:19 *** nomeata has joined #gnucash
17:00:07 *** kielein has quit IRC
17:10:41 *** andi5 has joined #gnucash
17:10:41 *** gncbot sets mode: +o andi5
17:17:28 *** jsled has quit IRC
17:24:13 *** donfede has quit IRC
17:32:32 *** nomeata has quit IRC
17:48:08 *** jsled has joined #gnucash
17:48:09 *** gncbot sets mode: +o jsled
17:48:09 *** jsled has quit IRC
17:48:10 *** jsled has joined #gnucash
17:48:10 *** gncbot sets mode: +o jsled
18:50:08 *** nbinont has joined #gnucash
18:52:38 *** ErKa has joined #gnucash
18:53:50 *** andi5 has quit IRC
19:30:52 *** cortana has quit IRC
19:56:47 *** ErKa has quit IRC
20:01:25 *** warlord is now known as warlord-afk
20:34:49 *** twunder has joined #gnucash
20:36:22 *** localhost1 has joined #gnucash
20:42:42 *** nbinont has left #gnucash
20:42:50 *** localhost has quit IRC
20:55:29 *** twunder has quit IRC
21:07:48 *** Mr has joined #gnucash
21:08:47 <Mr> Just discovered GnuCash. Wanted to say thanks for the excellent work the devs have put in. Finally an accounting program I understand.
21:09:24 <Mr> Question/feature request: is there a way to see the list of invoices that I have without using the find function? AND
21:09:52 <jsled> AIUI, the only way to get at invoices is via find.
21:10:36 <Mr> I have a client that I do dozens of little jobs for and bill at the end of the month. These jobs, though not properly invoiced are still assets, Is there a way to have those small jobs show up in assets previous to my billing?
21:11:39 <Mr> Finally, a question open to interpretation: say I lend someone $5, or they lend me $5, how would you handle that in accounting terms?
21:14:59 <Mr> Sorry, one last additional question: I might have missed it, but is there a preference or option for having the "show income/expense" permanently checked in the transfer window? (I spend more time entering expenses than any other task)? Thanks!
21:17:04 *** sjc has quit IRC
21:56:21 *** Mr has left #gnucash
22:19:16 *** twunder has joined #gnucash
23:24:18 *** twunder has quit IRC