2010-03-02 GnuCash IRC logs

00:19:56 *** trucklover has quit IRC
01:54:06 *** shivam_finkler has joined #gnucash
01:54:51 *** ErKa has joined #gnucash
01:56:21 <shivam_finkler> does gnucash support Indian tax structure?
02:09:21 *** Zoolooc__ has quit IRC
02:19:20 *** jean has joined #gnucash
02:28:56 *** e-ndy has joined #gnucash
02:45:45 *** bentob0x has joined #gnucash
02:47:20 *** jpetersen has joined #gnucash
02:51:06 *** ed` has left #gnucash
02:54:55 *** Gokee2 has quit IRC
03:15:29 *** shivam_finkler has quit IRC
03:35:05 <harlan> what's the timeline for the 2.4 release (or where can I find it)?
03:35:51 <harlan> And I recall folks telling me that the current gnucash code gets slower as the number of transactions in the db increase - will the new SQL stuff "solve" that problem?
05:44:00 *** jean has quit IRC
06:38:17 *** up_the_irons has joined #gnucash
06:39:36 <up_the_irons> does GNUCash support the <INVOICE> OFX tag? If so, does anyone use it as a workaround to there being no memorized invoice feature? (such as, just import the same .ofx each month and the invoices would be generated)
07:12:06 *** fDavid has joined #gnucash
07:14:48 *** bentob0x has quit IRC
07:38:36 *** fDavid has quit IRC
07:39:56 *** warlord-afk is now known as warlord
07:40:11 *** fDavid has joined #gnucash
07:40:15 <warlord> harlan: we're nearing 2.4.0, but still trying to work out some kinks. And no, the SQL code wont fix that issue.
07:40:24 <warlord> up_the_irons: no, it does not
07:53:27 *** Jimraehl has left #gnucash
08:09:29 *** Jimraehl has joined #gnucash
08:49:35 *** localhost has quit IRC
09:02:14 *** e-ndy has quit IRC
09:12:29 *** localhost has joined #gnucash
09:17:02 *** ben has joined #gnucash
09:17:27 <ben> Hi / Bonjour
09:17:29 *** daedeloth has joined #gnucash
09:21:56 <warlord> good morning
09:24:05 *** localhost has quit IRC
09:43:33 *** ben has quit IRC
09:44:48 *** thoth has joined #gnucash
09:45:22 <thoth> I would like a second Accounts window that shows a specific list of accounts and hides the vast majority. Is that possible?
09:46:13 <warlord> I think so...
09:46:29 <warlord> Open a new Account Tree.
09:46:37 <thoth> done that.
09:47:07 <warlord> Then you should be able to have different sets of accounts expanded in the different windows.
09:47:21 <warlord> (I guess it depends on your definition of "show" and "hide"
09:47:23 <warlord> )
09:47:44 <thoth> yeah, some of the ones I want shown are buried in a list of 7 or 20 other accounts.
09:48:13 <warlord> There's no way to show an account w/o its peers and parents
09:49:03 <thoth> OK. I was just remembering how some of the bar charts let you pick and choose which accounts the data will come from.
09:49:51 <warlord> Unfortunately not the CoA.
09:53:58 *** localhost has joined #gnucash
09:54:35 *** fDavid has quit IRC
10:06:46 *** localhost has quit IRC
10:16:12 *** localhost has joined #gnucash
10:19:09 <thoth> Hmm, if you activate the "hide accounts with zero balance" option (which I can't remember where it is) then you can't see container accounts with zero balance, even if they are the parent of accounts with non-zero balance.
10:19:29 <warlord> Interesting!
10:19:45 <thoth> I'm running 2.2.9
10:28:51 <warlord> I dont think that's changed since.
10:52:30 *** blizgerg has quit IRC
11:06:20 *** jpetersen has quit IRC
11:41:10 *** ErKa has quit IRC
12:08:22 <thoth> My main complaint with gnucash is that I find it impossible to remember exactly where each of my investment funds lives within the tree. When I need to make an entry for RVS Dividend Opportunity I have to check 6 different places. If I could create an account tree which only has the accounts that get modified every month (as opposed to the 40 which have been closed out, or don't change until I sell) then I'd be faster.
12:09:58 *** ErKa has joined #gnucash
12:15:50 <warlord> You can easily hide the ones that you've closed out..
12:16:02 <warlord> Just mark it "hidden"
12:16:25 <thoth> *facepalm*
12:16:45 <thoth> Go stand in the corner until I stop being embarrassed.
12:19:56 *** jpetersen has joined #gnucash
12:35:49 <warlord> heh.
12:37:43 *** bentob0x has joined #gnucash
12:38:43 *** Zoolooc has joined #gnucash
12:40:34 *** jean has joined #gnucash
12:56:38 *** andyt has joined #gnucash
13:26:42 *** matt has joined #gnucash
13:27:29 <matt> What's the deal with the Windows 2.29 version not able to parse an xml file after saving?
13:28:12 <warlord> There is no version 2.29. We've not even released a 2.4 yet!
13:29:48 <warlord> But assuming you mean 2.2.9 -- what's the error? And where did you save the data file?
13:29:50 <matt> 2.2.29
13:29:56 <warlord> There's no 2.2.29 either
13:30:00 <warlord> Latest is 2.2.9
13:30:05 <matt> closest guess
13:30:24 <matt> I have no problem running, saving, and opening in ubuntu...
13:30:56 <matt> Started a fresh chart of accounts for 2010 in the windows version, spent hours on it, after saving can't open the file "unable to parse"
13:31:17 <matt> I was able to bzip/extract the xac file into an eml viewer just now, but don't know what I'm doing
13:31:42 <matt> I'm controller for an XML-based software company too!
13:32:23 <warlord> what's the exact error you get, and where did you save the data file?
13:32:33 <matt> Can also open gnucash files saved in linux environment in windows, but after saving from windows, can't open on any platform
13:33:20 <matt> There was an error parsing the file D:\Matt-Personal\GNUCASH\nelson2010.
13:33:28 <matt> no extension
13:33:49 <matt> is windows missing some library for xml?
13:34:40 <matt> ..all because I'm too lazy to dual boot...ugh
13:35:47 <warlord> What happens if you take the data file from windows to linux and try to gunzip it?
13:36:00 <warlord> No, windows isn't missing any libraries.
13:36:14 <matt> is this a problem (in the xac file): <gnc:book version="2.0.0">
13:36:31 <warlord> But there may be bugs in the compression hooks on windows.. I've seen issues where it damaged the file.
13:36:51 <warlord> That looks like a valid tag. why would it be a problem?
13:37:49 <matt> maybe it needed to be version specific
13:37:51 <matt> like a sql db
13:37:53 <matt> ?
13:38:17 <warlord> Nope.
13:38:22 <matt> I haven't been able to open the windows file in linux
13:38:31 <matt> same error
13:39:05 <matt> I thought parsing errors had to do with data corruption, like HDD sectors, but if I can blame Bill Gates...
13:40:26 <matt> even though 7zip successfully decompresses the xac file to a readable xml format, I can't load this file in gnucash either
13:47:22 <warlord> compare it to the xac backup?
13:49:45 <matt> hmm..executive decision...just going to clear some partition space for ubuntu on this win laptop
13:50:05 <matt> leave it to mystery...thanks very much though...I love gnucash!
13:50:12 *** matt has quit IRC
14:11:40 *** bentob0x has quit IRC
14:42:43 *** Gokee2 has joined #gnucash
15:53:34 <up_the_irons> warlord: roger on no invoice ofx tag
15:56:58 *** raleightile has joined #gnucash
15:59:35 <raleightile> I have a customer that over-paid, when I issued the refund via check it selected accounts receivable like before, but I reversed it from a deposit to withdrawal. The customer still shows a negative balance.. What is the best way to correct this?
16:01:07 <warlord> Ummm.. You need to delete that transaction and issue an Invoice for the refund amount.
16:01:36 <raleightile> ok, i thought about that, but now my sales are inflated..
16:01:51 <raleightile> (its only 70 bucks, but still..)
16:02:16 <warlord> Yep.. But in the updated Invoice you can just use something like "Income:Overpaid Refund"
16:02:21 <warlord> (instead of Income:Sales)
16:03:10 <raleightile> Then just exclude that from the sales reports for sales tax, like non taxable sales
16:03:54 <warlord> Yeah
16:06:38 *** fDavid has joined #gnucash
16:11:45 *** fDavid has quit IRC
16:11:58 <raleightile> Will it mess up my profit/loss reports?
16:12:59 <raleightile> what if i made a fake payment for the same amount and then reversed the two columns?
16:14:26 *** thoth has left #gnucash
16:32:45 *** cstim has joined #gnucash
16:33:55 <cstim> Is plongstaff around, and what nick does he use?
16:35:11 <jsled> plongstaff, IIRC, but he's not often around.
16:35:13 * jsled checks local logs
16:35:21 <cstim> ok, thanks
16:36:07 <cstim> Are people currently working on SVN code, so that I shouldn't commit re-indentations in specific directories right now?
16:36:28 <jsled> I actually don't see any evidence he's been around here.
16:36:41 <jsled> oh, wait, no.
16:36:46 <jsled> @seen phil
16:36:46 <gncbot> jsled: phil was last seen in #gnucash 33 weeks, 2 days, 22 hours, 52 minutes, and 48 seconds ago: <phil> :q
16:37:02 <jsled> 33 weeks.
16:37:03 <jsled> wow.
16:37:13 *** jpetersen has quit IRC
16:37:24 <cstim> @seen cstim
16:37:24 <gncbot> cstim: cstim was last seen in #gnucash 1 minute and 17 seconds ago: <cstim> Are people currently working on SVN code, so that I shouldn't commit re-indentations in specific directories right now?
16:38:15 <cstim> ok. It's late over here anyway, so I better get some sleep
16:38:39 *** cstim has quit IRC
16:40:54 <warlord> raleightile: if you change the amount in a biz txn it'll just screw up all the numbers and your biz reports will never work.
16:43:54 <raleightile> ok, i was afraid of that, but it will still make my profit/loss report incorrect, because the income:refund should be reversed?
16:44:47 <raleightile> So what if I write up the invoice to apply the payment, then use the credit memo procedure to undo and issue a "refund" of the sale that never happened?
16:45:21 <warlord> there is no "credit memo procedure"
16:45:31 <warlord> Do you expect this customer to ever request more work from you?
16:45:44 <raleightile> yes, but not this year
16:46:21 <raleightile> I thought you told me how to make credit memos.. maybe it was j?
16:48:39 <raleightile> http://www.fpaste.org/ZyL1/
16:51:56 <warlord> Wasn't me.
16:53:48 <raleightile> will it wreck everything?
16:54:12 <raleightile> i think I do this about 2 times a week..
16:54:42 *** jean has quit IRC
16:57:28 <warlord> customers overpay you that much??
16:57:53 <warlord> It's perfectly acceptable to change the non-A/R endpoint of a payment transaction.
16:58:01 <warlord> Just don't touch the A/R Split
17:02:41 <harlan> hey warlord
17:02:49 <harlan> thanks for the update.
17:02:58 <warlord> you're welcome
17:03:37 <harlan> What's the underlying problem with speed as one uses gnucash for Years? is it just an O(n) problem with the way the beast was designed?
17:07:04 <raleightile> :)
17:07:10 <raleightile> customers over buy
17:08:18 <harlan> bbl
17:08:41 <raleightile> they usually bring back something... maybe a bag of grout or a threshold or something, today a white toothbrush holder, it's always random..
17:10:51 <warlord> Ahh, point-of-sale returns..
17:11:03 <warlord> I'm not sure that using invoices is the right thing for that.
17:11:24 <warlord> harlan: Well, the underlying accesses are O(n), but some other algorithms could be worse than that.
17:18:48 <raleightile> if I can improve anything I am willing to change, but I don't really know what changes to make
17:28:21 <warlord> raleightile: I'd just use regular transactions. Your customers are paying you on the spot, right?
17:29:51 <raleightile> yes
17:30:52 <raleightile> I have to give a receipt, and be able to reprint later when the order arrives
17:32:35 <warlord> I'm not sure GnuCash is the right solution.
17:33:00 <warlord> it sounds like you want a PoS solution (gnucash is an accounting program)
17:35:02 <raleightile> I have put every transaction for the last 6 months through gnucash, and I understand what you are saying
17:35:47 <warlord> okay...
17:39:10 <raleightile> we used quickbooks from the dos version until last year.. I started trying to keep using quickbooks for sales and then using gnucash to track banking ect, but it was too much work, way to much! so I cut out quickbooks and now balancing my accounts is faster and more accurate
17:39:18 *** daedeloth has quit IRC
17:39:42 <warlord> Well, except for the receipts thing you might be better off ignoring the biz features.
17:40:34 <raleightile> you think they cause more problems then they fix?
17:40:52 <raleightile> did you see my receipt?
17:40:55 <warlord> In your case, probably.
17:42:14 <raleightile> I wish there was a way to import more into gnucash, then I would be open to using more than one program
17:43:21 <warlord> No biz import at all.
17:44:48 <raleightile> could you import income:sales, liabilities:sales tax, and assets:undeposited funds ?
17:45:05 <warlord> Of course! QIF would do that just fine.
17:45:43 <raleightile> so the only difference would be no accounts receivable?
17:46:06 <warlord> and no "invoices" or "payment"... But in your case it sounds like you do invoice/process payment immediately, right?
17:46:30 <raleightile> not always, but mostly
17:47:41 <raleightile> some jobs are 1/2 down, rest on completion, stock materials are 30 days, special orders are paid before ordering
17:47:59 <warlord> Hmmm
17:48:17 <raleightile> I think it would be better to hang out with gnucash for a while
17:48:25 <raleightile> maybe i can help make it better
17:49:03 <raleightile> but i have wondered if a seperate program could be implemented to compliment gnucash
17:49:45 <raleightile> 6 days a week for 6 months and my only complaint is refunds... not bad really
17:50:21 <raleightile> well maybe a spell checker would be good too
17:50:53 *** ErKa has quit IRC
17:51:26 <warlord> hey, thank you! Says a lot that I got that much right! :)
17:53:29 <raleightile> I'm glad you did whats done so far, I have spent time on never ending projects that never make it to production, so no motivation for me to blaze a trail on a new program.. Stick with the team and push for the best
17:58:33 <warlord> :)
18:00:00 *** fDavid has joined #gnucash
18:11:45 *** fDavid has quit IRC
18:17:35 *** andyt has quit IRC
18:36:01 *** raleightile has quit IRC
18:49:03 *** Gokee2 has quit IRC
18:49:03 *** Zoolooc has quit IRC
18:49:03 *** localhost has quit IRC
18:49:03 *** up_the_irons has quit IRC
18:49:03 *** pvizeli_ has quit IRC
18:49:03 *** vbatts has quit IRC
18:49:03 *** Gokee2 has joined #gnucash
18:49:03 *** Zoolooc has joined #gnucash
18:49:03 *** localhost has joined #gnucash
18:49:03 *** up_the_irons has joined #gnucash
18:49:03 *** pvizeli_ has joined #gnucash
18:49:03 *** vbatts has joined #gnucash
18:49:17 *** pvizeli_ has quit IRC
18:49:17 *** up_the_irons has quit IRC
18:49:17 *** Zoolooc has quit IRC
18:49:17 *** Gokee2 has quit IRC
18:49:17 *** localhost has quit IRC
18:49:20 *** vbatts has joined #gnucash
18:49:20 *** pvizeli_ has joined #gnucash
18:49:20 *** up_the_irons has joined #gnucash
18:49:20 *** localhost has joined #gnucash
18:49:20 *** Zoolooc has joined #gnucash
18:49:20 *** Gokee2 has joined #gnucash
18:57:49 *** mib_zchvsl has joined #gnucash
19:00:22 *** mib_zchvsl has quit IRC
20:06:15 *** fDavid has joined #gnucash
20:11:40 *** Zoolooc has quit IRC
21:11:35 *** Jimraehl has quit IRC
21:11:56 *** Jimraehl has joined #gnucash
21:19:25 *** fDavid has quit IRC
21:20:22 *** fDavid has joined #gnucash
21:49:40 *** fDavid has quit IRC
22:04:16 *** blizgerg has joined #gnucash
22:09:17 <shade304> warlord: what about an invoice with a line Liabilities:Labor to record money received to pay a subcontractor
22:10:16 <shade304> also Liabilities:Deposit for overpayments?
22:12:39 <warlord> invoices wont accept Liability accts
22:13:40 <shade304> it looked like it did, but that may be bad..
22:13:47 <shade304> should i delete it?
22:16:21 <shade304> I'm using 2.2.9
22:17:08 <warlord> Dunno.. Sorry. But gotta go.
22:17:10 *** warlord is now known as warlord-afk
22:17:21 <shade304> k
22:29:33 *** localhost has quit IRC
22:46:26 *** localhost has joined #gnucash