2017-03-02 GnuCash IRC logs

00:26:58 *** O01eg has quit IRC
00:33:26 *** fell has quit IRC
01:23:16 *** Mechtilde has joined #gnucash
01:58:34 *** Mechtilde has quit IRC
01:58:57 *** mirage335 has quit IRC
02:34:32 *** fekepp has joined #gnucash
03:00:49 *** fabior has joined #gnucash
03:05:57 *** gnomey has quit IRC
03:11:27 *** gnomey has joined #gnucash
03:22:45 *** fabior has quit IRC
03:44:26 *** serrador has joined #gnucash
03:47:30 *** mrklintscher has joined #gnucash
03:47:41 *** gjanssens has joined #gnucash
03:47:41 *** ChanServ sets mode: +o gjanssens
03:50:42 *** fabior has joined #gnucash
04:00:20 *** Artefact2 has quit IRC
04:00:45 *** Artefact2 has joined #gnucash
04:06:30 *** fabior has quit IRC
04:07:36 *** serrador has quit IRC
05:08:17 *** fekepp has quit IRC
05:27:31 *** fabior has joined #gnucash
05:40:16 *** fabior has quit IRC
05:40:33 *** To7 has quit IRC
05:55:35 *** fekepp has joined #gnucash
06:19:43 *** Jimraeh1 has joined #gnucash
06:20:21 *** Jimraeh1 has quit IRC
06:27:33 *** User has joined #gnucash
06:31:50 *** User has quit IRC
06:43:49 *** fabior has joined #gnucash
06:48:37 *** fabior has quit IRC
06:49:52 *** fabior has joined #gnucash
06:55:15 *** Jimraehl1 has joined #gnucash
06:55:51 *** Jimraehl1 has quit IRC
07:07:02 *** mib_9xuuxr has joined #gnucash
07:12:40 <mib_9xuuxr> I have a problem with invoice importation and/or payment allocation. I am importing invoices in a batch file, which seems to work: the invoices show the correct subtotal and tax, if I view the invoice.
07:14:24 <mib_9xuuxr> But if I try to assign a payment to an invoice, in the Process Payment dialog I only see the tax element of the invoice. This also applies in the Customer Report, which therefore shows a big overpayment.
07:14:36 <mib_9xuuxr> Where am I going wrong?
07:17:27 *** To7 has joined #gnucash
07:24:37 *** mlncn has joined #gnucash
07:26:01 *** User has joined #gnucash
07:28:16 *** User_ has joined #gnucash
07:30:25 *** User has quit IRC
07:53:36 *** rickoehn has joined #gnucash
08:06:17 *** fell has joined #gnucash
08:40:39 *** fabior has joined #gnucash
08:45:54 *** storyjesse has joined #gnucash
08:56:47 *** fabior has quit IRC
09:25:17 <mib_9xuuxr> Back!
09:25:38 *** tuxd00d has quit IRC
09:36:15 *** storyjesse has quit IRC
10:02:39 <MrKeuner> what does reconcilation do? Why needed?
10:05:51 <mib_9xuuxr> It confirms that every item in your bank statement is included in your accounts.
10:18:18 *** fabior has joined #gnucash
10:27:07 *** fabior has quit IRC
10:38:20 *** O01eg has joined #gnucash
10:42:00 *** miklcct_ has joined #gnucash
10:42:02 *** miklcct has quit IRC
10:54:30 *** tuxd00d has joined #gnucash
11:31:27 *** warlord has joined #gnucash
11:31:27 *** gncbot sets mode: +o warlord
11:49:41 <MrKeuner> mib_9xuuxr, I would reconcile only if I import OFX from my bank account?
11:55:44 <mib_9xuuxr> No, you can do it with any type of statement. It's just a checking routine showing that you've matched the transactions in your accounts bank account(s) with the relevant bank statement(s).
11:59:55 <warlord> MrKeuner: FWIW, I only reconcile, manually, using the monthly bank statements.
12:07:20 *** gncbot sets mode: +o fell
12:16:32 *** fabior has joined #gnucash
12:18:37 *** Mechtilde has joined #gnucash
12:34:47 *** mirage335 has joined #gnucash
12:39:39 *** mrklintscher has quit IRC
12:42:36 *** tuxd00d has quit IRC
12:54:28 <fell> gjanssens: could you write down your expirience with kdevelop in the wiki?
13:03:12 *** fabior has quit IRC
13:11:45 *** fabior has joined #gnucash
13:15:06 *** fabior has quit IRC
13:43:23 *** KaiForce has joined #gnucash
13:54:25 *** fabior has joined #gnucash
13:55:08 *** kael has joined #gnucash
13:59:00 *** fabior has quit IRC
14:00:45 *** mlncn has quit IRC
14:05:03 *** mib_9xuuxr has left #gnucash
14:05:37 *** mib_9xuuxr has joined #gnucash
14:15:45 *** frakturfreak has joined #gnucash
14:16:21 *** tuxd00d has joined #gnucash
14:17:18 *** kael has quit IRC
14:26:23 *** mlncn has joined #gnucash
14:32:16 *** Mechtilde has quit IRC
14:33:36 <MrKeuner> warlord, mib_9xuuxr sorry a financial software beginner here. What is a statement?
14:34:15 *** tuxd00d has quit IRC
14:34:41 <mib_9xuuxr> your bank gives you a list of the transactions on your account: that's called a statement
14:35:08 <MrKeuner> ah i see.
14:36:24 <MrKeuner> simply type in or import transactions in a statement and reconcile to see if anything falls into imbalance?
14:39:29 <mib_9xuuxr> to see if you've missed anything, and that it's all accurate, yes
14:41:06 <MrKeuner> thank you
15:10:56 *** tuxd00d has joined #gnucash
15:24:56 *** kriesel has joined #gnucash
15:26:31 <kriesel> I am trying to build the git master on Mac OS X. While it worked for me once it now always fails with "ice-9/boot-9.scm:109:20: In procedure dynamic-link: file: "libtest-core-guile", message: "file not found" make[3]: *** [unittest-support.go] Error 1"
15:26:42 <kriesel> Any idea?
15:42:40 *** tuxd00d has quit IRC
15:51:55 *** tuxd00d has joined #gnucash
16:01:06 *** fabior has joined #gnucash
16:16:25 *** tuxd00d_ has joined #gnucash
16:16:25 *** karl has joined #gnucash
16:16:57 *** tuxd00d has quit IRC
16:16:59 *** tuxd00d_ is now known as tuxd00d
16:17:51 *** gjanssens has quit IRC
16:20:54 *** karl has left #gnucash
16:27:06 <jralls> kreisel: What build environment are you using?
16:29:06 *** frakturfreak has quit IRC
16:30:03 <kriesel> Quartz/jhbuild
16:34:33 *** kriesel1 has joined #gnucash
16:35:32 *** kriesel1 has quit IRC
16:44:27 <jralls> kreisel: Did you try removing the guile caches in ~/caches/guile and $PREFIX/lib/gnucash/scm/ccache?
16:45:37 <kriesel> jralls: no. will try
16:47:00 <jralls> If that doesn't do it I suggest building libtool with -DLT_DEBUG_LODERS in CFLAGS. That will cause ltdl to spew a bunch of debug messages that will help figure out what exactly it can't find.
17:01:48 *** jonas has quit IRC
17:06:49 *** jonas has joined #gnucash
17:11:50 *** tuxd00d has quit IRC
17:12:56 *** tuxd00d has joined #gnucash
17:12:58 <kriesel> Clearing caches did not help. I am doing a full build now. If that doesn't help I will do the libtool thing. But that will need to wait...
17:16:47 *** User_ has quit IRC
17:22:56 *** mlncn has quit IRC
17:33:17 *** tuxd00d has quit IRC
17:33:22 *** tuxd00d has joined #gnucash
17:41:47 *** mib_9xuuxr has quit IRC
17:49:48 *** KaiForce has quit IRC
18:01:52 *** User_ has joined #gnucash
18:03:09 *** fekepp has quit IRC
18:03:28 <MrKeuner> how to record mortgage payments in a home Mortgage account? Just add principal payment transactions?
18:03:44 <mirage335> Any scheme developers in here?
18:04:38 <MrKeuner> hmm, naturally, if balance shows interest to be paid, then record interest payments, as well, right?
18:04:58 <MrKeuner> if not (my case) then record them elsewhere?
18:06:01 *** tuxd00d has quit IRC
18:16:46 <jralls> MrKeuner: If you're doing it manually, you should have a Liability account with the loan amount, an Expense account for interest, and maybe an Expense account for fees and whatever. Each payment would have a split for each, and if the lender's statements don't break out the amounts they can probably provide you with a spreadsheet that does.
18:19:21 <MrKeuner> jralls, got it, thanks
18:19:27 <MrKeuner> yes doing manually.
18:19:34 <MrKeuner> Learning to do manually before automating things
18:20:50 <MrKeuner> just noticed a mortgage interest account under expenses:Interest :)
18:24:15 <jralls> The mortgage assistant helps create scheduled transactions, but because it's nearly impossible to duplicate exactly how the bank sets up the loan you almost always wind up with the SXs being close but not quite right and having to adjust them each month to match the statement.
18:24:18 *** tuxd00d has joined #gnucash
18:26:04 *** mlncn has joined #gnucash
18:26:28 <MrKeuner> Doesn't 2.6.4 have a mortgage assistant? or is it loan repayment calculator you are referring to?
18:28:05 <MrKeuner> Nevermind, found it, under Actions/Scheduled/...
18:39:43 *** mlncn has quit IRC
18:43:18 *** tuxd00d has quit IRC
18:50:32 *** fabior has quit IRC
18:55:38 *** tuxd00d has joined #gnucash
19:02:51 *** kael has joined #gnucash
19:03:38 <mirage335> jralls: Are *any* core GNUCash developers really in here or on the mailing list?
19:04:07 <mirage335> I've been trying to get someone to look at my reporting script for about a day now, and I'm wondering if it's a lost cause.
19:06:03 *** warlord has quit IRC
19:06:07 <jralls> mirage335: Yes, I'm a core developer, but I'm not fluent in Scheme nor very familiar with the report code. warlord is more conversant with both, but may not be at his computer just now.
19:06:34 <mirage335> Thanks. Good to know someone's out there. I'll keep waiting.
19:06:41 <jralls> What's going wrong with your "reporting script"?
19:07:25 <mirage335> http://pastebin.com/yFUHpQ34
19:07:40 <mirage335> It works if I output "text" to the html, but not if I actually try to read out an account balance.
19:08:43 <mirage335> I think it might be an array, rather than a variable, but I think I need someone more knowledgeable of the GNUCash scheme API to determine how to properly read it out.
19:10:05 <jralls> Are you talking about lines 198 and 199? if 199 is uncommented then it displays but if 198 is nothing happens? Or do you get a scheme exception?
19:10:14 <mirage335> The goal is to calculate simple things like Working Capital, Cash Buffer, and Cash Ratio from specific accounts.
19:10:18 <mirage335> Yeah, those lines.
19:10:35 <mirage335> Not sure what errors I get, mostly seem to be from unrelated deeper scheme functions in GNUCash.
19:12:16 <jralls> When scheme throws an exception it dumps a stack trace with the last call, the one that threw, at the bottom.
19:12:47 <jralls> How about putting one up on pastebin?
19:20:31 *** kael has quit IRC
19:23:11 <mirage335> Ok. I'll share that with interested developers.
19:36:54 *** tuxd00d has quit IRC
19:38:39 *** tuxd00d has joined #gnucash
19:40:09 *** tuxd00d has quit IRC
19:44:52 *** gnomey has quit IRC
19:45:30 *** gnomey has joined #gnucash
19:46:09 <mirage335> jralls: Do you think implementing some SQL code might be a better approach than trying to use this scheme report generator I've been working on?
19:46:45 <jralls> I don't know if it would be better, but unless you're really fluent in Scheme it would surely be easier!
19:46:51 <mirage335> heh
19:47:20 <mirage335> Maybe a better question would be, what do you think would be the best approach to extending GNUCash report functionality would be currently, given the state of the project today?
19:49:09 <jralls> We've had a couple of discussions about that. I think ideally it would be to point a 3rd-party report generator like Crystal Reports at it, but unfortunately there don't seem to be any FOSS ones.
19:50:10 <mirage335> So I'm not the only one to see a need for a better reporting tool in the FOSS world. Interesting.
19:50:24 <mirage335> How would a tool like Crystal Reports access the GNUCash data? SQL?
19:50:53 <jralls> I had a thought recently that maybe we could provide a simple query-and-report parser in C++ and point YAML report descriptions at it. That would be within reach of many users who are unable to write code.
19:51:00 <jralls> Yes, SQL.
19:51:39 <mirage335> Default save format for GNUCash seems to be XML. Is that intended to remain the case going forward?
19:53:11 <jralls> Unfortunately I didn't get far enough along in rewriting the backend and engine to be able to change to SQL for the next major release at the end of this year, but in order for GnuCash to be a SQL application it must obviously connect to a database, not an XML file.
19:53:38 <mirage335> Ah.
19:53:38 <jralls> The XML format would be retained for backup and data exchange.
19:54:08 *** karelk has quit IRC
19:54:21 <mirage335> So, XML and SQLite would both continue to be supported, but SQL type systems would really be the 'native' format.
19:56:26 <mirage335> jralls: What do you think about building a WebUI for the GNUCash SQL db?
19:56:38 <jralls> Correct. MySQL and PostgresQL are also and will continue to be supported.
19:57:52 *** rickoehn has quit IRC
19:57:57 <jralls> Not much, I don't really like WebUIs.
19:58:07 <mirage335> ok
19:58:16 <mirage335> Interesting.
19:58:25 <jralls> It's time for me to make dinner. Goodnight.
19:58:42 <mirage335> Goodnight, and thanks for helping me understand more about GNUCash development.
20:08:05 *** karelk has joined #gnucash
20:25:21 *** warlord has joined #gnucash
20:25:22 *** gncbot sets mode: +o warlord
21:24:23 *** User_ has quit IRC
21:32:26 *** tuxd00d has joined #gnucash
21:37:08 *** tuxd00d has quit IRC
21:42:44 *** storyjesse has joined #gnucash
22:01:53 *** kael has joined #gnucash
22:15:23 *** MrWhite has joined #gnucash
22:17:30 *** kael has quit IRC
22:52:51 *** mlncn has joined #gnucash