2009-05-12 GnuCash IRC logs
00:54:31 *** twunder has quit IRC
01:33:14 *** MechtiIde has quit IRC
02:44:21 *** MechtiIde has joined #gnucash
03:27:29 *** ErKa has joined #gnucash
03:55:44 *** eukreign2 has joined #gnucash
04:04:15 *** eukreign has quit IRC
04:45:34 *** Teka has joined #gnucash
04:46:58 <Teka> Hi gnucash starts but can not open any accounts - being using gnucash for 10 months
04:49:52 *** Teka has quit IRC
04:51:21 *** Teka has joined #gnucash
04:53:36 <Teka> Hi gnucash statrs but can't open any accounts - being using for 10 months. Tried using previous revision of data and deleted program followed by downloading windows version of latest program but no joy
04:53:53 <Teka> any suggestions please?
05:10:02 *** Feisar has joined #gnucash
05:15:04 *** Rolf3 has joined #gnucash
05:22:37 *** Rolf has quit IRC
05:27:43 <puck> Hmmm, there's no report that'll show me the running balance of an account and all sub-accounts? (the sub-accounts are effectively journals for a bank account)
05:30:13 <puck> "Open Subaccounts" is soo close, but no running total
05:59:40 *** bentob0x has joined #gnucash
06:22:30 *** aindilis has quit IRC
06:22:31 *** aindilis has joined #gnucash
08:02:57 *** bentob0x has quit IRC
08:09:18 *** warlord-afk is now known as warlord
08:10:41 <warlord> garyk: the bug is purely in a patch that the Debian people put in.
08:11:04 <warlord> Teka: what happens when you try to open an account?
08:11:21 <warlord> puck: maybe a transaction report?
08:11:33 <warlord> (no, there is no running balance of "account+subaccounts")
08:52:56 *** dilbert1970 has joined #gnucash
08:53:40 <dilbert1970> hello everyone
08:54:59 <dilbert1970> may I ask a question about the scheduled transaction editor?
08:55:45 <warlord> sure, just ask
08:56:54 <dilbert1970> thanks. I feel quite stupid, but I can't find the manual for credit/debit formula anywhere...
08:58:07 <dilbert1970> like for example on my loan repayment SX
08:58:18 <dilbert1970> I'd like to add a field to the split
08:58:43 <dilbert1970> to account for the constant fee my bank adds to each payment
08:59:50 <dilbert1970> and of course I have to add the same amount to the "tot funds out" column as well
08:59:56 <warlord> Just add " + <fee amount>"
09:06:28 *** Rolf3 has left #gnucash
09:08:10 <dilbert1970> ok, I just realized I misunderstood an error message :-(
09:09:13 <dilbert1970> when I try to modify the SX, I get "The Scheduled Transaction Editor cannot automatically balance this transaction. Should it still be entered?"
09:09:31 <warlord> Right, that just means that gnucash cannot heuristically check the entries.
09:09:46 <dilbert1970> so this has nothing to do with the formula syntax
09:09:48 <warlord> Happens to me all the time
09:09:52 <warlord> No.
09:11:10 <dilbert1970> it's probably caused not by my addition but by the fact that the total of the loan is "pmt" and the single rows are computed by "ppmt" and "ipmt"...
09:11:39 <dilbert1970> thank you very much
09:14:00 <dilbert1970> well, since I am here... could you point me to some resources about how to write (if it's possible) a custom import procedure?
09:14:22 <dilbert1970> my bank formats are totally non-standard.
09:16:49 <jsled> dilbert1970: if you can pastebin all the credit/debit formulæ, perhaps we can spot the imbalance.
09:17:11 <jsled> As for importing, writing a new importer is non-trivial; it's probably better to convert your bank's wacko format into QIF.
09:19:06 <dilbert1970> good point.
09:19:13 <dilbert1970> about the imbalance:
09:19:57 <dilbert1970> the "tot funds out" columns has only one row:
09:20:05 <dilbert1970> 1,03+pmt( 0,02288 / 12,00 : 85,00 : 42650,00 : 0 : 0 )
09:20:15 <dilbert1970> the "tot funds in" has three:
09:20:20 <dilbert1970> ppmt( 0,02288 / 12,00 : i : 85,00 : 42650,00 : 0 : 0 )
09:20:31 <dilbert1970> ipmt( 0,02288 / 12,00 : i : 85,00 : 42650,00 : 0 : 0 )
09:20:36 <dilbert1970> 1,03
09:20:55 <dilbert1970> --end of the split transaction-
09:21:23 <jsled> Ah. Try using '.' as the decimal separator, instead.
09:21:34 <jsled> Was this working without with "1,03" addition?
09:21:39 *** Rolf2 has joined #gnucash
09:22:01 <warlord> jsled: I suspect he's in a "comma-as-decimal-sep" locale
09:22:15 <dilbert1970> yes, I'm in the it_IT.utf8 locale
09:22:28 <jsled> IIRC the expression parser doesn't take that into account.
09:23:28 <warlord> jsled: I'm pretty sure it does, which is why SXes fail when you change locale.
09:23:53 <jsled> ah, right … cause it should save a normalized form, not the literal string.
09:24:10 <warlord> right.
09:25:56 *** Jimraehl has left #gnucash
09:26:04 <dilbert1970> ok I did the two tests
09:26:44 <dilbert1970> if I manually enter the same expressions the druid created for me (i.e. without the +1,03)
09:27:20 <dilbert1970> I get the error message "... cannot balance ..."
09:27:38 <dilbert1970> if I try to substitute "," with "."
09:28:00 <dilbert1970> I get a "An error occurred while processing pmt" error message
09:29:18 <dilbert1970> well, since I trust that pmt=ppmt+ipmt, I can live with forcing gnucash to enter the transaction :-)
09:31:06 *** Rolf2 has left #gnucash
09:38:57 *** garyk has quit IRC
09:45:52 *** JimRaehl2 has joined #gnucash
09:56:11 *** Rolf1 has joined #gnucash
09:56:14 *** Rolf1 has left #gnucash
10:07:41 *** Rolf1 has joined #gnucash
10:07:53 *** Rolf1 has left #gnucash
10:19:10 *** dilbert1970 has left #gnucash
10:22:39 *** Rolf1 has joined #gnucash
10:31:35 *** JimRaehl2 has quit IRC
10:43:45 *** JimRaehl2 has joined #gnucash
11:33:49 *** soa2ii has joined #gnucash
11:58:58 *** Feisar has quit IRC
12:09:27 *** hvx has joined #gnucash
12:16:35 *** MechtiIde has quit IRC
12:49:20 *** soa2ii has quit IRC
13:13:49 *** MechtiIde has joined #gnucash
13:22:07 *** ErKa has quit IRC
13:28:22 *** bentob0x has joined #gnucash
14:14:34 *** andyt has joined #gnucash
14:29:41 *** bentob0x has quit IRC
15:13:27 *** twunder has joined #gnucash
15:31:33 *** hibana has joined #gnucash
15:34:48 *** Teka has quit IRC
15:35:47 <hibana> hi
15:39:23 *** iamawake has quit IRC
15:59:34 *** twunder has quit IRC
16:21:45 *** hvx has quit IRC
16:21:50 *** chris has quit IRC
16:24:34 *** sjc has joined #gnucash
16:25:19 *** chris has joined #gnucash
16:30:40 *** iamawake has joined #gnucash
16:44:28 *** Rolf1 has left #gnucash
16:53:09 *** ErKa has joined #gnucash
17:06:14 *** johnteddy has joined #gnucash
17:06:28 <johnteddy> Is there an intuit quickbooks for GNU/Linux, for accounting for a company, making invoices etc?
17:06:31 <johnteddy> can gnucash do that?
17:10:56 *** johnteddy has quit IRC
17:18:50 *** goodger has joined #gnucash
17:24:40 *** andyt has quit IRC
17:43:04 *** ErKa has quit IRC
17:54:53 *** eukreign2 has quit IRC
17:56:52 *** eukreign2 has joined #gnucash
18:08:04 *** MechtiIde has quit IRC
18:34:19 *** iamawake has quit IRC
19:36:17 *** warlord is now known as warlord-afk
19:54:41 *** goodger has quit IRC
19:57:55 *** iamawake has joined #gnucash
20:21:28 *** iamawake1 has joined #gnucash
20:21:37 *** iamawake has quit IRC
20:36:44 *** iamawake has joined #gnucash
20:36:51 *** iamawake1 has quit IRC
20:39:40 *** iamawake1 has joined #gnucash
20:39:47 *** iamawake has quit IRC
20:49:38 *** iamawake has joined #gnucash
20:49:46 *** iamawake1 has quit IRC
21:02:44 *** jsled has quit IRC
21:13:40 *** JimRaehl2 has quit IRC
21:13:40 *** aindilis has quit IRC
21:13:40 *** donfede has quit IRC
21:13:40 *** localhost has quit IRC
21:13:40 *** puck has quit IRC
21:13:40 *** joerlend has quit IRC
21:13:40 *** todd has quit IRC
21:13:40 *** warlord-afk has quit IRC
21:19:06 *** localhost has joined #gnucash
21:19:54 *** todd has joined #gnucash
21:20:55 *** warlord-afk has joined #gnucash
21:20:55 *** puck has joined #gnucash
21:20:55 *** joerlend has joined #gnucash
21:20:55 *** irc.eagle.y.se sets mode: +o warlord-afk
21:22:14 *** donfede has joined #gnucash
21:22:36 *** Rolf has joined #gnucash
21:22:44 *** iamawake has quit IRC
21:40:34 *** sjc has quit IRC
21:54:28 *** twunder has joined #gnucash
22:03:35 *** xvzf has quit IRC
22:11:09 *** Jimraehl has joined #gnucash
22:17:07 *** twunder has quit IRC
22:30:31 *** iamawake has joined #gnucash