2007-03-05 GnuCash IRC logs

00:05:21 *** egsavage has quit IRC
00:06:14 *** twunder has joined #gnucash
00:17:13 *** jpeach has joined #gnucash
00:18:32 *** jpeach has left #gnucash
00:58:53 *** jpeach has joined #gnucash
01:02:05 *** jpeach has left #gnucash
01:25:30 *** imperito has joined #gnucash
02:03:41 *** twunder has quit IRC
03:14:29 *** ErKa has joined #gnucash
03:26:28 *** |gunni| has joined #gnucash
03:35:20 *** _gunni_ has quit IRC
04:43:20 *** motin has quit IRC
05:04:34 *** Hank has joined #gnucash
05:05:31 <Hank> Hello, I have problems with the change from TAN to iTAN on my german sparkasse account.
05:05:48 <Hank> the setting in the bank is done. the new TAN-List is active.
05:06:21 <Hank> But for some reason there is no way to place an order in the bank now.
05:06:54 <Hank> Call for transactions and for the amount of money is working fine.
05:08:24 <Hank> I'm using the aqbankgin assistant from within gnucash to move from TAN to iTAN mode.
05:09:17 <Hank> using (sorry but miy gnucash is in german, so I'm not sure about the correct english labes) the tab 'User'
05:09:42 <Hank> there is one entry, I choose 'edit'
05:10:07 <Hank> than I use the tab 'HBCI' and in this mask the button 'Get iTAN Modes'
05:10:36 <Hank> the connection to the bank starts, I have to enter the PIN
05:11:45 <Hank> and now I'm getting (among others) 'HBCI: 3050 - UPD nicht mehr aktuell, aktuelle Version enthalten. (S)' and
05:12:15 <Hank> 'HBCI: 3050 - BPD nicht mehr aktuell, aktuelle Version enthalten. (S)'
05:12:59 <Hank> and 'HBCI: 3920 - Auftr?ge werden nur gem?? Zwei-Schritt-Verfahren (ITAN) angenommen. (S)'
05:13:15 <Hank> then I choose 'close'
05:14:20 <Hank> and after that I choose 'OK' (in the window with the HBCI-Tab), I choose 'OK' in the window with the 'User'-Tab
05:14:35 <Hank> And now there is an error-message poping up:
05:17:07 <Hank> freely translated: The external programm returned an error code which means that the setting did not succed sucesfully. the further HBCI Setting can only proceed if the assitent succeds with success. Please try again to run the assistent correct.
05:17:11 <Hank> But how?
05:17:18 <Hank> any ideas? Thanks.
05:26:52 <Hank> I'm using gwenhywfar: 2.4.0.0 and aqhbci: 2.2.1.0-stable on a amd-64 gentoo-box
06:43:49 *** IanL has joined #gnucash
06:49:19 *** ceplma has joined #gnucash
07:36:42 *** conrad has quit IRC
07:40:25 *** ceplma has quit IRC
07:50:43 *** conrad has joined #gnucash
07:52:05 *** warlord-afk is now known as warlord
07:52:18 <warlord> Hank: I'm afraid you might need to ask this on the gnucash-de mailing list.
08:08:23 *** minDscrm has quit IRC
08:31:08 *** minDscrm has joined #gnucash
08:57:28 *** twunder has joined #gnucash
09:04:25 *** ceplma has joined #gnucash
09:10:52 *** dsch04 has joined #gnucash
09:12:02 <dsch04> Hi all, I'm just starting to use gnucash to manage my business.
09:12:16 <dsch04> I guess I'm looking for a bit of help getting started.
09:12:55 <dsch04> I'm in the UK, but do technical consultancy and system admin for clients in the USA
09:13:18 <dsch04> Initially, I was paid in USD, but now some of my clients pay me in UKP
09:14:20 <dsch04> RIght now, I've managed to enter invoices but I'm not sure how to process payments, making sure they're in the right currency and the appropriate fees are applied
09:15:03 <dsch04> Can anyone help?
09:24:33 <dsch04> The other complication is that I receive payment via Paypal, so there are paypal fees to include in the calculations.
09:24:43 *** warlord has quit IRC
09:25:10 <dsch04> Do I need to setup a separate Paypal account in gnucash into which to receive payments?
09:33:11 <cortana> dsch04: there were some tutorials for doing multi-currency accounting posted to the mailing list a few days ago
09:33:33 <cortana> http://www.mathstat.dal.ca/~selinger/accounting/
09:34:44 <cortana> dsch04: for the paypal stuff, i have an Asset account for the paypal accounts; then withdrawing money is a split transaction that takes money out of the paypal account, and transfers it to my current account & a "paypal fees" Expense account
10:00:26 *** hampton sets mode: +oo benoitg conrad
10:04:01 *** hardcorelamer has joined #gnucash
10:04:19 *** warlord has joined #gnucash
10:04:19 *** gncbot sets mode: +o warlord
10:05:02 <hardcorelamer> so, my accounts file is missing some invoices that I made last year... i have the .log files and it shows the proper IDs, is there anything to do to replay the logs?
10:05:17 <hardcorelamer> is there anyway to reconcile the current file against the logs and figure out exactly what is missing?
10:05:18 <warlord> dsch04: not sure if this was answered, but you need to use two sets of accounts.. You'll need two A/R accounts, and two sets of Income accounts, and two "bank" accounts.
10:05:37 <warlord> hardcorelamer: log replay doesn't affect business features.
10:06:05 <hardcorelamer> what does that mean? business features?
10:06:56 <hardcorelamer> like, records disappeared
10:07:22 <warlord> I disbelieve that records disappeared.
10:07:39 <hardcorelamer> so, you think i deleted some invoices?
10:07:41 <warlord> ... unless your disk filled up and the file got truncated.
10:07:45 <hardcorelamer> i didn't think i could do that
10:07:47 <warlord> No, because you CANT delete invoices.
10:08:10 <hardcorelamer> exactly
10:08:18 <jsled> warlord: are the business objects even in the logs? If not, how can the proper ids be in there?
10:08:21 <hardcorelamer> so, replaying a log file should bring them back, right?
10:08:39 <warlord> hardcorelamer: no, because the business features aren't in the logs.
10:08:54 <warlord> jsled: no, they are not.. But the created transaction should be.
10:09:10 <jsled> warlord: ah, right.
10:09:22 <warlord> I think replaying the log of an invoice-generated transaction may corrupt the system.
10:09:25 <hardcorelamer> okay, i really don't understand what you're saying, is it possible for me to get my accounts file back to where it was on december 29th ?
10:09:33 <hardcorelamer> or is that not possible?
10:09:44 <jsled> hardcorelamer: business features = jobs, customers, invoices, ...
10:09:48 <warlord> hardcorelamer: Well, what exactly appears to be missing?
10:09:55 <warlord> You said invoices, and I just dont believe you.
10:10:03 <hardcorelamer> invoices
10:10:13 <warlord> there's no way to delete an invoice, so any corruption must've come from outside gnucash.
10:10:19 <warlord> did your disk fill?
10:10:19 <hardcorelamer> and some accounts receivable records
10:10:35 <hardcorelamer> it's possible
10:10:43 <hardcorelamer> but i dont think while gnucash was running
10:11:06 <hardcorelamer> i'm looking right at invoice 30 in my 20061229 .log file
10:11:22 <warlord> hardcorelamer: that's the posted transaction.
10:11:29 <warlord> Did you, maybe, UNPOST it?
10:12:06 *** twunder has quit IRC
10:12:26 <hardcorelamer> no, i've filterd on posted, unposted, paid, unpaid, company name and invoice number in the invoice search field
10:12:38 <hardcorelamer> it's also just dissappeared from my accounts recievable line
10:12:44 <hardcorelamer> and my customer reports
10:12:59 <hardcorelamer> wait a minute
10:13:02 <hardcorelamer> i think i know
10:13:24 <hardcorelamer> let's say... somehow... the main accounts file got rsynced over by an older version...
10:13:34 <hardcorelamer> opps
10:14:03 <hardcorelamer> could i "replay" the logs then? or should i just comb through them manually?
10:14:09 <hardcorelamer> and try to recreate things?
10:14:13 <warlord> No.. You should revert to a backup.
10:14:20 <hardcorelamer> this is the backup
10:14:31 <hardcorelamer> i think rsync went the wrong way last time
10:14:32 <warlord> See those <foo>.YYYYMMDDHHMMSS.xac files?
10:14:36 <hardcorelamer> it would make sense
10:14:44 <hardcorelamer> yeah xac files
10:15:49 <warlord> Check the most recent .xac backup file for your data, and if it has your data then you can just copy it over your main data file..
10:16:03 <warlord> Replaying the log doesn't help you with invoices, etc.
10:16:04 <hardcorelamer> oh awesome
10:16:07 <warlord> invoices aren't in the logs.
10:16:08 <hardcorelamer> okay
10:16:09 <hardcorelamer> phew
10:16:25 <hardcorelamer> but i can manually read the logs to use my brain to figure out what's missing, right?
10:16:39 *** CSWookie has left #gnucash
10:17:07 <hardcorelamer> so, do i have to gzip those .xac files? my main accounts file is gzipped
10:17:24 <jsled> `file $xac_file` should tell you
10:18:21 *** IanL has quit IRC
10:20:47 <warlord> hardcorelamer: yeah, you should be able to read the logs and see what happened.
10:22:00 *** twunder has joined #gnucash
10:23:16 <hardcorelamer> phew... gotta go take a walk now, that was a close one
10:26:20 <warlord> Yay backups!
10:29:09 *** twunder has quit IRC
10:29:54 *** twunder has joined #gnucash
10:39:11 <hardcorelamer> thanks
10:39:46 <warlord> hardcorelamer: you're welcome.
10:49:17 <dsch04> cortana: Thanks, I'll check those out
10:50:28 <dsch04> cortana: Where do you handle the currency conversion?
10:50:50 <dsch04> warlord: Thanks.
10:51:13 <dsch04> Ultimately, all the money ends up in my UKP current account.
10:51:25 <dsch04> So, I guess I only need "one" bank account?
10:51:27 <warlord> dsch04: well, at some point your need to handle the exchange rate.
10:51:36 <dsch04> How do I ... yeah, I was just going to as kthat
10:52:10 <dsch04> It currently gets done by Paypal, i.e. I get paid in USD and extract money in GBP
10:52:13 <warlord> dsch04: technically, but you'll either need to use Process Payment in the invoice currency into an asset account of the same currency and then later transfer that amount..
10:52:35 <dsch04> That's what I was thinking.
10:52:39 <warlord> Oh, in that case I would make Paypal a USD account..
10:52:55 <dsch04> And I also get paid in UKP :)
10:53:02 <dsch04> So, two Paypal accounts.
10:53:13 <warlord> your second option is to use Process Payment in the invoice currency and then go in manually and adjust the exchange rate.
10:53:43 <dsch04> I think I'd prefer to mirror the "actuality", i.e. money -> paypal -> bank account
10:54:38 <warlord> Okay.
10:56:06 <dsch04> OK, I'll give it a go and see how I get on.
10:56:26 <dsch04> Are there any tutorials describing general gnucash usage?
10:56:47 <jsled> Like the Tutorial and Concepts Guide? :)
10:57:04 <dsch04> i.e. covering the life-cycle of creating invoices, receiving payment (including partial payments), and transferring monies to external accounts?
10:57:11 <dsch04> jsled: That sounds like the sort of thing... :)
10:57:19 <dsch04> IS that on the web site?
10:57:52 <jsled> And in the help menu.
10:58:15 <jsled> I don't know that it covers multi-currency accounting very well.
10:58:20 <dsch04> Aha, I'd better start reading then...
10:58:39 <dsch04> No, I guess I'll have to bolt that on somehow.
10:58:48 <jsled> what distro?
10:58:52 <dsch04> FC6
10:59:03 <jsled> it might be a in separate 'gnucash-docs' package.
10:59:19 <dsch04> Possibly - it's installed, wherever it is.
10:59:28 * dsch04 reading it now
11:10:29 <cortana> dsch04: the document i linked to, is the theory... at the end there is a lnk to another document which is the practice
11:15:14 <dsch04> Thanks - lots of reading to do!
11:16:23 <warlord> indeed. there's lots of docs.
11:17:18 *** ErKa has quit IRC
11:24:30 *** backblue has joined #gnucash
11:24:33 <backblue> hi.
11:25:44 <jsled> hello
11:27:04 <dsch04> Quick question: how do I import customers?
11:27:28 <dsch04> I exported them using Business|export|QSF Customer
11:27:39 <dsch04> How can I import them into a new accounts file?
11:28:45 <jsled> I'm pretty sure there's no way to do so.
11:28:50 <jsled> Either via the QSF format or otherwise./
11:34:25 <dsch04> Damn
11:34:36 <dsch04> I exported them so I wouldn't have to enter the customers again
11:35:03 <dsch04> (I'm currently experimenting until I know what I'm doing.)
11:35:28 <dsch04> So the next obvious question is:
11:35:43 <dsch04> Is it possible to transfer customers between account files?
11:39:49 <jsled> Like, copy/pasting the XML blocks between the datafiles?
11:45:48 <warlord> dsch04: There MAY be an import->QSF.. Unless that's still disabled.
11:45:54 <warlord> It wasn't ever quite working well.
11:46:23 <dsch04> jsled - copying and pasting may work.
11:46:40 <jsled> dsch04: well, it's not at all supported, and might not be a good idea.
11:46:45 <dsch04> Which files?
11:48:55 <jsled> ah, see, that'd be support. ;) (your datafiles, presumably.)
11:49:27 <jsled> dsch04: I'm not sure. It might work. I'd imagine the customers are pretty context-free. But I don't recommend it.
12:03:13 <elb> the questino is, are they regular?
12:03:15 <elb> HAH
12:03:59 <elb> I'm sure you were talking about a customer data structure, but I just couldn't pass up the "context free"/"regular" versus "regular customer"
12:05:25 <jsled> *rimshot*
12:05:48 <jsled> Thank you, thank you! We'll be here all week, enjoy the buffet, and tip your waitresses!
12:43:41 *** ceplma has quit IRC
13:35:07 *** MrN has joined #gnucash
13:35:36 <MrN> hi
13:41:15 *** jpeach has joined #gnucash
13:41:20 *** jpeach has left #gnucash
14:24:39 *** backblue has quit IRC
14:31:00 *** hardcorelamer has quit IRC
14:46:46 <Hank> warlord, thanks, I send an eMail to the list already. So I can leave here now. byby
14:47:08 *** sjc has joined #gnucash
14:47:15 <warlord> Hank: ok
14:47:18 <warlord> good luck
14:47:53 <Hank> hopefully, otherwise I have to turn back to paper order and paper banking, who want's this any longer?
14:48:53 *** Hank has quit IRC
15:33:47 *** _gunni_ has joined #gnucash
15:41:01 *** sjc_ has joined #gnucash
15:41:25 *** cortana has quit IRC
15:42:24 *** |gunni| has quit IRC
15:45:40 *** sjc has quit IRC
15:56:03 *** bonez39 has joined #gnucash
15:57:29 *** ErKa has joined #gnucash
16:06:48 *** benoitg has quit IRC
16:07:04 *** benoitg has joined #gnucash
16:34:11 *** egsavage has joined #gnucash
16:51:45 *** ErKa has quit IRC
17:02:13 *** twunder has quit IRC
18:39:02 *** sjc__ has joined #gnucash
18:47:23 *** sjc_ has quit IRC
19:07:23 *** aphexer has joined #gnucash
19:07:54 <aphexer> Could anyone verify that when you change a customer's address, and then quit gnucash it does not ask to save?
19:08:30 <aphexer> (if only editing the address... in my case the lines 3 and 4 of the space available for the customer's address
19:11:11 <warlord> aphexer: what version of gnucash?
19:11:26 <aphexer> 2.0.1
19:12:06 <warlord> Huh, interesting! I can reproduce that in 2.0.5.
19:12:12 <warlord> Can you file a bug report, please?
19:18:07 *** twunder has joined #gnucash
19:22:22 *** jpeach has joined #gnucash
19:25:11 <aphexer> sure
19:28:20 *** jpeach has left #gnucash
19:29:04 <aphexer> warlord, http://bugzilla.gnome.org/show_bug.cgi?id=415127 :)
19:33:06 *** MrN has quit IRC
19:36:05 <aphexer> thanks for the help, gotta go now :)
19:36:06 *** aphexer has quit IRC
19:37:06 <twunder> hmm, I cancelled an SX last night, but gnucash didn't re-set the last transaction date in the template transaction, it seems
19:45:33 *** benoitg has left #gnucash
19:49:18 *** cortana has joined #gnucash
20:23:02 *** _gunni_ has quit IRC
20:33:02 *** foo has quit IRC
21:16:59 *** jpeach has joined #gnucash
21:17:16 *** jpeach has left #gnucash
21:23:57 *** sjc__ has quit IRC
21:24:51 *** Wilddev has joined #gnucash
21:24:51 *** gncbot sets mode: +o Wilddev
21:32:10 <warlord> hiiya Wilddev
21:33:21 <Wilddev> hey warlord
21:33:41 <warlord> How are you?
21:34:07 <Wilddev> doing good thx, keeping pretty busy
21:34:12 <Wilddev> how about you?
21:35:57 <warlord> Very busy
21:45:59 *** twunder has quit IRC
22:00:10 <warlord> too much to do, not enough time to do it.
22:00:41 <Wilddev> yep, know the feeling
22:00:50 <Wilddev> I've been working weekends to catch up lol
22:02:11 <warlord> i needed to..
22:02:50 <Wilddev> I gotta move too so been looking for apartments
22:03:35 <warlord> :(
22:03:39 <warlord> i hate moving
22:04:01 <Wilddev> well maybe I'll finally clean up a bit now lol
22:04:14 <warlord> ok
22:23:48 *** foo has joined #gnucash
22:23:57 <foo> Hmm, anyway to do a recurring invoice? /me looks in gnucash
22:27:02 <warlord> foo: nope.
22:28:19 <foo> ah, ok. /me requests the feature
22:28:19 <foo> hehe
22:31:51 <warlord> too late. it's been requestred for a while
22:39:08 *** egsavage has quit IRC
22:43:29 <foo> oh, hehe
22:56:52 <Wilddev> bwahahahha
22:57:21 <Wilddev> warlord: I just got a call from atimeshare salesman and when I started to tell him I wasn't interested and why he just cut me off
22:57:42 <warlord> Hung up on you?
22:57:46 <Wilddev> yeah
22:57:51 <Wilddev> man funny
22:58:39 <foo> Wilddev: haha. Job for what?
22:58:41 <warlord> He's probably not supposed to do that!
22:59:59 <Wilddev> foo: not a job, he was trying to sell me a timeshare
23:00:30 <foo> ahh, I see
23:09:43 <foo> hm, I want to do a withdraw on the business... eg. how much I pay myself from it. My accountant told me that it should not be deducted as an expense, but it should be shown... anyway to not include an expense or what's the best way to go about this?
23:11:38 <aj> foo: that's a "distribution", should go against your equity account
23:12:41 <foo> hm, how would I do that
23:12:43 <foo> ?
23:18:20 <aj> add a transaction in the bank account you're withdrawing from, put the account field as your "owner's equity" account
23:19:05 <aj> (could be called "retained earnings", or something else, or you might not have one yet; type should be "equity" though)
23:21:52 *** benoitg has joined #gnucash
23:22:31 *** Wilddev has quit IRC
23:31:49 <foo> aj: ah, ok, so - I make a transaction under assets:current assets:checking account (where I withdraw from) that has money that goes to the Equity:Retained Earnings - correct?
23:32:26 <aj> foo: sounds right to me, i'd double check with your accountant next time you talk though
23:32:35 <foo> alright, thanks
23:44:39 *** datakid23 has joined #gnucash
23:45:25 <datakid23> is there an encryption method? sO I can hide all my black market money from prying CIA spys?
23:45:31 <datakid23> :)
23:45:40 <datakid23> I'm serious about the encryption though?
23:56:00 <jsled> datakid23: why would you want encryption written by people distracted by an accounting app? ;)
23:56:19 <jsled> datakid23: http://wiki.gnucash.org/wiki/FAQ#Q:_Is_it_possible_to_provide_security_for_GC_data_using_CFS.2C_etc..3F
23:56:48 <datakid23> fair enough, I just thought they may be someway to have a password on a file...or to encrypt the file without having to decrypt manually before opening in gnucash....
23:57:21 <jsled> All that is better handled outside of gnucash.
23:57:24 <datakid23> I mean, everyone tells me the money makers online are the porn adn mafia - so why not cater to them by providing encryption?
23:58:27 <datakid23> jsled: cheers, sorry I didn't read the FAQ