2012-01-03 GnuCash IRC logs

00:27:28 *** kpreid has quit IRC
00:34:24 *** kpreid has joined #gnucash
02:31:13 *** gour has joined #gnucash
02:33:40 *** Fabzgy has joined #gnucash
03:05:45 *** ErKa has joined #gnucash
03:11:12 *** ErKa has quit IRC
03:20:11 *** ErKa has joined #gnucash
03:20:24 *** Fabzgy has quit IRC
03:21:43 *** ErKa has quit IRC
03:22:30 *** ErKa has joined #gnucash
03:23:55 *** ErKa has quit IRC
03:24:38 *** ErKa has joined #gnucash
03:28:10 *** ErKa has quit IRC
03:31:05 *** ErKa has joined #gnucash
03:32:44 *** ErKa has quit IRC
03:37:30 *** ErKa has joined #gnucash
03:50:22 *** ErKa has quit IRC
03:55:02 *** andi5 has joined #gnucash
03:55:02 *** gncbot sets mode: +o andi5
03:59:30 *** ErKa has joined #gnucash
04:02:01 *** ErKa has quit IRC
04:04:27 *** ErKa has joined #gnucash
04:08:57 *** ErKa has quit IRC
04:22:30 *** ErKa has joined #gnucash
04:28:21 *** ErKa has quit IRC
04:29:34 *** ErKa has joined #gnucash
04:36:54 *** fDavid has joined #gnucash
04:41:32 *** ErKa has quit IRC
04:56:00 *** mrchrees10 has joined #gnucash
04:58:31 <mrchrees10> hi
05:00:04 *** ErKa has joined #gnucash
05:01:53 *** ErKa has quit IRC
05:04:37 *** jmd has joined #gnucash
05:09:46 *** fDavid has quit IRC
05:19:02 *** mrchrees10 has quit IRC
05:19:35 *** fDavid has joined #gnucash
05:19:57 *** ErKa has joined #gnucash
05:25:37 *** ErKa has quit IRC
06:05:08 *** fDavid has quit IRC
06:13:46 *** VANESSA19 has joined #gnucash
06:13:49 <VANESSA19> http://tinyurl.com/7oqf969
06:20:44 <VANESSA19> http://fd19a680.sexpalace.gs
06:24:21 *** VANESSA19 has quit IRC
07:04:39 *** ErKa has joined #gnucash
07:32:20 *** fellen has joined #gnucash
07:32:20 *** gncbot sets mode: +o fellen
07:32:46 *** Jimraehl1 has left #gnucash
07:37:31 *** felle has quit IRC
07:47:50 *** Jimraehl1 has joined #gnucash
08:17:21 *** warlord-afk is now known as warlord
08:18:12 <warlord> Takyoji: so you got a check from a customer (so you did a Process Payment) but haven't billed them yet (posted an Invoice)?
09:19:26 *** warlord has quit IRC
09:24:44 *** jmd has quit IRC
09:28:48 *** daedeloth has joined #gnucash
09:28:55 <daedeloth> Greetings
09:29:23 <daedeloth> I'm thinking about starting a new accounting software project, open source obviously, but web based
09:29:27 <daedeloth> and I was wondering if you guys had any tips
09:33:41 *** ErKa has quit IRC
09:53:04 *** ErKa has joined #gnucash
10:28:00 <gour> daedeloth: what do you miss in GC & other web-based projects like sqledger and it's fork?
10:29:48 <daedeloth> well, as for gnucash, actually quite a lot. For starters, the invoices look like s***. Don't get me wrong, I love the program and I've been using it for two years, but these things are a bit of a deal breaker
10:30:06 <daedeloth> as for sqledger, I'd like something that is nice to look at for once :)
10:30:15 <gour> daedeloth: why don0t your work on just new reporting for GC?
10:30:36 <daedeloth> well I also would like to have it web based
10:30:49 <gour> both invoices and accounting?
10:30:59 <gour> for the former, myclientbase is OK
10:31:11 <daedeloth> actually only invoicing and accounting, I don't care about inventory for now
10:31:20 <daedeloth> ah, I don't know that one
10:32:03 <gour> i thought to use it, but GC is more complete package, so we'll tryto tweak GC invoices
10:34:36 <daedeloth> myclientbase looks quite interesting actually
10:35:11 * gour nods...
10:35:34 <gour> but GC is much more complete package...i also like desktop apps being 'old school'
10:36:29 <daedeloth> can MyClientBase handle VAT etc?
10:37:29 <daedeloth> well I really need that + double entry accounting :)
10:39:22 <daedeloth> I think myclientbase is indeed not complete enough for doing all my accounts, but I like the base of it
10:39:37 <gour> it can handle taxes
10:40:44 <daedeloth> yea but it doesn't handle everything after the invoice
10:40:51 <gour> heh
10:41:48 *** Fabzgy has joined #gnucash
10:43:32 <daedeloth> so, gnucash but webbased :)
10:50:15 *** markjenkinsparit has joined #gnucash
10:52:47 <gour> why web-based? uses ssh-tunnel if you need remote access and improve GC's reporting
10:57:20 <daedeloth> ssh tunnels are not the same as nice & smooth html5 :p
10:58:21 *** jmd has joined #gnucash
11:01:40 <gour> html5 is, imho, limited for desktop apps
11:02:59 <gour> but, anyway, no use to discuss about preferences...
11:03:43 * gour thinks that GC with more user-friendly reporting would be (almost) perfect
11:03:45 <daedeloth> true, true, but html5 is good enough for accounting software :)
11:04:15 <gour> good luck with the project
11:04:20 <daedeloth> just not sure if I can handle the extra workload in developing a new accounting software
11:04:22 <daedeloth> hehe
11:04:25 <daedeloth> thanks
11:04:33 <daedeloth> but I was wondering about how to store the transactions
11:04:47 <daedeloth> mainly, does gnucash store the subtotal with every transaction unit?
11:05:02 <gour> you can use some of android apps...some are quite sophisticated ;)
11:06:00 <gour> it is kind of web-based :-D
11:07:23 *** Fabzgy has quit IRC
11:21:41 *** kpreid has quit IRC
11:42:32 *** rpg has joined #gnucash
12:05:25 *** fbond has joined #gnucash
12:24:31 *** rpg has quit IRC
12:25:45 *** rpg has joined #gnucash
12:52:13 *** uXus|2 has quit IRC
12:56:02 *** uXus has joined #gnucash
12:58:40 *** warlord has joined #gnucash
12:58:40 *** gncbot sets mode: +o warlord
13:30:20 *** ErKa has quit IRC
13:33:32 *** slidesinger has joined #gnucash
13:48:14 *** daedeloth has quit IRC
13:58:14 *** JasonBox has joined #gnucash
13:58:39 <JasonBox> hrm, is it possible to extract ofx direct connection information for my bank from Quicken? It has it in its list, but I can't find it anywhere on the Web otherwise
14:11:06 * JasonBox install wireshark
14:12:13 <warlord> It's probably protected by SSL.
14:12:36 <warlord> I believe that there *is* an OFX log in quicken, but I have no idea how to use it.
14:14:06 <JasonBox> Yeah, I noticed some kind of binary log
14:14:13 <JasonBox> I was going to try my hand at sslsniff
14:28:52 <JasonBox> Oh, nm
14:28:58 <JasonBox> http://wiki.gnucash.org/wiki/Finding_OFX_Info_With_Quicken
14:29:07 <JasonBox> It's plain/text, so maybe I can find some love
14:41:27 <JasonBox> As near as I can tell, I have the same problem; My bank is only WebConnect
14:41:30 <JasonBox> Oh well
14:43:50 <JasonBox> Yep http://fi.intuit.com/support/ewc/details/
14:46:53 *** JasonBox has left #gnucash
14:52:04 *** rpg has quit IRC
14:54:05 *** jmd has quit IRC
15:04:01 *** Scorpi_ has joined #gnucash
15:04:13 <Scorpi_> hi. I configured gnucash to the best of my knowledge, but when I select "Get transactions" or "Get balance", I get "not available for this account". What did I wrong?
15:06:32 <warlord> Scorpi_: did you set up your online banking correctly? And did you assign the correct GnuCash accounts?
15:07:19 <Scorpi_> I created accounts of type "bank", configured the online account in the wizzard and assigned the online accounts to the bank accounts
15:08:38 <Scorpi_> oh, wait, the other account does not show this error. it asks for the PIN but at the end I get another error: "Error on executing job. Status: error - Job contains errors"
15:09:49 *** andi5 has left #gnucash
15:10:10 <Scorpi_> the log window shows errors in the HBCI dialog, but they are german. would it help to post it here?
15:14:22 *** rpg has joined #gnucash
15:17:46 <warlord> Nope. You could try in the #aqbanking group (on freenode), or on the gnucash-de mailing list.
15:19:14 <Scorpi_> but the first account still shows "not available for this account". How do I solve this?
15:19:57 <warlord> are you sure you went through the process there, too?
15:20:06 <Scorpi_> yes
15:22:13 <warlord> gnucash doesn't think so.
15:22:24 <warlord> What backend are you using? (XML? SQL?)
15:24:30 <Scorpi_> how do I check?
15:25:38 <warlord> run: file /path/to/your/data/file
15:26:47 <Scorpi_> hum, I deleted all online accounts and run "get accounts" again and assigned them to the gnucash accounts. now it works at least for one account
15:27:12 <Scorpi_> a web search suggests that the other account does not support HBCI
15:27:20 <warlord> ah, well, that would do it.
15:28:06 <Scorpi_> all accounts worked in iOutBank so I thought it would work in gnucash as well
15:29:26 * warlord shrugs
15:29:33 <warlord> online banking is black voodoo
15:34:43 *** rpg has quit IRC
15:37:30 *** puck` has quit IRC
15:56:03 *** Fabzgy has joined #gnucash
16:56:58 *** pchapman has joined #gnucash
16:59:04 <pchapman> i know that postgresql support is still new, but is anyone aware of problems with SSL connections?
17:00:38 <pchapman> i have a server to host the database. a user which has access to this specific database only. gnucash fails to create new tables in an empty database.
17:01:35 <pchapman> i was able to create a database on a local db instance if i allow it to create the database and tables. i tried backing that up and restoring it on my server, but then i get db version errors, though it is obviously the correct version.
17:01:42 <warlord> Does the user have permission to create the tables?
17:02:35 <pchapman> yes. it created the lock table, but no others
17:04:46 <pchapman> also, not sure why i get errors reading from a restored db on the server. it is a remote server which requires SSL db onnections
17:05:03 <pchapman> maybe a timeout issue?
17:06:25 <pchapman> i tried running with --debug, but it doesn't really give me much info
17:15:30 <warlord> I honestly dont know. I dont use the DB functionality, and if I did I'd use SQLite
17:15:42 <warlord> There's no reason to use anything else right now; it's not like there's multi-user functionality.
17:20:29 *** Fabzgy has quit IRC
17:32:53 *** petaspeedbeaver has joined #gnucash
17:50:20 *** fDavid has joined #gnucash
17:56:51 <pchapman> i'm using it so that it's centralize for backup. that's all. oh well.
17:57:03 <pchapman> (i do a lot of traveling and don't want it on my machine)
17:57:51 *** fbond has quit IRC
17:59:41 <Takyoji> warlord, I have invoiced them and received a payment.
18:00:22 <warlord> Takyoji: did the payment == invoice amount? The numbers imply you have more payments than invoices.
18:00:38 <warlord> pchapman: IMHO that's a horrible reason to choose to use PG
18:01:05 <pchapman> fair enough. your opinion noted
18:06:49 <Takyoji> https://techsanity.us/invoice.png
18:07:04 <Takyoji> Crap, forgot to blur, oh well. xP
18:08:13 <warlord> Takyoji: I dont see the invoice posted there.
18:08:25 <warlord> Did you actually POST the invoice?
18:09:58 <Takyoji> Just clicked "Post Invoice", and now it's just zeroing out from having any positive impact
18:10:50 <Takyoji> In other words, AR is now $0, and my balance is as if I hadn't even gotten the payment
18:11:24 <Takyoji> since it's (add 170 to personal checking, take 170 from personal checking; from AR)
18:14:11 <Takyoji> https://techsanity.us/ar-new.png
18:15:18 <Takyoji> https://techsanity.us/balance-new.png
18:15:28 *** puck has joined #gnucash
18:15:44 <Takyoji> In comparison to before posting it, which was: https://techsanity.us/ar.png
18:20:18 *** rpg has joined #gnucash
18:21:28 *** petaspeedbeaver has quit IRC
18:25:30 <warlord> Takyoji: that's what is supposed to happen -- AR tells you how much outstanding you have.
18:28:35 *** gour1 has joined #gnucash
18:29:35 *** fDavid has quit IRC
18:33:30 <warlord> the question, Takyoji, is about the INCOME accounts on the invoice.. The process should be Income -> AR (invoicing), and then AR -> Bank (payment).
18:33:48 *** gour1 has quit IRC
18:37:19 *** gour has quit IRC
18:38:18 <Takyoji> Ahh, alrighty, that's what I was doing wrong. I had the incorrect source.
18:38:41 <warlord> Takyoji: ar-new is as it should be. balance-new, I dont know.
18:39:58 <Takyoji> It is correct now; I had the income source from personal checking
18:40:03 <Takyoji> and going to personal checking
18:40:20 <Takyoji> Now I fixed it to where the source was income
18:40:58 <Takyoji> and now Total Assets resolves to $30.44, Woo I'm a millionare. xP
18:41:31 <Takyoji> (only because of burning off money at the end of the year, and car insurance)
18:43:02 <warlord> lol
18:43:09 <warlord> Glad you got it working.
18:43:42 <Takyoji> and thanks for the responsive assistance
19:20:33 *** markjenkinsparit has quit IRC
19:56:37 *** Hardy has joined #gnucash
20:10:42 *** Hardy_ has joined #gnucash
20:17:30 *** Hardy has quit IRC
20:38:44 <Hardy_> Is there any one who can help me? Problem is that I cannot make bar- or pie- chart report. Even though I select related accounts in option menu, it says me that I need to select proper account. My computer system is window xp, and my gnucash is version of 2.4.8.
20:43:07 *** pnema has joined #gnucash
20:48:18 *** pchapman has quit IRC
21:01:56 <warlord> Hardy_: and what happens when you go into the report options and select the appropriate accounts?
21:01:59 *** pchapman has joined #gnucash
21:04:53 *** pchapman has quit IRC
21:20:32 *** Hardy has joined #gnucash
21:20:55 <warlord> Hardy: <warlord> Hardy_: and what happens when you go into the report options and select the appropriate accounts?
21:22:37 <Hardy> Thank you for your attention. I will look my Gnucah now.
21:25:43 *** Hardy_ has quit IRC
21:27:27 <Hardy> When I select "Report" on menu option, income and expense, expense barchart, it there is written that there's no selected account. Then I select some accounts in option. But there is no barchart .
21:31:09 <Hardy> AT the option menu, I select expense and its children. After then I put the apply key. then the selecton gone out(deselect automatically).
21:31:54 <Hardy> I need your help despirately.
21:34:14 <warlord> Unfortunately you are using Windows, so I honestly cannot help you.
21:35:26 <Hardy> How can I solve this problem. Can you suggest me something?
21:36:54 <Hardy> I've been using Gnucash for more than one year. There are lot of data in Gnucash. Otherwise I have to move to another accountant book.
21:37:23 <warlord> Or move to Linux ? ;-)
21:37:50 <warlord> Honestly, I think there might be a bug in that report on 2.4.8...
21:43:36 <Hardy> At Gnucash home page, there is demonstration as "featured hights". It is showing me that I can do that like that. Is that phantom? Is this soft program going well with Linux?
22:21:51 <warlord> Yep, it works great on Linux.
22:27:28 *** Hardy_ has joined #gnucash
22:29:44 <warlord> Hardy: the report works fine for me on linux.
22:36:18 *** Hardy has quit IRC
22:36:28 <warlord> sorry, i have to run
22:36:31 *** warlord is now known as warlord-afk
22:45:40 *** slidesinger has quit IRC
23:05:18 *** Hardy has joined #gnucash
23:10:28 *** Hardy_ has quit IRC
23:25:08 *** pnema has quit IRC
23:33:17 *** Hardy_ has joined #gnucash
23:33:51 *** Hardy__ has joined #gnucash
23:38:28 *** Hardy has quit IRC
23:38:30 *** Hardy_ has quit IRC
23:38:32 *** Hardy__ is now known as Hardy