2018-04-10 GnuCash IRC logs
00:24:46 *** storyjesse has quit IRC
00:29:47 *** boldstripe has quit IRC
01:01:22 *** josephcocoa has quit IRC
01:24:40 *** Robert847 has joined #gnucash
01:26:42 *** Mechtilde has joined #gnucash
01:27:47 *** Robert847 has quit IRC
01:41:54 *** Mechtilde has quit IRC
01:42:38 *** fell has quit IRC
01:43:52 *** fell has joined #gnucash
01:50:54 *** fekepp has quit IRC
02:13:10 *** jotrago1 has quit IRC
02:26:13 *** gjanssens has joined #gnucash
02:26:19 <gjanssens> .
02:26:53 *** ChanServ sets mode: +o gjanssens
02:30:25 <gjanssens> arahael: the feature branch workflow is what we use and promote as well
02:39:24 <arahael> Cool. :) I must've misinterpreted the discussion.
02:47:03 <gjanssens> arahael: the current discussion is only about a big version jump and how to handle our three long-running branches at that point
02:47:38 <gjanssens> jralls, fell: it's less of an issue as I thought.
02:48:32 <gjanssens> I did a local experiment. With a branch 'tmp' checked out at maint right before merging it into unstable, if I then run
02:48:38 <gjanssens> git merge origin unstable
02:49:02 <gjanssens> then the tmp branch will nicely fast-forward to current unstable
02:49:34 <gjanssens> So it suffices to
02:50:53 <gjanssens> 1. merge maint into unstable one last time using "git merge -s ours maint" while unstable is checked out (-s ours because the 2.6.21 related commits are not relevant for unstable)
02:51:14 <gjanssens> 2. reset maint to current unstable
02:51:19 <gjanssens> (hard reset)
02:51:26 <gjanssens> 3. force push new maint upstream
02:52:10 <gjanssens> Then we can decide whether we want to keep unstable (dormant) or effectively delete it until the next beta cycle.
02:53:47 <gjanssens> Although it's a forced push, it won't cause pull issues (forced pull). It would still be a fast forward.
02:54:17 <gjanssens> However if contributors still had a different local maint branch head, they will have to rebase.
02:54:34 *** fabior has joined #gnucash
02:54:36 <gjanssens> That only makes sense because we won't take contributions on the old branch any more anyway.
02:55:06 *** harshitaneja has joined #gnucash
03:11:21 *** hoijui__ has joined #gnucash
03:28:58 <arahael> Ah, thanks for that explaination - makes sense. :)
03:29:54 <arahael> Contributors using a different local maint branch can also just update their tracking branches to unstable branch.
03:30:16 <arahael> (But they'd need to know how to do that, I'm guessing most git users today tend to be relatively naive :) )
03:38:31 *** gour has joined #gnucash
03:59:43 *** ncv_ has joined #gnucash
04:13:09 *** hoijui__ has quit IRC
04:13:35 *** fabior has quit IRC
09:25:36 *** gncbot has joined #gnucash
09:25:47 *** kael has joined #gnucash
09:26:24 <warlord> gjanssens, jralls -- can one of you /op gncbot
09:26:34 *** gjanssens sets mode: +o gncbot
09:26:38 <gjanssens> done
09:26:40 <warlord> thanks
09:28:41 <Hinnerk> warlord, I have a problem starting GnuCash 3.0 on Windows 10
09:28:50 <Hinnerk> here'S the trace:
09:29:13 <Hinnerk> https://pastebin.com/eiRBvsRA
09:29:35 <Hinnerk> In windows event log I find an error message concerning msvcrt.dll
09:29:57 <Hinnerk> I ran some tools to make sure, there's nothing wrong with the windows installation.
09:30:04 <Hinnerk> (sfc, dism)
09:30:17 <Hinnerk> And here's the event log:
09:31:07 <Hinnerk> https://pastebin.com/LAeadrCg
09:31:24 <Hinnerk> It's chrashing during startup, welcome screen is displayed.
09:31:39 <warlord> Hinnerk: maybe jralls or gjanssens can look?
09:32:45 <Hinnerk> I use online price retrieval and hbci, not sure if that info helps.
09:32:57 <warlord> That should not affect startup.
09:33:01 *** boldstripe has joined #gnucash
09:33:31 <Hinnerk> I just have no idea where to look anymore.
09:33:54 <Hinnerk> Does the trace point more to gnucash issue or a windows issue?
09:34:08 <Hinnerk> or a gnucash on windows issue?
09:36:52 <warlord> Hinnerk: I'm afraid I cannot look right now.
09:37:02 <Hinnerk> ok
09:37:21 <gjanssens> Hinnerk: this may be https://bugzilla.gnome.org/show_bug.cgi?id=794934
09:37:53 <gjanssens> Try moving saved-reports-xzy and config.user out of the way and see if you can successfully start then
09:42:59 <Hinnerk> will do, sec
09:45:54 <Hinnerk> fixed it, thank you!
09:46:56 <Hinnerk> it is worthwhile to attach the reports to the bugrepoprt you posted?
09:47:19 *** bob_ has quit IRC
10:02:32 *** fekepp has quit IRC
10:10:00 <Hinnerk> has anyone experience with using hibiscus to prepare credit card data for gnucash?
10:11:00 <gjanssens> Hinnerk: more data may be helpful so please do attach your saved-reports data as well
10:11:16 <gjanssens> And never heard of hibiscus...
10:11:39 <Hinnerk> hibiscus can be used to do screen scaping
10:12:41 *** entreprnr has quit IRC
10:12:42 *** entreprnr has joined #gnucash
10:25:25 *** seanh has quit IRC
10:25:26 *** seanh has joined #gnucash
10:28:43 *** Farelli has quit IRC
10:28:54 *** Farelli has joined #gnucash
10:35:30 <Hinnerk> I noticed that the Bayes algorithm only uses white space as seperator. Also, text contains newlines. You don't see them on screen, however, you can see, how fragmented the tokens in bayes are.
10:35:44 <Hinnerk> And while I'm at it: Thank you for the tool to prune bayes!
10:37:09 *** kael has quit IRC
10:50:35 *** kael has joined #gnucash
10:55:10 *** warlord has quit IRC
10:56:37 *** warlord has joined #gnucash
11:16:52 *** Mechtilde has joined #gnucash
11:22:42 *** harshitaneja has quit IRC
11:27:10 *** Robert847 has joined #gnucash
11:27:13 *** Robert847 has left #gnucash
11:42:55 *** oozer has quit IRC
11:43:58 *** oozer has joined #gnucash
11:53:13 <fell> Hinnerk, can you change your systems codepage from (MS).1252 to utf-8?
11:58:04 <chris> .... gnc upgrade started with a bang rather than a whimper
11:58:34 *** gncbot sets mode: +o fell
12:03:29 *** ArtGravity has joined #gnucash
12:06:57 *** oozer has quit IRC
12:06:58 *** storyjesse has quit IRC
12:18:01 *** bob_ has joined #gnucash
12:23:50 <jralls> fell: Excellent thought. Can you add it to the bug?
12:24:41 <jralls> gjanssens: Heh, after thinking and reading more about reusing branches I had come around to your position from yesterday.
12:24:50 *** Hinnerk has quit IRC
12:25:46 <jralls> gjanssens: Did you test pushing to a bare repo and then pulling from another working repo, i.e. different from the one from which you'd done the force push?
12:26:27 *** boldstripe has quit IRC
12:28:19 <gjanssens> jralls: no, not yet. I'll do so and report back
12:37:53 <fell> Added to https://bugzilla.gnome.org/show_bug.cgi?id=794934 and Bug 794934
12:39:38 <fell> gjanssens Hibiacus is a java tool similar to aqbanking
12:41:01 <fell> https://www.willuhn.de/products/hibiscus/
12:52:30 *** ncv_ has quit IRC
12:53:07 *** boldstripe has joined #gnucash
12:54:29 <gjanssens> jralls: I ran the following test:
12:54:55 <gjanssens> clone my local gnucash working directory into a bare repo
12:55:04 <gjanssens> then cloned that bare repo twice
12:55:26 <gjanssens> checked out maint in both repos
12:55:50 <gjanssens> The state of the repo is as you can see in github currently: maint is not yet merged into unstable
12:56:08 <gjanssens> in repo A, I did:
12:56:44 <gjanssens> 1. checkout unstable and run "git merge -s ours maint" to discard the 2.6.21 changes while merging into unstable
12:56:54 <gjanssens> 2. git checkout maint
12:57:07 <gjanssens> 3. git reset --hard origin/unstable
12:57:13 <gjanssens> 4. git push origin maint
12:57:48 <gjanssens> => first observation, this doesn't even require a force-push. git sees it as a normal progression of the maint branch
12:57:56 <gjanssens> in repo B, I did:
12:58:07 <gjanssens> (with maint still checked out)
12:58:08 <gjanssens> git pull
12:58:29 <gjanssens> => It happily considered this pull a fast-forward
12:58:58 <gjanssens> I do believe the key here is that all changes in maint should be merged into unstable before resetting maint
13:03:46 *** bob_ has quit IRC
13:07:08 <jralls> OK, great. I've fixed my mistake with the 795049 fix and the typo that I didn't catch quite fast enough and re-tagged. Let's not find out if the windows build-tags works when the branch has been pulled out from under it. ;-)
13:07:17 *** kael has quit IRC
13:10:17 *** kael has joined #gnucash
13:10:25 <gjanssens> :)
13:11:25 <warlord> 2.6.21a?
13:12:15 <gjanssens> IIRC the tag is only stored when built successfully. Didn't verify though
13:16:40 <jralls> warlord: Yeah, because of the problem with 2.6.21 gjanssens noticed in the commit mail this morning.
13:17:19 <warlord> jralls: okay.
13:18:15 *** kael has quit IRC
13:20:06 <jralls> gjanssens: The error detection isn't that good, so it sometimes stores the tag even when the build fails. Editing the tag file allows build_tags.sh to run again.
13:20:28 <jralls> With luck this is the last build ever with that build system...
13:20:44 <jralls> But I thought that *last* week, too.
13:20:48 <gjanssens> Fingers crossed...
13:22:02 *** kael has joined #gnucash
13:22:06 <jralls> Meanwhile I'm not terribly happy with Mingw-w64. They're constantly upgrading everything and it makes the build really fragile.
13:23:36 <warlord> jralls: is there an alternative?
13:24:31 *** Hinnerk has joined #gnucash
13:24:38 <jralls> Well, I've looked at https://github.com/Microsoft/vcpkg/blob/master/docs/index.md and I'll give it a try when we get the 3.0 fires tamped down a bit.
13:25:06 <Hinnerk> @fell: Where do I change the codepage? Is it a systemwide setting? Not sure I would want to do that for 1 program only.
13:25:06 <gncbot> Hinnerk: Error: "fell:" is not a valid command.
13:26:08 <fell> It might be at easiest in system setting region and language o similar
13:28:10 <Hinnerk> I think it has to be done in the registry, after having thrown an eye to a few pages...
13:28:33 <fell> No
13:28:52 <fell> There is a module
13:29:16 <jralls> Hinnerk: https://knowledgebase.progress.com/articles/Article/4677
13:32:42 <Hinnerk> hm, that manual is outdated, i don't see an "administrative tab" and the related settings
13:33:55 <jralls> But utf-8 isn't one of the choices.
13:35:12 <Hinnerk> I think there's a misunderstanding. I don't even see where to do the settings, and the link oyu posted is outdated, in W10 there's no such "administrative tab"
13:35:53 <jralls> On win10 it's control panel>region. There are three tabs, formats, location, and administrative.
13:35:54 <fell> Is there Language and region or similar?
13:36:39 <jralls> Then a button "Change system locale". It lists a lot of countries, but UTF-8 isn't one of the choices.
13:37:41 <jralls> This is likely also the problem with path handling (https://bugzilla.gnome.org/show_bug.cgi?id=795134).
13:38:43 *** tuxd00d has joined #gnucash
13:40:16 *** gjanssens is now known as gjanssens_afk
13:40:22 <fell> msdn talks about "Unicode"
13:40:25 *** fabior has quit IRC
13:41:10 <jralls> By which they mean UTF16, M$'s standard.
13:41:41 <fell> An application can use the MultiByteToWideChar and WideCharToMultiByte functions to convert between strings based on code pages and Unicode strings.
13:42:00 *** tuxd00d has quit IRC
13:42:44 <fell> https://msdn.microsoft.com/en-us/library/windows/desktop/dd374081(v=vs.85).aspx
13:43:49 <jralls> Yes, I'm way more conversant with that than I'd like. I spent several months on Gramps getting various character sets to work.
13:46:13 <jralls> But we don't use M$ API directly in GnuCash, we rely on Mingw and GLib to abstract that away for us. It seems that Mingw64 does something different, causing several regressions including this one.
13:47:15 *** oozer has joined #gnucash
13:47:19 <jralls> Another is revealed by Bob Fewell's workaround for Windows on https://bugzilla.gnome.org/show_bug.cgi?id=793461.
13:50:52 <fell> Until now we suggested https://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_Windows
13:52:13 <jralls> That doesn't say anything about character set.
13:52:48 <fell> append .UTF-8 to LANG
13:54:09 <jralls> ISTR that wasn't enough for Windows. Hinnerk, can you try it?
13:55:44 <fell> LANG=de_DE.UTF-8
13:55:53 <fell> in your case
14:01:15 *** fekepp has joined #gnucash
14:16:02 <jralls> GTG. Back in a couple of hours.
14:16:48 *** frakturfreak has joined #gnucash
14:34:12 *** boldstripe has quit IRC
14:43:23 *** Mechtilde has quit IRC
15:21:58 *** Hinnerk has quit IRC
15:23:02 *** fabior has joined #gnucash
15:49:28 *** boldstripe has joined #gnucash
15:50:56 *** boldstripe has joined #gnucash
15:55:22 *** fabior has quit IRC
16:16:23 <jralls> gjanssens_afk: Where the heck does the saved-reports file get read? I see write and backup in gnc-report.c and the calls to those in report.scm, but nowhere that it's read.
16:27:49 *** frakturfreak has quit IRC
16:28:01 *** boldstripe has quit IRC
16:28:30 *** boldstripe has joined #gnucash
16:29:11 *** marco82 has joined #gnucash
16:48:07 *** dgrabla_ has joined #gnucash
16:50:54 <dgrabla_> Hello there. I've been using gnucash for a few years and I think I understand it quite well. There is a UX issue that bothers me a lot, that maybe somebody here can tell me if it is fixed on newer gnucash releases... or maybe if there is an alternative way
16:51:36 <dgrabla_> I am using german locale, with gnucash chart of accounts for germany
16:51:55 <dgrabla_> when I file a new bill and I need to select an expense account
16:52:17 <dgrabla_> I need to fish the correct expense account on a list with HUNDREDS of accounts
16:53:32 <dgrabla_> Ideally this should be a fuzzy search field, so I can for example type "Phone" and the list is only populates with accounts whose name matches "Phone". It should be searchable by account name and also account code.
16:54:11 <dgrabla_> Is there a way to do this search? Does anybody else has this problem?
16:56:13 <gour> dgrabla_: type Ex:Ph and you'll get it ;)
16:57:46 <dgrabla_> No, those shortcuts are not good enough with this German chart of accounts because the accounts are really deeply nested.
17:00:41 <gour> i see...don't know about other workarounds
17:01:07 *** boldstripe_ has joined #gnucash
17:01:19 *** gour has quit IRC
17:02:27 <dgrabla_> The German account tree would force me to do something like 08:a:8:Telefon
17:03:08 <dgrabla_> Accountants are used to have the account codes on their heads
17:03:51 *** bob_ has joined #gnucash
17:04:50 *** boldstripe_ has quit IRC
17:05:57 <gjanssens_afk> jralls: it gets loaded in gnucash-bin.c, starting from load_user_config
17:05:59 <jralls> dgrabia: IIRC the typeahead in the register's account field also works on account codes as long as they're not ambiguous with the account names.
17:06:28 <gjanssens_afk> That calls try_load_config_array with the two possible names (saved-reports-2.4/2.8)
17:06:58 <gjanssens_afk> That eventually calls gfec_try_load
17:07:25 <gjanssens_afk> And that's a fancy wrapper around opening a file via guile calls, wrapped in an exception handler
17:07:38 <gjanssens_afk> Got to leave for tonight...
17:08:33 *** marco82 has left #gnucash
17:08:49 <jralls> Yeah, I know about gfec. So the difference in this case is probably guile-2.0 reads the code page and guile-1.8 didn't.
17:08:55 <jralls> Goodnight.
17:08:59 <dgrabla_> jralls: Is this a new feature? Im using 2.6.15
17:09:13 <gjanssens_afk> Bye
17:09:25 <jralls> dgrabia_: AFAIK it's been there since 2.2 at least.
17:09:34 *** gjanssens_afk has quit IRC
17:09:49 <jralls> dgrabia_: Assuming, of course, that I do in fact remember correctly.
17:14:45 <dgrabla_> jralls: It doesnt work for me. I introduce the account code and it doesnt expand. If I type 'tab' or 'enter' it tells me the account '6805' does not exist, and asks me if I want to create it
17:15:13 <jralls> Sorry, I guess I don't remember correctly.
17:17:16 <jralls> The typeahead is as gour described. While we'd happily accept a PR with a new typeahead that works the way you describe, it's not something that's going to get on the core developer's list anytime soon.
17:17:41 <dgrabla_> Wait I found the issue
17:18:24 <dgrabla_> Indeed it works like you said on the register's account. There it expands correctly
17:19:00 <dgrabla_> But it doesn't work on the bill expense account input field
17:19:33 <dgrabla_> maybe the typeahead is not active on the bill/invoice business tools?
17:20:18 <jralls> Probably. The code for the register is separate and quite different from the dialogs.
17:22:27 *** Joc has joined #gnucash
17:23:01 <dgrabla_> I understand.. Is a refresh/rewrite of the business tools on the roadmap for 2018/2019?
17:34:07 <jralls> No, but if you write up a bug report Bob Fewell might pick it up and copy the code over. I think it can be argued that the behavior should be consistent across GnuCash.
17:46:37 <dgrabla_> I will do that, let's cross fingers and hope Bob gives it a look. Thanks!
17:47:10 *** warlord has quit IRC
17:49:32 <Joc> I'm in Canada and working mostly in CAD, but have some USD accounts. The "total" under the "Accounts" tab shows the totals in the currency set for that accounts, that's fine. To show the CAD equivalent I've selected to enable the column "Total (CAD) , but that amount is completely wrong. Any idea what's going on?
17:50:14 <Joc> The money goes from a CAD account to an USD account, and all the amounts are right, each in their own currency value.
17:56:13 <Joc> I created a " Transaction Report" with that USD account and selected " Common Currency" option, and that gave me the approximate CAD amounts, but not exactly. Again, any idea what's going on?
17:58:07 <jralls> Joc: What exchange rate are you applying in your head and is it perhaps different from the one that GnuCash is using?
17:59:20 <Joc> when I enter the amount, gnucash asks me to enter the exchange rate.
18:00:10 <Joc> that exchange rate changes all the time, so I enter a different one for each transaction
18:00:56 <Joc> what do you mean by "that GnuCash is using" ?
18:04:19 <jralls> GnuCash is converting the amounts in USD to CAD for the report. How it does that depends on the "price source" setting on the commodities tab of report options. That defaults to "nearest in time", and that in turn should be the price stored when you created the transaction.
18:09:39 <Joc> I don't understand. I don't see that setting. Under " Edit" I see " Report Options", but don't see a price source anywhere.
18:10:22 <jralls> Sorry, that's a different report.
18:11:07 <Joc> As I see it, I would not expect the see the CAD price to change
18:12:23 <Joc> As I see it, I would not expect *to* see the CAD price to change (nor the USD)
18:13:12 *** kael has quit IRC
18:15:58 <jralls> From your point of view it's the price of USD in CAD that's significant.
18:17:26 <Joc> right
18:19:41 <jralls> The transaction report doesn't have a selection, it just uses "nearest in time". You can see those prices if you review Tools>PriceDB. So if you go to the Display tab of report options and select Shares and Price you'll see the amounts in USD, the ratio between USD and CAD stored in the transaction, and then the calculated amount of CAD using the "shares" of USD and the price in the pricedb with the date that's closest to the date of the transacti
18:19:41 <jralls> on.
18:22:30 <jralls> The reason it doesn't use the stored value in CAD of the transaction is that the selection of the report currency is arbitrary. If you tell it GBP and prices exist in your pricedb for USD->GBP and CAD->GBP--or even just one of them, IIRC it can handle one level of indirection, it will produce a report in GBP.
18:23:17 <jralls> Now unless you have a thoroughly populated pricedb those results may not be very meaningful, but that's another matter entirely.
18:24:23 *** bob_ has quit IRC
18:25:38 <Joc> mmh, I'm confused... that Tools>PriceDB shows a large number of CAD and USD values, got the feeling I'm not doing something the right way.
18:26:22 *** bob_ has joined #gnucash
18:26:34 <jralls> One would expect that. Ideally you'd have a price for each transaction, but GnuCash only records one price per day in the pricedb.
18:27:00 <Joc> I like that it records the convertion rate of each transaction, that allows to verify the bills
18:27:28 <Joc> but at the end of the day, everything goes to CAD
18:28:24 <jralls> Note that the conversion rate stored in the transaction isn't necessarily the one in the pricedb. The one in the pricedb is the last one retrieved or created on the day.
18:29:08 <Joc> mmmh. When I get a bill in USD, how should it be entered?
18:29:09 *** bob_ has quit IRC
18:29:42 <jralls> Depends on how you pay it.
18:29:52 *** boldstripe has quit IRC
18:30:35 <jralls> If you're paying in USD then you have a USD account and the payment transaction itself won't have any exchange rate associated with it.
18:31:40 <jralls> OTOH if you're paying with CAD then you should enter the amount in CAD that you're paying instead of retrieving the current rate from Alphavantage.
18:31:59 <jralls> In the first case you
18:32:37 <Joc> got a little company, most of the time I pay the bills myself, and enter the bill as an expense in USD, and transfer the amount from my CAD liability account, then from time to time, refund myself.
18:32:53 <jralls> In the first case you'll have funded that USD account and the actual exchange rate that applies will be whatever got when you did that funding.
18:33:24 <jralls> Umm, OK, but how do you actually *pay* the vendor?
18:34:03 <jralls> Do you write a check (cheque), use a credit card, mail cash...?
18:35:18 <Joc> from my own credit card, in CAD, and occasionally write a company cheque to refund me of all the expenses so far.
18:37:14 <jralls> OK, so your actual exchange rate is the one the CC company uses for you. So you should be setting the amount field in the transfer dialog with the CAD amount that's on your CC bill.
18:39:55 <Joc> that's what I do, I believe. I created an expense account in USD, I enter the bill amount in USD, when I select to transfer the amount from my CAD liability account, gnucash asks me to enter the converstion rate
18:40:49 <Joc> the problem, I want to know the total of the expenses in CAD, and that's where I got trouble
18:42:04 <Joc> when I look at the USD account and the CAD account, all the amounts are right, but when I look at the total from the " account" tab, the totals don't work
18:43:13 <Joc> that is, the USD total are right, but when I add the column "total (CAD), that total is completely wrong
18:46:37 <jralls> The Account tab's Total (CAD) uses only the latest price. It's intended to show the current market value of assets, not income and expenses.
18:48:12 <jralls> Try using the Profit & Loss report and set the price source to "average cost".
18:49:38 *** boldstripe has joined #gnucash
18:50:25 <Joc> can I get the total of the expenses in CAD, as entered?
18:51:03 <jralls> The average cost price source should do that.
18:51:51 <Joc> but average means that it won't be the amounts as entered, right?
18:52:07 <Joc> I guess it would means that gnucash would need to add each CAD expense value by looking at the CAD value as entered into the liability account.
18:55:14 <jralls> Hmm, what it actually does is use every single conversion between USD and CAD that it can find. That works fine for valuing assets, but isn't going to work where you need to get just the CAD amounts for one year's (or month's, or whatever) expenses.
18:56:39 <jralls> So maybe the best way to get the amount in CAD is to run the transaction report on your Liability account and look at the totals to each expense account for the period of interest. That way you get the CAD values directly.
18:56:55 <Joc> what complicate matters is that most transactions are split, includes part+shipping+tax
18:59:04 *** pilotauto has joined #gnucash
18:59:14 <jralls> And of course only a single split to CAD.
18:59:17 <Joc> I can't help, but to thing that there's got to be a better way, it's pretty usual to want to know how much you've spent for a particular product at the end of the year for example, in CAD
19:01:40 <Joc> I was pretty impressed at the way Gnucash handles multiple currency, at the transaction level, all the data is easily accessible, just by looking from the USD side of the CAD side.
19:02:56 <jralls> Indeed. The easy way to do it is to simply record everything as CAD, though that can be a PITA for splitting out the shipping and tax.
19:04:39 <jralls> How many of these transactions do you post per day and does the rate actually vary within a day?
19:04:47 <Joc> some of the amounts are paid in USD and some in CAD, so I enter the amount in USD using the USD side, and enter the other amounts in CAD using the CAD side, that works well
19:05:24 <Joc> Over the year, typically, about 100 to 200 transactions
19:05:29 <Joc> not that much
19:06:56 <jralls> It's the per-day thing that matters. Now that you've fully explained it I think that the best result will come from "nearest in time" and making sure that your pricedb gets you the right rate as often as possible.
19:08:09 <jralls> If you have multiple transactions at different exchange rates in a single day you need the pricedb to have that day's price be the one that gets the right total CAD for that day.
19:08:10 <Joc> never noticed a problem with the rate, I simply enter the amounts on the bill. I don't know if I ever entered two rates on the same day.
19:08:31 *** ArtGravity has quit IRC
19:09:10 <jralls> Right, you wouldn't know unless you calculated it yourself for each transaction.
19:10:18 <Joc> the converted amounts on the "transaction report" are close, but the total on the " accounts" tab is way off, about 3 times higher than it should be.
19:10:19 <jralls> There are a bunch of experienced users on the list who have multi-currency businesses. Why don't you ask there how they set it up to get intelligible reports?
19:10:49 <Joc> I sure would like to find out
19:10:51 <jralls> Like I said, the accounts tab uses only the latest price. It's never going to be right for your purposes.
19:11:43 <Joc> the strange thing, is that the total in CAD is about 3 times higher
19:12:17 <jralls> The accounts tab number is 3x higher or the other way around?
19:12:33 <jralls> GTG, back in 20-30 min.
19:12:50 <Joc> I'm guessing I need to read more about the price db you mentioned, might help
19:13:21 <Joc> thanks for all the help you've provided, much appreciated
19:17:45 <chris> Joc: you should set your General / Report currency to CAD
19:19:18 <Joc> I believe it is, checking...
19:22:06 <Joc> under edit>preferences>reports, I got CAD
19:23:41 <Joc> under edit>preferences>accounts, I got CAD
19:23:53 <chris> no: Transaction report options- General/Report Recurrency
19:24:03 <chris> Ah sorry
19:24:52 <chris> what about your Expense accounts - what currencies do they use?
19:24:53 *** GabrieleV has quit IRC
19:25:30 <chris> I presume you have asset bank acct in AUD, and some expense accounts in USD?
19:25:33 <Joc> I've set some expense account as USD, and some as CAD,
19:25:41 <chris> AUD->CAD
19:26:01 <Joc> all the rest is set as CAD, including bank account
19:26:48 <chris> ah I get it now - in this case, when you select your USD expense account for reporting, the CAD amounts will always be approximates - the Transaction Report will not 'look into' the CAD bank account to retrieve the CAD amount, it will convert USD to CAD and print
19:29:14 <chris> IIRC the conversion rate will depend on the pricedb
19:30:31 <Joc> real sorry, Chris, forgot time, got to run, but I will read back the messages. I have to think about what you just said.
19:36:06 *** dgrabla_ has quit IRC
19:39:02 *** lispmacs has quit IRC
19:55:17 <chris> Joc: in other words, if you have bank/creditcard in CAD, spend 20 USD using 25 CAD, your transaction will strictly recordd 20USD -> 25CAD, and your pricedb will store 1USD=1.25CAD
19:55:33 <chris> The Transaction Report will take 20 USD, convert to CAD using the pricedb and print
19:56:16 <chris> The issue may arise if you have multiple pricedb e.g. you make multiple purchases on the same date with differing exchange rates - IIRC the pricedb will only store the latest entry made.
19:57:13 <chris> On the other hand, if, say, you choose to set report currency to GBP, and you have some GBP->USD or CAD values in pricedb, the Transaction Report will be able to give you an indication of GBP prices
20:14:07 *** Joc has quit IRC
20:24:08 <boldstripe> Gnucash imports the memo field in my CSV, but I cannot see how to display it. I can Sort by (invisible) Memo, or generate a report showing the Memo, but I can't find how to see it or edit it.
20:30:52 <jralls> boldstripe: If it's actually importing it to the memo field it will be on one of the splits. You view them by clicking the split button in the toolbar or picking a different mode in the View menu.
20:31:06 *** kus has joined #gnucash
20:31:38 <jralls> OTOH if they're going to the Notes field on transactions you view that in double line mode, View>Double Line.
21:02:32 <chris> jralls the TR always does currency conversion using gnc:exchange-by-pricedb-nearest to the trans-date - it's been like this for years. I haven't yet decoded the pricedb shenanigans yet. The average-cost boggles!
21:05:10 <jralls> chris: Read the average-cost bug and supporting docs a few times. It'll sink in eventually. I'm still not convinced it's the Right Way™, but I haven't really figured out a better one.
21:06:22 <chris> do you have any understanding of weighted average too? is there an accounting principle behind it?
21:06:34 <jralls> Regardless of that it's not going to give Joc the answer he's looking for, and with his book structure it would be really hard to write one.
21:07:12 <jralls> I haven't really dug into weighted average, but I think the idea was more from an investment perspective than an accounting one.
21:07:24 <chris> Hmm Joc can always report from BANK/CARD, filter to/from USD expenses only, and get the exact CAD amounts
21:07:34 <jralls> Anyway, I'm summoned for dinner. Goodnight.
21:07:39 <chris> Night!!
21:07:43 *** jralls has quit IRC
21:32:10 *** oozer has quit IRC
21:34:02 <boldstripe> Got it. Thank you!
21:58:52 *** josephcocoa has quit IRC
22:20:03 *** kus has quit IRC
22:43:19 *** warlord has joined #gnucash