Re: [GNC] Scheduled transaction frequency?
On Tue, 16 Mar 2021 19:29:03 -0700 gnu Gord wrote: > Thanks to all that replied. > I have set it up as 'last day of the month', that's one of the > options, because it is an expense. I'll have to remember, or better > yet, add a comment that says something like "change the date to the > real date before posting". It's not a huge problem but an interesting > situation... > > Thanks again, > Gord Make it for review when it comes up. I can't recall the name of the option, but I use it for one expense we have all winter and not in summer. I have a template set up with a few fictitious parts and I take the option to review since last run, and the item comes up. If its summer I delete it, if its winter I edit it to what I want. Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transaction frequency?
That would be a checkbox in the 'Overview' tab of the SX labeled: "Notify me when created", (and make sure 'Since Last Run' fires on open in 'Preferences > Scheduled Transactions', or else run it manually) and then be sure in the 'Since Last Run' dialog to tick the box at the bottom for "Review created transactions". Regards, Adrien On 3/17/21 5:57 AM, Liz Dodd wrote: Make it for review when it comes up. I can't recall the name of the option, but I use it for one expense we have all winter and not in summer. I have a template set up with a few fictitious parts and I take the option to review since last run, and the item comes up. If its summer I delete it, if its winter I edit it to what I want. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing Accounts with non-English Characters
Not sure if this is related with the overload, but I noticed that when triggering the accented character selector/pop-up in MacOS, I can't type the number for the character I want like in other apps. I still can use the arrow keys though. Otherwise, I can get most characters by remembering the specific Option sequence, but all of mine are simple two-key presses so I've yet to know if more complicated combos are an issue. Regards, Adrien On 3/16/21 11:21 PM, John Ralls wrote: Looks like option is getting used as part of shortcuts, intercepting its use for extending the keyboard. Option-u-u opens that weird entry box and option-o operates the OK key. Option-e still works to create an accent-grave so it's just modifier key overloads. In the transfer dialog option-u-u makes a ü as it should, but option-o still operates the OK button. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Mystery per-security Opening Balances accounts appearing
I've been using Gnucash for well over a year and a half. Sometime within the past few months, I have seen a number of completely empty Opening Balances equity accounts opening themselves for certain securities that I own. They are always denominated in the currency of the security; so for example I have one right now: [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] These accounts have no balance, no transactions in them, and *to the best of my knowledge* have never had a transaction in them. I have asset accounts for about 75 securities, but only see this for around 10 of my securities. Most of them were acquired after starting to use GnuCash, so the top-level Equity:Opening-Balances account would not have been involved at all. (1) Has anyone else seen this? (2) What gives? Thanks! Peter ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Billable Expenses carried over into the new year
Small business owner who is definitely not a trained accountant here, so please bear with me if none of this makes sense. Our business regularly incurs travel expenses while performing work for clients, which we invoice to the client with no markup. We reimburse the employees as they incur the expenses and I book those as Reimbursable Expenses. When the client pays their invoice, I rebate that expense account the portion of the invoice that was expenses while the reminder of the invoice is marked as income in the appropriate client's account. I was doing this so that I could differentiate between what was truly income, and what was just a cost that I was pass through to the client. This really seemed to work well until we closed our books at the end of the year and started 2021 fresh and we had a client pay their December 2020 invoice late. Came in on January 3rd. So now I've got a billable expense being reimbursed to us, but for the life of me I can't figure out how to handle it since we zeroed out all the expense accounts on January 1. Do I set up an opening balance in the Reimbursable Expenses Account? This seems like I would be double-booking the same expense in two different years. Do I set up a Reimbursable Expenses Receivable Account and have the new invoice go there? Thanks, Andrew ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mystery per-security Opening Balances accounts appearing
It looks like this issue was also raised (by someone other than me) on the GnuCash reddit: https://www.reddit.com/r/GnuCash/comments/m5fgk1/confused_about_opening_balance_still/ On Wed, Mar 17, 2021 at 1:00 PM peterb wrote: > I've been using Gnucash for well over a year and a half. Sometime within > the past few months, I have seen a number of completely empty Opening > Balances equity accounts opening themselves for certain securities that I > own. They are always denominated in the currency of the security; so for > example I have one right now: > [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] > These accounts have no balance, no transactions in them, and *to the best > of my knowledge* have never had a transaction in them. > I have asset accounts for about 75 securities, but only see this for > around 10 of my securities. Most of them were acquired after starting to > use GnuCash, so the top-level Equity:Opening-Balances account would not > have been involved at all. > > (1) Has anyone else seen this? > (2) What gives? > > Thanks! > > Peter > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Strange message on launching app
Finbar,
I'm running GnuCash Version 4.4 on Windows 10 Pro.
I have a single GnuCash file, called Alan, which I store in a GnuCash folder
in my Documents folder, i.e. C:\Users\\Documents\GnuCash\Alan.gnucash.
Also in this folder are large numbers of Alan.gnucash.mmddhhmmss.gnucash
and Alan.gnucash.mmddhhmmss.log files, 30 days' worth controlled by the
setting in preferences. If GnuCash is open there is also an Alan.gnucash.LCK
file.
To minimise risk of loosing my data I have daily automatic backups of my
data, which includes my GnuCash files, to a NAS.
Under normal circumstances I have no problems, apart from occasions when
GnuCash complains that the LCK already exists when I start it which I can
usually tie up with GnuCash not having been closed correctly.
However, I do get some problems of my own making. When I new version of
GnuCash is released and I'm ready to install it. For example when I was
ready to install GnuCash Version 4.4 I used File -> Save As to save a backup
as Alan - Pre V4.4.gnucash, closed GnuCash, installed Version 4.4, restarted
GnuCash, and then ran Actions -> Check & Repair.
It's usually the next day when I release that I have a problem, as I'm using
the WRONG file. GnuCash remembers the last file it used, which in the above
situation is Alan- Pre V4.4.gnucash rather than Alan.gnucash.
Reading through your problems I suspect you've used File -> Save As at some
point and this has exacerbated your problems with files.
Alan A Holmes
-Original Message-
From: gnucash-user
On Behalf Of
Mahon Finbar
Sent: 16 March 2021 14:08
To: John Ralls
Cc: Gnucash Users
Subject: Re: [GNC] Strange message on launching app
OK, I found the GNU FEB 12 2019.gnucash file saved on 19.2.2021, but not the
others. Anyway if that is the "good" backup that should be OK? It only has
362kb in it.
As it happens the file wasn't in a GnucashLCK folder, there were two
files on 8.3.2021 with the same name and time and date, but in different
folders, one of which was empty and lots of other stuff on an around
that date.
The storage of GNU files has always been a bit of a mystery to me, they seem
to shuffle around, a search of files with .gnucash results in more than 600
answers!!
OK, if I uninstall and reinstall will it find the 'good' backup mentioned?
Thanks so much for your patience and help.
Finbar
On 15/03/2021 17:03, John Ralls wrote:
> The trace file associated with a crash just means that GnuCash got far
enough into the program to open it before trying to load the library linked
to libgncmod-app-utils.dll. That's not meaningful.
>
> "GNU FEB 12 2019.gnucash" is a very odd name for a book, but OK. The
existence of a lock file from the 8th means that that's when you last
successfully opened the file, and that the full name is "GNU FEB 12
2019.gnucash.20210219151108.gnucash.LCK" means that you've been working with
a backup file since mid-afternoon on 19 February. The other two files aren't
from GnuCash; perhaps they're download or cache files from your browser?
>
> Navigate to the folder where "GNU FEB 12
2019.gnucash.20210219151108.gnucash.LCK" is and look for "GNU FEB 12
2019.gnucash", "GNU FEB 12 2019.gnucash.20210219151108.gnucash", and files
of the form "GNU FEB 12
2019.gnucash.20210219151108.gnucash.MMDDHHMMSS.gnucash" which will be
backups of your GnuCash sessions since you opened the backup file instead of
the original.
>
> Regards,
> John Ralls
>
>
>> On Mar 15, 2021, at 7:13 AM, Mahon Finbar wrote:
>>
>> OK, I appreciate that, thank you.
>>
>> However, in trying to find the last backup file before uninstalling, I am
finding some very strange file dates and times in the list.
>>
>> For example - gnucash.trace.3JC5Z0.log - on 14.3.2021 - a time when I
could not get the app to load, [with the same message as originally].
>>
>> I don't seem to have any backups, which according to the help file
>> should read as .MMDDHHMMSS.gnucash
>>
>> The 'latest' file in the list is GNU FEB 12
2019.gnucash.20210219151108.gnucash.LCK on 8.3.2021 and I have several -
https___bugs_gnucash_org_enter_bug_cgi_product=GnuCash files on the same
date, as well as several -
{7C5A40EF-A0FB-4BFC-874A-C0F2E0B9FA8E}_gnucash_doc_gnucash_README_win32-bin_
txt files dated the same date, 8.3.2021.
>>
>> The file names don't seem to align with the help file data.
>>
>> Any ideas?
>>
>> Thanks Finbar
>>
>> On 13/03/2021 19:47, John Ralls wrote:
>>
>>> The important thing is to make sure that you don't restore an old
version of GnuCash dlls. The most straightforward way is to leave
executables out of the backup plan because you can always download them
again from their respective sources. A bit less simple is to have a separate
backup set for them so that you can easily roll back after an update or
restore more quickly after a disk failure.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
On Mar 13, 2021, at 6:06 AM, Mahon Finbar
wrote:
OK, I'll try that, thanks.
I
[GNC] weird price for LU0067412154
Hi. Something odd is going on but I can't decide if it is F::Q at fault or GC: Thing is, the UK website lists a totally reasonable price, so it's either gnc-fq-dump or F::Q who is playing fast and loose with numbers :) The price editor is affected as well, actually that's how I found out. For the moment I simply switched source but I'm puzzled. Any pointers? Thanks, Andrea. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
What quote source are you using? This doesn't work for me with Yahoo-JSON:
gnc-fq-dump yahoo_json LU0067412154
Use of uninitialized value $json_name in concatenation (.) or string at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 132.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 145.
Use of uninitialized value $info{"LU0067412154\34currency"} in string eq
at /usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 156.
Use of uninitialized value in sprintf at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 178.
Use of uninitialized value in sprintf at
/usr/share/perl5/vendor_perl/Finance/Quote/YahooJSON.pm line 178.
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
date: 03/17/2021 <=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
-derek
On Wed, March 17, 2021 3:07 pm, Andrea Borgia wrote:
> Hi.
>
> Something odd is going on but I can't decide if it is F::Q at fault or GC:
>
> Thing is, the UK website lists a totally reasonable price, so it's
> either gnc-fq-dump or F::Q who is playing fast and loose with numbers :)
>
>
> The price editor is affected as well, actually that's how I found out.
> For the moment I simply switched source but I'm puzzled.
>
> Any pointers?
>
>
> Thanks,
>
> Andrea.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Billable Expenses carried over into the new year
On 3/17/2021 1:04 PM, Andrew via gnucash-user wrote: Small business owner who is definitely not a trained accountant here, so please bear with me if none of this makes sense. Our business regularly incurs travel expenses while performing work for clients, which we invoice to the client with no markup. We reimburse the employees as they incur the expenses and I book those as Reimbursable Expenses. When the client pays their invoice, I rebate that expense account the portion of the invoice that was expenses while the reminder of the invoice is marked as income in the appropriate client's account. I was doing this so that I could differentiate between what was truly income, and what was just a cost that I was pass through to the client. This really seemed to work well until we closed our books at the end of the year and started 2021 fresh and we had a client pay their December 2020 invoice late. Came in on January 3rd. So now I've got a billable expense being reimbursed to us, but for the life of me I can't figure out how to handle it since we zeroed out all the expense accounts on January 1. Do I set up an opening balance in the Reimbursable Expenses Account? This seems like I would be double-booking the same expense in two different years. Do I set up a Reimbursable Expenses Receivable Account and have the new invoice go there? Thanks, Andrew Not exactly a gnucash question as you have the same question in the old pen and ink on paper days. Treat it the same way you usually do (temporarily, that "reimbursable expenses" might have a credit balance). What happened is that your expenses were slightly overstated last year (by what was still in ""reimbursable expenses", not yet cancelled out) and this year will be slightly understated, by the same amount. Opening balances are just for when creating new books. You don't need to use them even in that case as you can use an explicit opening transaction (or two to avoid a two sided split) Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
Il 17/03/21 20:12, Derek Atkins ha scritto: What quote source are you using? This doesn't work for me with Yahoo-JSON: It was in the first screenshot, here is the text version: gnc-fq-dump morningstarch LU0067412154 gnc-fq-dump mstaruk LU0067412154 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
Hi, On Wed, March 17, 2021 3:18 pm, Andrea Borgia wrote: > > Il 17/03/21 20:12, Derek Atkins ha scritto: >> What quote source are you using? This doesn't work for me with >> Yahoo-JSON: > > It was in the first screenshot, here is the text version: The screenshot didn't make it through the email, most likely because you sent it as an embedded image in HTML instead of as a text with attachment. > > gnc-fq-dump morningstarch LU0067412154 When I run this, I get: gnc-fq-dump morningstarch LU0067412154 Finance::Quote fields Gnucash uses: symbol: LU0067412154 <=== required date: 03/17/2021 <=== recommended currency: USD <=== required last: 2150.31 <=\ nav: 2150.31 <=== one of these price: 2150.31 <=/ timezone: <=== optional > gnc-fq-dump mstaruk LU0067412154 This gives me different results: gnc-fq-dump mstaruk LU0067412154 Finance::Quote fields Gnucash uses: symbol: LU0067412154 <=== required date: 03/17/2021 <=== recommended currency: USD <=== required last: 5356.02 <=\ nav: 5356.02 <=== one of these price: 5356.02 <=/ timezone: <=== optional So I would say the issue is upstream, possibly with the quote sources. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
Il 17/03/21 20:32, Derek Atkins ha scritto: The screenshot didn't make it through the email, most likely because you sent it as an embedded image in HTML instead of as a text with attachment. Yes and I never had any issues before. Weird. My apologies. gnc-fq-dump morningstarch LU0067412154 When I run this, I get: gnc-fq-dump morningstarch LU0067412154 Finance::Quote fields Gnucash uses: symbol: LU0067412154 <=== required date: 03/17/2021 <=== recommended currency: USD <=== required last: 2150.31 <=\ nav: 2150.31 <=== one of these price: 2150.31 <=/ timezone: <=== optional gnc-fq-dump mstaruk LU0067412154 This gives me different results: gnc-fq-dump mstaruk LU0067412154 Finance::Quote fields Gnucash uses: symbol: LU0067412154 <=== required date: 03/17/2021 <=== recommended currency: USD <=== required last: 5356.02 <=\ nav: 5356.02 <=== one of these price: 5356.02 <=/ timezone: <=== optional So I would say the issue is upstream, possibly with the quote sources. Hmm, the UK site of MorningStar gives a totally reasonable value. That's why I asked. Pity, the screenshot of the website is missing as well. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mystery per-security Opening Balances accounts appearing
> (1) Has anyone else seen this? Yes, you are not going crazy, I have had a similar problem on a few occasions myself in the past month, however I can't put my finger on the reason why or reproduce it. GnuCash 4.4 on Windows 10. > (2) What gives? No idea, I just deleted the accounts. It's a minor nuisance. Regards Geoff = On 18/03/2021 4:00 am, peterb wrote: I've been using Gnucash for well over a year and a half. Sometime within the past few months, I have seen a number of completely empty Opening Balances equity accounts opening themselves for certain securities that I own. They are always denominated in the currency of the security; so for example I have one right now: [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] These accounts have no balance, no transactions in them, and *to the best of my knowledge* have never had a transaction in them. I have asset accounts for about 75 securities, but only see this for around 10 of my securities. Most of them were acquired after starting to use GnuCash, so the top-level Equity:Opening-Balances account would not have been involved at all. (1) Has anyone else seen this? (2) What gives? Thanks! Peter ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
The pretty-printed elements from the Developer menu won’t be matched by the RE. Can you see the raw html? Peter — p...@ehealth.id.au “…an hour is coming when all who are in the tombs will hear his voice and come out…” > On 18 Mar 2021, at 10:09 am, Geoff wrote: > > This looks like a problem with Finance Quote's MStaruk.pm module. Did > Morningstar change their web site recently? > > Testing the recent Finance Quote v1.50 release candidate, without using any > GnuCash code, I get the same results. > > See attached screenshot - I think the problem lies with the long regular > expression on line 160. It contains a couple of "greedy" matches that are > probably causing a match on the last decimal number (Share Class Size) > instead of the first (NAV). > > Geoff > = > > On 18/03/2021 6:48 am, Andrea Borgia wrote: >> Il 17/03/21 20:32, Derek Atkins ha scritto: >>> The screenshot didn't make it through the email, most likely because you >>> sent it as an embedded image in HTML instead of as a text with attachment. >> Yes and I never had any issues before. Weird. >> My apologies. gnc-fq-dump morningstarch LU0067412154 >>> When I run this, I get: >>> >>> gnc-fq-dump morningstarch LU0067412154 >>> Finance::Quote fields Gnucash uses: >>> symbol: LU0067412154 <=== required >>>date: 03/17/2021 <=== recommended >>>currency: USD <=== required >>>last: 2150.31 <=\ >>> nav: 2150.31 <=== one of these >>> price: 2150.31 <=/ >>>timezone: <=== optional >>> >>> gnc-fq-dump mstaruk LU0067412154 >>> This gives me different results: >>> >>> gnc-fq-dump mstaruk LU0067412154 >>> Finance::Quote fields Gnucash uses: >>> symbol: LU0067412154 <=== required >>>date: 03/17/2021 <=== recommended >>>currency: USD <=== required >>>last: 5356.02 <=\ >>> nav: 5356.02 <=== one of these >>> price: 5356.02 <=/ >>>timezone: <=== optional >>> >>> So I would say the issue is upstream, possibly with the quote sources. >> Hmm, the UK site of MorningStar gives a totally reasonable value. >> That's why I asked. >> Pity, the screenshot of the website is missing as well. >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mystery per-security Opening Balances accounts appearing
I've been meaning to ask about this behavior too. I *think* it started sometime between version 4.1 and 4.4. It seems to me to happen when creating -- or editing -- an account that has a non-currency commodity. As Geoff said, it's a minor nuisance and I just delete the extra accounts when they appear. But I am curious about the use case that would necessitate this change. Unless creating a new set of books, I'm generally not going to offset an asset acquisition transaction against an opening balance account. But almost any editing of an account setup will trigger the creation of the Opening Balance account. And I'm not sure what the equity account is supposed to show. For example in the following test case: 1) Create an account with type STOCK. Opening Balance tab is greyed out. 2) The stock account and the Opening Balance accounts are created 3) Enter a transaction from the stock account, with a DR to the stock account and a CR to the Opening Balance account. Result shows the transaction in the stock account register as expected; but in the Opening Balance account register, the transaction is entered, but no value in either the DR or CR column 4) Enter a transaction from the Opening Balance account with a CR to the Opening Balance account and a DR to the stock account. Save the transaction and Gnucash displays the transfer dialog. Enter a price and save the transaction. Then the transaction appears as expected in both registers. I'm using the SQLite database, so in the transaction from Step 3, Opening Balance account split shows 0 in the quantity_num field, but the transaction in Step 4 shows the appropriate share value in quantity_num split on both sides of the transaction. Step 3 seems like a bug, notwithstanding the purpose of the Opening Balance account I'm using Gnucash 4.4 in Ubuntu 20.04 as a VM client on a Windows 10 host machine. On Wed, Mar 17, 2021 at 7:20 PM Geoff wrote: > > (1) Has anyone else seen this? > > Yes, you are not going crazy, I have had a similar problem on a few > occasions myself in the past month, however I can't put my finger on the > reason why or reproduce it. > > GnuCash 4.4 on Windows 10. > > > > (2) What gives? > > No idea, I just deleted the accounts. It's a minor nuisance. > > > Regards > > Geoff > = > > On 18/03/2021 4:00 am, peterb wrote: > > I've been using Gnucash for well over a year and a half. Sometime within > > the past few months, I have seen a number of completely empty Opening > > Balances equity accounts opening themselves for certain securities that I > > own. They are always denominated in the currency of the security; so for > > example I have one right now: > > [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] > > These accounts have no balance, no transactions in them, and *to the best > > of my knowledge* have never had a transaction in them. > > I have asset accounts for about 75 securities, but only see this for > around > > 10 of my securities. Most of them were acquired after starting to use > > GnuCash, so the top-level Equity:Opening-Balances account would not have > > been involved at all. > > > > (1) Has anyone else seen this? > > (2) What gives? > > > > Thanks! > > > > Peter > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mystery per-security Opening Balances accounts appearing
May be side effect from https://github.com/Gnucash/gnucash/pull/762 On Thu, 18 Mar 2021, 11:09 am Robin Chattopadhyay, wrote: > I've been meaning to ask about this behavior too. I *think* it started > sometime between version 4.1 and 4.4. It seems to me to happen when > creating -- or editing -- an account that has a non-currency commodity. As > Geoff said, it's a minor nuisance and I just delete the extra accounts when > they appear. > > But I am curious about the use case that would necessitate this change. > Unless creating a new set of books, I'm generally not going to offset an > asset acquisition transaction against an opening balance account. But > almost any editing of an account setup will trigger the creation of the > Opening Balance account. > > And I'm not sure what the equity account is supposed to show. For example > in the following test case: > 1) Create an account with type STOCK. Opening Balance tab is greyed out. > 2) The stock account and the Opening Balance accounts are created > 3) Enter a transaction from the stock account, with a DR to the stock > account and a CR to the Opening Balance account. Result shows the > transaction in the stock account register as expected; but in the Opening > Balance account register, the transaction is entered, but no value in > either the DR or CR column > 4) Enter a transaction from the Opening Balance account with a CR to the > Opening Balance account and a DR to the stock account. Save the transaction > and Gnucash displays the transfer dialog. Enter a price and save the > transaction. Then the transaction appears as expected in both registers. > > I'm using the SQLite database, so in the transaction from Step 3, Opening > Balance account split shows 0 in the quantity_num field, but the > transaction in Step 4 shows the appropriate share value in quantity_num > split on both sides of the transaction. Step 3 seems like a bug, > notwithstanding the purpose of the Opening Balance account > > I'm using Gnucash 4.4 in Ubuntu 20.04 as a VM client on a Windows 10 host > machine. > > On Wed, Mar 17, 2021 at 7:20 PM Geoff wrote: > > > > (1) Has anyone else seen this? > > > > Yes, you are not going crazy, I have had a similar problem on a few > > occasions myself in the past month, however I can't put my finger on the > > reason why or reproduce it. > > > > GnuCash 4.4 on Windows 10. > > > > > > > (2) What gives? > > > > No idea, I just deleted the accounts. It's a minor nuisance. > > > > > > Regards > > > > Geoff > > = > > > > On 18/03/2021 4:00 am, peterb wrote: > > > I've been using Gnucash for well over a year and a half. Sometime > within > > > the past few months, I have seen a number of completely empty Opening > > > Balances equity accounts opening themselves for certain securities > that I > > > own. They are always denominated in the currency of the security; so > for > > > example I have one right now: > > > [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] > > > These accounts have no balance, no transactions in them, and *to the > best > > > of my knowledge* have never had a transaction in them. > > > I have asset accounts for about 75 securities, but only see this for > > around > > > 10 of my securities. Most of them were acquired after starting to use > > > GnuCash, so the top-level Equity:Opening-Balances account would not > have > > > been involved at all. > > > > > > (1) Has anyone else seen this? > > > (2) What gives? > > > > > > Thanks! > > > > > > Peter > > > > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > - > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. >
Re: [GNC] Importing Accounts with non-English Characters
Resent to the list because of a server bounce. Sorry for the dupe, Adrien. There's a checkbox in System Preferences>Keyboard>Input Sources to show input menu in the menu bar. Turn that on: It includes two items, Show Emoji & Symbols, that actually gives access to all code points, and Show Keyboard Viewer, which shows what keys do what; it's interactive so if you hold down option it shows what characters it makes available. With the US English keyboard there are some combining keys, circled in orange: `, e, u, i, and n for accent aigue, accent grave, dieresis, circumflex, and cedilla respectively. Regards, John Ralls > On Mar 17, 2021, at 8:26 AM, Adrien Monteleone > wrote: > > Not sure if this is related with the overload, but I noticed that when > triggering the accented character selector/pop-up in MacOS, I can't type the > number for the character I want like in other apps. I still can use the arrow > keys though. Otherwise, I can get most characters by remembering the specific > Option sequence, but all of mine are simple two-key presses so I've yet to > know if more complicated combos are an issue. > > Regards, > Adrien > > On 3/16/21 11:21 PM, John Ralls wrote: >> Looks like option is getting used as part of shortcuts, intercepting its use >> for extending the keyboard. Option-u-u opens that weird entry box and >> option-o operates the OK key. Option-e still works to create an accent-grave >> so it's just modifier key overloads. In the transfer dialog option-u-u makes >> a ü as it should, but option-o still operates the OK button. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] weird price for LU0067412154
Here’s the RE.
m[NAV([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*>([0-9\.\-]+)]
There is no trailing modifier, so this has to be a single line in the html.
So it will start looking with the initial literal string including NAV and
ending with the '’ which shows in pretty-print as ‘’. That won’t
match if it’s actually like that, of course. What is the full raw html text of
the in which the $5356.02 appears?
—
p...@ehealth.id.au
“…you refuse to come to me that you may have life.”
> On 18 Mar 2021, at 11:57 am, Peter West wrote:
>
> The pretty-printed elements from the Developer menu won’t be matched by the
> RE. Can you see the raw html?
>
> Peter
> —
> p...@ehealth.id.au
> “…an hour is coming when all who are in the tombs will hear his voice and
> come out…”
>
>> On 18 Mar 2021, at 10:09 am, Geoff wrote:
>>
>> This looks like a problem with Finance Quote's MStaruk.pm module. Did
>> Morningstar change their web site recently?
>>
>> Testing the recent Finance Quote v1.50 release candidate, without using any
>> GnuCash code, I get the same results.
>>
>> See attached screenshot - I think the problem lies with the long regular
>> expression on line 160. It contains a couple of "greedy" matches that are
>> probably causing a match on the last decimal number (Share Class Size)
>> instead of the first (NAV).
>>
>> Geoff
>> =
>>
>> On 18/03/2021 6:48 am, Andrea Borgia wrote:
>>> Il 17/03/21 20:32, Derek Atkins ha scritto:
The screenshot didn't make it through the email, most likely because you
sent it as an embedded image in HTML instead of as a text with attachment.
>>> Yes and I never had any issues before. Weird.
>>> My apologies.
> gnc-fq-dump morningstarch LU0067412154
When I run this, I get:
gnc-fq-dump morningstarch LU0067412154
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
date: 03/17/2021 <=== recommended
currency: USD <=== required
last: 2150.31 <=\
nav: 2150.31 <=== one of these
price: 2150.31 <=/
timezone: <=== optional
> gnc-fq-dump mstaruk LU0067412154
This gives me different results:
gnc-fq-dump mstaruk LU0067412154
Finance::Quote fields Gnucash uses:
symbol: LU0067412154 <=== required
date: 03/17/2021 <=== recommended
currency: USD <=== required
last: 5356.02 <=\
nav: 5356.02 <=== one of these
price: 5356.02 <=/
timezone: <=== optional
So I would say the issue is upstream, possibly with the quote sources.
>>> Hmm, the UK site of MorningStar gives a totally reasonable value.
>>> That's why I asked.
>>> Pity, the screenshot of the website is missing as well.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing Accounts with non-English Characters
Yes, well aware of that and I have it on and use it occasionally. I also use key combos as you noted. I don't always remember which option-combos produce which accent. So I usually use something else: MacOS has a feature where you can hold down a key that has accented options and you get a pop-up displaying each of them. There is a number under each one. You can then type the number for the glyph you want, or use the arrow keys (or mouse/pointer) to select it. (this way, you don't have to remember 'aigue' is the 'e' key. If you want that on the letter 'a', just hold down 'a' and you'll get the pop-up. (this might be something you can toggle, not sure) When using GnuCash, I can't use the method of typing the number for the glyph. But the arrow keys or point-n-click works. (as does direct combo entry if I can remember it) Of course, using the 'Emoji & Symbols' tool works as well, it's just that none of those are as convenient as the pop-up. I thought since multiple subsequent key presses are required for that method, perhaps it might be related. Sorry if I hijacked the thread. Regards, Adrien On 3/17/21 11:06 PM, John Ralls wrote: Resent to the list because of a server bounce. Sorry for the dupe, Adrien. No worries. There's a checkbox in System Preferences>Keyboard>Input Sources to show input menu in the menu bar. Turn that on: It includes two items, Show Emoji & Symbols, that actually gives access to all code points, and Show Keyboard Viewer, which shows what keys do what; it's interactive so if you hold down option it shows what characters it makes available. With the US English keyboard there are some combining keys, circled in orange: `, e, u, i, and n for accent aigue, accent grave, dieresis, circumflex, and cedilla respectively. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
