2018-03-08 GnuCash IRC logs
00:00:37 <fell> https://imgur.com/a/D5vhS
00:02:19 <fell> CharlesIC, where is the problem now?
00:02:40 <fell> Looks your A/R similar?
00:07:00 <CharlesIC> not by default, no
00:07:08 <CharlesIC> and if i made it look like that, the easyinvoice doesn't show the 6.65
00:08:04 <CharlesIC> it seems like the easiest thing to do is to just manually add the repaid expense at some point in expenses:reimbursed expenses
00:08:12 <CharlesIC> so that i balance out income:reimburseable expenses
00:09:33 <CharlesIC> so the other issue is, how do i find out how much i received in income in a year?
00:09:40 <CharlesIC> on the invoice, i always put income:sales
00:09:46 <CharlesIC> but that doens't mean i was actually paid
00:09:57 <CharlesIC> so i can't go to income:sales to see how much i madefor the year, so how do i do so?
00:10:07 <CharlesIC> look at accounts receivable and filter it somehow?
00:12:07 <chris> Charles - try the Transaction Report, account: Account/Receivable, filter by - include transactions to/from Bank
00:12:07 <fell> did you reload he easyinvoice after editing the invoice?
00:12:09 <CharlesIC> how do i see total payments in A/R for the year?
00:12:19 <CharlesIC> yes, i reloaded
00:12:30 <CharlesIC> chris, i use multiple banks
00:12:42 <CharlesIC> it seems the way to see how much money i actually received was tot:payment
00:13:03 <CharlesIC> however, that also shows reimbursed expenses
00:13:18 <CharlesIC> how do i total up income:sales for the year, but only show the actual payments?
00:13:30 <fell> chris, can you continue? I need some food.
00:13:40 <CharlesIC> fell, im giving up on that part, thanks anyway
00:13:41 <chris> I'm only 10min lunch break
00:13:42 <chris> :)
00:14:04 <CharlesIC> chris, on all my invoices, i use income account is income:sales
00:14:04 <fell> I will hurry
00:14:11 <chris> chris: ISTM accrual accounting means any Income booked must be accounted as "Income" whether you're paid or not
00:14:11 <CharlesIC> and i use also income:reimbursable expenses
00:14:17 <CharlesIC> i only want to count income:sales for the year
00:14:19 <chris> if they don't pay then it's Expense:Bad Debt
00:14:37 <CharlesIC> to show how much i actually amde in the year
00:14:55 <CharlesIC> the problem is, if ijust go look at income:sales account, for instance, it shows one customer's $8,000 item
00:14:58 <CharlesIC> but they still haven't paid
00:14:59 <chris> you can still do Transaction Report, and use FilterBy... to/from all banks
00:16:10 <CharlesIC> ok, i did transaction report
00:16:12 <CharlesIC> and start/end of previous year
00:16:19 <CharlesIC> but i dont want to include the reimbursed expenses
00:16:27 <CharlesIC> because some bank deposits included those
00:16:43 <CharlesIC> dang it, i cant do it that way either
00:16:47 <CharlesIC> cuz i can't discriminate
00:17:08 <CharlesIC> unless i manually do it
00:17:21 <chris> I don't personally use Business Features, I do cash accounting myself so I haven't got personal experience
00:18:11 <chris> but I think there's no inbuilt report to find total income from invoices in a period
00:18:38 <CharlesIC> ok
00:18:52 <CharlesIC> im just having a big problem here
00:18:59 <CharlesIC> i almost always have to pay for shipping
00:19:06 <CharlesIC> so for each invoice, before i post
00:19:12 <CharlesIC> i do the work going to income:sales
00:19:18 <CharlesIC> and i do the postage going to income:reimburseable expenses
00:19:33 <CharlesIC> and then i get paid, make a deposit to the bank account
00:19:41 <CharlesIC> and i assigned that as a payment to accounts receivable
00:19:57 <CharlesIC> so how at the end of the year do i just count the income:sales that was actually PAID?
00:20:03 <CharlesIC> so i can put how much income i made for the year?
00:20:09 <chris> in upcoming 3.0 there will be further improvements to the Transaction Report whereby you can fine-tune the filter transactions
00:21:17 <CharlesIC> what id like to do is look at A/R
00:21:28 <CharlesIC> for the year
00:21:32 *** storyjesse has quit IRC
00:21:35 <CharlesIC> but really separate out the reimbursed expenses
00:22:50 <chris> you basically want sum amounts for Income:Reimbursable Expenses for all txns from A/R to Bank
00:23:26 <CharlesIC> well, i cant do it that way
00:23:37 <CharlesIC> because not all my expenses were reimbursed for the year
00:23:51 <chris> there's no inbuilt report for this... your choices are to massage the Transaction Report in 3.0, or save data as SQL and use custom SQL query
00:23:57 <CharlesIC> ok
00:24:06 <CharlesIC> chris, for the future
00:24:09 <CharlesIC> how can i fix this?
00:24:25 <CharlesIC> 1. i make a new invoice, one line is my work, and i have that from income account, income:sales
00:24:35 <CharlesIC> 2. the second line is income:reimburseable expenses, such as shipping, filing fees, etc
00:24:40 <CharlesIC> 3. i post the invoice
00:25:00 <CharlesIC> 4. i receive a payment to my bank account, as a single check. i assign it as a payment for the invoice, so it shows it going to accounts receivable
00:25:10 <chris> umm I think to satisfy tax authorities you're doing everything right
00:25:19 <CharlesIC> so at the end of the year, how do i see how much income i made?
00:25:42 <CharlesIC> i cant just total up income:sales, because i wasn't necessarily paid for all invoices.
00:26:09 <CharlesIC> and i dontknow which income:reimburseable expenses were actually reimbursed
00:26:21 <CharlesIC> unless i get really technical.
00:26:59 *** CDB-Away_ has quit IRC
00:27:02 <chris> I'm thinking SQL query here
00:27:37 <chris> sounds like multidimensional data that the software shouldn't make too many assumptions
00:27:41 <CharlesIC> surely i can do a report?
00:27:51 <CharlesIC> or should i stop doing my invoices like that?
00:28:05 <CharlesIC> or do a separate invoice for reimburseable expenses? that seems painful
00:28:24 <chris> how many invoices per year are you dealing with
00:29:18 <CharlesIC> 25-30, but in the future it could be 100
00:29:35 <CharlesIC> nearly every single invoice, i have a reimbursed expense
00:29:44 <CharlesIC> whether for shipping or filing fee
00:29:50 <CharlesIC> so it's not income
00:30:10 <CharlesIC> i want a way to make it to where i can easily see my RECEIVED income for the year
00:30:15 <CharlesIC> not how much i billed
00:30:59 <chris> tbh I'
00:31:12 <CharlesIC> i thought for sure i did something last year where i just saw a report
00:31:25 <chris> I'd do a multicolumn report from the "Income/GST Statement" report which can show multiple Income accounts
00:31:25 <CharlesIC> but i think previously i never charged reimburseable expenses like this
00:31:50 <chris> but the Income/GST statement takes values from billed amounts
00:31:54 <CharlesIC> i mean, the issue with just looking at income:sales it doesn't show how much i actually received
00:32:10 <chris> then I'd go through the 100 invoices (not too many to do manually) and discard the unpaid lines
00:32:25 <chris> until the reports are upgraded I think this is the best way
00:32:30 <CharlesIC> ok
00:32:46 <CharlesIC> is there an easy way to go through all my invoices instead of having to manually change the number every time?
00:32:50 <chris> I can recommend filing an enhancement request in Bugzilla
00:33:03 <chris> dunno, but I really need to go
00:34:04 <CharlesIC> thanks
00:34:07 *** CharlesIC has quit IRC
00:34:20 <chris> that was ... intense
00:39:35 *** marusich has quit IRC
00:49:05 <chris> This requires an upgrade to the TR: "Filter / Filter AP/AR Transactions By..." Unposted/Posted/Paid or something to that effect
01:01:31 *** jotrago has quit IRC
01:01:35 *** jotrago has joined #gnucash
01:03:37 *** chris has quit IRC
01:21:48 *** Mechtilde has joined #gnucash
01:25:36 *** bob_ has joined #gnucash
01:25:37 <fell> @tell chris: I still believe somewhere is a thinking error in CharlesIC's problem somehow mixing accruel vs. cash based accounting. But probably is simply GC's business features are not fit for cash based accounting.
01:25:37 <gncbot> fell: The operation succeeded.
01:54:45 *** fell has quit IRC
01:55:55 *** fell has joined #gnucash
02:10:15 *** Mechtilde has quit IRC
02:40:39 *** bob_ has quit IRC
02:43:21 *** gjanssens has joined #gnucash
02:43:21 *** ChanServ sets mode: +o gjanssens
02:43:44 <gjanssens> .
02:44:08 *** fekepp has quit IRC
03:11:37 *** fekepp has joined #gnucash
03:17:22 *** fekepp has quit IRC
03:18:49 *** fekepp has joined #gnucash
03:21:54 *** fekepp has quit IRC
03:23:03 *** ncv_ has joined #gnucash
03:23:52 *** fekepp has joined #gnucash
04:36:46 *** jethrogb has quit IRC
04:39:37 *** pilotauto has quit IRC
05:02:47 *** mipesom has joined #gnucash
05:25:53 *** jethrogb has joined #gnucash
05:52:24 *** mipesom has quit IRC
06:06:23 *** kus has joined #gnucash
06:19:09 *** kus has quit IRC
06:32:26 *** kus has joined #gnucash
07:54:27 *** bob_ has joined #gnucash
08:04:58 *** oozer has joined #gnucash
08:38:27 *** fekepp has quit IRC
08:38:36 *** mipesom has joined #gnucash
08:38:39 *** fekepp has joined #gnucash
08:50:05 *** bob_ has quit IRC
09:28:50 *** Jimraehl1 has joined #gnucash
09:33:07 *** Jimraehl1 has left #gnucash
09:47:40 *** Robert has joined #gnucash
09:51:56 *** fabior has joined #gnucash
10:03:18 *** tuxd00d has joined #gnucash
10:03:21 *** darshan1 has joined #gnucash
10:03:59 *** NestorZ has joined #gnucash
10:04:06 *** darshan1 has quit IRC
10:04:34 *** darshan1 has joined #gnucash
10:11:53 *** ArtGravity has joined #gnucash
10:14:44 *** oozer has quit IRC
10:25:04 <warlord> .
10:28:05 *** xmaka has quit IRC
10:32:58 *** xmaka has joined #gnucash
10:38:09 *** xmaka has quit IRC
10:42:08 *** xmaka has joined #gnucash
10:43:43 *** xmaka has quit IRC
10:43:44 *** xmaka has joined #gnucash
11:03:33 *** fekepp has quit IRC
11:08:36 *** chris has joined #gnucash
11:09:27 *** darshan1 has quit IRC
11:09:38 <chris> .
11:15:52 <Robert> Hi, I need to get the detailed debug info from Windows and I can't remember where the instructions are to do that. GnuCash is crashing and I think I finally know a way to repeat it
11:20:28 *** oozer has joined #gnucash
11:30:10 <Robert> The procedure to get the detailed trace file is not where I thought it was in FAQ
11:30:10 *** oozer has quit IRC
11:32:34 <warlord> Robert: https://wiki.gnucash.org/wiki/TraceFile ?
11:33:04 <Robert> that link is dead
11:34:30 <Robert> ...kind of
11:34:54 <Robert> definitely not useful
11:36:20 <warlord> Robert: oops, it's Tracefile not TraceFile
11:36:34 <warlord> https://wiki.gnucash.org/wiki/Tracefile
11:36:51 <Robert> better
11:46:19 <Robert> I thought that I needed to run GnuCash under a special program to get enough details. That is not explained here.
11:47:46 *** jralls has joined #gnucash
11:47:47 *** ChanServ sets mode: +o jralls
11:49:17 <warlord> Robert: it depends what "enough detail" you are looking for
11:49:30 <warlord> Are you looking for a trace file? Or a Stack Trace?
11:49:56 <warlord> If a stack trace: https://wiki.gnucash.org/wiki/Stacktrace
11:50:18 <jralls> Robert: Depends on what kind of debug info you want. If you want to run GnuCash under a debugger then you need to set up a MinGW environment and install gdb in it. OTOH you can run GnuCash from a shell (CMD or PowerShell) and pass it arguments to get more messages in the trace file.
12:01:18 *** Mechtilde has joined #gnucash
12:03:10 *** NestorZ has quit IRC
12:04:07 <Robert> Not sure how much you need. I created bug 794181 to submit the regular tracefile
12:06:58 <Robert> If that is not adequate I could try running from the command line most easily
12:14:36 <jralls> Robert: Why are you masking your identity? Yes, the tracefile attached to 794181 doesn't tell me anything so at least run from the command line and use options --debug --extra. Attach the whole tracefile, and remember to change the file type to "text/plain".
12:19:29 <Robert> It is a long story about masking but it is summarized by having multiple laptops with different computer names and just using defaults when setting up pidgin.
12:20:41 <Robert> That short tracefile is all she wrote. The reason I thought you would need more
12:21:35 *** fabior has quit IRC
12:22:48 <Robert> It will take a while to do the next step, probably several hours including lunch and walking dogs, etc.
12:26:46 <Mechtilde> .
12:47:35 *** Mechtilde has quit IRC
12:48:47 *** Mechtilde has joined #gnucash
12:56:38 *** fabior has joined #gnucash
13:00:46 *** oozer has joined #gnucash
13:01:31 *** fabior has quit IRC
13:13:16 <jralls> gjanssens: I'd think that getting used to PRs is a good thing!
13:13:43 <gjanssens> jralls: it is :)
13:15:12 <jralls> Since we're going to have to do something about BZ sometime in the next year or two, it would be nice to have something that integrates well with Github and doesn't suck like Github/Gitlab's issue tracker.
13:16:46 <jralls> Maybe that's too strong. "Doesn't rely entirely on tags for categorization" would be better, I suppose.
13:27:30 <jralls> gjanssens: Separate issue: https://bugzilla.gnome.org/show_bug.cgi?id=794137#c2. I'm planning a work-around template specialization for GncNumeric::operator<< <char> that uses a basic_ostringstream<utf16> to stringify the number and then transcodes it to utf-8. I suppose we'll need to do something similar for operator>> and the string constructor.
13:27:48 <jralls> But it makes me wonder where else that problem might pop up.
13:35:21 <jralls> Meanwhile, back at Windows I can't reproduce the failure on the build VM on my locale one so I just blew away the whole "unstable" branch on the build VM and started a clean build.
13:52:35 <gjanssens> jralls: perhaps the csv importer is affected as well
13:52:48 <gjanssens> It's also reading files via a stringstream
13:53:54 <jralls> How does it handle numbers? Does it use the GncNumeric operator>>?
13:57:54 *** ncv_ has quit IRC
13:58:38 <gjanssens> Not yet, it's currently still xaccParseAmount
13:58:46 <gjanssens> still using*
13:59:21 <gjanssens> jralls: I have to leave in a few minutes but I wanted to check our roadmap with you
13:59:30 <jralls> No problem then until you decide to switch.
13:59:40 <jralls> OK.
13:59:45 <gjanssens> Do you think we'll be ready to release 3.0 by the end of March ?
14:00:58 <jralls> I'd like to, but you're away for the second half. Do you have anything left that needs to be done before 3.0?
14:01:07 <gjanssens> That more or less means will *you* be ready by then, because I'll be afk starting Sunday until March 26
14:02:01 <gjanssens> I don't have any blocking bugs as far as I know, and today I pushed the final data format altering changes I had in mind
14:02:34 <gjanssens> I didn't get to writing a full unit test suite for the csv importer as I had hoped so there may be hidden bugs in there still.
14:02:36 <gjanssens> BRB
14:03:15 <gjanssens> Or better yet, BBL, I'll try to continue in an hour or 2
14:03:19 *** gjanssens is now known as gjanssens_afk
14:03:42 <jralls> OK. I plan to do a release this weekend and weekly after that.
14:03:54 *** josephcocoa has joined #gnucash
14:16:40 *** mipesom has quit IRC
14:23:12 *** frakturfreak has joined #gnucash
14:31:43 *** mipesom has joined #gnucash
14:59:38 *** Mechtilde has quit IRC
15:00:19 *** Mechtilde has joined #gnucash
15:14:08 *** Mechtilde has quit IRC
15:36:48 *** gncbot sets mode: +o fell
15:41:16 *** Grav has joined #gnucash
15:41:25 *** ArtGravity has quit IRC
16:01:49 <fell> jralls: about https://wiki.gnucash.org/wiki/Account_Hierarchy_Template#Future_Development and DiMans PRs 300ff I think we take for now the direct namespacing, OK?
16:20:05 *** tuxd00d has quit IRC
16:27:20 *** josephcocoa has quit IRC
16:30:34 *** frakturfreak has quit IRC
16:35:48 <jralls> fell: You mean "non-namespaces" rather than "direct namespacing", I think. If there's no xmlns: declaration then they're just identifiers with colons in the middle. As long as we don't try to do any namespace magic on them it should be OK.
16:37:35 <fell> This section: https://wiki.gnucash.org/wiki/Account_Hierarchy_Template#Adjust_the_Header
16:38:49 <fell> between gnc-ccount-example and gnc-acct:title
16:42:04 <fell> Then I wiill ask him to apply the change on the other locales, too. Then we can use xmllint in make check.
16:53:30 <jralls> Um, yes, that's my understanding of how it works. So I don't know what is the alternative that you imply.
16:55:01 <fell> Put the Namespace declarations in an DTD and reference that in the templates.
17:05:51 <jralls> I don't think that works. IIUC one can declare namespaces in schemas but not DTDs because the DTD syntax predates the invention of namespaces.
17:08:40 <fell> So it is something to read if there is some spare time.
17:09:06 *** pilotauto has joined #gnucash
17:21:07 *** User_ has joined #gnucash
17:31:46 *** ArtGravity has joined #gnucash
17:32:01 *** Grav has quit IRC
17:35:30 *** gjanssens_afk is now known as gjanssens
17:40:44 <gjanssens> jralls: Ok on the release schedule
17:41:03 <gjanssens> What should still be done from your point of view ?
17:43:01 *** User_ has quit IRC
17:44:18 <jralls> Well, first of all windows needs to get sorted. I'd like to fix Dmitry's python test failure if I can figure out how to reproduce it. The Gtk input methods seem to be whacked on Windows. There are a few crasher and data-integrity bugs, most of which are in "needinfo".
17:46:23 *** User_ has joined #gnucash
17:46:45 <jralls> There are a couple of other tweaks, like https://bugzilla.gnome.org/show_bug.cgi?id=789594 that I'd like to get done if there's time.
17:51:07 <jralls> On the windows build, wiping the whole "unstable" tree fixed the unittest-support guile problem but failed to find appdata.its.
17:51:15 <gjanssens> jralls: ok. So still quite some Windows work :(
17:51:48 <gjanssens> Odd... Did the GETTEXTDATADIR setting get lost ?
17:52:31 <jralls> I don't think so. It's in jhbuildrc.
17:52:52 <gjanssens> On your own Windows machine or the build server ?
17:53:04 <jralls> On the build server. I'm in there now.
17:57:45 <gjanssens> Ok.
17:59:33 <jralls> I just adjusted the path to start at _basedir instead of /mingw32, though /mingw32 works on my local VM.
18:01:40 *** User_ has quit IRC
18:02:44 *** oozer has quit IRC
18:02:45 *** mipesom has quit IRC
18:03:12 <jralls> No joy.
18:04:05 *** oozer has joined #gnucash
18:04:56 *** ArtGravity has quit IRC
18:07:54 *** oozer_ has joined #gnucash
18:09:27 *** mipesom has joined #gnucash
18:09:29 <gjanssens> Damn...
18:09:39 <gjanssens> And the files are there where we expect them ?
18:10:56 <jralls> Yeah. I thought there might be a version mis-match issue, gettext --version reports 0.19.8.1, so I made a symlink. Still fails.
18:11:29 <jralls> Does appdata.xml actually do anything in Windows? Maybe we should just disable it.
18:12:41 <jralls> Or maybe even more to the point, does running msgfmt on windows even make sense?
18:18:11 *** oozer_ has quit IRC
18:19:50 <jralls> OH. Sigh. I had set GETTEXTDATADIRS instead of GETTEXTDATADIR.
18:20:22 *** mipesom has quit IRC
18:21:06 <jralls> Why it worked on my local VM and not the build one is a mystery, but now it works.
18:21:23 <gjanssens> Hah, that's a subtle but important difference...
18:21:46 <gjanssens> I was about to reply we don't really use the desktop and appdata files on Windows
18:22:16 <gjanssens> But if we can avoid platform build exceptions I prefer that even more
18:22:33 <gjanssens> And it would be nice to have if we can also generate .po files on Windows
18:22:51 <gjanssens> Should some windows user feel the urge to work on translations
18:28:45 <jralls> On the topic of translations, I wonder if we should drop a few of the long-unmaintained ones, especially those that have only a few strings. I'm thinking of az and kr in particular.
18:33:34 <gjanssens> That thought has crossed my mind as well. I don't see kr on the tp, but there's rw.
18:34:04 <gjanssens> I'd suggest any language in red on the tp are good candidates for removal.
18:34:27 <gjanssens> Or should we just prevent them from being installed instead ?
18:34:47 <jralls> Sorry, yes, rw. Some got the "k" from its name.
18:36:34 <jralls> We could make them not installed. The only issue would be in the extremely unlikely event that someone comes along with a new translation we'd have to remember to turn them back on as well as committing the new po.
18:39:45 <gjanssens> If we forget the translator will no doubt remind us the translation is still not available, but otherwise a good point.
18:40:14 <gjanssens> It's high time for bed. Unless you still have something urgent, I'll be off
18:41:34 *** benoitg has joined #gnucash
18:42:23 <gjanssens> Good luck with further code polishing and release preparations!
18:42:32 *** KettleBlack has joined #gnucash
18:43:33 <jralls> OK, Good night.
18:44:17 *** gjanssens has quit IRC
18:44:51 *** KettleBlack has left #gnucash
18:46:32 *** jralls_ has joined #gnucash
18:48:47 *** jralls has quit IRC
18:49:19 *** jralls_ has quit IRC
19:03:06 *** jralls has joined #gnucash
19:03:07 *** ChanServ sets mode: +o jralls
19:08:55 <chris> I've succeeded in combining html-barchart.scm and -linechart.scm, and barchart now works well. will fix linechart soon.
19:19:14 <chris> guile-json makes it so easy
19:22:29 *** josephcocoa has joined #gnucash
19:24:50 *** chris has quit IRC
20:44:20 *** kus has quit IRC
20:48:21 *** kus has joined #gnucash
21:01:28 *** oozer has quit IRC
22:18:02 *** robin has quit IRC
22:26:57 *** kus has quit IRC
22:55:48 *** lispmacs has quit IRC
22:58:20 *** benoitg has quit IRC
23:34:28 *** mipesom has joined #gnucash
23:47:48 *** josephcocoa has quit IRC