2009-06-18 GnuCash IRC logs
02:58:46 *** bentob0x has joined #gnucash
03:09:42 *** ramon has joined #gnucash
03:12:11 <ramon> hi everyone! i believe this is a developer channel, right? coz i have a question about how to do a certain thing in gnucash - particularly having an invoice in another currency (accepting another currency for certain invoices). is this possible?
03:26:16 *** MechtiIde has joined #gnucash
03:34:43 *** phil has joined #gnucash
04:27:37 *** ammonia has joined #gnucash
04:28:38 <ammonia> hello
04:30:07 <ammonia> I'm a programmer and would like to help with the gnucash project. I'm interested in helping with the database backend work.
04:30:39 <ammonia> Can anyone direct me to information about this. Thanks
05:51:24 *** Zero has joined #gnucash
05:53:42 *** ErKa has joined #gnucash
06:17:52 *** ramon has quit IRC
06:38:45 *** Zero has quit IRC
06:58:49 *** DavidV has joined #gnucash
07:02:05 <DavidV> hi all, I am using vversion 2.2.9 and the balance sheet report aggregates plaeholder items incorrecly = shows 0 in the placeholder items
07:02:39 <DavidV> I use multicurrency, and I have set the exchange rate in Currency editor
07:04:09 <DavidV> the balance sheet report does not summarize at all
07:06:29 <DavidV> the "Accounts" sheet is ok, but the balance sheet report is not ... is it a known bug?
07:07:33 *** ramon has joined #gnucash
07:09:37 <DavidV> well... and the answer is: go to report options > display and set up parent account balances = "subtotal"
07:09:49 <DavidV> :]
07:28:44 <DavidV> so, it is ok
07:30:05 <DavidV> but, the following has been confirmed earlier:
07:31:55 <DavidV> - I have a customer's currency set in EUR; I have my debtors account set in EUR and I issue an invoice to the customer; the invoice is to be in EUR (which is a foreign currency; my local currency is GBP)
07:32:52 <DavidV> - when posting the invoice I select income account
07:35:03 <DavidV> - my income accounts are in GBP
07:35:54 <DavidV> - the posted invoice does not write any figure to the income account
07:37:53 <DavidV> precisely speaking the invoice posting process fails when posting the transaction and does not show error message
07:39:23 <DavidV> is there any progres in the issue, please? or where could I track it ?
07:46:07 <DavidV> the workaround proposed - to keep the income account in the foreign currency - it is nonsense from the accounting perspective
07:46:52 <DavidV> I must translate the foreign currency transaction to my local currency in the day when it occures
08:00:56 *** ramon has quit IRC
08:16:52 *** warlord-afk is now known as warlord
08:18:30 <warlord> DavidV: All invoice-touched accounts must be in the same currency.
08:18:39 <warlord> So yes, you need EUR income account.
08:32:16 *** Jimraehl has left #gnucash
08:37:37 <DavidV> warlord: well, I know that ... and the question is whether the issues is thing for development and whether I can track a progress in it
08:38:17 <warlord> Nobody is working on multi-currency business.
08:38:24 <warlord> You're welcome to submit patches.
08:42:48 *** JimRaehl2 has joined #gnucash
08:45:04 *** JimRaehl2 has left #gnucash
08:45:21 *** JimRaehl2 has joined #gnucash
08:50:10 <DavidV> warlord: warlord, thanks for response, I can not do anyting in the gnu technology (I am lucky when I install it) :(
08:52:01 <DavidV> but anywa gnucash is pretty good
08:52:22 *** kfo has joined #gnucash
08:52:29 <warlord> Thanks. Sorry, but right now it's just not high on the priority list, and gnucash has limited development cycles.
08:52:55 <kfo> How can I redo/go back if I change the text in a memo
08:53:33 <warlord> kfo: There is no "undo".
08:53:47 <kfo> Could I ask why not?
08:53:47 <warlord> If you haven't committed you can 'cancel'
08:53:57 <warlord> Because nobody has implemented it.
08:53:58 <kfo> where?
08:54:07 <kfo> ahh, nice
08:54:09 <kfo> found :)
08:54:31 <warlord> However, once you commit the change, you might not be able to go back -- depends what version you're using and which backend.
08:55:31 <kfo> ok
08:55:37 <DavidV> kfo: in accounting systems - a redo is not much usal
08:57:21 <DavidV> once a transaction is posted, it is done, no redo
08:58:18 <kfo> I'm doing this more for "fun"
08:59:16 <DavidV> kfo: :) :)
08:59:57 <kfo> Want to see what I spend my money on :)
09:06:03 <kfo> Can I use GnuCash 2.3.1, or is it to unstable?
09:12:52 <warlord> The 2.3.x series are testing releases.
09:30:54 <DavidV> kfo: 2.2.9 is stable
09:32:07 <DavidV> kfo:if you want to use it for personal finance, it is definitely good choose
09:32:34 <DavidV> (I would do it in Excel... but you can securely use gnucash )
09:52:36 <kfo> why excel
10:11:26 *** DavidV has quit IRC
10:37:43 *** twunder has joined #gnucash
10:40:11 *** twunder has quit IRC
11:03:09 *** ErKa has quit IRC
11:07:14 *** twunder has joined #gnucash
11:26:43 *** ErKa has joined #gnucash
12:22:05 *** Mike has joined #gnucash
12:24:12 *** Mike has quit IRC
13:08:29 *** hvx has joined #gnucash
13:23:34 *** MechtiIde has quit IRC
13:27:46 *** seacaptain has joined #gnucash
13:30:47 *** seacaptain has quit IRC
13:47:36 *** ErKa has quit IRC
14:16:05 *** eric_ has joined #gnucash
14:17:55 <eric_> hi there, first time gnucash user, i am trying to import a qif from mac os x, quicken 2007 (i think) and gnucash is crashing
14:18:20 <eric_> this is a sample of the error i am getting in gnucash.trace
14:18:22 <eric_> * 12:02:18 WARN <gnc.core-utils> g_locale_to_utf8 failed: Invalid byte sequence in conversion input
14:18:23 <eric_> * 12:02:18 WARN <gnc.core-utils> Invalid utf8 string: ¥Realized Gain NT
14:19:03 *** twunder has quit IRC
14:22:38 <warlord> Most likely the QIF has non-UTF8 characters in it..
14:23:57 <warlord> Are you actually HAVING issues, or just wondering about the gnucash.trace messages?
14:24:40 *** ErKa has joined #gnucash
14:30:25 <eric_> well the importer recognizes everything in the qif, runs me through the process of assigning accounts etc.
14:30:42 <eric_> then i go to import and gnucash quits
14:30:59 <eric_> then there is a lock file etc.
14:31:43 <eric_> and none of my data has been imported
14:32:13 <warlord> What version of gnucash?
14:33:08 <eric_> 2.2.6
14:33:41 <warlord> Oh, well... 2.2.9 is current.
14:33:51 <eric_> ahhhh
14:33:58 <warlord> I thought there were some QIF fixes..
14:34:02 <eric_> ok will upgrade and see if that fixes it
14:34:04 <warlord> But I dont know about this one in particular.
14:34:22 <eric_> thanks, i feel like a serious noob
14:34:34 <eric_> which, actually, i am
14:35:00 <warlord> that's okay. everyone is a n00b at some point.
14:36:14 *** bentob0x has quit IRC
14:39:52 *** MechtiIde has joined #gnucash
14:48:24 *** linas has quit IRC
15:18:10 *** phil has quit IRC
15:24:21 *** palatin has joined #gnucash
15:30:49 *** Mike has joined #gnucash
15:37:06 *** linas has joined #gnucash
15:40:20 *** eric_ has quit IRC
15:51:40 *** linas has quit IRC
16:06:01 *** linas has joined #gnucash
16:23:56 *** linas has quit IRC
16:24:27 *** hvx has quit IRC
16:27:03 *** linas has joined #gnucash
16:42:41 *** linas has quit IRC
16:47:02 *** linas has joined #gnucash
17:02:39 *** linas has quit IRC
17:15:38 *** Mike has quit IRC
17:19:12 *** palatin has quit IRC
17:19:28 *** MechtiIde has quit IRC
17:56:39 *** ErKa has quit IRC
18:23:33 *** ammonia has left #gnucash
18:34:08 *** twunder has joined #gnucash
18:57:51 *** twunder has quit IRC
19:28:37 *** twunder has joined #gnucash
19:37:09 *** twunder has quit IRC
19:37:44 <warlord> @op chris
19:37:45 *** gncbot sets mode: +o chris
19:40:40 *** RobotCow has joined #gnucash
19:51:43 *** RobotCow has quit IRC
20:18:26 *** BlueAidan has joined #gnucash
20:19:22 <BlueAidan> Just started using 2.3.1. I'm really liking the integration with Postgres.
20:21:29 <BlueAidan> although tonight I poked around in the schema, and it seems like you're not really using pg very well. for instance, I see dates stored in a varchar? also, pg 8.3 has a native UUID datatype. http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html
20:22:24 <BlueAidan> I'm also seeing a few tables with no defined primary keys.
20:22:52 <warlord> BlueAidan: we're using DBI, so the SQL is generic and shared across PG, MySQL, and SQLite.
20:22:59 <warlord> Also, the guy you want to talk to is Phil, and he's not here.
20:23:36 <BlueAidan> ok
20:23:40 <BlueAidan> by dbi, do you mean http://libdbi.sourceforge.net/ ?
20:23:46 <warlord> yea
20:23:51 <BlueAidan> k
20:24:05 <warlord> So no, we don't use database-specific types. We use SQL types.
20:24:23 <BlueAidan> I really like the ability to use pg, as I'm a dba by trade and love pg.
20:24:33 <warlord> glad you like it.
20:26:59 <BlueAidan> I'll idle and see if I can catch him at some point
20:27:13 <warlord> You'll be waiting a while. I recommend email.
20:27:19 <warlord> He gets here.... once a month? Maybe?
20:27:26 <BlueAidan> ah
20:27:26 <BlueAidan> ok
20:43:20 <jsled> the dates are stored as a varchar? :( That's sad.
20:45:36 <warlord> Yeah, it is pretty sad that dates are stored as VarChar -- not sure why he did that.
21:06:50 *** JimRaehl2 has left #gnucash
21:07:14 *** Jimraehl has joined #gnucash
21:07:29 <BlueAidan> is it possible to link transactions from one account to another one where the dates don't match?
21:09:03 <jsled> no.
21:10:00 <BlueAidan> darn... It's really annoying getting my ing direct savings accounts' transactions linked up to what shows up in my checking account.
21:10:09 <BlueAidan> they're usually a couple of days apart.
21:14:11 <warlord> That's what the 'cleared' flag is for
21:35:15 <BlueAidan> but what do I use for the account in the transfer?
21:37:26 <warlord> what do you mean?
21:37:40 <warlord> ING <-> Checking
21:38:22 <warlord> Choose a reasonable date.. Then use the cleared field to denote that it's actually hit the account.
21:39:12 <BlueAidan> hmm, let me explain some more I think... I pull my checking in via online banking and my ing transactions via a qfx import because it's hard to match all the ing transactions that hit on the same day as they don't include specific account numbers.
21:39:51 <warlord> okay.....
21:40:59 <warlord> So during the import you make sure the far account is set correctly, and then during the duplicate checking you mark it as a dup.
21:41:06 <warlord> (this might be easier if you for the QIF second)
21:41:26 <warlord> Oh, wait, you said QFX, not QIF..
21:41:45 <warlord> Well, still... the dup checking should let you be 'off' by a couple days.
21:42:42 <BlueAidan> ok, sounds good.
22:26:31 <warlord> I need to take off. Good night.
22:26:34 *** warlord is now known as warlord-afk
23:00:26 *** twunder has joined #gnucash
23:20:48 *** twunder has quit IRC