2019-07-13 GnuCash IRC logs

00:12:03 *** omnireq has joined #gnucash
00:20:12 *** jangid has joined #gnucash
00:33:19 *** jangid has quit IRC
00:49:57 *** davidyon__ has joined #gnucash
00:50:23 *** davidyon_ has quit IRC
00:53:13 *** omnireq has quit IRC
00:56:43 *** omnireq has joined #gnucash
00:56:43 *** ChanServ sets mode: +v omnireq
01:11:07 *** Mechtilde has joined #gnucash
01:12:55 <chris> @tell gjanssens I've merged envelope-budgeting into budget.scm -- my query is whether the terminology is correct. It replicates Phil Longstaff's ytd-budget.scm functionality. We can modify option name to a better one.
01:12:55 <gncbot> chris: The operation succeeded.
01:18:53 *** jangid has joined #gnucash
01:24:16 *** jangid has quit IRC
01:24:52 *** jangid has joined #gnucash
01:24:52 *** ChanServ sets mode: +v jangid
01:43:11 *** sokol99 has joined #gnucash
01:44:14 *** ChanServ sets mode: +v sokol99
01:45:53 *** jangid has quit IRC
01:47:27 <sokol99> Another quick question... When setting up several online accounts what causes previously configured accounts to cease being available for online actions? ..I'm hoping not to have to delete and reconfigure these previously-functioning accounts but am not sure what's happening.
01:53:59 *** Aussie_matt has joined #gnucash
01:54:49 *** boustrophedon has left #gnucash
02:21:03 *** bertbob has quit IRC
02:23:27 *** bertbob has joined #gnucash
02:23:28 *** ChanServ sets mode: +v bertbob
02:33:35 *** jangid has joined #gnucash
02:33:35 *** ChanServ sets mode: +v jangid
03:06:49 *** boldstripe has joined #gnucash
03:24:59 *** Scrounger has joined #gnucash
03:48:14 *** davidyon__ has quit IRC
03:48:50 *** davidyon has joined #gnucash
03:48:50 *** ChanServ sets mode: +v davidyon
03:49:16 *** Scrounger has quit IRC
03:51:25 *** davidyon has quit IRC
03:55:20 *** jangid has quit IRC
03:55:45 *** jangid has joined #gnucash
03:55:45 *** ChanServ sets mode: +v jangid
04:08:12 *** fell_laptop has quit IRC
04:12:41 *** davidyon has joined #gnucash
04:14:30 *** ChanServ sets mode: +v davidyon
04:37:54 *** fell_laptop has joined #gnucash
04:37:55 *** ChanServ sets mode: +o fell_laptop
04:41:13 *** fell_laptop is now known as fell
04:42:52 *** fabior has joined #gnucash
04:46:42 *** davidyon has quit IRC
04:49:52 *** davidyon has joined #gnucash
05:18:37 <chris> warlord: do open invoices *always* have associated lot? The lot definition states it opens with a split, which I understand means a lot exists in an account
05:19:29 <chris> IIUC invoices can exist in isolation, and gets a lot/txn only when posted
05:19:50 *** boldstripe has quit IRC
05:20:49 *** boldstripe has joined #gnucash
05:22:21 <chris> perhaps my question is - how to retrieve a list of all invoices using API; scanning APAR accs yields only posted invoices
05:28:03 *** jangid has quit IRC
05:43:42 *** jangid has joined #gnucash
05:43:42 *** ChanServ sets mode: +v jangid
05:46:31 *** jangid has quit IRC
06:28:39 *** User has joined #gnucash
06:36:50 *** mr_sm11th has joined #gnucash
06:36:50 *** ChanServ sets mode: +v mr_sm11th
06:37:59 *** fell has quit IRC
06:50:45 *** jangid has joined #gnucash
06:50:45 *** ChanServ sets mode: +v jangid
06:57:48 *** fabior has quit IRC
07:08:44 *** jangid has quit IRC
07:13:49 *** jangid has joined #gnucash
07:13:49 *** ChanServ sets mode: +v jangid
07:20:30 *** boldstripe has quit IRC
07:21:27 *** boldstripe has joined #gnucash
07:22:03 *** Aussie_matt has quit IRC
07:24:20 *** jangid has quit IRC
07:38:20 *** fabior has joined #gnucash
07:39:19 *** jangid has joined #gnucash
07:42:08 *** jangid has quit IRC
07:44:01 *** jangid has joined #gnucash
07:44:02 *** ChanServ sets mode: +v jangid
07:55:52 *** Scrounger has joined #gnucash
07:58:16 *** User has quit IRC
07:59:43 *** warlord has quit IRC
08:01:31 *** warlord has joined #gnucash
08:01:31 *** gncbot sets mode: +o warlord
08:05:34 *** Scrounger has left #gnucash
08:09:26 *** Scrounger has joined #gnucash
08:09:26 *** ChanServ sets mode: +v Scrounger
08:10:07 <Scrounger> Hello, Bonjour, Grusdich, &c. I am having a problem with fetching stock price quotes from online.
08:10:32 <Scrounger> I have gotten myself a free license code.
08:11:00 <Scrounger> I installed Perl separately because the automotic installation didn't work (details 'pon request)
08:11:23 <Scrounger> Now when I try to update prices, it opens a window and does nothing else - it stalls.
08:14:21 <Scrounger> Hm.
08:15:13 <Scrounger> May have been a network issue. While typing at you good people, it seems to have decided to work.
08:15:53 <Scrounger> Took awhile, though - I had enough time to ponder it, make a drink, try a few more times, register with /nickserv, and /join this channel with +v.
08:16:18 <Scrounger> Thanks, I guess. Seeya the next time it acts weird... ;-)
08:17:01 *** Scrounger has quit IRC
08:31:08 *** Jimraehl1 has joined #gnucash
08:31:36 *** Jimraehl1 has left #gnucash
08:33:11 <warlord> chris, define "open". the lot only gets created when the invoice is posted.
08:33:42 <warlord> chris, correct, AR/AP is only posted invoices. You would need to go through the Query API to obtain unposted invoices.
08:33:49 <warlord> There is no other way to access them.
08:42:04 <chris> warlord: ok I figured as such. owner-report can only find posted invoices. I found gncBusinessGetOwnerList to get book's owners, but there's no gncOwnerGetInvoices
08:42:49 <chris> I don't understand Query.h enough to retrieve all invoices
08:43:25 <chris> oh I think it's qofQuery.h now
08:43:57 <chris> Query.h seems old school
08:44:38 <warlord> Note that unposted invoices technically "don't exist". They could be a trial, or in progress.. So owner report should NOT report on them!
08:45:11 <chris> ok...
08:52:17 *** warlord has quit IRC
08:53:33 *** fell has joined #gnucash
08:53:34 *** ChanServ sets mode: +o fell
08:53:34 *** warlord has joined #gnucash
08:53:34 *** gncbot sets mode: +o warlord
08:55:43 *** warlord has quit IRC
08:58:57 *** warlord has joined #gnucash
08:58:57 *** gncbot sets mode: +o warlord
09:10:42 *** jerryq has quit IRC
09:14:26 *** jerryq has joined #gnucash
09:21:10 *** boldstripe has quit IRC
09:22:05 *** boldstripe has joined #gnucash
09:42:08 *** marlon has joined #gnucash
09:55:30 *** User has joined #gnucash
10:29:24 <chris> `warlord: does https://imgur.com/a/i7mU1AP look like a good set of invoices/payments/CN to test owner-report? did I get the signs correct? note owner-report is not yet modified in this report
10:30:32 <warlord> chris, probably.
10:32:32 <chris> the last challenge is to create a payment and apply to multiple invoices
10:33:04 <chris> IOW invoice = increase owner balance, CN/payment = decrease owner balance?
10:48:21 *** jangid has quit IRC
10:48:55 *** User has quit IRC
10:49:15 *** boldstripe_ has joined #gnucash
10:49:30 *** boldstripe has quit IRC
10:49:30 *** boldstripe_ is now known as boldstripe
10:49:58 *** oozer has joined #gnucash
10:51:34 *** fabior has quit IRC
10:51:37 *** fabior_ has joined #gnucash
10:54:08 *** boldstripe has quit IRC
11:07:49 *** fabior_ has quit IRC
11:34:57 *** jerryq has quit IRC
11:37:20 *** fell_laptop has joined #gnucash
11:37:20 *** fell has quit IRC
11:37:20 *** ChanServ sets mode: +o fell_laptop
11:45:45 *** fell_laptop is now known as fell
11:59:37 *** jerryq has joined #gnucash
12:07:55 *** fell has quit IRC
12:08:02 *** fell has joined #gnucash
12:08:02 *** ChanServ sets mode: +o fell
12:09:42 *** omnireq has quit IRC
12:19:53 *** seanh has joined #gnucash
12:20:29 *** seanh has joined #gnucash
12:31:19 *** omnireq has joined #gnucash
12:31:19 *** ChanServ sets mode: +v omnireq
12:46:10 *** mdf has joined #gnucash
12:46:10 *** ChanServ sets mode: +v mdf
13:03:17 *** jangid has joined #gnucash
13:03:17 *** ChanServ sets mode: +v jangid
13:11:47 *** davidyon has quit IRC
13:14:18 *** fabior has joined #gnucash
13:16:51 <jralls> soko199: Each online account has a one-to-one relationship with a GnuCash account. That's managed on the third page of the Online Banking Assistant. Only the GnuCash accounts matched to online accounts will enable the online actions.
13:19:31 <jralls> warlord: I don't think that the importers are exposed to Python.
13:22:06 *** fabior has quit IRC
13:37:45 *** jervin has joined #gnucash
14:00:51 *** phoenix has joined #gnucash
14:07:42 *** oozer has quit IRC
14:18:54 *** jangid has quit IRC
14:19:43 *** jangid has joined #gnucash
14:19:43 *** ChanServ sets mode: +v jangid
14:25:19 *** jervin has quit IRC
14:26:07 *** jervin has joined #gnucash
14:26:19 *** jervin has joined #gnucash
14:30:00 <warlord> jralls, you're right, i don't think the importers are..
14:32:22 *** frakturfreak has joined #gnucash
14:45:08 *** phoenix has quit IRC
14:48:26 *** bertbob has quit IRC
14:52:20 *** guak has joined #gnucash
14:54:48 *** jervin has quit IRC
15:48:50 *** sokol99 has quit IRC
15:49:11 *** sokol99 has joined #gnucash
15:53:16 *** marlon has quit IRC
16:09:57 *** sokol99 has quit IRC
16:13:09 *** bertbob has joined #gnucash
16:13:10 *** ChanServ sets mode: +v bertbob
16:22:29 *** sokol99 has joined #gnucash
16:23:35 *** ChanServ sets mode: +v sokol99
16:24:54 <sokol99> jralls: thank you. So, when I'm setting up a new account (unsuccessfully), is that breaking the linkage of already-existing accounts such that I don't have access to the online actions like updating?
16:36:25 *** jangid has quit IRC
16:39:17 *** frakturfreak has quit IRC
16:44:52 *** frakturfreak has joined #gnucash
16:50:16 *** fell has quit IRC
16:50:40 *** fell has joined #gnucash
16:50:40 *** ChanServ sets mode: +o fell
17:03:33 <jralls> soko199: Having the Online Banking Assistant open doesn't cause the Actions>Online Banking... menu items to be disabled for me. Is that what you're seeing?
17:08:44 *** Mechtilde has quit IRC
17:14:37 *** RASSRQ has joined #gnucash
17:15:32 *** mpiechotka has joined #gnucash
17:15:32 *** ChanServ sets mode: +v mpiechotka
17:17:19 *** RASSRQ1 has joined #gnucash
17:17:46 *** RASSRQ2 has joined #gnucash
17:20:26 *** phoenix has joined #gnucash
17:38:56 *** guak has quit IRC
17:51:48 *** mpiechotka has quit IRC
17:59:30 *** phoenix has quit IRC
18:18:06 *** RASSRQ2 has quit IRC
18:18:06 *** RASSRQ1 has quit IRC
18:18:07 *** RASSRQ has quit IRC
18:21:05 *** oozer has joined #gnucash
18:27:48 *** gnomey has quit IRC
18:28:09 *** gnomey has joined #gnucash
18:34:14 *** gnomey has quit IRC
18:43:17 *** omnireq has quit IRC
18:48:41 *** phoenix has joined #gnucash
18:49:19 *** seanh has quit IRC
18:52:48 *** phoenix has quit IRC
19:05:17 *** omnireq has joined #gnucash
19:05:17 *** ChanServ sets mode: +v omnireq
19:37:27 <sokol99> jralls: Hi jralls, no, what's happening is that I have set up 2 of 3 on line accounts. And when I had set them up, I had the option to to sync the transactions. Then, I try (unsucessfully so far) to add the third account and when I complete the account setup wizard the option is now no longer available. And if I delete the third, non functioning account, the option to sync the two remaining and previously working accounts remains grayed out.
19:39:09 <jralls> sokol99, Start the Online Banking Assistant and go to page 3 and make sure that the online account->gnucash account mapping is correct.
19:41:50 <sokol99> ok, thanks I'll take a look. Perhaps the mapping to the gnucash accounts was broken. I'll take a look.
19:49:41 <sokol99> jralls: Ok, when I go to that third page everything appears properly mapped to the corresponding gnucash account. ... When I'm actually in the aqbanking wizard however and I click on the accounts tab the name of the corresponding mapped gnucash account is not there for two of the accounts but there's no 'picker' for that and I'm not sure it matters. ...
19:52:05 <jralls> sokol99: It doesn't mattr if the account name in the AQBanking Setup Wizard matches the account you map it too, but IIRC it *does* matter that there's a name.
19:52:59 <jralls> So enter something (even "something" will work ;-) ) in the Account Name for each account.
20:01:38 <sokol99> ok, thanks I'll give it a try. :)
20:13:24 <sokol99> jralls: ok, i tried that but it didn't make a difference. What's odd is that these two accounts were working before I tried to set up the third. I also reverified the mapping to gnucash accounts was correct. ..Any other ideas why previously working accounts would stop being available for syncing?
20:16:17 <jralls> Well, when all else fails, I look at the code... so give me a minute.
20:18:11 <sokol99> ok. :) ..I have to step out in a few minutes but will check in when I get back.
20:23:16 <jralls> sokol99, you might try running GnuCash from the command line with `--log gnc.import.aqbanking=debug`. That will write a bunch of diagnostic messages to the tracefile that might shed some light on the problem.
20:28:56 *** oozer has quit IRC
20:40:48 *** seanh has joined #gnucash
20:41:17 *** seanh has quit IRC
20:41:22 *** seanh has joined #gnucash
20:46:51 <jralls> sokol99: The code says that it checks the Bank Code and Account Number (not the name) from the Accounts tab of AqBanking Setup. Each entry on the third page should say "Bank code xxxxx (bank name), Account yyyyy() zzzzz where xxxxx and yyyyy need to be numbers and zzzz is the name of the GnuCash account it's associated with. It's actually looking at data recorded on the GnuCash account, so it might help to double-click that, select something else
20:46:51 <jralls> then select the account you want and click OK.
21:18:05 *** gnomey has joined #gnucash
21:40:21 *** mr_sm11th has quit IRC
21:51:03 *** frakturfreak has quit IRC
22:15:14 <sokol99> thanks jralls, I will double check that. I did 'move' some of the accounts in the accounts 'tree' and maybe that broke the linkage somehow...
22:27:12 *** omnireq has quit IRC
22:28:41 *** omnireq has joined #gnucash
22:29:43 *** omnireq has quit IRC
22:29:53 *** omnireq has joined #gnucash
22:38:41 *** fell has quit IRC
22:42:16 *** fell has joined #gnucash
22:42:16 *** ChanServ sets mode: +o fell
22:50:38 *** seanh has quit IRC
22:53:51 *** Aussie_matt has joined #gnucash