2018-05-16 GnuCash IRC logs
00:29:57 *** Mechtilde has joined #gnucash
00:52:56 *** Skeletron has quit IRC
00:53:04 *** Skeletron has joined #gnucash
01:03:35 *** chris has joined #gnucash
01:04:49 *** fell has quit IRC
01:04:59 *** fell_laptop has quit IRC
01:06:01 *** fell has joined #gnucash
01:06:10 *** fell_laptop has joined #gnucash
01:06:11 *** Mechtilde has quit IRC
01:07:31 *** Skeletron has quit IRC
01:13:14 *** marusich has joined #gnucash
01:18:44 *** storyjesse has joined #gnucash
01:23:36 *** chris has quit IRC
01:29:13 *** yuriks has quit IRC
01:42:03 *** fekepp has joined #gnucash
01:44:27 <fell> jralls, mikee: can you /op gncbot?
01:58:43 *** fekepp has quit IRC
02:19:34 *** storyjesse has quit IRC
02:32:11 *** fell_laptop has quit IRC
02:32:37 *** mikee_ has joined #gnucash
02:34:14 *** mikee has quit IRC
02:38:10 *** fell_laptop has joined #gnucash
02:39:54 *** gjanssens has joined #gnucash
02:39:54 *** ChanServ sets mode: +o gjanssens
02:40:37 *** mikee_ is now known as mikee
02:42:40 <mikee> @op
02:42:40 <gncbot> mikee: Error: I need to be opped to op someone.
03:15:21 *** ncv has joined #gnucash
03:40:28 *** gour has joined #gnucash
04:29:12 *** pilotauto has quit IRC
04:29:16 *** pilotauto has joined #gnucash
04:37:31 *** pilotauto has quit IRC
05:00:36 *** chris has joined #gnucash
05:03:13 <chris> warlord in case anyone remembers how invoicing works - https://github.com/christopherlam/gnucash/commit/b359b639633d82d1ebc5f4eff421c89810e055a1#diff-1625b4f2db9166674389d58f2f585131R122 attempts to add an entry however invoice still shows Quantity=2 UnitPrice=$3 Discount=0% Tax-Amount=0% Total=$6, I was hoping to trigger Tax-Amount to 10% = $0.60 - anyone ?
05:05:35 <chris> I think the answer lies somewhere in https://github.com/Gnucash/gnucash/blob/maint/libgnucash/engine/gncEntry.c#L1328 onwards - "how tax tables are retrieved to calculate gncEntry tax"
05:15:42 <gour> chris: morning. i cp-ed last version of your transaction.scm report under 3.0, but i get some error
05:16:48 <chris> what erro
05:18:34 <gour> here is complete log containing error from custom-vs-average report as well since i didn't have time to tackle it yet
05:18:37 <gour> https://pastebin.com/2hmHMt8d
05:20:06 <chris> ah I've removed addto! from transaction.scm into utilities.scm - just copy&paste it from my github utilities.scm and paste somewhere into transaciton.scm
05:21:33 *** fabior has joined #gnucash
05:27:03 <gour> chris: in which directory is utilities.scm?
05:27:52 <chris> gnucash/libgnucash/scm
05:32:23 *** bertbob has quit IRC
05:33:21 <gour> chris: i've cp-ed 4-line definition of addto, but now get: https://pastebin.com/6ybcjKg1
05:34:03 *** bertbob has joined #gnucash
05:37:18 *** bertbob has quit IRC
05:38:21 <chris> this is quick'n'dirty try different sorting options eg primarykey=acc secondarykey=date monthly
05:41:01 <chris> both primary-key and sec-key must have subtotals
05:42:33 <chris> oops hang on
05:43:18 <gour> i already had that sorting
05:44:04 <chris> repushed, try again, need to paste addto! again
05:48:39 *** fabior has quit IRC
05:50:22 <gour> chris: https://pastebin.com/DKTCe4Rh
05:52:23 *** bertbob has joined #gnucash
05:52:27 <gour> gnucash is such a nice application...it just requires some ironing (love) to get its reporting system (more) straight
05:52:58 <chris> your settings don't seem to have secondary grouping
05:54:58 <chris> choose primary-sortkey = account, primary-subtotal=true, sec-sortkey = date, sec-sortkey=monthly
05:55:23 <gour> chris: primary/secondary subtotal for date key are both greyed out with default set to Monthly
05:55:35 *** bertbob has quit IRC
05:56:01 <chris> well no, set primary-sortkey = account, primary-subtotal=true, sec-sortkey=date, sec-subtotal=monthly
05:56:35 <chris> sec-subtotal-for-date-key = monthly
05:56:56 <gour> ahh, that worked
05:57:19 <gour> chris: that's cool report now!!
05:57:32 <chris> :)
05:58:07 <gour> now if i could just transfer thost average amounts in the budget's estimated value
05:58:21 <chris> well don't ask me
05:58:26 <gour> ;)
06:04:40 <chris> back to invoice - i'm trying to get gncEntry to take my tax-amount-or-percentage and discount-amount-or-percentage seriously.... no matter what i put into entry, the entry total ignores them - hope devs can pitch in
06:05:35 <gour> chris: why the average columns shows amounts as eg. 62 + 399/850 kn
06:06:07 <chris> because scheme uses exact fractions for division
06:06:34 <chris> check the guile documentation how to convert to decimal
06:07:05 <gour> chris: ahh...i noticed that with racket when fiddled with it. what do you think whether it would be more appropriate to float it here?
06:07:12 <gour> ok
06:09:24 *** storyjesse has joined #gnucash
06:11:04 *** bertbob has joined #gnucash
06:25:18 *** fabior has joined #gnucash
06:33:38 *** Aussie_matt has joined #gnucash
06:47:57 *** fabior has quit IRC
06:53:06 *** Jimraehl1 has joined #gnucash
06:54:16 *** Jimraehl1 has left #gnucash
07:01:54 *** chris has quit IRC
07:18:29 *** Mechtilde has joined #gnucash
07:31:23 *** Mechtilde has quit IRC
07:32:50 *** Mechtilde has joined #gnucash
07:37:20 *** Mechtilde has quit IRC
07:46:34 *** ncv_ has joined #gnucash
07:47:44 *** ncv has quit IRC
07:50:33 <warlord> Wow, only downloaded 2400 bugs so far after 12 hours. Glad I wrote code to only re-pull if there's been an update!
07:50:53 *** ChanServ sets mode: +qo warlord warlord
07:50:54 *** warlord sets mode: +o gncbot
07:55:33 *** harshitaneja has quit IRC
08:00:40 *** Mechtilde has joined #gnucash
08:10:00 *** harshitaneja has joined #gnucash
08:10:05 <mikee> @op
08:10:06 *** gncbot sets mode: +o mikee
08:35:08 *** boldstripe has joined #gnucash
08:44:01 *** chris has joined #gnucash
08:48:35 *** ncv__ has joined #gnucash
08:49:53 *** ncv_ has quit IRC
08:50:57 *** oozer has joined #gnucash
08:55:38 *** harshitaneja has quit IRC
09:02:13 *** Aussie_matt has quit IRC
09:21:55 *** kael has joined #gnucash
09:45:19 *** kael has quit IRC
09:54:28 *** Mechtilde has quit IRC
09:55:22 *** chris has quit IRC
10:19:30 *** Mechtilde has joined #gnucash
10:20:25 *** User has joined #gnucash
10:26:49 *** User has quit IRC
10:33:50 *** Mechtilde has quit IRC
10:45:32 *** bertbob has quit IRC
10:56:23 *** Mechtilde has joined #gnucash
11:03:21 *** Mechtilde has quit IRC
11:33:17 *** chris has joined #gnucash
11:46:16 *** phebus has joined #gnucash
11:52:16 * chris still struggling to get gncEntry to accept tax-amounts and discounts
11:59:15 *** bertbob has joined #gnucash
11:59:31 * chris in other words gncEntryGetDocValue is giving me unitprice * qty, ignoring taxtable and discount%
12:03:14 *** storyjesse has quit IRC
12:11:19 <gjanssens> chris: you can get tax-amounts and discounts via the equivalent functions gncEntryGetDocTaxValue and gncEntryGetDocDiscountValue
12:11:41 <gjanssens> But it probably depends on whether TaxIncluded? is set or not.
12:13:55 <chris> gjanssens - I know the invoice.scm is using them well - my problem is creating a new invoice from scratch in unit test. Most numbers are being stored (and retrieved) however I can't seem to make taxtable / discount% be counted for each entry.
12:14:12 <chris> i'm probably missing a step in invoice creation
12:14:55 <chris> (similar to generating regular transactions in unit tests involving forex - all's good except pricedb isn't created - which means TR foreign currency conversions become $0.00)
12:15:57 <gjanssens> Do you have your code up somewhere ?
12:18:35 <chris> frustratingly I'm away from home on 3G and it seems to be dropping https like mad
12:20:54 <chris> should be on my github branch scheme-progress-business-tests now
12:22:29 <chris> if test-invoice.scm is run with "/usr/bin/ctest -V -R test-invoice" it will create /tmp/test-inv-*.html for debugging
12:22:52 <chris> anyway late here need to continue another time
12:22:57 <chris> thanks!
12:29:26 *** Cuare has quit IRC
12:43:26 *** chris has quit IRC
12:45:52 *** ncv__ has quit IRC
12:46:01 *** ncv__ has joined #gnucash
12:51:06 *** fabior has joined #gnucash
12:54:09 *** gour_ has joined #gnucash
12:56:30 *** gour has quit IRC
12:59:55 *** calvinct has joined #gnucash
13:05:49 *** gour_ is now known as gour
13:20:06 *** tuxd00d has joined #gnucash
13:22:58 *** fabior has quit IRC
13:24:50 *** tuxd00d has quit IRC
13:37:25 *** bertbob has quit IRC
13:39:40 *** ncv__ has quit IRC
13:39:41 *** bertbob has joined #gnucash
13:42:15 *** karthik has joined #gnucash
13:43:02 <karthik> Hey Guys, New to Gnucash, for my small business, need a lil help, anybody here?
13:44:06 *** karthik has quit IRC
13:47:01 *** User has joined #gnucash
13:51:39 *** User has quit IRC
14:13:25 *** calvinct has quit IRC
14:14:13 *** calvinct has joined #gnucash
14:19:36 *** calvinct has quit IRC
14:20:54 *** tuxd00d has joined #gnucash
14:46:12 *** Mechtilde has joined #gnucash
14:48:47 *** frakturfreak has joined #gnucash
15:03:31 *** Mechtilde has quit IRC
15:04:03 <mikee> karthik has no patience.
15:08:14 <mikee> warlord: I experimented with python to download bugs, and possibly insert into Mantis, concluded very slow=yes. Also in that case complicated mapping.
15:24:58 *** Mechtilde has joined #gnucash
16:11:00 *** frakturfreak has quit IRC
16:15:47 *** Mechtilde has quit IRC
16:17:17 *** harshitaneja has joined #gnucash
16:17:40 *** calvinct has joined #gnucash
16:18:24 *** gour has quit IRC
16:19:28 *** boldstripe has quit IRC
16:22:31 *** gjanssens has quit IRC
16:29:45 *** calvinct has quit IRC
16:37:14 *** calvinct has joined #gnucash
16:38:57 *** calvinct has quit IRC
16:42:00 *** calvinct has joined #gnucash
17:04:55 *** harshitaneja has quit IRC
17:05:58 *** calvinct has quit IRC
17:21:52 *** harshitaneja has joined #gnucash
17:50:36 *** harshitaneja has quit IRC
17:51:12 *** harshitaneja has joined #gnucash
18:00:55 *** harshitaneja has quit IRC
18:03:48 *** calvinct has joined #gnucash
18:07:00 *** calvinct has quit IRC
18:15:05 *** harshitaneja has joined #gnucash
18:28:26 *** badger92 has quit IRC
18:30:51 *** harshitaneja has quit IRC
18:38:39 *** pilotauto has joined #gnucash
18:41:11 *** harshitaneja has joined #gnucash
18:59:27 *** badger92 has joined #gnucash
19:07:28 <warlord> fell: FYI, the larger issue is the inability to obtain some of that information via the JSON interface. Although worst-case I can hard-code some of the data.
19:07:45 <warlord> (I'll reply more, via email, tomorrow)
19:08:07 <fell> OK
19:09:14 *** gncbot sets mode: +o fell
19:20:01 *** harshitaneja has quit IRC
19:42:33 *** oozer has quit IRC
19:44:07 *** Agfarmer18 has joined #gnucash
19:54:31 *** Agfarmer18 has quit IRC
20:25:30 *** tuxd00d has quit IRC
22:17:03 *** gncbot has joined #gnucash