2008-06-02 GnuCash IRC logs
00:07:55 *** fell has quit IRC
00:25:45 *** nodje has joined #gnucash
01:18:57 *** ErKa has joined #gnucash
01:40:11 *** warlord is now known as warlord-afk
02:43:55 *** kielein has joined #gnucash
04:02:41 *** nodje has quit IRC
07:27:57 *** nodje has joined #gnucash
08:41:40 *** aggieryan has joined #gnucash
08:42:42 <aggieryan> How do I add multiple lines to the description field when creating a transaction? Right now it is i just a single continuous line. Using 2.2.5 on XP.
08:46:57 <jsled> you can't. You can add one line for the transaction, and one line per Split.
08:47:35 <aggieryan> yikes, what if there is quite a bit of information I want to list? Like a warranty # and address?
08:47:48 <aggieryan> ...say for a large purchase
08:48:16 <jsled> Put it all on one line? With '|' as a "line-break".
08:48:27 <jsled> You could copy/paste between a text editor, say, to transform it.
08:48:39 <aggieryan> ok
08:52:25 <aggieryan> My only concern with this is that in reports the larger description field becomes cumbersome. I think it would be prudent to make it multiline for power users.
08:54:44 *** warlord-afk is now known as warlord
09:04:43 <warlord> The <enter> key has a specific meaning here.
09:05:07 <warlord> If you really have that much information to store it probably doesn't belong there.
09:06:22 <aggieryan> In that case it really would be nice to have a Notes section for the transactions or a way to attach files.
09:06:36 <aggieryan> Like, dare I say, Quicken. I have successfully made the switch, however.
09:07:13 <warlord> There is a notes section. Turn of double-line mode. ( View -> Double Line mode )
09:07:17 <warlord> s/of/on
09:07:34 <jsled> Right. The "notes" field. *headslap*
09:08:13 <aggieryan> I did find this, and it's nice to have the "Action" field when I do this.
09:08:25 <aggieryan> Is there any way to add/edit Actions?
09:08:34 <warlord> jsled: it's okay, it's early. You probably haven't had your coffee yet.
09:08:42 <warlord> aggieryan: it's just a text field -- you can type in whatever you want.
09:08:43 <jsled> indeed.
09:09:11 <aggieryan> warlord: I am wanting to add/edit Action types, not just what's in the field.
09:09:27 <warlord> The list is hard-coded in the app.
09:14:10 <aggieryan> For the reports, is it possible to list subaccounts? For instance, I have two checking accounts under "Checking Account", but they do not appear. Only the top-level account appears.
09:17:13 <warlord> change the reporting level in the report options
09:20:05 <aggieryan> If I run the report "Account Summary", how do I do that?
09:20:20 <aggieryan> Ok, got it. Thanks!
09:20:37 <warlord> :)
09:28:00 *** burki has joined #gnucash
09:28:48 *** illuminator08 has joined #gnucash
09:29:28 <illuminator08> HI, I have trouble in Gnucash 2.2.1., O/S Ubuntu Gutsy I noticed this same problem in the windwos port of gnucash awhile back too. The problem comes in when I try to print out a customer report. I get an empty table, by that I mean the table is empty of all data that should be there. no customers figures show up. I have row and title headings just no data, I've repeatedly tried different combinations of dates, and making sure the opt
09:32:03 <warlord> illuminator08: first, 2.2.5 is the most recent release.
09:32:16 <warlord> second, do you have multiple A/R accounts?
09:32:21 <illuminator08> yes
09:32:34 <warlord> Are you sure you're choosing the correct A/R account?
09:33:14 <illuminator08> I see. Yes. i tried choosing either account separately, still nothing.
09:34:07 <warlord> Are you sure there are Invoices and Payments in the time frame you've chosen?
09:34:14 <illuminator08> Yes.
09:35:25 <warlord> So if you go to Business -> Customer -> Find Invoice -> [Customer] -> [name] -- what are some of the dates?
09:36:40 <illuminator08> I'll update to the latest 2.2.5 see what happens. It used to work, it just for seemingly no reason just quit one day. I'll try the update.
09:36:55 <illuminator08> The dates in there are 5/28/08
09:37:04 <illuminator08> 5/29/08
09:37:09 <illuminator08> 5/28/08
09:37:25 <warlord> You have multiple invoices for the same customer on the same day?
09:38:27 <illuminator08> Yes, I do have multiple invoices for the same customer on the same date.
09:39:22 <illuminator08> I subcontract work, each Job is billed separately. Instead of the same invoice.
09:51:52 <warlord> And in the report you chose the same customer & A/R account?
09:52:13 <warlord> Is anything printed on the terminal or in /tmp/gnucash.trace?
09:54:57 <illuminator08> I haven't looked there I will check. I'm downloading the latest version now. Hopefully the latest ver. will fix this.
10:00:51 *** rcross has joined #gnucash
10:01:53 *** illuminator08 has quit IRC
10:03:25 *** nodje has quit IRC
10:07:36 *** nodje has joined #gnucash
10:26:58 *** aggieryan has quit IRC
10:32:17 *** donfede has joined #gnucash
11:18:40 *** pll` has joined #gnucash
11:18:40 *** pll has quit IRC
11:29:22 *** StocksR has joined #gnucash
11:33:19 <StocksR> Reports Question: I need a report of all the transactions in one account, that are not reconciled, and I need it formated to only show the part of the split (with memo) that refers to the selected account. is this going to be a case of write the report yourself? if so where should I start?
11:35:03 <StocksR> I have got allmost there by setting up the register in Journal mode and setting the filters to hide reconciled, then running the account report. I guess I just need to add an option to that report which hides split lines that are not from this account?
11:35:08 <StocksR> is this the right track?
11:35:26 *** ErKa has quit IRC
11:54:39 *** rcross has quit IRC
11:59:46 <jsled> StocksR: have you checked the report options once you create it?
12:00:09 <jsled> I'm not sure what base report that one is, but a couple of the reports have an account exclusion list.
12:01:39 <StocksR> This appears to be "register.scm" however my tests on the transaction report (which does have account exclusions) does not give me the required display.
12:02:08 <StocksR> what I need is only those parts of a split that refer to the selected account.
12:03:51 <StocksR> e.g. I get my t-mobile bill, there are 3 phones on the bill - 1 TX split to 3 accounts - I need a report on one of those accounts to show to the owner of that phone
12:04:47 <StocksR> btw this is made more complicatied by the fact that it is 6 splits as call and line rental are reported seperatly.
12:07:30 <StocksR> if this is going to be to hard I have a plan where I use an intermidery account (t-mobile) and record each bill in that account as 7 transactions (1 pay from checking 6 - individual parts for each item) I will be using the SX system to add them so this is not a huge pain it just seems to be a lot of extra work.
12:49:05 *** sjc has joined #gnucash
13:27:29 *** ErKa has joined #gnucash
13:39:47 *** Pepe66 has joined #gnucash
14:10:23 *** jrgenolsen has quit IRC
14:24:04 *** twunder has joined #gnucash
14:32:22 *** twunder has quit IRC
15:29:44 *** andi5 has joined #gnucash
15:29:44 *** gncbot sets mode: +o andi5
16:07:15 *** donfede has quit IRC
16:25:39 *** sjc has quit IRC
16:33:48 *** sjc has joined #gnucash
16:40:22 *** kielein has quit IRC
17:01:11 *** Pepe66 has quit IRC
17:16:51 *** Sideburns has joined #gnucash
17:17:08 *** andi5 has quit IRC
17:18:27 <Sideburns> I'm trying to use gnucash as a simple check register, and it's turning into a horror show. First, the balance vanished off the right side and I couldn't get it back. Then the reconciled checks stopped showing up. Now, I have a bank statement and Reconcile is grayed out.
17:19:36 <Sideburns> If it helps, I'm using version 2.2.5 on Fedora 9.
17:22:23 *** twunder has joined #gnucash
17:23:02 <Sideburns> Are you looking for help, twunder, or offering it?
17:24:14 <twunder> Sideburns: neither? I tend to autojoin and lurk. ;)
17:25:04 <Sideburns> Ah! I'm having major trouble with using gnucash as a simple check register. Previous assistance didn't work, and it's gotten worse. i was hoping...
17:25:44 <warlord> Sideburns: Do you have a scrollbar to scroll over to the balance?
17:26:39 <Sideburns> Yes, but it won't go that far. The balance just slips off the edge like it was doing last week. No real change there, and the balance isn't on the status bar, either.
17:27:17 <warlord> What do you mean, "isn't on the status bar"?
17:27:29 <warlord> What did you do to get it into this state?
17:27:57 <warlord> (and don't say "nothing", because there's no way GnuCash put itself into this state without user intervention)
17:29:16 <Sideburns> I have no idea. I just opened it up to add some transactions, and there it was. If I did anythng, I have no idea what it was. However, I did copy over the file from the version used in Fedora 8. Could this have an effect? I'd not want to start from scratch again, especially as I can't even see all the transactions now.
17:29:41 <Sideburns> Oops! I have no idea what I did. I just opened the program and there it was.
17:30:09 <Sideburns> I did, however, bring in the file from the version used with Fedora 8. Could this have done it?
17:30:11 <jsled> maybe can you post a screenshot?
17:30:43 <Sideburns> Wait one. I've never done this before on Linux, so it may take a bit of time...
17:31:22 <jsled> If you don't care about the transaction name/values, then Applications > Accessories > Take Screenshot should suffice.
17:31:53 <jsled> If you want to edit it to black that stuff out, then (assuming you have Gimp installed) I think it's File > Acquire > Screenshot... or something like that .
17:32:00 <Sideburns> I have the screenshot; how do I post it?
17:32:06 <warlord> Moving your datafile from F8 to F9 shouldn't affect the visible area.
17:32:33 <jsled> imageshack.us
17:32:42 <jsled> Or your own personal website, if you have one.
17:32:57 <Sideburns> Wait one...
17:38:06 <Sideburns> Sorry for the delay. I hadn't put anything on my site since the upgrade and had to configure the ftp program.
17:38:10 <Sideburns> It's at http://www.zeff.us/gnucash.png
17:41:05 <jsled> You could probably make the "Total Funds" column a bit smaller.
17:41:28 <jsled> Oh. Except, there's not going to be a balance column for the General Ledger.
17:42:07 <Sideburns> OK, how do I change it back to being a simple check reigister, then?
17:42:16 <jsled> Don't use the General Ledger. Close that tab, go back to Accounts, and double-click on the register for the account you want to enter transactions for.
17:42:35 <jsled> (Probably Assets:Current Assets:Checking.
17:42:36 <jsled> )
17:44:02 <Sideburns> Current Assets has nothing listed.
17:44:16 <jsled> See the little triangle control on the left? Expand the tree.
17:44:50 <jsled> The register for {Assets:Current Assets} shouldn't have anything. Most transactions are against children of it.
17:46:57 <Sideburns> OK! Got it! The triangle was on Accounts, not Assets, but I managed to follow it down. Thanx!
17:47:23 <jsled> you're welcome.
17:47:46 *** Demitar has quit IRC
17:47:57 <Sideburns> That's what it used to look like! Any idea how I mucked it up? (So that I can avoid doing it again.)
17:48:16 <jsled> Just don't use the General Ledger. :)
17:48:38 *** twunder has quit IRC
17:48:46 <Sideburns> OK. I'll remember that. Bye!
17:48:52 *** Sideburns has quit IRC
17:59:01 *** ErKa has quit IRC
18:06:18 *** burki has left #gnucash
18:19:37 *** localhost1 has joined #gnucash
18:25:38 *** localhost has quit IRC
18:41:10 *** davf has joined #gnucash
18:41:55 <davf> Hello, can anyone tell me how to delete all the config files for gnucash. I deleted .gnucash but it is still asking for a previous account file.
18:42:48 <jsled> that information is stored in gconf, which will keep it in ~/.gconfd/apps/gnucash/
18:43:00 <jsled> If you want to be more specific, you can just change the single key its looking at.
18:43:30 <jsled> Or you can blow the whole directory away. But be advisded that you'll probably need to run `gconftool-2 --shutdown` before doing so so gconfd doesn't see a cached copy of the data.
18:43:51 <jsled> But I wonder why you care? As soon as you open another file, it'll become "sticky" to that file.
18:44:11 <jsled> Or, if you just want to start "empty", try `gnucash --nofile`, or File > New File.
18:44:46 <davf> Well this is my first attempt with gnucash and I tried importing a qic and it was blank (export from kmymoney2)
18:45:07 <jsled> qic?
18:45:15 <davf> I tried money dance and that imported the same file ok but I don't want to use a commercial pgm$$$
18:45:53 <davf> So I just wanted to make sure that I didn't have anything in gnucache before reattempting to import again.
18:47:09 <davf> So basically I want to start again with the wizard asking for the option to import or make new file...
18:47:37 <jsled> Ah. Well, that dialog isn't all that interesting. Just do File > New File, then import. It's the same thing.
18:47:57 <davf> ok thx.
18:51:47 <davf> Ok, did the import again but the General Ledger is still blank.
18:52:27 <jsled> The general ledger will often be blank; you generally don't wan to use it.
18:52:38 <jsled> Open the register for the account you're interested in viewing from the Account tree.
18:53:28 <davf> Sorry to sound dumb but I don't see an account tree.
18:53:51 <jsled> Ah. Did you go through the "New hiearchy" thingy?
18:53:52 <warlord> davf: the page labeled "Accounts"
18:54:08 <jsled> It might not be there. Try File > New > New Account Page or something.
18:54:43 <davf> Ok that's progress. but the account has a 0 balance from the import.
18:54:56 <jsled> What's a "QIC" file. Do you mean QIF?
18:55:03 <davf> sorry yes qif
18:55:11 <davf> from kmymoney2
18:55:26 <davf> exported using defaults, catagories, accounts
18:55:34 <jsled> What account did you map the entries to?
18:56:47 <davf> There are two "accounts" but I only actually have one. One account says "Retained Earnings" and the other is my account called "My checking account" (that's what I called it)
18:57:02 <davf> I don't know what "Retained Earnings" is.
18:58:06 <davf> Perhaps I should walk through the import and verify my choices...
18:58:23 <jsled> Perhaps. You might want to use one of the predefined account hierarchies, as well.
18:58:51 <jsled> It has a whole tree of common asset (checking, savings, &c.), income and Expense accounts
18:59:06 <jsled> Well, the "Common" hierarchy does, anyway.
18:59:16 *** yrro has joined #gnucash
18:59:25 <davf> ok... so I will delete the .gnucash and start again.
18:59:39 <jsled> Don't worry about deleting ~/.gnucash.
19:00:02 <davf> I just ddin't want to have several attempts to import the same file?
19:00:51 <davf> Ok... so I'm at a totally blank screen with only the menu and the buttons save and close
19:01:10 <jsled> You'll still want to do {file > new file}.
19:01:33 <jsled> And, fair enough, the importer does save some state in ~/.gnucash/ during import. But it shouldn't matter too much.
19:01:52 <davf> ok so now I"m at new accthierarchy setup.
19:02:21 <davf> I didn't actually do this before. I thought the qif would set all this up.
19:02:55 <davf> Common accounts is chosen
19:03:23 <davf> do I need to highlight anything in the right hand accounts in common accounts?
19:03:30 <jsled> nope
19:04:07 <davf> Ok so the next page I'm choosing only checking acct and savings acct. I don't need assets etc...
19:04:34 <jsled> I don't believe you can edit the tree in there. You can do so afterwards if you like.
19:04:39 <davf> ok thx.
19:04:47 <jsled> But for the time being, I'd suggest just leaving it and see if you can get the import to go.
19:04:53 <jsled> If it works out, you can always re-import later.
19:04:54 <davf> I don't need a starting balance.
19:05:36 <davf> ok... that's done and there is a list of the various accounts.
19:06:10 <davf> what should I do next?
19:06:16 <jsled> File > Import
19:07:17 <davf> ok... on the match qif acconts with gnucash accounts shows "retained earnings" and "my checking acct". I don't know what this retained earnings is.
19:08:19 <jsled> Retained Earnings is basically money left over after you "close" the books. It'd be the starting equity (starting balances) that you would use to initialize a new year's datafile.
19:08:34 *** cort has quit IRC
19:09:58 <davf> ok... so the next screen (where I was a little unsure last time) is the "match qif categories with gnucash accounts" They basicly show the qif catagory name and the gnucash account name and that is the same as the catagory. I changed them all to my checking acct but I'm not sure about this.
19:10:31 <warlord> That's NOT what youwant!
19:10:38 <davf> ok...
19:10:47 <davf> should I just leave them as they are?
19:10:51 <warlord> Those are the Income/Expense categories (Accounts) that describe where the money goes to/comes from
19:11:15 <davf> yes. but what about that it says gnucash account name
19:11:30 <warlord> Right! The GnuCash Income/Expense Account Name.
19:11:33 <warlord> Have you read the GnuCash Docs?
19:11:34 <jsled> Earlier in the process, you said that all of these transactions are related to your checking account … now you need to specify the *other* leg of the transaction.
19:11:45 <warlord> Anyways, I gotta un.
19:11:47 *** warlord is now known as warlord-afk
19:12:04 <davf> jsled - the other leg?
19:13:40 <jsled> In a double-entry sense. All transactions affect at least two accounts, and the debits and credits of those Splits *always* sum to zero.
19:13:52 <jsled> The Tutorial and Concepts guide covers all this.
19:14:04 <davf> ok... so for now I just keep them as they are?
19:14:14 <jsled> So, in the common case, a transaction is going to touch your Checking account and an Expense account.
19:14:32 <davf> ok... ahh... that worked.
19:14:36 <jsled> You can, but you're going to want to do it again later.
19:15:08 <jsled> Because now they're all mapped to the … what … Unknown account? And more over, you've trained the importer to associate them with the Unknown account rather than the relevant Expense accounts.
19:16:35 <davf> Ahh.. I think I understand. Ok. So what happened is a seperate account was created for each catagory.
19:18:10 <davf> Ok... just from looking around everything seems in place. I think where I went wrong was I needed to create the account tree first. Thanks for you patience jsled. I really appreciate it.
19:18:22 <jsled> you're welcome.
19:19:22 *** StocksR has quit IRC
19:21:05 *** davf has quit IRC
19:37:02 *** twunder has joined #gnucash
19:42:19 *** foo has joined #gnucash
19:42:41 <foo> hm, has there ever been issues of a pdf exported from gnucash not being able to be opened under OS X?
19:42:48 <foo> I can't see why... I'm going to resend ... just wondering
19:43:17 <jsled> I've not heard that, no.
19:43:28 <foo> Ok, must have been a hiccup or something. *shrug*
19:52:05 *** twunder has quit IRC
20:34:30 *** nbinont has joined #gnucash
20:36:57 *** sjc has quit IRC
20:45:48 *** nbinon1 has joined #gnucash
20:52:58 *** nbinont has quit IRC
21:01:34 *** warlord-afk is now known as warlord
21:06:54 *** localhost has joined #gnucash
21:12:37 *** localhost1 has quit IRC
21:14:24 *** nbinon1 has quit IRC
21:21:31 *** twunder has joined #gnucash
21:37:45 *** jrgenolsen has joined #gnucash
21:44:06 *** jcreigh has joined #gnucash
21:49:00 *** twunder has quit IRC
21:49:53 *** localhost1 has joined #gnucash
21:56:54 *** localhost has quit IRC
22:01:45 *** jrgenolsen has quit IRC
23:21:19 *** jcreigh has quit IRC
23:57:22 *** paulproteus has quit IRC
23:57:56 *** jrgenolsen has joined #gnucash