2013-06-14 GnuCash IRC logs
10:23:01 *** gncbot has joined #gnucash
10:25:14 <warlord> And there is gncbot, signalling code is back online.. Okay, 20 minutes to reboot..
10:25:42 <warlord> carlson417: You should be able to reach code now.
10:25:57 <warlord> httpd is responding to me now
10:26:09 <carlson417> yes
10:26:19 <warlord> Thanks for your patience.
10:28:20 *** fabior has joined #gnucash
10:41:35 <carlson417> If I have a report open in a separate window when I close GnuCash, all the tabs that were open in the main window disappear. is that the way it is supposed to work?
10:44:43 <warlord> I dont think so -- when you restart gnucash it should reopen all windows with all tabs
10:47:04 <carlson417> I am pretty sure that my wife closed the program and she is not revealing the details of what she did. When I re-opened the program only the report appeared. The main window never re-appeared.
10:47:42 <carlson417> GuCash 2.4.13 in Windows 7 64 bit
10:47:45 <warlord> That is... very odd..
10:48:18 <warlord> There may be no way to recover your old window state, but you can certainly open a new Chart of Accounts tab from the View menu
10:49:45 <carlson417> I found that and I have started re-opening tabs. I guess I need to build a test case to see if I think there is a bug.
10:51:10 <warlord> Sounds like a good idea ;)
10:52:05 <carlson417> Are there any caveats about closing separate windows first before closing the main window? should child windows be recalled just as tabs and tab order are recalled?
10:59:28 <warlord> Oh, if you close the windows then of course they wont reopen.
11:00:13 <warlord> No, open child windows will reopen as child windows. But if you close the window before existing gnucash then the window wont exist when you exit, and therefore gnucash wont reopen it
11:06:02 *** IanL has quit IRC
11:07:06 <carlson417> so, in Windows, if I click on the red X button in the upper right corner of the main window that should close child windows too and all should re-appear next time. is that correct?
11:07:43 <warlord> No
11:07:47 <warlord> That is NOT correct.
11:08:00 <warlord> The little X just closes that window; it does not exit the application
11:08:09 *** ErKa has joined #gnucash
11:08:52 <carlson417> I am not referring to the X in the tab
11:10:38 <warlord> Neither am I; I am talking about the X in the window header
11:10:51 <warlord> where it has: _ [] X
11:11:11 <warlord> (minimize, maximize, close-window)
11:12:10 <warlord> That really is "close window", not "exit application"
11:12:34 <warlord> a close-window even on the *last* window will effect an "exit application"
11:12:39 <carlson417> I am still confused. When GnuCash only has one window open and I click on that button Gnucash stops running
11:12:40 <warlord> s/even/event
11:12:55 <warlord> Correct.. Because when there are no windows left to close gnucash exits
11:13:09 <warlord> This is true of firefox, too
11:13:16 <warlord> (and pretty much every application)
11:15:42 *** benoitg has joined #gnucash
11:16:53 <carlson417> I need to digest that. Next question: is there a parent/child relationship between windows when there are more than one window?
11:17:35 <carlson417> or are they all equal?
11:20:01 <carlson417> To retain all windows when leaving GnuCash Would I need to do ctrl-Q?
11:21:25 *** fabior has quit IRC
11:25:16 <carlson417> I think I found out why I have been avoiding multiple windows.
11:25:44 <carlson417> too much washing, anyways
11:29:09 <warlord> They are effectively all equal
11:29:26 <warlord> Yes, to retain all windows you need to File -> Quit (or Ctrl-Q)
11:30:39 <carlson417> Back in the old days Alt+f, x worked too. is that gone?
11:31:19 <carlson417> I think F4 worked too
11:31:23 <warlord> I think so, yes. I don't recall that ever working.
11:31:32 <warlord> But I'm not a winblows user
11:31:48 <carlson417> :)
11:36:02 <carlson417> I have been a captive since ms-DOS pretty much replaced CP/M on Intel 8-bit cpu's
11:36:40 <carlson417> I can still change, tho
11:41:01 *** benoitg has quit IRC
11:42:55 <warlord> Linux has been out there for over 20 years...
11:43:07 <warlord> ... and works on all those intel machines (and much more)
11:47:20 <carlson417> I am already playing with Ubuntu 12.04 on my older laptop The Windows secret key is Alt-F4. Apparently I have been sucked into believing that the red X closes programs by the many alleged experts on the internet.
11:48:26 <carlson417> they have been lying to me. (why am I surprised?)
11:49:33 <carlson417> Thanks for the help.
11:56:30 <carlson417> Now for a real question. I have a stock purchase transaction from January that combines four purchases of the same security in four different sub-accounts of the same brokerage account. The Balance report gives the correct number of shares and value for the security on March 31 in three of the sub-accounts but the value is incorrect in one of the sub-accoun
11:57:09 *** ErKa has quit IRC
11:58:20 <carlson417> combining purchases reduced 96 transactions to 24.
12:00:48 <carlson417> I am fairly certain that the transaction is correct in the register
12:04:10 <carlson417> when I try to isolate the error I am not having good luck. Is there any report that can help me determine if that transaction is actually balanced?
12:11:53 *** mikee has joined #gnucash
12:11:58 <warlord> Why do you have a single stock in multiple subaccounts of a brokerage?
12:15:35 <carlson417> this is a re-incarnation of a very old 401(k) that has separate sub-accounts for company contributions under various previous plans. Also there could be after-tax accounts and Roth accounts
12:16:45 *** fabior has joined #gnucash
12:17:08 <warlord> Okay, so why record it as a single transaction?
12:18:15 *** benoitg has joined #gnucash
12:18:47 <carlson417> It was easier to model one transaction and replicate it 12 times instead of 96 times.
12:19:33 <warlord> well, your replication could be wrong.
12:19:49 <warlord> you could have a wrong price in there.. one split could be wrong..
12:20:21 <warlord> biaw..
12:20:25 <carlson417> that is why I want a printout of the transaction
12:21:24 <carlson417> the transaction looks fine on the screen, I want a piece of paper that I can use a highlighter on
12:22:19 <carlson417> 75% of it is correct
12:23:21 <carlson417> the rest looks ok on the screen, I need to compare it to the excel download I got in January
12:25:21 <carlson417> it gets blurry when I stare at so many numbers on the screen
12:26:14 <warlord> carlson417: choose the transaction, click on the Split button to expand it, then Report -> Account Transaction Report (at the bottom of the menu)
12:26:33 <carlson417> screen print doesn't work because the account names are too long to see on the screen
12:29:17 <carlson417> I did that from the top brokerage account and I cannot make the report show the line-by-line detail. It just says split
12:37:45 <carlson417> If I look at teh same transaction from the account that has the incorrect value, that report only shows the number of share purchased for that account, not the price paid for that account or the other transaction lines tha might be interacting
12:42:57 *** todd has quit IRC
12:43:00 *** todd has joined #gnucash
12:48:56 <warlord> carlson417: from the register expand the split, and then from the report you need to reset the report options to have it show the split-expanded transaction
12:53:13 <carlson417> I cannot find an option to do that
12:54:18 *** benoitg has quit IRC
12:59:18 <carlson417> ok, under the display tab I checked every box. Now I do not see all the lines but for some reason I am in the account for fund RICGX but there is a price shown for fund RGAGX
12:59:54 <warlord> Hmm, I THOUGHT there was a way to do it there..
13:00:10 <carlson417> there are no lines in that transaction for RGAGX
13:04:18 <warlord> Your other option to print it out would be to print a transaction report. I know that from THERE you can have it print all the splits..
13:05:39 <carlson417> I also tried the trial balance report but it seems different than I recall from the past. Has it changed recently? I can get down to a few accounts but something seems different
13:07:02 *** Grabben sets mode: +o gncbot
13:08:43 <warlord> No clue -- never used it.
13:09:21 <warlord> @op
13:09:21 <gncbot> warlord: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
13:09:39 <warlord> @op
13:09:40 *** gncbot sets mode: +o warlord
13:09:52 <warlord> @op fell mikee linas
13:09:53 *** gncbot sets mode: +ooo fell mikee linas
13:12:24 <carlson417> the transaction report seems to only select lines from the transaction that relate to accounts highlighted in the reports' accounts tab.
13:13:20 <warlord> But from the txn report you can tell it to show all splits.
13:14:02 <warlord> I know that for a fact, but I'm on a work call so cant spend the time to re-figure-out how to do it again. There is a mode on one page to show all splits.
13:16:22 <carlson417> If there are no lines for fund RGAGX in any transaction appearing in a security account for fund RICGX why would a report for that fund RICGX account have a fund RGAGX price in it?
13:20:53 <warlord> Because you have an entry in the pricedb?
13:24:47 <carlson417> Ok lets table this for now. I do own both securities but each security has it's own security accounts in various brokerage accounts. There must be a hidden pointer in the transaction pointing to the wrong security price
13:25:47 <warlord> Transactions have prices embedded in them. There is no external pointer
13:26:14 <warlord> The reports have various methods to pull prices when reporting on securities, the Quote Source, which you can control from the report options.
13:26:25 <warlord> Generally you want Nearest in Time -- which might not always be the default.
13:26:38 <warlord> generally you do NOT want Weighted Average -- which sometimes MAY be the default.
13:28:41 <carlson417> I was careful to choose nearest in time and to copy prices from March 28 (the last business day of March) to March 31 so that the April 1 prices would not step on them.
13:29:07 *** fabior has quit IRC
13:29:43 <carlson417> it would be nice to have a choice 'last price before...'
13:29:49 *** fabior has joined #gnucash
13:34:53 <carlson417> Should I put an email in the user maillist about prices in reports seeming to not match transactions?
13:37:34 <carlson417> there is a disconnect somewhere, but I am not finding it.
13:37:35 <warlord> Prices in reports WONT match transactions, because the entries in the pricedb are different.
13:39:17 <carlson417> the report should not select a price for the wrong security
13:39:48 <carlson417> unless there is something in the transaction that comfuses it
13:42:00 <warlord> Are you sure that's what it is doing?
13:48:50 *** aqua___ has joined #gnucash
13:50:34 <carlson417> So far I am still searching for a tool to help me figure out why the reports appear to be wrong. I have now found a transaction report that shows a purchase of shares of RGAGX in a stock account for RICGX. The transaction in that account only shows purchases of RICGX. Where is the report getting it's mis-information?
13:55:22 <warlord> That implies a bogus memo field, bogus account name, or wrong account security..
13:55:52 <warlord> The report is getting that infomration directly from the Transaction/Split/Account in question
13:58:40 <carlson417> Somehow, what I see in the transaction doees not match what the report sees
13:59:56 <carlson417> that is what I want to fix
14:03:13 <warlord> Then you're looking at the wrong transaction. The report wont show you something that doesn't exist.
14:10:29 <warlord> (since I dont see what's on your screen it's hard to point over your shoulder to the mistake)
14:13:13 <carlson417> Ok. Start over. I go to a register for the security RICGX. I find three transactions, all describing actions on RICGX. I highlight one of those transactions and select Reports -> Account Transaction Report. The report that appears contains the security RGAGX
14:14:19 <warlord> Can you post some screen shots of this?
14:14:36 <carlson417> If I click on the link to RGAGX, it takes me back to the same transaction that only shows RICGX
14:15:12 <carlson417> how do i post a screenshot here
14:15:31 <warlord> imagebin
14:15:34 <warlord> (wesite)
14:15:36 *** benoitg has joined #gnucash
14:15:36 <warlord> website
14:16:11 <warlord> My guess is that you have an account of name RICGX with an account security of RGAGX, or vice-versa
14:18:13 <carlson417> That was IT!!!!!!!!!!
14:19:44 <carlson417> Now I can reload those reports and they are correct
14:20:38 <warlord> Like I said above: <warlord> That implies a bogus memo field, bogus account name, or wrong account security..
14:20:49 <warlord> You had a wrong account security (or bogus account name) ;)
14:21:58 <carlson417> That did not jump out at me in the reports. Thanks for your patience with me.
14:22:11 <warlord> you're welcome.
14:22:44 <carlson417> bye
14:23:25 *** carlson417 has quit IRC
14:25:20 *** fabior has quit IRC
14:50:15 *** wizkid238 has joined #gnucash
14:52:07 *** Krzysiek_K has joined #gnucash
14:58:13 *** aqua___ has quit IRC
15:00:37 *** aqua___ has joined #gnucash
15:14:25 *** aqua___ has quit IRC
16:10:26 *** calbasi has left #gnucash
17:28:23 *** fell_ has joined #gnucash
17:28:23 *** gncbot sets mode: +o fell_
17:37:25 *** fell has quit IRC
18:05:34 *** shanny has joined #gnucash
18:09:11 *** arrainey has joined #gnucash
18:11:38 *** shanny has quit IRC
18:16:49 *** arrainey has quit IRC
20:56:25 *** kpreid has joined #gnucash
22:07:50 *** fell_ has quit IRC
22:08:17 *** fell_ has joined #gnucash
22:08:17 *** gncbot sets mode: +o fell_
22:30:15 *** arrainey has joined #gnucash
22:35:17 *** arrainey has quit IRC
22:35:53 *** arrainey has joined #gnucash
22:40:53 *** arrainey has quit IRC
22:41:26 *** arrainey has joined #gnucash
22:46:26 *** arrainey has quit IRC
22:47:05 *** arrainey has joined #gnucash
22:52:06 *** arrainey has quit IRC
22:52:40 *** arrainey has joined #gnucash
22:57:42 *** arrainey has quit IRC
22:58:22 *** arrainey has joined #gnucash
23:03:24 *** arrainey has quit IRC
23:04:14 *** arrainey has joined #gnucash
23:09:14 *** arrainey has quit IRC
23:09:48 *** arrainey has joined #gnucash
23:16:36 *** arrainey has quit IRC
23:17:11 *** arrainey has joined #gnucash
23:22:11 *** arrainey has quit IRC
23:22:49 *** arrainey has joined #gnucash
23:49:46 *** arrainey has quit IRC
23:50:22 *** arrainey has joined #gnucash
23:55:24 *** arrainey has quit IRC
23:55:55 *** arrainey has joined #gnucash