2009-07-02 GnuCash IRC logs
00:46:50 *** localhost has quit IRC
00:54:19 *** localhost has joined #gnucash
01:12:48 *** hvx has joined #gnucash
01:33:04 *** hvx has quit IRC
01:47:15 *** MechtiIde has joined #gnucash
01:58:51 *** MechtiIde has quit IRC
02:36:47 *** goodger__ has joined #gnucash
02:45:07 *** goodger_ has quit IRC
02:45:17 *** goodger_ has joined #gnucash
02:49:01 *** goodger__ has quit IRC
02:49:16 *** bentob0x has joined #gnucash
02:55:00 *** goodger__ has joined #gnucash
03:03:17 *** goodger_ has quit IRC
03:04:48 *** goodger_ has joined #gnucash
03:07:30 *** MechtiIde has joined #gnucash
03:08:59 *** goodger__ has quit IRC
03:10:21 *** phil has joined #gnucash
03:10:33 *** goodger__ has joined #gnucash
03:11:37 <phil> Hallo Zusammen, ich bräuchte mal einen kleinen Tip, wie man sprechende URLs in der MySQL - Datenbank ausschalten kann (ich kann mich gerade nicht einloggen)
03:19:07 *** goodger_ has quit IRC
03:29:06 *** bentob0x has quit IRC
03:33:33 *** goodger_ has joined #gnucash
03:42:29 *** goodger__ has quit IRC
04:55:17 *** Jimraehl has left #gnucash
05:00:08 *** Jimraehl has joined #gnucash
06:09:45 *** gordan has joined #gnucash
06:10:01 *** gordan has left #gnucash
06:48:21 *** ErKa has joined #gnucash
07:04:20 *** puck has quit IRC
07:08:38 *** puck has joined #gnucash
07:22:13 *** twunder has joined #gnucash
07:39:55 *** twunder has quit IRC
08:43:16 *** Jimraehl has left #gnucash
08:50:47 *** JimRaehl2 has joined #gnucash
08:56:02 *** warlord-afk is now known as warlord
10:20:28 *** bentob0x has joined #gnucash
12:39:35 *** the-moog has joined #gnucash
12:39:57 <the-moog> Some time back I asked the following question:
12:40:22 <the-moog> I have imported my bank statements into GC. I have created an invoice and tried to pay it, trouble is the payment also goes into the bank account. How do I link a bank transaction to an invoice?
12:40:34 <the-moog> The answer was:
12:41:06 <the-moog> You cannot "assign" an existing transaction to the invoice. (there is a feature request for that)
12:41:30 <the-moog> Does anybody know if that feature was implemented and if there is a BugTrack for it?
12:41:46 <warlord> No. Yes.
12:41:55 <warlord> The bugzilla entry is many many years old.
12:42:05 <jsled> http://bugzilla.gnome.org/browse.cgi?product=GnuCash is a good entry point for bugs
12:42:11 <warlord> Nobody is working on it, and it's unlikely to be worked on forquite a while.
12:42:19 <the-moog> I can see it is a popular request :(
12:42:37 <the-moog> Is there a workaround?
12:42:54 <warlord> Process Payment first, then during import mark the imported txn as a dup.
12:43:50 <the-moog> Ah, yet I think it was yourself that mentioned that last time, but this means putting in years of invoices before doing the bank import.
12:44:10 <the-moog> I was kind of hoping that the issue was resolved, oh well.....
12:44:13 <warlord> Yep! Or ignoring the "invoicing" of previous history.
12:44:36 <warlord> Nope, and unlikely to get resolved anytime soon unless some coder comes along and wants to do it.
12:45:17 <the-moog> I'd be happy to have a go, but I know nothing about the internals of GnuCash and would not know where to start.
12:46:43 <the-moog> I guess the work entering 9 years of invoices is probably less than the learning curve on GnuCash's code structure.
12:47:32 <warlord> I'd recommend you ignore the 9 years of invoices and just start from, say, Jan 1 2009
12:47:59 <the-moog> Even that is a daunting task. The last year has been the busiest ever.
12:48:15 <the-moog> Hence the need for an accountancy program, still using excel
12:48:29 *** nimrod has joined #gnucash
12:48:29 <the-moog> And a bank import routing I wrote in VB
12:50:04 <warlord> Let me rephrase: Feel free to import all your old transactional data, but only deal with invoices going forward. Only enter your current outstanding invoices, but beyod that dont worry about it.
12:50:11 <warlord> I presume you have paper backup of previous history.
12:54:34 <the-moog> Yes I do, but I tried that (I'm a GC/book keeping noob) and the accounts don't balance. I'm a better engineer than accountant !
12:54:45 <the-moog> I'm probably simply setting GC up wrong.
12:57:54 <the-moog> I'll have another play when I get a chance, thanks!!
12:57:57 <warlord> Multiple currencies?
12:58:20 <the-moog> No
12:59:01 <warlord> Umm... Maybe imblanced txns? Which importer did you use?
13:00:39 <the-moog> QIF - though a third party program that generates QIF from Excel. The import data is perfect, it just breaks when I include invoices.
13:01:21 <the-moog> Its a while since I looked at it (January) and at the time I came to the conclusion that I'd wait to see if the feature emerged, I don't think I realised now low priority it is.
13:02:07 <warlord> Check the Invoice txns -- Are you sure you're a single currency>
13:02:07 <warlord> ?
13:03:23 <the-moog> The problem is that invoices generate payments, as do bank imports, duplicating payments. I suppose I could fudge it by splitting the importing up to the invoice, then generate the invoice and remove the bank credit from the import.
13:04:20 <warlord> This is why you need to Process Payment first, then during the import mark the payment txn as a Dup.
13:04:21 <the-moog> I was kind of hoping that it would be able to use the bank data without messing with it going forward to verify the bank matches external records.
13:05:40 <the-moog> Yep, I understand.
13:13:53 <warlord> ok
13:14:16 <warlord> As for why it's not balancing, do you mean that it doesn't match your current account, or that the balance sheet report isn't balancing?
13:15:04 <the-moog> The value of all accounts does not match the bank balance, its out by the sum total of all paid invoices.
13:15:08 *** MechtiIde has quit IRC
13:15:34 <the-moog> .....or at least that is how I recall it, it was months ago when I last tried to get it working.
13:16:04 <warlord> that implies you didn't mark your invoices as dups..
13:16:22 <warlord> (assuming gnucash is reporting higher)
13:16:46 <the-moog> Indeed
13:18:09 <the-moog> I'm too busy at the moment to try it again given how much time I spent on it before and how successful it was, but perhaps sometime before 2010 I'll give it another go.
13:18:40 <the-moog> I don't suppose you know the reference for the enhancement request relating to this?
13:18:59 <the-moog> I've tried searching for it but I'm probably using the wrong words.
13:21:33 <the-moog> Not that I've got the time to fix it, but it would be nice to know somebody else has had the same problem even if a long time ago. Perhaps notes attached to the request will help me understand the correct way of using it.
13:22:00 <warlord> http://bugzilla.gnome.org/show_bug.cgi?id=108570
13:24:52 <the-moog> I see it rears its head every year and then dies again. By the way Derek answers the questions it looks like not an easy thing to fix.
13:25:25 <the-moog> Gota go, thanks for the help
13:25:28 <the-moog> bye
13:28:18 <warlord> That would be me.
13:28:20 <warlord> :-D
13:30:04 <the-moog> And here's me thinking you drive round selling arms and need GnuCash to keep track of your ill gotten gains. Hhehe
13:30:51 <warlord> LOL
13:34:00 *** the-moog has quit IRC
14:15:20 *** andyt has joined #gnucash
14:28:07 *** MechtiIde has joined #gnucash
14:37:11 *** hvx has joined #gnucash
14:38:58 *** XiXaQ has joined #gnucash
14:40:40 *** nimrod has quit IRC
15:13:01 *** palatin has joined #gnucash
15:28:08 *** bentob0x has quit IRC
15:40:36 *** Rolf1 has quit IRC
15:55:01 *** hvx has quit IRC
16:08:36 *** XiXaQ has quit IRC
16:35:41 *** palatin has quit IRC
17:02:15 *** nimrod has joined #gnucash
17:04:22 *** nimrod has left #gnucash
17:14:22 *** hvx has joined #gnucash
17:20:22 *** kling0n has joined #gnucash
17:34:51 *** phil has quit IRC
17:50:56 *** MechtiIde has quit IRC
18:09:51 *** hvx has quit IRC
18:33:07 *** andyt has quit IRC
18:58:01 *** warlord is now known as warlord-afk
19:11:34 *** kling0n has quit IRC
19:49:57 *** goodger__ has joined #gnucash
19:58:00 *** goodger_ has quit IRC
20:18:35 *** ErKa has quit IRC
20:34:39 *** vantage has joined #gnucash
21:10:19 *** vantage has quit IRC
21:56:27 *** beawealthy2 has joined #gnucash
21:58:39 *** beawealthy2 has quit IRC
22:31:30 *** localhost has quit IRC
23:07:26 *** gasull has joined #gnucash
23:08:23 *** JimRaehl2 has left #gnucash
23:08:36 <gasull> Hi all. If I forgot to enter an opening balance when creating an account, can I enter it now? Thank you.
23:13:00 *** Jimraehl has joined #gnucash
23:31:49 *** gasull has left #gnucash