2009-05-25 GnuCash IRC logs
00:16:36 *** sgtyork has quit IRC
00:46:24 *** applejuicekiss has quit IRC
00:47:52 *** jmd has joined #gnucash
00:52:13 *** gumpwea has joined #gnucash
01:09:27 *** Rafael_ has quit IRC
01:49:55 *** gumpwea has quit IRC
02:06:34 *** jmd has quit IRC
02:20:46 *** warlord is now known as warlord-afk
03:08:43 *** MechtiIde has joined #gnucash
03:59:00 *** ErKa has joined #gnucash
04:28:10 *** amidelalune has joined #gnucash
05:54:42 *** vitoc has joined #gnucash
06:01:45 *** cortana has joined #gnucash
08:19:38 *** bentob0x has joined #gnucash
09:04:20 *** Jimraehl has left #gnucash
09:09:04 *** mattt has joined #gnucash
09:10:19 <mattt> I have a question about reports in gnucash - hoping someone can help me? I'm running version 2.2.7.
09:10:34 <mattt> What I'd like is to see a summary of activity in all of my expense accountws for a given calendar month.
09:10:57 <mattt> Sorry, a summary (or balance?) for _each_ of my expense accounts for a given month.
09:11:17 <mattt> Does a report already exist that I can configure to do this for me?
09:11:25 <mattt> I've tried a few out, but so far haven't found one.
09:17:10 *** JimRaehl2 has joined #gnucash
09:18:52 *** JimRaehl2 has left #gnucash
09:19:07 *** JimRaehl2 has joined #gnucash
09:22:20 <mattt> OK, I've just tried the "Transaction report", and it's pretty close to what I want.
09:22:43 <mattt> It's listing "Total for April 2009" for the selected accounts, which is perfect.
09:23:07 <mattt> But it's also listing each individual transaction, which I'd like ot get rid of...
09:46:10 <cortana> mattt: maybe a cash flow report?
09:46:42 <cortana> in the report options, you can limit the dates and accounts that it will run over
10:14:01 <mattt> OK, thanks. I'll give that a try.
10:17:14 *** warlord-afk is now known as warlord
10:17:24 <warlord> mattt: Try the Income Statement
10:17:35 <warlord> cortana: the cash flow isn't what he wants.
10:17:58 <warlord> That tells you the influx/outflow of money into/outof a set of accounts, which isn't what you're looking for.
10:29:41 *** gumpwea has joined #gnucash
10:29:57 <cortana> oh i misunderstood--thanks
10:31:02 <lenscape> my accounts list has something called: Emoulements
10:31:42 <lenscape> (under Expenses)
10:53:21 *** MechtiIde has quit IRC
10:54:28 <warlord> lenscape: what language?
10:54:42 <warlord> I have no idea what "Emoulements" are.
11:11:45 <mattt> warlord: thanks - that's perfect.
11:13:30 <warlord> Happy to help.
11:15:30 *** mattt has quit IRC
11:21:05 *** amidelalune has quit IRC
11:39:28 *** ErKa has quit IRC
12:05:24 *** soa2ii has joined #gnucash
12:27:08 *** Rafael_ has joined #gnucash
12:29:02 *** Rafael_ has quit IRC
12:42:16 *** asqui has joined #gnucash
12:45:08 <asqui> If I am using an intermediate account to split up the cost of a future expense over multiple accounting periods (months) can I still balance the "real" transactions in the source account against a bank statement?
12:49:11 <asqui> (For example, how can I avoid the synthetic transaction to transfer some partial sum to my intermediate account causing a discrepancy with the official account statement.)
12:53:37 <warlord> asqui: you'd still have your Bank -> <Holding> account, so that would be the one you reconcile.
12:53:55 <warlord> There's no way to reconcile the <Holding> -> Expense (depreciation?) transactions.
13:09:42 *** ErKa has joined #gnucash
13:18:28 <asqui> I don't understand.
13:21:52 <asqui> If my actual transaction is an annual cost of $1,200 Assets:BankAccount -> Expenses:Foo in January, is it possible to split this into 12 monthly transactions of $100, without losing the ability to balance a monthly statement for "BankAccount" (which lacks the synthetic $100 transaction, but instead has an annual $1,200 transaction in January)?
13:22:29 *** MechtiIde has joined #gnucash
13:23:09 <warlord> asqui: yes, by using an intermediary account, so you'd do Assets:BankAccount -> Intermediary for $1200, then each month create a transaction from Intermediary -> Expenses:Foo for $100
13:23:17 <warlord> biab
13:23:18 *** warlord is now known as warlord-afl
13:23:21 *** warlord-afl is now known as warlord-afk
13:24:49 <asqui> Oh right... that makes sense. I think I was confused about the correct way to use the intermediary account. Thanks.
13:24:54 *** sjc has joined #gnucash
13:36:37 *** vitoc has quit IRC
13:43:37 *** nomeata has joined #gnucash
13:46:14 *** hvx has joined #gnucash
13:55:18 *** warlord-afk is now known as warlord
13:55:28 <warlord> you're welcome asqui
14:13:14 *** cstim has joined #gnucash
14:13:32 <warlord> hiya cstim
14:14:18 <cstim> hi warlord
14:14:22 <cstim> how are you?
14:14:42 <warlord> hot and tired.. but I've been moving dirt around .
14:15:48 <warlord> (I think I moved about 1 to 1.5 m^3 of dirt today)
14:16:29 <cstim> huh
14:16:33 <cstim> that's a lot
14:17:01 <warlord> Yeah.. so I'm a little tired.. but it's a beautiful day.
14:17:20 <cstim> login doesn't work. Username was "cstim", right?
14:17:50 <warlord> Yeah.
14:18:12 <warlord> Hmm, it says "rejected password"
14:18:15 <warlord> Let me try...
14:18:44 <warlord> where is 'pwgen'?
14:19:44 <cstim> I don't know
14:19:45 <warlord> Oh, probably because the S2K isn't something supported...
14:20:08 <cstim> opensuse has a pwgen package
14:20:12 <cstim> S2K?
14:20:26 <warlord> ahh, so does fedora. just not installed.
14:21:29 * cstim is away: phone
14:28:45 *** nomeata has quit IRC
14:29:52 * cstim is back
14:29:53 *** OsamaK has joined #gnucash
14:34:26 <OsamaK> Hello. Is it possible to set a scheduled item to start in the past? I tried to change the 'Start Date' in 'Edit Scheduled Transaction' into past but nothing got added.
14:35:03 <warlord> Did you then run the SX?
14:38:21 <OsamaK> warlord: and what's that?
14:38:49 <warlord> http://wiki.gnucash.org/wiki/FAQ#Q:_What_is_the_.22SX.22_thing_I_see_on_the_lists_and_IRC_periodically.3F
14:39:55 *** localhost has quit IRC
14:40:53 *** localhost has joined #gnucash
14:43:39 <OsamaK> warlord: yes I did.
14:43:52 <OsamaK> warlord: does it support past-stuff?
14:44:02 <warlord> In theory.
14:44:11 <warlord> (i've had issues creating new SXes)
14:44:27 <OsamaK> past ones?
14:45:48 <jsled> OsamaK: yes
14:46:31 <OsamaK> Is it better with the new beta version?
14:46:33 <jsled> I just created a new file, created a monthly 25th SX start date 1/1/2009, ran since last run, 5 transactions show up, [x] Review created, Ok, and 5 are there.
14:46:48 <jsled> I'm using 2.2.9; it's always supported creating transactions in the past.
14:47:17 <OsamaK> let me test yours.
14:51:26 * jsled is back out in the yard
15:08:42 *** OsamaK has quit IRC
15:09:44 *** soa2ii has quit IRC
15:14:36 *** OsamaK has joined #gnucash
15:15:03 <OsamaK> not sure if you got it:
15:15:04 <OsamaK> warlord: I cannot delete any transaction not by right-click, Transaction menu or the Toolbar.. but I can change and duplicate it.
15:15:42 <warlord> OsamaK: Actions -> Reset Warnings
15:15:55 <warlord> Most likely you hit "cancel" and also clicked the "do not remind me again"
15:20:04 <OsamaK> work, thanks :)
15:20:28 <warlord> :)
15:26:47 *** iamawake has joined #gnucash
15:46:36 *** mwic has joined #gnucash
15:48:16 <mwic> anyone ever done a networked gnucash installation? By that I mean two different clients would have access to the same datafiles?
15:53:58 <warlord> mwic: how are you sharing the data file?
15:54:14 <mwic> i'm not yet; looking for advice on how
15:54:15 <warlord> note that gnucash only supports serialized access to the data file, so only 1 user/client can access the data file at a time.
15:54:20 <mwic> i was thinking vanlla subversion
15:54:36 <mwic> right, i'd only access from one machine at a time, but i want them synced
15:54:53 <warlord> Why not use an NFS share?
15:55:29 <mwic> 'cause one machine's at the office and the other's at home.. so just SSH access
15:55:51 *** hvx has quit IRC
15:56:07 <mwic> and 'cause i know nothing about NFS
15:57:43 *** Zoolooc_ has joined #gnucash
15:59:50 *** asqui has quit IRC
16:06:28 <mwic> ooh, unrelated question: on this installation (2.2.4) i don't seem to have the "show table" option in reports..
16:06:55 *** iamawake has quit IRC
16:09:54 *** bentob0x has quit IRC
16:13:25 <warlord> "show table"?
16:13:39 <warlord> mwic: consider sshfs?
16:16:18 *** OsamaK has quit IRC
16:25:24 *** twunder has joined #gnucash
16:26:01 *** mwic has quit IRC
16:26:37 *** cstim has quit IRC
16:29:21 *** twunder has quit IRC
16:52:11 *** Zoolooc_ has quit IRC
17:27:40 *** sjc has quit IRC
17:31:52 *** sjc has joined #gnucash
17:33:03 *** JR9-9 has joined #gnucash
17:34:01 <JR9-9> Question: After I update my securities with the price editor, the values of the securites update correctly in the accounts window and income statement, but not in the balance sheet. Any ideas?
17:34:53 <warlord> JR9-9: check your quote source selection in the report options.
17:36:06 *** ErKa has quit IRC
17:37:43 *** Rafael has joined #gnucash
17:39:00 *** Rafael has joined #gnucash
17:49:04 <JR9-9> I looked in the options for the balance sheet but could not find a quote source selection. I did look in the security editor and verified each security is set to update from Yahoo, and the securities do update in the account list and income statement - just not in the balance sheet.
17:50:52 <warlord> It's on the "Commodities" page of the report options
17:53:57 <JR9-9> warlord: That was it. I had it set on "average cost" instead of "most recent." Thank you. By the way, this is a great program. Very stable and it has simplified my financial life.
17:54:14 <warlord> great
17:56:05 *** JR9-9 has quit IRC
17:58:36 *** twunder has joined #gnucash
17:58:47 *** andyt has quit IRC
18:00:37 *** Lin has joined #gnucash
18:00:40 <Lin> hi all.
18:01:01 <Lin> is possible to make gnucash work in a mysql database? is so, any documentation points that?
18:01:26 <Lin> btw, im working with ubuntu 9.04 gnucash
18:09:23 <jsled> Lin: the current dev release has support for a generic database backend.
18:09:57 <jsled> http://wiki.gnucash.org/wiki/Announcement_2.3.0
18:09:58 <Lin> 2.2.6 isnt the current dev release right?
18:10:02 <Lin> jsled: ok.
18:10:31 <Lin> but what do you mean about generic db backend? gnome-gda?
18:11:09 <jsled> DBI, I believe.
18:11:19 <Lin> jsled: ty.
18:11:29 <jsled> right, "This is a new implementation using libdbi.", from that link.
18:15:02 *** sjc has quit IRC
18:22:47 *** sjc has joined #gnucash
18:43:07 *** Rafael has quit IRC
18:44:08 *** lamma has joined #gnucash
18:45:32 <lamma> Hi everyone! How do I mark an invoice as "inactive"?
18:46:24 *** Zoolooc_ has joined #gnucash
18:48:13 <warlord> click on the Active checkbox and uncheck it.
18:51:55 <lamma> I can´t find this checkbox.... =/ in the invoice screen there´s only save, close, edit, register, cancel, delete, duplicate, send...
18:53:10 <lamma> oooh i just saw it haha! tks!
18:53:29 <warlord> Yeah, in the INvoice Information section.
18:57:23 *** Rafael has joined #gnucash
19:01:48 <lamma> one more question: can I schedule transacions with Accounts Receivable? My company runs contracts, and every star of the month I have to send them invoices and credit it in my accounts receivable
19:05:32 <warlord> No
19:17:14 *** Rafael has quit IRC
19:20:32 *** iamawake has joined #gnucash
19:28:55 *** lamma has quit IRC
19:36:28 *** Rafael has joined #gnucash
19:37:04 *** iamawake has quit IRC
19:55:41 *** Zoolooc_ has quit IRC
20:01:38 *** cortana has quit IRC
20:09:06 *** sjc has quit IRC
20:23:56 *** twunder has quit IRC
20:36:49 *** twunder has joined #gnucash
20:45:48 *** Bob has joined #gnucash
20:47:17 *** Rafael has quit IRC
20:50:48 *** JimRaehl2 has left #gnucash
20:51:07 *** Jimraehl has joined #gnucash
21:18:52 *** iamawake has joined #gnucash
21:21:48 *** twunder has quit IRC
21:48:56 *** Zoolooc has joined #gnucash
22:03:06 *** iamawake has left #gnucash
22:21:29 *** Zoolooc__ has joined #gnucash
22:21:36 <warlord> jsled: ping?
22:29:41 *** Zoolooc has quit IRC
22:43:17 *** eukreign has quit IRC
22:59:37 *** eukreign has joined #gnucash
23:08:47 *** eukreign has quit IRC
23:13:13 *** Zoolooc__ has quit IRC
23:13:20 *** Zoolooc__ has joined #gnucash
23:25:16 *** Zoolooc__ has quit IRC
23:37:35 *** eukreign has joined #gnucash