2008-06-26 GnuCash IRC logs
00:42:42 *** nodje has quit IRC
01:09:10 *** nodje has joined #gnucash
01:32:08 *** romkyns has quit IRC
01:32:20 *** cort has quit IRC
01:42:14 *** romkyns has joined #gnucash
02:33:36 *** |gunni| has joined #gnucash
02:42:22 *** _gunni_ has quit IRC
02:55:46 *** ErKa has joined #gnucash
03:11:04 *** ErKa has quit IRC
03:46:14 *** ErKa has joined #gnucash
04:03:21 *** StocksR has joined #gnucash
04:40:51 *** cortana has joined #gnucash
04:47:35 *** StocksR has quit IRC
04:58:05 *** StocksR has joined #gnucash
05:04:21 *** StocksR_ has joined #gnucash
05:04:21 *** StocksR has quit IRC
05:15:07 *** StocksR_ has quit IRC
05:15:10 *** StocksR has joined #gnucash
05:17:55 *** ErKa has quit IRC
05:23:40 *** cortana has quit IRC
05:56:05 *** ErKa has joined #gnucash
05:59:50 *** StocksR has left #gnucash
06:28:48 *** kling0n has joined #gnucash
06:40:46 *** ErKa has quit IRC
06:59:25 *** zakia has joined #gnucash
06:59:39 <zakia> hello
07:00:38 <zakia> anyone know a french bank supporting gnucash "out of the box" ?
07:01:50 *** zakia has quit IRC
07:24:18 *** RobbieAB has quit IRC
07:24:30 *** RobbieAB has joined #gnucash
07:38:13 *** JimRaehl has left #gnucash
07:47:18 *** ErKa has joined #gnucash
07:48:05 *** JimRaehl has joined #gnucash
07:52:10 *** twunder has joined #gnucash
08:10:27 *** ErKa has quit IRC
08:11:42 *** kling0n has quit IRC
08:42:03 *** kling0n has joined #gnucash
09:06:12 *** ErKa has joined #gnucash
09:19:51 *** ErKa has quit IRC
09:30:03 *** Rolf has quit IRC
09:30:13 *** Rolf has joined #gnucash
09:38:39 *** ErKa has joined #gnucash
10:23:31 *** daum has joined #gnucash
10:24:15 <daum> hey guys is there a way to setup an invoice that reoccurs each month?
10:24:22 *** donfede has joined #gnucash
10:26:10 <jsled> no.
10:30:29 *** daum has quit IRC
10:34:34 *** Rolf has quit IRC
10:47:22 *** StocksR has joined #gnucash
11:06:59 *** JonathanElli1 has joined #gnucash
11:08:20 <JonathanElli1> Hi. Is there any way I can trace payments of invoices? I have got into a mess with which payments have been applied to which invoices for a certain customer.
11:08:43 *** ErKa has quit IRC
11:19:32 <JonathanElli1> So the total paid matches the amount of all the invoices, but when I look at customer's invoices I see some that dont have a green tick to show that they have been paid. Some of the payments in the accounts receivable register have been split with part showing as pre-payments.
11:20:28 *** peppych has joined #gnucash
11:21:26 <peppych> Hi there, first off all thanks for gnucash guys, it really rocks ;)
11:21:26 <peppych> here my question, is it possible to manage payments and generate DTA files in order to send them to a bank??? I looked up but didn't found any thing about this. Can any body tell me, if it's possible and if so, how to do it or where I might found the info ???
11:21:48 <jsled> DTA files?
11:22:24 <peppych> transfer files used by swiss and german banks
11:22:30 <jsled> Is that related to HBCI?
11:23:22 <peppych> don't know
11:23:43 *** ErKa has joined #gnucash
11:24:13 <peppych> if I'm on my e-banking page at UBS I can import those dta files and so I don't need to enter my payments manually
11:24:45 <peppych> I don't really know more about them sorry :(
11:26:08 <jsled> Would this be known by "DTAUS" as well?
11:26:51 <peppych> yep
11:26:59 <jsled> I do have "Import DTAUS" and "Import DTAUS (and send)" options here, when built with hbci support.
11:27:08 <jsled> I don't know about generating them, however.
11:28:37 <peppych> you mean under file->import you have a dtaus import option ???
11:29:21 *** Zoolooc has joined #gnucash
11:29:43 <jsled> yes.
11:29:51 <jsled> peppych: what OS/distro are you using?
11:30:12 <peppych> Ubuntu 8.04
11:30:42 <peppych> I might build gnucash my self then because it hasn't those options in the repo version
11:30:55 <jsled> yes, in fact, you need to.
11:31:17 <jsled> see <http://wiki.gnucash.org/wiki/Ubuntu> and <http://wiki.gnucash.org/wiki/Debian#Creating_packages_with_HBCI_and_aqofxconnect_enabled>.
11:31:24 <peppych> ok but there only import and no export right ???
11:31:40 <jsled> I'm not sure. I don't know that part of the app at all.
11:32:31 <peppych> ok I've a look at it if you can import you probably can export
11:32:39 <peppych> I'll try thanks for your help
11:33:03 <jsled> I wouldn't assume that if you can import you can export.
11:33:59 <peppych> Me neither but I'm a positive thinking guy ;)
11:35:26 <peppych> anyhow I'll try and we'll see thanks for your help jsled
11:45:09 <JonathanElli1> Is there any way to see which invoices payments have been attributed to? In the accounts receivable register the payment does not show an invoice number
11:45:50 <JonathanElli1> try jonnybal@googlemail.com
11:46:42 <JonathanElli1> Oh sorry - wrong window
11:47:51 <JonathanElli1> Does anyone know anything about this bug http://bugzilla.gnome.org/show_bug.cgi?id=537293?
12:06:10 <JonathanElli1> I cant find any mention in the help about online banking although the web site says that Gnucash supports OFX which is how my bank works
12:08:19 <jsled> the help isn't well updated.
12:08:39 <JonathanElli1> So how is it done?
12:09:24 <jsled> See <http://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect_in_GnuCash_2#Where_to_find_connection_info> for more details.
12:11:30 <JonathanElli1> Thanks
12:15:05 <JonathanElli1> jsled: I installed Gnucash on Ubuntu using the package in the repository. I ended up with v 2.2.4 but I understand the latest stable version is 2.2.5
12:15:28 <JonathanElli1> Following these instructions, I dont think I will get the latest version#
12:18:52 <jsled> If you use those directions, you can build whatever you like.
12:18:59 <jsled> And you should build 2.2.5, yes.
12:34:27 <JonathanElli1> Do I need to remove 2.2.4 before I start building?
12:34:57 <jsled> no.
12:35:13 <jsled> Though you might want to build into /opt/gnucash/ or something isolated for easy future removal.
12:35:13 <JonathanElli1> I will end up with both versions installed?
12:35:32 <jsled> Also, I have seen problems when building into /usr/local with a version installed in /usr/
12:35:38 <jsled> It might be safer to remove the existing one.
12:35:51 <jsled> But if you --prefix into /opt/gnucash/ or something, I've not seen those problems.
12:37:18 <JonathanElli1> Which versions of aqbanking etc do I need?
12:38:18 <JonathanElli1> Or a better question would be where do I download the latest versions of those files in case the ubuntu repository doesnt contain the latest?
12:38:35 <jsled> The ultimate truth is configure.in, which does whatever the appropriate checks are.
12:38:45 <jsled> I'd, uh ... let's see what Gentoo does. :)
12:39:14 <jsled> http://sources.gentoo.org/viewcvs.py/gentoo-x86/app-office/gnucash/gnucash-2.2.5.ebuild?view=markup
12:39:54 <jsled> hmm. which isn't super-helpful because it doesn't have a minimum version for aqbanking; but installed here I have 2.3.2.
12:40:36 *** Rolf has joined #gnucash
12:40:49 <JonathanElli1> Its also totally incomprehensible to me
12:41:10 <JonathanElli1> Do you mean I can pretty much download any version?
12:41:36 <JonathanElli1> Ubuntu repositories have 3.3.0
12:41:47 <jsled> Any 2.x version.
12:41:54 <jsled> Well, the latest 2.x version.
12:41:59 <jsled> 3.x is a different API.
12:43:28 <JonathanElli1> So now I am really confused. If I follow the instructions it seems like I will get incompatible versions of the packages
12:45:42 <jsled> hmm?
12:46:22 <JonathanElli1> Ubuntu repositories have libaqbanking 3.3.0 which you say is incompatible with Gnucash 2.2.5
12:46:46 <JonathanElli1> So I dont know where I will get the correct versions of all the packages mentioned if I cant use apt-get to get them
12:47:13 <jsled> Are you looking at <http://wiki.gnucash.org/wiki/Debian#Downloading_prerequisites> ?
12:47:19 <JonathanElli1> Yes
12:47:23 <jsled> The 2.x version of aqbanking should still be available.
12:47:29 <JonathanElli1> From?
12:47:42 <jsled> From debian, maybe. I don't know.
12:47:55 <JonathanElli1> My understanding is that apt will download the most up to date version
12:48:04 <jsled> If you really want to stick to only debian sources, then, yes, they might have put you in a situation where you can't build gnucash.
12:48:27 <JonathanElli1> I just want to know how to do it so it works
12:48:29 <jsled> In cases where a libraries API changes, often both API versions are available.
12:49:30 <jsled> Here, <http://packages.ubuntu.com/search?keywords=aqbanking&searchon=names&suite=hardy§ion=all> it looks like the aqbanking 2.x package is called aqbanking20 (and -dev)
12:50:53 <JonathanElli1> Thanks. It is so confusing
12:52:02 <jsled> aye. software development is not simple.
12:53:18 <JonathanElli1> Im not a developer - just a user
12:53:29 <jsled> yup.
12:54:03 <jsled> Well, at some point, maybe, the license incompatability that requires all this shit will be resolved, and debian/ubuntu can ship gnucash with aqbanking enabled.
12:54:17 <JonathanElli1> I have to say, imho this sort of stuff stands in the way of this software being adopted by people
12:54:23 <jsled> yup!
12:54:52 <jsled> see http://linuxhaters.blogspot.com/ for more along those lines. (nsfw language)
12:54:59 <JonathanElli1> And I thought windows was a pain in the arse
12:55:51 <jsled> Well, when things are going well, in other circumstances, yadda yadda, it's great.
12:56:06 <jsled> The problem is computers, not windows or linux.
12:56:20 <JonathanElli1> You mean if you only run openoffice and firefox!
12:56:27 <jsled> heh.
12:56:27 <Rolf> hbci?
12:56:36 <Rolf> FinTS?
12:57:35 <Rolf> JonathanElli1: https://launchpad.net/~gnucash/+archive is all you'll likely need
12:57:55 <jsled> What does "PPA" mean, anyways?
12:58:22 <jsled> Rolf: could you please update the Ubuntu or Debian pages to include that?
12:58:34 <Rolf> personal package archive
12:58:42 <Rolf> Sorry, no time
12:58:59 <Rolf> Maybe you can commit the stuff I've been bugging you guys about for several days now?
12:59:27 <Rolf> http://bugzilla.gnome.org/show_bug.cgi?id=144669
13:00:02 <JonathanElli1> Rolf: Do you mean that if I just add those two repositories I should be able to just run the apt commands?
13:00:10 <Rolf> two?
13:00:17 <Rolf> It's just one repo
13:00:20 <JonathanElli1> As shown in http://wiki.gnucash.org/wiki/Debian
13:00:32 <JonathanElli1> The src and the deb
13:00:34 <Rolf> foget about the wiki
13:00:43 <Rolf> You only need the deb line
13:00:47 <Rolf> for above ppa
13:00:58 <JonathanElli1> But apparently I need to recompile to get ofx working
13:01:00 <Rolf> do you understand German?
13:01:04 <JonathanElli1> No
13:01:08 <Rolf> OK
13:01:17 <Rolf> You need nothing but that repo
13:01:21 <Rolf> OK?
13:01:30 <JonathanElli1> And that will include the ofx stuff?
13:01:47 <Rolf> "sudo aptitude install gnucash-hbci"
13:02:03 <Rolf> I don't know anything about ofx
13:02:17 <JonathanElli1> Right. Thanks. My bank uses ofx not hbci. Are they both installed?
13:02:22 <Rolf> but if there was a license issue, then that should be equally fixed
13:02:25 <Rolf> try it
13:02:28 <Rolf> gotta run
13:02:31 <JonathanElli1> Thanks
13:17:11 *** peppych has quit IRC
13:25:22 *** ErKa has quit IRC
13:49:45 *** ErKa has joined #gnucash
13:59:46 *** ErKa has quit IRC
14:40:26 *** _gunni_ has joined #gnucash
14:46:36 *** adam_ has joined #gnucash
14:47:04 *** adam_ has quit IRC
14:48:48 *** |gunni| has quit IRC
15:04:57 *** sjc has joined #gnucash
15:56:25 *** LiENUS has quit IRC
16:01:33 *** ErKa has joined #gnucash
16:13:41 *** ErKa has quit IRC
16:26:31 *** ErKa has joined #gnucash
16:36:23 *** lenscape has joined #gnucash
16:36:44 <lenscape> how do I delete an invoice started by mistake?
16:36:59 <lenscape> it has no entries
16:41:32 *** warlord-afk is now known as warlord
16:41:36 <warlord> lenscape: you dont. See the FAQ
16:42:34 *** kling0n has quit IRC
16:43:40 <lenscape> warlord: thanks
16:44:30 <lenscape> is gnucash in active development or is it stagnating a bit?
16:44:56 *** ErKa has quit IRC
16:57:59 <JonathanElli1> Hi. Is there any way I can trace which payments have been applied to which invoices? I have got into a mess with a certain customer who paid different parts of different invoices at different times. The total paid matches the amount of all the invoices, but when I look at the customer's invoices I see some that dont have a green tick to show that they have been paid. Some of the payments in the accounts receivable register have been split with pa
17:01:44 <jsled> JonathanElli1: cut off at " with pa".
17:02:17 <JonathanElli1> Some of the payments in the accounts receivable register have been split with part showing as pre-payments.
17:02:22 <jsled> lenscape: there are people doing work, but it's coming in fits and spurts.
17:02:43 <jsled> and right now its in specific areas.
17:02:54 <lenscape> jsled: what's it written in? C++?
17:02:55 <jsled> (e.g., the SQL backend work)
17:03:11 <jsled> C, mostly. Some scheme.
17:03:20 <jsled> mostly = probably 85/90%.
17:03:35 <lenscape> if it was Python, I might offer some help
17:03:45 <jsled> I hear ya.
17:04:04 <lenscape> I really can't be arsed with writing C for this sort of thing
17:04:12 <jsled> Yup.
17:04:36 <lenscape> so is the SQL backend likely to appear again?
17:04:57 <jsled> I've not been following it too closely, but it does seem to be making progress.
17:05:09 <lenscape> that's encouraging
17:06:57 <warlord> JonathanElli1: Payments are applied FIFO. Selecting an invoice in the process payment dialog puts that one invoice at the head of the FIFO. If you then perform some sequence of unposting and reposting invoices it's possible to get the system into a strange state.
17:08:32 <warlord> What you're seeing is the system applying over-payments across invoices in the FIFO.
17:08:52 <JonathanElli1> OK. Thanks. Is there any way of seeing which payments have been applied to which invoices? The register doesnt show which is which
17:10:47 <warlord> Payments aren't made to invoices. Payments are made to Customers.
17:11:09 <warlord> BUT.. You can run an Invoice Report and select "Show Payments" in the report options..
17:11:13 <warlord> Or you can run a Customer Report.
17:12:50 <JonathanElli1> The customer report shows the balance is zero because the payments equal the invoices. However, the invoices dont all show as paid (green tick). The receivable ageing report shows the customer with a zero balance whereas if all the invoices were marked as paid then the customer wouldnt appear in the receivable ageing report at all.
17:16:45 <JonathanElli1> Is there any way of hacking the database so that the invoices appear paid?
17:17:58 <warlord> JonathanElli1: go into A/R, delete all your payments and auto-splits, then Process Payment again for all your payments in order.
17:18:14 <JonathanElli1> OK. Thanks
17:18:19 <warlord> Sorry.
17:19:44 *** JonathanElli1 has left #gnucash
17:20:29 *** JonathanElli1 has joined #gnucash
17:22:03 <JonathanElli1> Does anyone know anything about the bug I reported? http://bugzilla.gnome.org/show_bug.cgi?id=537293
17:22:41 <jsled> JonathanElli1: the standard print workaround is "export to html and print from a real browser".
17:22:58 *** donfede has quit IRC
17:23:46 <JonathanElli1> OK. Thats a bit of a pain. Is this bug likely to be fixed?
17:25:11 <jsled> Hard to say. I think it'll get fixed when the reports get overhauled.
17:25:21 <JonathanElli1> An alternative might be for gnucash to send reports to the default browser instead of using its own
17:25:49 <jsled> Yeah. Or using moz or webkit embedded rather than gtkhtml.
17:25:56 <jsled> But even then, some report overhauling is needed.
17:26:09 <JonathanElli1> Fair enough.
17:27:01 <JonathanElli1> Another question. I heard that the database is xml. Is it possible to look at it in some other application? Is it text based?
17:32:29 <jsled> xml is text based, yes. And yes, it is.
17:41:53 <JonathanElli1> So I can just open it in a text editor?
17:42:26 <romkyns> jsled: regarding the report overhaul, is there a link with info? Wiki doesn't show anything. I've been thinking about developing some reports but if the system gets overhauled it might make sense to wait
17:42:45 <jsled> no. There's no report overhaul in the works. It's just an idea.
17:42:59 <jsled> I did post some notes a while back to devel about how I think it should work.
17:43:39 <jsled> romkyns: it's more 'a [hypothetical] report overhaul', not 'the report overhaul'. :)
17:43:58 <jsled> JonathanElli1: yes. Note that the file is compressed by default, so you may need to gunzip it first.
17:44:02 <jsled> (or turn off compression)
17:44:13 <JonathanElli1> OK. Thanks
17:44:15 <jsled> but, you know, if you're thinking of changing stuff, make a backup first and whatnot.
17:44:16 *** JonathanElli1 has left #gnucash
17:51:01 *** silfreed has joined #gnucash
17:51:30 <silfreed> I'm not sure what I'm doing wrong, but when using the loan wizard to setup a bi-weekly payment I end up w/ ~2x the correct loan payment.. like it's still using the monthy calculations, but scheduling it to happen twice as often
17:52:01 <jsled> bug. Not-monthly repayment schedules are not supported.
17:52:23 <jsled> sorry.
17:52:33 <silfreed> ah; okay
17:52:58 <silfreed> is it possible to edit the calculation once the wizard is complete in teh scheduled transaction?
17:53:50 *** Zoolooc has quit IRC
17:54:24 <jsled> yes. The druid just creates "normal" scheduled transactions with formula setup.
17:54:35 *** localhost1 has quit IRC
18:11:01 *** warlord is now known as warlord-afk
18:13:30 *** LiENUS has joined #gnucash
18:31:39 <romkyns> jsled: ok, got it :)
18:58:12 *** lenscape has quit IRC
19:46:20 *** localhost has joined #gnucash
19:50:39 *** cortana has joined #gnucash
20:58:56 *** sjc has quit IRC
21:29:21 *** nodje has quit IRC
21:37:06 *** silfreed has left #gnucash
22:54:35 *** cort has joined #gnucash
23:03:03 *** cortana has quit IRC
23:10:04 *** warlord-afk is now known as warlord
23:30:35 *** nodje has joined #gnucash
23:56:37 *** warlord is now known as warlord-afk