2008-12-09 GnuCash IRC logs
00:54:45 *** MechtiIde has quit IRC
01:31:34 *** warlord is now known as warlord-afk
02:39:57 *** bentob0x has joined #gnucash
02:55:56 *** MechtiIde has joined #gnucash
03:14:46 *** eukreign2 has joined #gnucash
03:19:51 *** eukreign has quit IRC
03:40:55 *** ErKa has joined #gnucash
04:26:18 *** ErKa has quit IRC
04:39:59 *** ErKa has joined #gnucash
06:05:36 *** IanL has joined #gnucash
06:33:19 *** ErKa has quit IRC
06:33:35 *** andrewsw has quit IRC
06:34:21 *** andrewsw has joined #gnucash
06:34:21 *** gncbot sets mode: +o andrewsw
06:46:35 *** IanL has quit IRC
07:12:44 *** IanL has joined #gnucash
07:49:18 *** JimRaehl has left #gnucash
08:01:57 *** ErKa has joined #gnucash
08:05:03 *** JimRaehl has joined #gnucash
09:02:39 *** ErKa has quit IRC
09:08:01 *** IanL has quit IRC
09:09:07 *** IanL has joined #gnucash
09:22:41 *** kielein has joined #gnucash
09:24:59 *** nebajoth has quit IRC
09:25:42 <ElectricBill> I voided a transaction just as a test to see how the feature works. Now it won't let me remove it.
09:25:52 <ElectricBill> Is there a way around this?
09:28:27 *** nebajoth has joined #gnucash
09:28:50 <ElectricBill> How do I remove read-only status on a transaction?
09:37:01 *** twunder has joined #gnucash
10:21:31 *** Rolf1 has joined #gnucash
10:51:02 *** dash1 has joined #gnucash
10:51:30 <jsled> ElectricBill: read-only? Where do you see that.
10:51:41 <jsled> There's roughly two ways to get rid of a transaction.
10:51:48 <jsled> Blank out all the components of the splits.
10:51:56 <jsled> Or right-click, Delete Transaction
10:58:21 <dash1> I want to import orders from a point of sale program (OpenBravo POS), creating sales transactions in gnucash.
10:58:44 <dash1> How should I be looking at doing this? is it going to be easiest to just write some code that drives the QOF library directly?
10:59:43 *** nebajoth has quit IRC
11:00:29 *** dash1 is now known as dash
11:01:45 <jsled> dash: don't think in terms of the QOF library, per se … think baout the gnucash engine API.
11:02:07 <jsled> If you just want to unidirectionally create normal transactions, try generating some QIF files, then importing them.
11:02:30 <jsled> I don't know how special you want your POS transactions to be, or how/if they need to be.
11:02:49 <dash> not very special
11:03:56 <dash> i'm setting up accounting for a (very) small business, and I just want to keep from having to enter sales figures twice. :)
11:05:38 <jsled> that's probably the way to go, then. Note that gnucash has no concept of stock or inventory. You'd just be able to get the register transactions.
11:05:51 <jsled> And, frankly, it's not obvious to me exactly how that would work.
11:06:14 <dash> sure
11:06:27 <dash> the POS system tracks inventory well enough for my purposes
11:06:37 <ElectricBill> jsled, I set the transaction to void. Now I am told it is read-only when I try to delete it.
11:07:49 *** warlord-afk is now known as warlord
11:07:58 <warlord> ElectricBill: yes, you would need to un-void it first.
11:08:31 <ElectricBill> warlord, yeah, but I couldn't figure out how to un-void it.
11:08:49 <warlord> Honestly I didn't even know there was a way /to/ void it in the UI
11:09:03 <warlord> Revert to a backup file?
11:28:42 <warlord> BIAB
11:28:59 *** warlord has quit IRC
11:38:04 *** bentob0x has quit IRC
11:52:42 *** mircmac has joined #gnucash
11:53:36 <mircmac> Hi all, what file/s should I back up when I backup my gnucash?
11:59:11 *** warlord has joined #gnucash
11:59:12 *** gncbot sets mode: +o warlord
11:59:45 <ElectricBill> warlord, found it - off the transaction submenu
12:00:39 <warlord> you found the un-void?
12:03:06 *** MechtiIde has quit IRC
12:03:41 <ElectricBill> warlord, yes - highlight register transaction and click transaction in menubar. It's in there.
12:04:45 <warlord> ok
12:05:55 <jsled> mircmac: http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_backup_my_GC_environment.2C_including_preferences.3F
12:09:05 <mircmac> jsled: thanks!
12:23:26 *** mircmac has left #gnucash
12:28:29 *** bAron has joined #gnucash
12:29:55 <bAron> hi asked a Q yesterday about not getting F::Q to work, now it does... After a resboot. Dont know if it was Active Perl or F::Q or som of f-q's "dependensies" that needed it... but it does work
12:30:34 <bAron> so it runs with Vista 64-bit and activePerl 5.8
12:30:50 <andrewsw> bAron: I don't know why I didn't thing to mention that. Too long away from windows for me, I guess.
12:30:55 <andrewsw> glad you got it sorted!
12:32:31 <bAron> yeah, well feel quite stupid my self... Could not see a reson for it since (as far as I can tell) no of the programs should need a restart to work. But what ever, now it works
12:33:00 <bAron> thanks alot for the help though
12:35:59 <warlord> glad it's working now!
12:36:58 <andrewsw> any reason not to push up changes that allow customization of the "Invoice #xxxxxx" strings in invoices?
12:37:51 <andrewsw> the aussie's can have "Tax Invoice #xxxxx"
12:38:34 <bAron> hmm, let see if I can Get any results out of this now. There is a report where you can get a report of the value of your stocks... I get price and value 0,00... so i probably missing som settings in gnucash here...
12:38:39 <warlord> andrewsw: I've seen no patch to allow that, but I don't object to one.
12:38:53 <andrewsw> that's 'cause I'm writing it right now...
12:39:01 <warlord> bAron: what price source do you have set in thereport options?
12:39:05 <bAron> the symbol to write down for http://finance.yahoo.com/q?s=TEL2B.ST this stock should be "TEL2B.ST" right?
12:39:10 <bAron> Yeahoo
12:39:22 <bAron> *Yahoo ;)
12:40:04 <andrewsw> the reports choose to use either "Invoice" "Bill" or "Expense Voucher". I'm setting it to allow editing of just the first, "Invoice" and letting the report decide whether to use the custom string or the other two.
12:41:18 <warlord> bAron: That's not the one of the price source choices in the report options...
12:42:25 <warlord> andrewsw: How hard would it be to just have "Invoice", "Bill", or "E.V." the default in a string option?
12:42:37 <warlord> .. then allow the user to override it.
12:42:59 <andrewsw> not sure honestly.
12:43:12 <andrewsw> THat is of course the right way to do it.
12:46:53 <andrewsw> wow, I've got a reliable crasher in svn. open an invoice, and then close it... boom... backtrace says "double free or corruption"
12:47:45 <bAron> I don think I get it. I have made 2 stockaccounts in Gnucash for 2 different stocks, In the name, I've typed the name of the stock (guess i could type what ever name here), under symbol I've typed the symbol that shows on Yahoo Finance. on Type i have typed Stockholm, since thats the stockmarket its tradeble on.
12:48:18 <warlord> bAron: what version of F::Q?
12:48:27 <bAron> think 1.15
12:48:31 <bAron> let me confirm that
12:48:36 <warlord> Yahoo did change their site and broke F::Q, but I dont know what version(s) fixed it.
12:48:40 <warlord> see the -user archives.
12:49:20 <bAron> yeah, I think so too. Read something about haveing atleast 1.13 to get yahoo working again
12:50:22 <bAron> To make it ease i could se what other scources tracking the swedish stocks and use anotherone
12:51:23 * bAron does spell too good, thinking about reading his lines before hitting enter
12:52:14 * bAron so he could see that it should be does not, for example
12:52:28 *** bentob0x has joined #gnucash
12:54:01 *** ErKa has joined #gnucash
12:54:07 <bAron> If i get it right, should it work right away then? does the report check the prices, or when and how are they checked?
12:57:17 <warlord> it all depends on how you have the report configured. But the report would never call out to F::Q itself.
12:57:57 *** bentob0x has quit IRC
12:58:03 <andrewsw> bAron: are there any prices in the pricedb? If you haven't actually updated the prices, then I think you'll get nothing.
12:58:29 <bAron> where can i find that db?
12:58:48 <jsled> it's in your datafile.
13:01:03 *** bentob0x has joined #gnucash
13:01:09 <bAron> well, i have enterd how many shares i have and what i have payed fore them... But it does not fel like thats what you are talking about?
13:02:29 <andrewsw> tools -> price editor?
13:04:15 <bAron> well, i cant see any prices there not, can't see where they should be either though?
13:04:29 <andrewsw> there should be a "get quotes" button
13:04:49 <bAron> Yeah, thats checked
13:05:32 <bAron> and i have tried "Europe (yeahoo, ...)", "Yahoo" and "Yahoo Europe"
13:09:04 <bAron> but can i be sure that F::Q actually have fetched the prices yet? or should I still tink its wrong?
13:09:27 <bAron> give me 20 min, ill check the manual again to see that i've got everything coverd
13:09:52 <warlord> bAron: what does gnc-fq-dump give you?
13:10:10 <bAron> i dont know how to rin that, running windows
13:10:15 <bAron> *run
13:11:01 <ElectricBill> Why does the reconciliation process generate an extra transaction?
13:11:03 *** bentob0x has quit IRC
13:12:07 *** bentob0x has joined #gnucash
13:13:46 <warlord> ElectricBill: To let you input Interest or Payment.
13:14:30 <ElectricBill> But I've already done that. But it won't accept zero. I'm missing something.
13:14:55 *** Tim__ has joined #gnucash
13:14:59 <Tim__> #gnucash
13:15:25 <ElectricBill> it's generating a transfer with the reconciled balance by default.
13:15:51 <Tim__> Hello.
13:15:52 <ElectricBill> I don't understand what the expected practice is here.
13:17:01 <ElectricBill> Oops. I see that I just need to click Cancel there....
13:17:08 <ElectricBill> But I still don't get the point.
13:18:20 <Tim__> Hi, can someone help me? I'm having trouble with a report printing incorrectly...
13:18:46 <jsled> Tim__: describe what you're seeing; if someone can help, they will.
13:19:16 <Tim__> The report is formatted correctly, however the text is upside down and backwards.
13:19:30 <Tim__> Well, the letters are backwards.
13:20:02 <Tim__> No, excuse me, their just upside down..
13:20:39 <jsled> Tim__: http://bugzilla.gnome.org/show_bug.cgi?id=462148 ?
13:20:56 *** MechtiIde has joined #gnucash
13:21:59 <bAron> i did get gnc-fq-dump to work now
13:22:19 <Tim__> Thanks.
13:22:28 <bAron> after copying openssl's dll's to my perl\bin folder
13:22:40 <bAron> checking gc now
13:25:08 <bAron> still not getting any values
13:25:12 <bAron> bbl
13:26:52 <warlord> ElectricBill: what kind of account?
13:27:09 <ElectricBill> Credit card.
13:27:26 <ElectricBill> It's making more sense to me now - but I still don't get the transfer option.
13:27:32 <warlord> Right, it's letting you make the CC payment. You got the statement, you're reconciling the statement, clearly you want to pay the bill.
13:27:36 <ElectricBill> Maybe it wants me to make a payment?
13:27:41 <warlord> yes
13:27:54 <ElectricBill> Ah - too smart.
13:28:19 <ElectricBill> In this case, I'm actually entering old data. The payment is history.
13:28:34 <ElectricBill> It took me a while to realize I had to press cancel.
13:28:48 <ElectricBill> I first that that would cancel the reconcilation marks.
13:29:02 <jsled> reasonable.
13:29:16 <ElectricBill> I thing the program needs to explain what it's thinking when it presents that window for newbies like me.
13:29:22 <jsled> yu
13:29:22 <jsled> yup
13:29:31 <warlord> It's in the docs.
13:29:34 <jsled> Should say "ignore payment" or something.
13:29:35 <ElectricBill> Anyway, very nice program so far.
13:29:48 <jsled> or "no payment", maybe.
13:30:08 <ElectricBill> Sorry, but "in the docs" does not compensate for ambiguous UI.
13:30:15 <jsled> yup
13:30:18 <ElectricBill> jsled, exactly.
13:30:35 <ElectricBill> or more precisely, "no new payment:
13:30:37 <ElectricBill> :
13:30:38 <ElectricBill> "
13:30:51 <ElectricBill> there will always be the clue-challenged like myself...
13:31:09 <ElectricBill> but I don't mean to look a gift-horse, yadda yadda.
13:31:14 <warlord> The more you idiot-proof something the more the world will make better idiots? ;)
13:31:24 <ElectricBill> I think it's pretty slick, and it's saving my bacon.
13:31:35 <warlord> Cool! I'm glad it'shelping you out.
13:31:39 <ElectricBill> The world loves idiots already... just look at the political leadership.
13:31:54 <jsled> perhaps, but "cancel" for not cancelling the Reconcilition opteration is the idiotic thing, here.
13:32:31 <ElectricBill> jsled, yeah - it needs some tuning. I wanted to "accept reconciliation only"
13:32:39 <ElectricBill> or sumthin like that.
13:32:52 <warlord> ElectricBill: you did, when you clicked "Finish"
13:33:06 <ElectricBill> I realize that ... now
13:33:09 <warlord> The reconcile window went away...
13:33:15 <warlord> A new window popped up for the payment.
13:33:26 <ElectricBill> No doubt that it makes perfect sense in hindsight.
13:33:47 <ElectricBill> But nobody starts a new task with hindisght
13:34:09 <andrewsw> "I see you've reconciled your credit card account. Would you like to make a payment?" -- clippy
13:34:35 <ElectricBill> andrewsw, that would be nice too
13:35:13 <warlord> That would be annoying to anyone BUT first-time users.
13:35:33 <warlord> Although I suppose one could add that dialog to the list of dialogs you can hide.
13:35:53 <andrewsw> indeed, but maybe at the top of the payment dialog, something to that effect.
13:36:29 <ElectricBill> An extra click would be very annoying.
13:36:39 <warlord> Well, I think just changing the buttons from "OK" and "Cancel" to "Make Payment" and "Cancel Payment" would suffice.
13:36:54 <ElectricBill> Some extra verbiage would be easily ignored, and as you suggest, optionally suppressed.
13:37:45 <ElectricBill> I would prompt with "make payment" and "just accept reconciliation"
13:38:43 <ElectricBill> anyway, I know this trick now. Much appreciate the feedback.
13:39:19 <ElectricBill> Onward to importing my accounts receivable
13:39:47 * ElectricBill goes a-perl-coding to make some .qifs
14:04:35 <bAron> Hi again, starting to feel a-little stupid and naggy ;)... Dont get GC to report the value of my stocks... gnc-fq-dump does work perfecly well... in the price editor i have typed in, Name of stock, symbol, and type, followed with source... the three stocks works from gnc-fq-dump
14:14:19 *** sjc has joined #gnucash
14:19:50 *** bentob0x has quit IRC
14:56:31 *** Zoolooc_ has joined #gnucash
14:59:26 *** cortana has joined #gnucash
15:05:41 *** benjamin has quit IRC
15:28:06 <warlord> bAron: how are you trying to get it to report on the current value?
15:52:35 <bAron> warlord, well i one of the reports witch show wich stocks you own, can't tell the name of it cause i run the swedish version... but there is one "advanced" and wich just shows what you own
15:53:09 <warlord> bAron: right.. and in the report options, which price source method do you select?
15:53:38 <bAron> where else should i be able to see the values?
15:55:31 <bAron> it's says SEK (swedish Krona) right now
15:55:42 <bAron> wait
15:56:04 <warlord> bAron: you're clearly not understanding my question. With the report open, click on "Options" to open the Report Options window.
15:56:43 <bAron> yeah and then i have price source, theres 3 alternatives right?
15:58:01 <bAron> one of them is "Most recent to report"?
15:58:32 *** benjamin has joined #gnucash
15:59:16 <bAron> is it these options you mean?
16:01:25 <warlord> yes.
16:01:27 <warlord> those options.
16:01:31 <warlord> which do you have selected?
16:01:37 <bAron> "most recent"
16:02:07 <bAron> i just changed the lang of GC to Eng, so no it will be easier for me to follow
16:05:13 <warlord> ok
16:05:27 <warlord> well, that should work. Did you run "Get Quotes"?
16:06:13 <bAron> no, that sound very very relevant thought
16:06:20 <bAron> how?
16:06:58 <bAron> do i run that in the batch that starts gnucash?
16:07:17 <warlord> Tools -> Price Editor
16:07:41 <bAron> running...
16:08:37 <bAron> that show very clearly all the prices of the stocks there, i am sure that that should be it
16:08:59 <bAron> do i have to do this manually in the future to?
16:09:35 <bAron> or is it triggered automaticly in some way?
16:10:36 *** kielein has quit IRC
16:11:12 <bAron> thanks alot for your patiens warlord, a hug to you to andrewsw
16:12:11 <warlord> you have to run it manually.
16:13:34 <bAron> ok, then i know how to do... is it a perlscript wich can be found in \bin\ it runs?
16:30:48 <warlord> Well, you have two options:
16:30:57 <warlord> 1) Click on Get Quotes periodically
16:31:49 <warlord> 2) Set up a cron job to run gnucash --add-price-quotes=/path/to/your/datafile
16:32:07 <warlord> If you choose option #2, make sure that you only run it when you dont already have gnucash running.
16:37:38 *** ErKa has quit IRC
16:47:51 <bAron> time to hit the bed, Thanks alot for all the help
16:47:55 *** bAron has quit IRC
16:52:19 *** ErKa has joined #gnucash
17:05:28 <andrewsw> sweet!
17:05:29 *** Tim__ has quit IRC
17:05:32 * andrewsw got a hug!
17:06:19 *** twunder has quit IRC
17:07:22 *** Rolf1 has quit IRC
17:08:44 <benjamin> eh?
17:16:55 *** Rolf1 has joined #gnucash
17:30:03 *** Zoolooc_ has quit IRC
17:36:51 *** warlord has quit IRC
18:50:26 <andrewsw> there's customizable invoice titles in all three invoices...
19:06:21 *** warlord has joined #gnucash
19:06:21 *** gncbot sets mode: +o warlord
19:14:28 *** warlord has quit IRC
19:30:31 *** jsled has quit IRC
19:43:47 *** jsled has joined #gnucash
19:43:47 *** gncbot sets mode: +o jsled
19:47:10 *** cortana has quit IRC
20:10:01 *** Rolf2 has joined #gnucash
20:16:31 *** Rolf1 has quit IRC
20:20:21 *** localhost has quit IRC
20:36:02 *** sjc has quit IRC
20:44:07 *** me has joined #gnucash
20:44:09 *** me has joined #gnucash
20:49:54 <me> OFX Question: When requesting list of accounts in aqBanking "User Configuration" I receive the status message: Status for signon request: Must change USERPASS (Code 15000, severity "INFO") The user must change his or her number as part of the next OFX request.
20:50:28 <me> How can I pass a new password?
20:51:33 <me> My password is new and the bank requires it to be changed immediately.
21:03:30 *** chris has quit IRC
21:16:43 *** chris has joined #gnucash
21:30:06 *** twunder has joined #gnucash
22:08:40 *** twunder has quit IRC
22:08:51 *** ErKa has quit IRC