2016-09-09 GnuCash IRC logs
00:27:08 *** mlncn has quit IRC
00:53:24 *** mlncn has joined #gnucash
01:02:05 *** kael has joined #gnucash
01:02:48 *** kael has quit IRC
01:17:23 *** mlncn has quit IRC
01:24:36 *** mlncn has joined #gnucash
01:25:42 *** fell has joined #gnucash
01:30:28 *** k4i has joined #gnucash
01:31:11 *** mlncn has quit IRC
03:26:09 *** PaulePan1er has quit IRC
03:46:48 *** fabior has joined #gnucash
03:55:38 *** k4i has quit IRC
03:59:20 *** k4i has joined #gnucash
04:09:34 *** k4i has quit IRC
04:14:48 *** fabior has quit IRC
04:17:05 *** k4i has joined #gnucash
04:26:59 *** k4i has quit IRC
04:28:21 *** k4i has joined #gnucash
04:44:03 *** fabior has joined #gnucash
05:45:43 *** User has joined #gnucash
05:56:52 *** mikee_ has joined #gnucash
05:58:39 *** mikee has quit IRC
05:58:40 *** mikee_ is now known as mikee
05:58:41 *** ChanServ sets mode: +o mikee
06:27:40 <myNameIsTaken> Not sure how to "reset" a style sheet. The tabs wouldn't come from the style sheet itself, would they? However I suppose I could hard-code the new reports, but that frightens me a bit as I have two languages to learn in order to do so. Has anyone else tried to modify a derived report and can confirm this behaviour? If so, I'd call it a bug.
06:27:49 *** hoijui has joined #gnucash
06:35:51 *** Jimraehl1 has joined #gnucash
06:36:44 *** Jimraehl1 has quit IRC
06:36:54 *** Jimraehl1 has joined #gnucash
06:37:38 *** Jimraehl1 has joined #gnucash
06:38:06 *** Jimraehl1 has left #gnucash
06:38:19 *** Jimraehl1 has joined #gnucash
06:46:03 *** Jimraehl1 has joined #gnucash
06:46:26 *** Jimraehl1 has left #gnucash
07:02:58 *** fabior has quit IRC
07:29:25 *** User has quit IRC
07:46:36 *** k4i has quit IRC
08:30:12 *** mlncn has joined #gnucash
08:36:16 *** mlncn has quit IRC
08:59:58 *** k4i has joined #gnucash
09:11:43 *** k4i has quit IRC
09:12:23 <warlord> myNameIsTaken: after you run the report, edit the report options and re-select the style sheet.
09:12:36 <warlord> I'm not sure what "tabs" you are talking about.
09:12:44 <warlord> (maybe send some screen shots?)
09:13:05 <warlord> What two languages would you need to learn? The reports are all in scheme.
09:13:51 <warlord> AFAIK you can modify a saved report and re-save it. HOWEVER it is possble that the style sheet selection is NOT saved when you save a report.
09:14:46 *** mlncn has joined #gnucash
09:17:02 <myNameIsTaken> Edit->Style Sheets->Easy->[Edit Button]. Opens Style Sheet Properties dialog with 5 tabs: Colors, Fonts, General, Images, Tables. It is the IMAGES tab that allows you to set: Background Title, Heading Banner, Heading Alignment, Logo.
09:17:35 <warlord> Ah, that's editing a style sheet..
09:17:59 <warlord> You will only be able to set that once.
09:18:10 <warlord> (well, one-at-a-time)
09:18:17 <myNameIsTaken> Edit->Style Sheets->MYSHEET->[Edit Button] performs exactly the same way except that instead of five tabs, there are four: Colors, Fonts, General, Tables. (and it is actually a different dialog box entirely)
09:18:50 <warlord> Where did "MYSHEET" come from?
09:19:35 <myNameIsTaken> Edit->Style Sheets->[New Button]->Template=EASY
09:20:25 <myNameIsTaken> As far as I know this is the only way to create a custom invoice. The problem arises if you have multiple clients needing distinct invoices; you cannot change thier logo or anything else in the missing "Images" tab.
09:21:43 <warlord> Well, no, it's not the only way..
09:21:47 <warlord> There are lots of ways..
09:22:17 <warlord> You could also do it by using the e-guile tax invoice and generating multiple e-guile (HTML-like) template files and choosing the right template for each customer.
09:22:39 *** fabior has joined #gnucash
09:23:12 <warlord> As for the style sheet -- I don't know why that function isn't working. It may be a bug. Or it may be an artifact of the easy style sheet. I'm honestly not sure -- I've never personally tried it.
09:23:36 <myNameIsTaken> Right. That's the path I was suspecting I needed to follow. But it isn't just eGuile I need is it? GetText and Scheme seem to be indicated in the wiki.
09:23:49 <myNameIsTaken> It does seem a bug and we do seem to have found the workaround.
09:24:16 <warlord> You dont need GetText..
09:24:36 <warlord> As for scheme -- that's what e-guile is.. embedded guile. Guile is Scheme. And it's embedded in HTML.
09:24:58 <warlord> So you generate an HTML template with embedded scheme. Then the report "runs" the scheme in the HTML and outputs the result.
09:25:47 <myNameIsTaken> OK, I can figure that part out with a bit of effort. I'm presuming that the wiki has it all there for me. Good to have someone confirm things; lets me know I'm not simply missing something obvious.
09:26:10 <warlord> I doubt you're missing something obvious.
09:26:23 <warlord> I'm sure a lot of it was not written with "multiple businesses" in mind.
09:27:04 <myNameIsTaken> Awesome. Hey, here's a thought: When I create my own invoices in eGuile, will that - finally - allow me to list my GST and PST on separate total lines with a more descriptive name than "Other Charges"? :-)
09:27:24 <myNameIsTaken> Make it bilingual - even?
09:27:55 <myNameIsTaken> (sorry, you're not Canadian... that may have been gibberish to you)
09:28:13 <warlord> I'm American.. But I understand Canadian PST/GST (got lots of friends up North)
09:28:44 <warlord> but you CAN do that today: in the invoice report options (might depend on which invoice report), select Display Individual Taxes.
09:29:20 <myNameIsTaken> OK, thanks Warlord. You have confirmed the correct path is eGuile. Much appreciated sir! (Display Individual Taxes is to generic: "Other Charges" = GST and "Other Charges" = PST)
09:29:47 <myNameIsTaken> I'm a coder - I can figure it out from here.
09:30:13 <warlord> myNameIsTaken: Where does "Other charges" come from? Is that what you named your GST an PST accounts?
09:31:04 <myNameIsTaken> No, the invoice doesn't show the account names for my GST or PST - instead both lines are labeled on the invoice as "Other Charges". There does not appear to be any way to customize this so I just combine them instead.
09:33:41 <warlord> Hmm.. which invoice report are you using?
09:34:45 <myNameIsTaken> Just cycled through them all - same result. No labelling on the taxes when you check "individual taxes" on the report options.
09:34:48 <warlord> The Printable Invoice definitely uses the account name
09:35:14 <myNameIsTaken> Sorry - am using "Printable Invoice" with the aforementioned style sheets.
09:35:25 <myNameIsTaken> (that's the only report I have available)
09:35:38 <warlord> What version of gnucash are you using?
09:35:48 <myNameIsTaken> 2.6.13
09:36:02 <myNameIsTaken> Bug?!
09:36:03 <warlord> Umm, there are at least 3 different invoice reports..
09:36:21 <warlord> I'm looking at the code now -- it's using the tax account name.
09:37:04 <myNameIsTaken> WTHECK? I choose "Print Report" and it opens. Going to Report Options allows me to change the Style Sheet - but no option to choose a different report.
09:37:13 <warlord> (let ((collector (gnc:make-commodity-collector))
09:37:13 <warlord> (commodity (xaccAccountGetCommodity acct))
09:37:13 <warlord> (name (xaccAccountGetName acct)))
09:37:13 <warlord> (collector 'add commodity value)
09:37:13 <warlord> (add-subtotal-row table used-columns collector
09:37:14 <warlord> "grand-total" name)))
09:38:00 <warlord> Reports -> Business Reports -> ....
09:38:11 <warlord> There are at least 3 different invoice reports there.
09:38:48 <warlord> You can choose which one is the report that gets run when you click on "Print Invoice". The default is "Printable Invoice". And it DEFINITELY will use the Account Names when you select the "Individual Taxes" report option.
09:41:16 <myNameIsTaken> Odd. I cycled through all three reports (Easy, Printable, Fancy) with the same text result. I'm going to open another set of books - with a different chart of accounts - and see what happens.
09:42:14 <warlord> It does depend on how you have your Tax Tables set up...
09:42:19 <warlord> And what accounts are there.
09:43:27 <myNameIsTaken> OFTLOG. It's working in another chart of accounts. Let me review my Tax Tables and see if they correspond with the invoice labels.
09:44:55 <myNameIsTaken> sigh. Imagine this Liability: Liabilities/Taxes/GST/Charged Or this: Liability:Taxes:GST:Charged One set just uses the word "CHARGED" because of how it fits into the COA.
09:45:13 <myNameIsTaken> Sorry... first said TAX/GST (not Charged)
09:45:46 <myNameIsTaken> So I see where it's coming from now. Tax Tables points to COA tax account. REname those and problem should be solved.
09:48:30 <myNameIsTaken> FIXED! That was it sir.
09:53:53 <warlord> There you go :)
09:54:04 <warlord> I told you it printed the account name! :)
09:55:19 <myNameIsTaken> The users will ALWAYS find a way to mess up carefully thought-out code by doing things nobody should ever do. That is exactly why my code-review is always followed by my WIFE using the app. She always does something I would have never considered. Today, I am she.
09:55:36 <myNameIsTaken> Thanks a lot Warlord. You are greatly appreciated.
09:55:36 *** hoijui has quit IRC
09:56:00 <warlord> My pleasure.
09:56:03 <warlord> HtH
10:04:31 *** hoijui has joined #gnucash
10:16:18 *** mlncn has quit IRC
10:23:08 *** aqua___ has joined #gnucash
10:36:37 *** mikee is now known as mikee-afk
10:41:47 *** mikee-afk is now known as mikee
10:46:13 *** mlncn has joined #gnucash
10:54:51 *** aqua___ has quit IRC
12:42:28 *** hoijui has quit IRC
13:36:00 *** fabior has quit IRC
13:50:23 *** Mechtilde has joined #gnucash
14:08:37 *** aqua___ has joined #gnucash
14:42:01 *** Mechtilde has quit IRC
14:48:38 *** aqua___ has quit IRC
14:51:59 *** k4i has joined #gnucash
16:05:24 *** kael has joined #gnucash
16:27:04 *** mlncn has quit IRC
16:28:19 *** k4i has quit IRC
16:36:48 *** hoijui has joined #gnucash
16:39:22 *** kael has quit IRC
17:24:17 *** nomeata has joined #gnucash
17:38:06 *** hoijui has quit IRC
17:41:26 *** nomeata has quit IRC
18:34:16 *** User has joined #gnucash
18:53:36 *** fell has quit IRC
19:35:41 *** CodingHero has joined #gnucash
19:37:06 *** CodingHero has quit IRC
19:49:15 *** CodingHero has joined #gnucash
19:52:31 <CodingHero> I've found that suddenly when I go to import a QFX file for a certain account, all the memos and descriptions are "null" but the dates and amounts are OK. Looking at the file with a text editor, it looks like the descriptions are all there. What could be going wrong?
19:55:41 <CodingHero> QFX files for other accounts import fine
20:14:35 <warlord> CodingHero: do you have examples of the ofx files from where they worked and now when they dont so you could compare them? Perhaps the bank changed something?
20:14:44 <warlord> (sorry, gotta run again)
20:40:09 <CodingHero> hmm I don't but I can try to download older batches that worked in the past
22:01:19 *** User has quit IRC
23:18:21 *** k4i has joined #gnucash
23:28:01 *** mlncn has joined #gnucash
23:49:21 <CodingHero> warlord: OK I re-downloaded an old set but I can't tell if it imports right or not as I had imported it previously so the import summary is blank. I did a diff on the two files and nothing was immediately obvious between the two as the cause of the trouble.