2010-01-08 GnuCash IRC logs
00:53:31 *** Parker has quit IRC
02:07:11 *** jean has joined #gnucash
02:41:56 *** Parker has joined #gnucash
03:24:28 *** demitar has joined #gnucash
03:40:33 *** daedeloth has joined #gnucash
04:21:50 *** muczy has joined #gnucash
04:21:54 <muczy> hi
04:22:34 <muczy> how can I get the root account without having any accounts (in scheme api)?
04:22:40 <muczy> warlord-afk: perhaps? :)
04:28:05 *** jean has quit IRC
05:19:23 <muczy> ah
05:19:25 <muczy> (gnc-get-current-root-account)
05:19:31 <muczy> bye
05:19:31 *** muczy has left #gnucash
05:26:07 *** daedeloth has quit IRC
05:49:04 *** Parker has quit IRC
07:02:37 *** XiXaQ has joined #gnucash
07:24:33 *** Jimraehl has left #gnucash
07:25:27 *** Jimraehl has joined #gnucash
07:36:59 *** XiXaQ has quit IRC
07:44:59 *** warlord-afk is now known as warlord
07:56:41 *** Jimraehl has left #gnucash
08:07:53 *** Jimraehl has joined #gnucash
08:35:01 *** XiXaQ has joined #gnucash
08:57:32 *** fosstux has joined #gnucash
08:57:52 <fosstux> Hi! How can I define starting values for my accounts?
08:58:26 <fosstux> I'm really new to GnuCash - so sorry for maybe asking the same thing often asked...
09:03:07 <warlord> Two ways: 1) when you create the account you can set an opening balance.. or 2) you can just create a txn from Equity:Opening Balances
09:13:47 *** bentob0x has joined #gnucash
09:19:35 *** bradgers has joined #gnucash
09:20:44 <bradgers> remember my problem from yesterday? My xml file won't save to sqlite? I think it's a problem with the currency.
09:23:07 <warlord> The currency?
09:24:24 <bradgers> yeah. I seem to remember having problems at one point with none of my transactions being visible because the accounts were unable to figure out from my locale what the currency was
09:24:42 <bradgers> which happened when I upgraded my system, probably a debian thing
09:24:53 <warlord> Oh.
09:25:21 <bradgers> so I had to change all of my accounts to U.S. Dollars, and that, for some reason, brought them back.
09:26:06 <bradgers> but a bunch of the invisible accounts, like "Bond", "Stock", etc. don't have currencies attached anymore
09:27:11 <bradgers> for example:
09:27:16 <warlord> That seems like a BUG..
09:27:20 <bradgers> file that will save to sql:
09:27:31 <warlord> (note that Stock accounts should have a stock commodity)
09:27:40 <bradgers> <gnc:account version="2.0.0">
09:27:40 <bradgers> <act:name>Brokerage Account</act:name>
09:27:40 <bradgers> <act:id type="guid">ae6ed2bd9fac2caa2734e3f9af709f8d</act:id>
09:27:40 <bradgers> <act:type>BANK</act:type>
09:27:40 <bradgers> <act:commodity>
09:27:42 <bradgers> <cmdty:space>ISO4217</cmdty:space>
09:27:45 <bradgers> <cmdty:id>USD</cmdty:id>
09:27:48 <bradgers> </act:commodity>
09:27:50 <bradgers> <act:commodity-scu>100</act:commodity-scu>
09:27:53 <bradgers> <act:description>Brokerage Account</act:description>
09:27:55 <bradgers> <act:parent type="guid">559e5d42bad7d91c002e237e5b600212</act:parent>
09:27:57 <jsled> *cough* pastebin *cough* :)
09:27:58 <bradgers> </gnc:account>
09:28:03 <bradgers> sorry
09:28:37 <warlord> Well, that XML looks correct.
09:29:07 <bradgers> in the file that WON'T save to sql, there is no <act:commodity> section
09:29:21 <bradgers> and a line: <act:commodity-scu>0</act:commodity-scu>
09:29:35 <warlord> Ummmm.... That's bad.
09:30:32 <warlord> What version did you use to save that data file! Bad XML is a BAD BAD BUG and should be reported as a critical failure.
09:31:35 <bradgers> not sure, really, but I think it was 2.3.8
09:32:47 <warlord> You should definitely file a critical bug report and provide as MUCH information as you can about what changed on your system between the good file and the bad file.
09:33:08 <warlord> jsled: I'm wondering how hard/bad it would be to add a tag in the XML that says the version of gnucash used to write the file?
09:33:21 <jsled> or just a comment
09:33:38 <fosstux> warlord: thx
09:34:26 <warlord> sure, a comment would work, too. (that's a 'tag' in my mind in this situation)
09:35:54 *** fosstux has quit IRC
09:39:25 <bradgers> It may have been an older version, though, and I tried to upgrade it hopes that it would work
09:39:37 <bradgers> I was using 2.3.5 for a while.
09:41:35 <warlord> Well, note that 2.3.x are alpha releases and we state clearly that it could destroy your data..
09:41:44 <bradgers> I know
09:41:50 <warlord> Having said that, it would be nice to make sure it doesn't happen!
09:41:56 <bradgers> Hey, I'm not doing the yelling here.
09:42:05 <bradgers> (unless you count the paste)
09:42:14 <bradgers> (for which I apologized)
09:42:18 <warlord> jsled: How far in advance should I email about a 24-hour planned system outage?
09:42:35 <warlord> bradgers: I'm not yelling.. Am I?
09:42:39 <warlord> (I certainly hope not)
09:42:58 <bradgers> oh, just one exclamation point
09:43:04 <bradgers> no biggie.
09:43:15 <jsled> friendly exclamation. nothing more. :)
09:43:19 <warlord> LOL
09:43:23 <jsled> warlord: dunno. a week, maybe?
09:43:23 <bradgers> I'm not offended; I understand how much work you've put into this, and it's a great product
09:43:31 <bradgers> and I really don't want to piss you off, either
09:43:35 <warlord> Excited to hear about a data corruption bug.. ;)
09:43:39 <jsled> heh
09:43:47 <warlord> jsled: fair enough.
09:43:58 <warlord> (it's not going to happen until Feb)
09:45:56 <bradgers> the problem happened, I am almost certain, when I saved to sql, entered a few transactions, then tried to go back to xml
09:54:03 <bradgers> when you say as much information as I can, do you mean you want me to post the entire 1.5 mb diff file?
10:14:04 <warlord> Oh, you did this in 2.3.5??? ISTR known currency issues in that release. Can you reproduce the symtoms using 2.3.8?
10:16:48 *** warlord is now known as warlord-afk
10:30:24 *** machtfuernacht has joined #gnucash
10:37:03 *** warlord-afk is now known as warlord
10:37:17 <machtfuernacht> Hi warlord, if you haven't seen it yet, the build of aqbanking didn't work in the nightlies for windows.
10:37:48 *** fDavid has joined #gnucash
10:37:50 <warlord> I dont look at the daily builds. You might want to email the build failure log snippet to -devel
11:02:42 <bradgers> looking at bugzilla, I bet my problem is related to bug 605110
11:08:01 <warlord> It does indeed.
11:09:36 *** demitar has quit IRC
11:15:48 *** demitar has joined #gnucash
11:52:55 *** fDavid has quit IRC
11:55:01 *** fDavid has joined #gnucash
11:58:26 *** fDavid1 has joined #gnucash
12:00:41 *** machtfuernacht has quit IRC
12:05:30 *** fDavid has quit IRC
12:07:34 *** daedeloth has joined #gnucash
12:16:00 *** ska has joined #gnucash
12:17:14 <ska> I accidentally overpaid a vendor in GC. Should I simply change the value in the checking ledger?
12:17:50 <ska> And then apply the refund check (later on) to checking, and offset the appropriate account?
12:22:06 *** bob25801 has joined #gnucash
12:23:08 <bob25801> Could you elaborate on the "active" status vs "posted"?
12:23:21 <bob25801> *for invoices or bills
12:25:07 <bob25801> I can see that unposting will take it off of the customer report, but deselecting active while posted seems to do nothing
12:29:09 *** fom_hd67 has joined #gnucash
12:30:23 <fom_hd67> hi there ... may i disturb with a question?
12:30:28 <warlord> bob25801: active only applies to default searches.
12:30:40 <warlord> ska: Did you overpay in real life, too?
12:30:48 <warlord> fom_hd67: you just did.
12:31:21 <fom_hd67> warlord: that's true :-)
12:32:26 <fom_hd67> how can i have two installations of gnucash on a linux box? One stable, and one test installation.
12:32:44 <warlord> opt-style. put one into /opt/gnucash-stable and another into /opt/gnucash-testing
12:32:47 <warlord> (for example)
12:36:23 <bob25801> is it useful?
12:38:11 <fom_hd67> hmmm ... ok - I'll try if i can compile the unstable version without any other changes on my machine.
12:39:17 <fom_hd67> my linux-box is 99% rpm-based, only gnucash is build from sources
12:41:22 <fom_hd67> Thanks a lot!
12:42:12 *** fom_hd67 has quit IRC
12:49:28 <warlord> bob25801: what do you mean, is it useful?
12:49:34 <bob25801> sorry
12:49:45 <bob25801> what would you use it for in real life..
12:50:24 <bob25801> i search for a po, but don't know the vendor, so after I look at each one i uncheck the box active so i'll know when I get to the end the list is empty?
12:50:57 <bob25801> I'm trying to find the contect for using the thing..
12:51:04 <bob25801> context
12:53:32 <ska> warlord: yes I overpaid the vendor by $5
12:54:30 <warlord> The context is when you no longer want to have that invoice show up in default searches. e.g., the invoice is invalid, unused, or so old that you dont care to see it anymore.
12:54:35 <ska> My invoice was correct by my check was wrong.
12:55:02 <warlord> ska: then dont worry about it.. Right now you have a credit with the vendor. They should apply it to your next bill, and gnucash will do that too.
12:55:23 <warlord> Unless they mailed you a $5 check?
12:56:08 <ska> warlord: i just changed the checking though, so that my reconcile would work out. It seems to be ok. The vendor has already mailed me a check though.. I didn't ask for one.
12:56:50 <warlord> What do you mean "changed the checking"? What did you do?
12:57:08 <warlord> Did you manually change the amount of the Process Payment transaction?
12:57:18 <ska> warlord: I changed the payment amount of the check to them to reflect the actual amount (overpaid by $5).
12:58:05 <warlord> No, Dont Do That!!! NEVER EVER EVER manually change the amounts of any Biz Txn!
12:58:10 <warlord> Delete it and re-run Process Payment
12:58:34 <ska> I delete the trans in checking?
12:58:45 <ska> and re-run payment. ok.
12:59:56 <warlord> And make sure you put in the correct amount of the check that you sent.
13:04:46 <ska> Ok,, done.. I guess doing the wrong way unbalances the vendor's balance?
13:05:20 <ska> Do i need to somehow apply the refund check to the vendor?
13:08:22 <ska> warlord: I see the $5 credit in the Payable Aging for the vendor.. I think its obvious now what to do.
13:09:36 <warlord> When you get it, process it as a vendor bill to Assets:Refunds and then when you deposit it you can just make a regular txn from A:Refunds -> Checking
13:11:45 <ska> warlord: ok, so I make a new bill for it, and use A:Refunds.. Do I put in negative value anywhere?
13:12:04 <warlord> No.
13:12:31 <warlord> The $5 refund is the same as you getting $5 in service.
13:12:40 <warlord> It's just that instead of an Expense, it's an Asset.
13:13:23 <ska> ok.. i think i got it.. Is this covered in the faq?
13:16:16 <warlord> I dont know... It's pretty straightforward "accounting 101"
13:23:17 <ska> warlord: when I deposit it, I just use the checking ledger, and not the Pay Invoice module.? This is somewhat confusing to me.
13:23:37 <warlord> You've pre-paid the invoice.
13:23:53 <ska> ok... I'll try it first..
13:26:05 <ska> Ok,, I see .. Thanks again...
13:37:02 <warlord> You're welcome
13:39:49 <bradgers> warlord: invoices are supposed to have currencies assigned too, right?
13:40:00 <warlord> bradgers: Absolutely!
13:40:07 <bradgers> found the problem, then
13:40:17 <bradgers> I think
13:40:50 <bradgers> somehow I got an xml file that didn't assign a currency to my invoices
13:42:08 <warlord> Ummmmm... That shouldn't ever happen!
13:42:40 <bradgers> like I said before, I don't know if it was 2.3.5, 2.3.8, or when, though
13:43:33 <bradgers> the neato "check and repair" item in the actions menu fixed transactions and entries, but not invoices
13:43:35 <warlord> Well, if you have a valid file re-try with 2.3.8 ;)
13:43:39 <bradgers> as near as I can tell.
13:43:45 <warlord> Right, it doesn't know about invoices.
13:44:21 <bradgers> well, a sed script shouldn't be too hard to whip up.
13:46:53 <warlord> Well, we should really track down the problem in the first place.
13:47:00 <warlord> But yeah, a sed script could fix it.
13:48:29 <bradgers> I'm checking the changelog now
13:48:37 <bradgers> don't worry, I won't abandon you
13:51:08 <warlord> Thanks!!!!!!!!!!
13:58:41 <bradgers> oh, and Ballard's xml file in the bug I mentioned above has the same problem
13:59:18 <bradgers> so it happened to him at least as far back as 2.3.3 -- disconcerting.
14:05:27 <warlord> Well, 2.3.3 ARE test releases...
14:05:49 <bradgers> true, true
14:10:42 <bradgers> I'm gonna go back to svn; the open file dialog is so much nicer.
14:15:06 <warlord> :)
14:15:15 <warlord> Note that svn head is what will be 2.3.9
14:44:05 <bradgers> tried reproducing, no go. Could spend hours on it, though.
14:44:25 <warlord> Well, if you cannot reproduce it with svn head that's a good thing!
14:58:10 *** fDavid1 has quit IRC
16:20:14 *** twunder has joined #gnucash
16:46:19 *** daedeloth has quit IRC
16:53:15 *** daedeloth has joined #gnucash
17:04:37 *** warlord is now known as warlord-afk
17:12:45 *** twunder has quit IRC
17:34:30 *** demitar has quit IRC
17:57:58 *** bradgers has quit IRC
18:03:07 *** Zoolooc_ has joined #gnucash
18:30:23 *** daedeloth has quit IRC
19:46:03 *** twunder has joined #gnucash
19:54:50 *** twunder has quit IRC
20:42:49 *** Zoolooc_ has quit IRC
22:33:34 *** osmosis has joined #gnucash
22:47:17 *** bentob0x has quit IRC