[GNC] operation still running....
I completed reconciliation and then tried to save and close. I received a message, "An operation is still running, wait for it to complete before quitting." I've been waiting for quite a while, and nothing seems to be hitting. If I attempt to save, I get the same message. Only the list of accounts window is open. How should I proceed? I am running Version: 4.8, Build ID: 4.8a+(2021-09-28), from, as I recall, Ubuntu repository. Using Neon Linux, and ubuntu derivative. Thank you for any suggestions. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.61 released!
On Thu, 18 Apr 2024 21:34:49 -0700 "Bruce Schuck" wrote: > New version 1.61 of Finance-Quote is available with the following > changes: > > * SIX.pm - Changed lookup for currency, added lookups for > symbol and last. Issue #380 > * YahooJSON.pm - URLs to retrieve required cookies and crumbs > were changed to allow EU based users to use the module. Issue #373 > Can confirm yahoojson is now working from the UK. Thank you! -- Richard signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 12:39:51 -0700
"Bruce Schuck" wrote:
> "AS=v=1=..." cookie.
>
> ### [Wed Apr 17 08:59:30 2024]cookie_jar : bless( {
> ### COOKIES => {
> ### 'login.yahoo.com' => {
> ### '/' => {
> ### AS => [
> ### 0,
> ###
> 'v=1=pdMraThU=A6620c4d1|itU7Kpb.2SoujXrNK8pQPMi...
> ### undef,
> ### 1,
> ### 1,
> ### undef,
> ### 1,
> ### {
> ### HttpOnly => undef
> ### }
> ### ]
> ### }
> ### }
> ### }
> ### }, 'HTTP::Cookies' )
>
> The other 3 cookies that I get can see in debug mode are not in the
> cookie jar. My theory is that for those it is not working, they are
> not getting all 4 cookies.
>
Sorry for the delayed response. I had to build packages for missing
dependencie
s required by stockdump.pl.
I'm in the UK and confirm output from stockdump.pl shows only the AS
cookie.
Output from
curl --include
https://login.yahoo.com/?.lang=en-US=finance&.done=https%3A%2F%2Ffinance.yahoo.com%2F=118332=ybar-signin
from the UK gives the same result.
--
Richard
signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 11:58:37 -0400 "Kalpesh Patel" wrote: > Richard, > > Is this happening on Windows 10 with Strawberry perl? > > There is one other user is having problem getting secure cookies on > Windows 10 which is what this appears to be as well. It is related to > some Perl's SSL package being broken or not installed correctly but > haven't been able to pinpoint it. Hi Kalpesh, I'm running Arch Linux with perl 5.38.2. -- Richard signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 08:23:38 +0200
"Adam Griffis" wrote:
> Yes, I have the AlphaVantage api key set. But that's not the issue --
> I'm not pulling from AlphaVantage. I'm pulling from YahooJSON.
>
> If I understand correctly, the 1.60 update should include a fix to get
> YahooJSON working again, resolving the "cookie and crumb" issue.
> However, YahooJSON is still giving me the same error. Is an API key
> required for YahooJSON now?
>
> Thanks,
> Adam
yahoojson and yahooweb are not working for me either in v1.60 and they
didn't work in 1.59_01.
I have perl-http-cookiejar installed.
perl-finance-quote has been dropped from the arch repos to the AUR.
It's still at 1.59 in the AUR so I've taken the PKGBUILD and modified
it for 1.60.
I am currently running gnucash v4.14.
The output for yahoojson is...
gnc-fq-dump -v yahoojson AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L<=== required
date: **
missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: Error retrieving quote for AEI.L. Attempt to
fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=AEI.L={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}=price,summaryDetail,defaultKeyStatistics resulted in
HTTP response 401 (Unauthorized)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
AEI.L symbol: AEI.L
The output for yahooweb is...
gnc-fq-dump -v y
ahooweb AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L (deduced) <=== required
date: ** missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: 500 Header line too long (limit is 8192)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
--
Richard
signature.asc
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] Invoking Vendors report causes closure of GNU Cash V5.5
Hi, I have used V5.4 satisfactorily for some while. I then recently installed V5.5 on an Asus notebook operating under Win 11. From the first time of use whenever I used the Vendor's Report GNU Cash closed. It simply exited with no invitation to save, or other warning. It did not close the lock file. To check this I ran GNU Cash with no other apps running. The behaviour was repeated irrespective of the specific vendor, or style sheet used. I have reverted to V5.4. Has anyone else experienced this. -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Scheduled Transactions status cannot be changed
I just installed GnuCash 5.5 yesterday (upgraded from 5.4.1) and noticed that I am not able to change the status of Scheduled Transactions from the Actions | Scheduled Transactions | Since Last Run dialog box. When I click on the status field of any of the transactions in the Since Last Run.. dialog I see the pop up menu listing (Ignored, Postponed, To Create, Reminder), but if I click on one any of them, the new status is not saved. I'm running GnuCash on Windows 11, latest patches, on an Intel Core i7-10700 CPU. I have had to downgrade to version 5.4.1 to get the scheduled Transaction functionality working. Warm Regards Richard De Vriese ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Since Last Run Status Options BUG
I have installed version 5.5 and have seen that only transactions within my days of notice appear. Great. However, now the options that you show for the Status are not responsive. Ignored Postponed To-Create Reminder If I try to change the status of the above listed 4-items from reminder to something else, it is not responding to my choice. Can you fix this? Richard ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reports not displaying.
John, The issue is with webkitgtk 2.42 on Nvidia GPUs and not directly related to flatpak. From the bug report [https://bugs.webkit.org/show\_bug.cgi?id=261874][https_bugs.webkit.org_show_bug.cgi_id_261874] setting WEBKIT\_DISABLE\_DMABUF\_RENDERER=1 provides a temporary fix. This fixed report rendering in gnucash for me. I'm running gnucash 4.14 built from source on an arch system which has webkitgtk 2.42. Regards, Richard \ Original Message On 4 Oct 2023, 05:08, john < jra...@ceridwen.us> wrote: > > Since releasing GnuCash 5.4 we've gotten 3 bug reports (see below) about > report tabs failing to display anything. Two of the three are for the flatpak > distribution of GnuCash 5.4 and running WEBKIT\_DISABLE\_COMPOSITING\_MODE=1 > flatpak run org.gnucash.GnuCash works around the problem and allows reports > to display normally. Both users have Nvidia GPUs, one quite old. The third > report says its for GnuCash 5.2 and the reporter hasn't yet provided any > details. The second reporter also installed Gnome Web, aka Epiphany, via > Flathub and reported that it has the same symptoms. For reference GnuCash > 5.3's flatpak used Gnome Runtime 43 with WebKitGtk 2.37, GnuCash 5.4's is > Gnome Runtime 44 with WebKitGtk 2.39, and the current Epiphany flatpak is > runtime 45 with WebKitGtk 2.42. In addition to flatpaks it seems likely to me > that bleeding-edge distributions like Arch Linux might be affected. I'd like > to know who else is affected along with what GPU and driver they have and if > they're not using the flatpak what version of WebKitGtk they have installed. > I'd also like to collect the same information from people who have Nvidia > GPUs and WebKitGtk >= 2.39 for whom GnuCash reports render normally. Regards, > John Ralls https://bugs.gnucash.org/show\_bug.cgi?id=799086 > https://bugs.gnucash.org/show\_bug.cgi?id=799095 > https://bugs.gnucash.org/show\_bug.cgi?id=799095 > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > gnucash-user mailing list gnucash-user@gnucash.org To update your > subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember > to CC this list on all your replies. You can do this by using Reply-To-List > or Reply-All. [https_bugs.webkit.org_show_bug.cgi_id_261874]: https://bugs.webkit.org/show_bug.cgi?id=261874 signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Copying report formats to new PC
Hi, I'm moving GNUCash to a new PC. I've moved the data files, but I've also got a bunch of customised graphs that open by default when I open that file. When I open the file on the new PC, those are missing. I've googled, and as a result have tried copying the files located at users\username\appdata\roaming\gnucash, but that hasn't helped. Obviously there's some extra data/preferences stored elsewhere, but I can't seem to find the info? I'm on GNUCash 5.3 on both PCs, and windows 11 on both. Thanks, Rich [d14fcb23-8f58-4585-a6d1-d6c95a1dea1d] ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.57_02 - YahooWeb gets correct trading date and fixed pricing for single char symbols
Hi Bruce, Just confirming there were no issues updating prices after market close yesterday. Arch Linux Gnucash 4.14 Finance::Quote 1.57\_02 yahoojson yahooweb mstaruk Regards, Richard \ Original Message On 16 Jul 2023, 21:38, Bruce Schuck < bsch...@asgard-systems.com> wrote: > > Greetings, Another beta pre-release for F::Q v1.58 has been uploaded to CPAN. > The URL used by YahooWeb (yahooweb) has been changed to the date is pulled > from web page. The issue with some single-character symbols getting bad > pricing has also been fixed, and labels 'open', 'high', 'low', and 'volume' > have been added. Again, not a production indexed release, you can still > install it using CPAN. $ cpan BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ > cpanm BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ perl -MCPAN -e shell cpan> > install BPSCHUCK/Finance-Quote-1.57\_02.tar.gz Bruce S. > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > gnucash-user mailing list gnucash-user@gnucash.org To update your > subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember > to CC this list on all your replies. You can do this by using Reply-To-List > or Reply-All. signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.57_01 - YahooJSON Quick Fix
On 15/07/2023 03:28, Bruce Schuck wrote: Greetings, A beta pre-release for F::Q v1.58 has been uploaded to CPAN. It has the quick fix I noted in the earlier "Yahoo Closed the Door on Finance API" thread. Hi Bruce, I've already updated Friday's prices using your quick fix which worked fine, so I'll test this using v1.57_01 after Monday's close. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance-Quote 1.57 released!
Hi Bruce, When prices are updated after midnight, the yahooweb price source is returning the current date instead of the price date. See below... date Wed 5 Jul 00:02:35 BST 2023 gnc-fq-dump yahoo_json STAN.L symbol: STAN.L <=== required date: 07/04/2023 <=== recommended currency: GBP <=== required last: 6.918<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb STAN.L symbol: STAN.L <=== required date: 07/05/2023 <=== recommended currency: GBP <=== required last: 6.918<=\ nav: <=== one of these price: <=/ timezone: <=== optional Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation
On 27/06/2023 02:43, Bruce Schuck wrote: On 6/26/23 22:42 +, Richard Ullger wrote: Thanks for the 1.56_04 update. The price format for LSE securities using the yahooweb price source is fixed but I'm getting a difference in precision on crypto between yahoo_json and yahooweb. Unfortunately that is because the precision available from https://finance.yahoo.com/quote/USDT-USD?p=USDT-USD&.tsrc=fin-srch is not the same as it is from the API. Bruce S. Hi Bruce, I just wanted to report that I have been downloading prices in gnucash for both US and UK stocks and ETFs using yahoo_json and yahooweb price sources without any errors. Arch Linux, gnucash 4.14, Finance::Quote 1.56_04. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation
On 25/06/2023 02:30, Bruce Schuck wrote: Oooops! Make that 1.56_04. I forgot to merge one pull request. Hi Bruce, Thanks for the 1.56_04 update. The price format for LSE securities using the yahooweb price source is fixed but I'm getting a difference in precision on crypto between yahoo_json and yahooweb. gnc-fq-dump yahoo_json USDT-USD symbol: USDT-USD <=== required date: 06/26/2023 <=== recommended currency: USD <=== required last: 1.0002108<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb USDT-USD symbol: USDT-USD <=== required date: 06/26/2023 <=== recommended currency: USD <=== required last: 1.0002 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation
On 15/06/2023 20:23, Bruce Schuck wrote: Non-production release 1.56_02 is available for evaluation/testing. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. Anticipating that Yahoo may block access to the URL used in the YahooJSON (yahoo_json) module, there are 3 new modules that gather information from URLs normally accessed through a browser. GoogleWeb (googleweb) MarketWatch (marketwatch) YahooWeb (yahooweb) Hi Bruce, I'm doing preliminary testing using gnc-fq-dump with the yahoo_json and yahooweb sources. I'm getting different price formats between the two sources for LSE securities with yahoo_json being the correct format. gnc-fq-dump yahoo_json SUK2.L symbol: SUK2.L <=== required date: 06/16/2023 <=== recommended currency: GBP <=== required last: 3.53975 <=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb SUK2.L symbol: SUK2.L <=== required date: 06/16/2023 <=== recommended currency: GBp (0.01 GBP) <=== required last: 353.98 <=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahoo_json STAN.L symbol: STAN.L <=== required date: 06/16/2023 <=== recommended currency: GBP <=== required last: 6.752<=\ nav: <=== one of these price: <=/ timezone: <=== optional gnc-fq-dump yahooweb STAN.L symbol: STAN.L <=== required date: 06/16/2023 <=== recommended currency: GBp (0.01 GBP) <=== required last: 675.20 <=\ nav: <=== one of these price: <=/ timezone: <=== optional Arch Linux, gnucash 4.14. Regards, Richard OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [Bug 798864] Budget Reporting on select reports are wrong
I have followed the GnuCash account structure format in setting up my accounts. Both my Income and Expense Accounts are Top Level Accounts. Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:43 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #8 from Christopher Lam --- P.S. even if this is the right fix, the budget report is very likely to show wildly incorrect amounts if the user has an unusual account structure, e.g. an Expense account whose parent-account is Income. -- You are receiving this mail because: You reported the bug. You are on the CC list for the bug. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [Bug 798864] Budget Revalues for the Income are positive numbers.porting on select reports are wrong
Sounds like you understand my problem. However, since I'm not a programmer, I hesitate to tackle this patch. Maybe it is easier than it looks and is probably the best fix? I'm just nervous here. Let me ask this basic question. When I am creating my Budget, I have assumed this: 1. All Income values are positive numbers. 2. All Expense values are negative numbers. With that being said and used, my reports work for; a) Profit and Loss Report and b) my Budget Report. Now the question is, where do I go from here? Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:19 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #7 from Christopher Lam --- Created attachment 374682 --> https://bugs.gnucash.org/attachment.cgi?id=374682=edit candidate patch Here's a candidate replacement for budget-income-statement.scm, or the patch pasted below. You can overwrite the budget-income-statement.scm somewhere into the Program Files\gnucash\etc...\ (you'll need admin access). It changes the definition of net-income from simple summation to a recalculation of balances of both income and expense budget amounts. I think this is the correct fix. modified gnucash/report/reports/standard/budget-income-statement.scm @@ -428,7 +428,11 @@ (gnc:get-assoc-account-balances-total expense-account-balances)) (net-income - (gnc:collector- revenue-total expense-total)) + (gnc:collector- + (gnc:get-assoc-account-balances-total +(get-assoc-account-balances-budget + budget (append revenue-accounts expense-accounts) + period-start period-end gnc:budget-account-get-net (table-env (list -- You are receiving this mail because: You are on the CC list for the bug. You reported the bug. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [Bug 798864] Budget Reporting on select reports are wrong
I expect GnuCash to show the actual Total amount of Income minus the Actual Expenses which would leave the difference, to show the actual net Loss or Gain. Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:08 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #6 from Christopher Lam --- In other words what do you think should be the "Total revenue", "Total expenses" and "Net loss/gain for Budget Unnamed Budget"? -- You are receiving this mail because: You reported the bug. You are on the CC list for the bug. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash 5.0 Budget Reporting on select reports are wrong
I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: 5.0+(2023-03-25)) after realizing that the budget expense calculations were not correct. Not all the budget reports are wrong, but of the reports that I choose to use that are wrong are: 1. Budget Income Statement 2. Budget Profit & Loss Statement. It appears that both the income and expense values(Data) for the above listed reports show the values in black (signifying that they are positive numbers for each income and expenses?). The other reports that I use (not listed) have their values for the income and expenses in black(income) and red(expenses). Those calculations appear to be working fine. The reports listed above show the calculations incorrect. In my preferences, I have checked the box to have all negative amounts to be in "Red". In addition to accessing the reports menu for my saved reports, the program often crashes. I then am required to reopen the program and are given five (5) options before being allowed to continue. They are: 1. Open Read Only 2. Create a new file 3. Open anyway 4. Open Folder 5. Quit I choose option # 3 "Open anyway". After doing that, I save the file and then I continue with my reports. If I am doing something wrong, please forgive me and show me the error of my ways. Thank you in advance for your help. I look forward to hearing from you. Richard Lindgren rlindgr...@outlook.com<mailto:rlindgr...@outlook.com> 269-876-9100 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Exporting from QuickBooks / Importing to GnuCash
I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help here. Please advise me as to a good plan of attack? Thank you very much for help in this matter, and look forward to hearing from you. Richard Lindgren 12799 Sandridge Rd, Sawyer, MI 49125 269-876-9100 rlindgr...@outlook.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Operation is still running, wait for it to complete before quitting
Crossed my fingers, closed GnuCash, and restarted. It started up OK, and all the data appears to be intact. I've been using GnuCash since 1998, and this is the first glitch I have encountered. Not a bad record. Richard On 2/13/23 16:34, David Carlson wrote: I have occasionally seen that release of GnuCash do something similar to that when it crashes. In my case I just re-start it and click open anyway at the prompt. Then I check to see if whatever I was doing completed or if I lost any recent keystrokes. Usually there is little or nothing missing because I do frequent saves before starting anything involving a lot of keystrokes. On Mon, Feb 13, 2023 at 5:52 PM Richard Dawson wrote: On 2/13/23 14:06, Tommy Trussell wrote: > On Mon, Feb 13, 2023 at 3:46 PM Richard Dawson wrote: > > Several hours after after successfully completing reconciliation, I > attempted to add another transaction, and I was greeted with the > message, "Operation is still running, wait for it to complete before > quitting." I've been waiting for an hour or so, and there is no hard > drive activity. Attempting to save gives the same message. > > If I recall correctly, I had saved the file when I completed the > reconciliation, as that is my general practice, but I left the > machine > on with the file open. > > How should I proceed? > > > Unless your system is very very slow, I wouldn't expect ANYTHING in > GnuCash to take more than a few seconds to complete, though I am sure > there must be exceptions. I would strongly suspect a hardware or > network problem in your case. > > Can you determine and tell us the version of GnuCash you're running > (and where you got it, if not from an official source), and can you > tell us what operating system is running on your computer? > > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > GnuCash 4.8, Build ID 4.8a+(2021-09-28) I installed it from Ubuntu repository. My operating system is Kubuntu 22.04 I've been running this version of gnucash for several years, since it became available via Ubuntu. I agree that it shouldn't take this long... It's now been several hours more! Richard ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Operation is still running, wait for it to complete before quitting
On 2/13/23 14:06, Tommy Trussell wrote: On Mon, Feb 13, 2023 at 3:46 PM Richard Dawson wrote: Several hours after after successfully completing reconciliation, I attempted to add another transaction, and I was greeted with the message, "Operation is still running, wait for it to complete before quitting." I've been waiting for an hour or so, and there is no hard drive activity. Attempting to save gives the same message. If I recall correctly, I had saved the file when I completed the reconciliation, as that is my general practice, but I left the machine on with the file open. How should I proceed? Unless your system is very very slow, I wouldn't expect ANYTHING in GnuCash to take more than a few seconds to complete, though I am sure there must be exceptions. I would strongly suspect a hardware or network problem in your case. Can you determine and tell us the version of GnuCash you're running (and where you got it, if not from an official source), and can you tell us what operating system is running on your computer? - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. GnuCash 4.8, Build ID 4.8a+(2021-09-28) I installed it from Ubuntu repository. My operating system is Kubuntu 22.04 I've been running this version of gnucash for several years, since it became available via Ubuntu. I agree that it shouldn't take this long... It's now been several hours more! Richard ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Operation is still running, wait for it to complete before quitting
Several hours after after successfully completing reconciliation, I attempted to add another transaction, and I was greeted with the message, "Operation is still running, wait for it to complete before quitting." I've been waiting for an hour or so, and there is no hard drive activity. Attempting to save gives the same message. If I recall correctly, I had saved the file when I completed the reconciliation, as that is my general practice, but I left the machine on with the file open. How should I proceed? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] End of year for taxes
After having covid and spending 4 months in a nursing home I have forgotten how to pull up the last year to do my taxes. It seems to have wiped my mind clear of how to proceed. I nave to do the last taxes and then close the business as I am in a wheelchair and can no longer carry on. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
Thanks again, Adrien. Much appreciated. I have uninstalled and reinstalled with same outcome. I see others with Windows 11 Pro have not had same issue. Something must be missing or corrupted in my setup or being shared with another program. Have already tried running sfc and DISM. Richard Sent from my iPhone > On 15 Sep 2022, at 15:25, Adrien Monteleone > wrote: > > Ah true, I forgot. And more than likely, the recommendation would be to try > v4.12 to see if the issue is resolved. > > As for dll damage. Windows has the System File Checker. But I think that is > only for stock files. I'm not sure it works for 3rd party software. > > I'd say the easiest route would be a full un-intstall and re-install of > GnuCash, but I think Richard has already done this a few times to no avail. > > Regards, > Adrien > >> On 9/14/22 11:09 PM, David Carlson wrote: >> The developers are less than two weeks away from releasing 4.12, so they do >> not have much time for addressing this issue. It appears to be pointing to >> a dll, which is a Windows module. I don't know if Windows has a way to >> verify whether it is damaged or not. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
Adrien Thank you for your suggestion. I am a novice, but I worked out how to view the Windows logs and think this is the relevant part: Sig[3].Name=Fault Module Name Sig[3].Value=libgdk-3-0.dll Sig[4].Name=Fault Module Version Sig[4].Value=3.24.34.0 Sig[5].Name=Fault Module Timestamp Sig[5].Value= Sig[6].Name=Exception Code Sig[6].Value=c005 Sig[7].Name=Exception Offset Does this mean I have to try and replace the highlighted dll? Richard -Original Message- From: gnucash-user On Behalf Of Richard Clarkson via gnucash-user Sent: 13 September 2022 22:54 To: nvsoar Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11 David Thank you , I’ll have a look tomorrow. Richard Sent from my iPhone > On 13 Sep 2022, at 17:27, nvsoar wrote: > > FWIW - Revo Uninstaller has worked well for me. nvsoar > >> On 09/12/22 13:20, David Carlson wrote: >> Also, in your thread started last May you mentioned an adventure with >> release 4.0 and 4.10, after which you may not have had a clean uninstall. >> Have you tried using either the Windows uninstaller or a third party >> uninstaller? I wish I could remember the name of the third party >> uninstaller that used to work very well, at least several years ago. >> >> On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >>> Richard (Clarkson), >>> >>> You mentioned in the other thread that you also tried from PowerShell. >>> >>> Is there no output there when it fails to completely open? >>> >>> Have you tried to view the Windows Logs to see if any warnings or >>> errors were reported about the time you tried to start GnuCash? >>> >>> Of course, if you can get a Trace File (see the wiki) and/or stack >>> trace that might help too. >>> >>> And to confirm - you downloaded GnuCash *from* the links on >>> gnucash.org, and not somewhere else? (which take you to the GnuCash >>> SourceForge project page) >>> >>> Regards, >>> Adrien >>> >>> On 9/10/22 6:03 PM, Richard Clarkson via gnucash-user wrote: >>>>>> Yes I use the windows installer and I have tried letting the >>>>>> installer >>> delete the previous version and have also tried deleting the >>> previous version myself. >>>>>> From: David Carlson >>>>>> Sent: 10 September 2022 17:33 >>>>>> To: Gyle McCollam >>>>>> Cc: Richard Clarkson ; Gnucash Users < >>> gnucash-user@gnucash.org> >>>>>> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on >>> Windows 11 >>>>>> Are you using the windows installer as downloaded from the >>>>>> Gnucash.org >>> website for each gnucash version? >>>>>> Do you let the installer delete the existing version or do you >>>>>> use >>> another method? >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> 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 > - > 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
David Thank you , I’ll have a look tomorrow. Richard Sent from my iPhone > On 13 Sep 2022, at 17:27, nvsoar wrote: > > FWIW - Revo Uninstaller has worked well for me. nvsoar > >> On 09/12/22 13:20, David Carlson wrote: >> Also, in your thread started last May you mentioned an adventure with >> release 4.0 and 4.10, after which you may not have had a clean uninstall. >> Have you tried using either the Windows uninstaller or a third party >> uninstaller? I wish I could remember the name of the third party >> uninstaller that used to work very well, at least several years ago. >> >> On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >>> Richard (Clarkson), >>> >>> You mentioned in the other thread that you also tried from PowerShell. >>> >>> Is there no output there when it fails to completely open? >>> >>> Have you tried to view the Windows Logs to see if any warnings or errors >>> were reported about the time you tried to start GnuCash? >>> >>> Of course, if you can get a Trace File (see the wiki) and/or stack trace >>> that might help too. >>> >>> And to confirm - you downloaded GnuCash *from* the links on gnucash.org, >>> and not somewhere else? (which take you to the GnuCash SourceForge >>> project page) >>> >>> Regards, >>> Adrien >>> >>> On 9/10/22 6:03 PM, Richard Clarkson via gnucash-user wrote: >>>>>> Yes I use the windows installer and I have tried letting the installer >>> delete the previous version and have also tried deleting the previous >>> version myself. >>>>>> From: David Carlson >>>>>> Sent: 10 September 2022 17:33 >>>>>> To: Gyle McCollam >>>>>> Cc: Richard Clarkson ; Gnucash Users < >>> gnucash-user@gnucash.org> >>>>>> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on >>> Windows 11 >>>>>> Are you using the windows installer as downloaded from the Gnucash.org >>> website for each gnucash version? >>>>>> Do you let the installer delete the existing version or do you use >>> another method? >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> - >>> 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
Thank you Kalpesh. I’ll try that tomorrow. Richard Sent from my iPhone > On 13 Sep 2022, at 22:44, Kalpesh Patel wrote: > > Richard, > > If GNC 4.11 is already installed and still not running then it is worth > reviewing if anything has popped up in any of those three protection > categories -- Ransomware Protection, Tamper Protection or Controlled folder > access -- to double check. Navigate to following on Win 11 and review each > entry listed there, specifically any related to GNC: > Settings --> Privacy & Security --> Windows Security --> Virus & threat > protection --> Virus & threat protection settings --> Manage Settings --> > Controlled folder access --> Manage Controlled folder access --> Block > History > > If nothing related to GNC is there then this is what I recommend: > > Uninstall 4.9 version of GNC using uninstall option of the Windows and then > rename existing directories if they exist to move them out of the harm's > way. Some of these directories contain your customization (like reports) so > you may want to keep track of what got renamed to what so you can undo and > set it back to as it was. The folders that you want to rename are: > "C:\Users\\AppData\Roaming\GnuCash" > "C:\Users\\aqbanking" > "C:\Program Files (x86)\gnucash" > > > Install GNC 4.11 and then tell the protection sub-systems to let it pass > "as-is". To do so add an exception to "Allow an app through Controlled > Folder access" list for GNC binary. Do this for sure as I have it set as > such. Navigate to: > Settings --> Privacy & Security --> Windows Security --> Virus & threat > protection --> Virus & threat protection settings --> Manage Settings --> > Controlled folder access --> Manage Controlled folder access --> Allow an > app through Controlled folder Access > And add the executable by clicking on the "+ Add an allowed app" button > followed by "Browse all app" selection from drop down and then navigating to > gnucash.exe binary located in "C:\Program Files (x86)\gnucash\bin" folder > and clicking "Open" button on the lower right corner. Make sure you have > clicked on gnucash.exe executable (the one with gnucash icon) before > (de-)pressing on the "Open" button. > > Just to rule out contents of the folders where GNC gets installed, add the > root folder exclusion to the list of virus scanning exception list. To do so > go to: > Settings --> Privacy & Security --> Windows Security --> Virus & threat > protection --> Virus & threat protection settings --> Exclusion --> Add or > remove exclusions > And add folder to the list by clicking the "+ Add an exclusion" button > followed by "Folder" selection from drop down and then navigating to > "C:\Program Files (x86)\gnucash\" folder and then clicking "Select Folder" > button in lower right corner. > > Let us see if this bears any fruits on getting GNC 4.11 working on your > Windows 11. > > Kalpesh... > > -Original Message- > From: Richard Clarkson > Sent: Monday, September 12, 2022 2:17 PM > To: 'Kalpesh Patel' > Cc: gnucash-user@gnucash.org > Subject: RE: Opening Gnucash > > Kalpesh > > I haven't enabled Ransomware Protection, Tamper Protection or Controlled > folder access. > > Just looking in to installing gdb so I can obtain the stack trace. Thank > you for that suggestion. > > Richard > > -Original Message- > From: Kalpesh Patel > Sent: 12 September 2022 17:17 > To: rtclark...@btinternet.com > Cc: gnucash-user@gnucash.org > Subject: Re: Opening Gnucash > > I have a feeling that those higher version of GNC are silently crashing due > to improper permission on a file somewhere. Do you know if you have enabled > the Ransomware Protection, Tamper Protection or Controlled folder access > feature in Windows 11? They tend to sometimes cause these sort of silent > error that might be experienced. > > If you are up to it, might be worth following steps in > https://wiki.gnucash.org/wiki/Stack_Trace which might have traces of GNC > failures if GNC is at fault. To capture good deal of debug info, add --debug > switch to GNC as part of the gdb call. > > > > -- > > Message: 1 > Date: Sun, 11 Sep 2022 23:35:53 +0100 > From: "Richard Clarkson" > To: "'Greg Feneis'" , > Subject: Re: [GNC] Opening Gnucash > Message-ID: <001801d8c62e$da672e20$8f358a60$@btinternet.com> > Content-Type:
Re: [GNC] Opening Gnucash
I may have been double clicking because my hands shake and I find myself typing double letters when I type. I carefully tried closing and it is working. I will just have to watch what I do. I am 90 and will watch what I am doing. Thank you for all that help. Richard Barmann On 9/12/2022 4:09 PM, Adrien Monteleone wrote: Richard (Barmann), To open GnuCash, just use the shortcut *for the app*, and *do not* double-click your data file. This will open the last used file. If this gets you what you want - great, the problem is solved. Open GnuCash this way from now on. If this isn't the version of data you expect to see, then please report to us the name of the file you see in the title bar at the top of the GnuCash window. For example, my title bar shows: "personal.gnucash - Accounts - GnuCash" the first part, "personal.gnucash" is the data file name. (the second part is the tab that has focus, "Accounts" in this case, and the third part is of course, the name of the app) If you see numbers in your file name that you didn't put there, you are inadvertently opening a dated backup copy instead of the original main file. We can help you fix it and get back to your main file. Regards, Adrien On 9/12/22 12:14 PM, Richard Barmann wrote: I am using Windows 10.When I close Gnucash and return the next day I cannot find the correct up to date file fr0m the day before. I tried to save/ and then close Gnucash. I wll see if that works. On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: When IO open Gnucash to make some entries in the checking account It opens a page from the past. How can I open the latest page with the entries up to date. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
I may have been double clicking the data file. I followed our instructions and it is working . I want to thank everyone that helped me. Richard Barmann On 9/12/2022 4:09 PM, Adrien Monteleone wrote: Richard (Barmann), To open GnuCash, just use the shortcut *for the app*, and *do not* double-click your data file. This will open the last used file. If this gets you what you want - great, the problem is solved. Open GnuCash this way from now on. If this isn't the version of data you expect to see, then please report to us the name of the file you see in the title bar at the top of the GnuCash window. For example, my title bar shows: "personal.gnucash - Accounts - GnuCash" the first part, "personal.gnucash" is the data file name. (the second part is the tab that has focus, "Accounts" in this case, and the third part is of course, the name of the app) If you see numbers in your file name that you didn't put there, you are inadvertently opening a dated backup copy instead of the original main file. We can help you fix it and get back to your main file. Regards, Adrien On 9/12/22 12:14 PM, Richard Barmann wrote: I am using Windows 10.When I close Gnucash and return the next day I cannot find the correct up to date file fr0m the day before. I tried to save/ and then close Gnucash. I wll see if that works. On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: When IO open Gnucash to make some entries in the checking account It opens a page from the past. How can I open the latest page with the entries up to date. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
Kalpesh I haven't enabled Ransomware Protection, Tamper Protection or Controlled folder access. Just looking in to installing gdb so I can obtain the stack trace. Thank you for that suggestion. Richard -Original Message- From: Kalpesh Patel Sent: 12 September 2022 17:17 To: rtclark...@btinternet.com Cc: gnucash-user@gnucash.org Subject: Re: Opening Gnucash I have a feeling that those higher version of GNC are silently crashing due to improper permission on a file somewhere. Do you know if you have enabled the Ransomware Protection, Tamper Protection or Controlled folder access feature in Windows 11? They tend to sometimes cause these sort of silent error that might be experienced. If you are up to it, might be worth following steps in https://wiki.gnucash.org/wiki/Stack_Trace which might have traces of GNC failures if GNC is at fault. To capture good deal of debug info, add --debug switch to GNC as part of the gdb call. -- Message: 1 Date: Sun, 11 Sep 2022 23:35:53 +0100 From: "Richard Clarkson" To: "'Greg Feneis'" , Subject: Re: [GNC] Opening Gnucash Message-ID: <001801d8c62e$da672e20$8f358a60$@btinternet.com> Content-Type: text/plain; charset="us-ascii" Greg Thank you! As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening from apps, from shortcut, directly from the GnuCash.exe in bin. I cannot open GnuCash from any version higher than 4.9. I see a circle for a few seconds while windows is try to open GnuCash and then nothing. I've tried opening from PowerShell too. Is there any way of seeing where the exe is getting stuck or if something is missing or if I need to update anything? I'm either go to have to stay on 4.9 or change to another program. Thanks you for your help. RIchard -Original Message- From: gnucash-user On Behalf Of Greg Feneis Sent: 11 September 2022 14:59 To: gnucash-user@gnucash.org Subject: Re: [GNC] Opening Gnucash Richard, You may want to provide a few more details. Perhaps mention the version of GnuCash you're using, which OS you're using. How do you open GnuCash, by starting the application or by clicking on a saved file? And so on. Kind regards, Greg Feneis ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
Thanks Gyle - no message, as GnuCash won't open. Tried opening data file with the GnuCash Program and still nothing. Richard -Original Message- From: gnucash-user On Behalf Of Gyle McCollam Sent: 10 September 2022 15:25 To: Richard Barmann ; gnucash-user@gnucash.org Subject: Re: [GNC] Opening Gnucash Richard, You may not have closed it correctly, however in that case you would have gotten a message that the file was locked with options on opening. Gnucash opens the last file, so you may have lost some data. To be sure you have the latest file use open/file and select the most recent ???.gnucash file not any of the log files or files with dates as part of the name. Then try Help/Tutorial and Concepts Guide. In the search box type "log files" enter and it will take you to the page explaining how to restore. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Richard Barmann Sent: Saturday, September 10, 2022 9:35 AM To: gnucash-user@gnucash.org Subject: [GNC] Opening Gnucash When IO open Gnucash to make some entries in the checking account It opens a page from the past. How can I open the latest page with the entries up to date. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
Thanks Michael. No it doesn't. The path is C:/Program Files (x86)/gnucash/bin/gnucash.exe My data file is GNUData.gnucash - there are of course backups. But even if I try to open GnuData.gnucash with GnuCash Program File then nothing happens. Richard -Original Message- From: gnucash-user On Behalf Of Fross, Michael Sent: 12 September 2022 18:35 To: Richard Barmann Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Opening Gnucash Richard, does your GNUCash file have a date string in the name? If so, then you are inadvertently using a backup file. Your filename should be FILENAME.gnucash (FILENAME is whatever you decided to call it) If it looks like: FILENAME.gnucash.20220909023225.gnucash (insert a valid date time stamp) then it's a backup file and you are working on a backup. This is not what you want. If this is the case, do a File | SaveAs and call it NAME.gnucash and go from there. Michael On Mon, Sep 12, 2022 at 12:15 PM Richard Barmann wrote: > I am using Windows 10.When I close Gnucash and return the next day I > cannot find the correct up to date file fr0m the day before. I tried > to save/ and then close Gnucash. I wll see if that works. > > Richard > > On 9/12/2022 10:25 AM, David Carlson wrote: > > Richard, > > > > Do I understand correctly that after you download > gnucash-4.11-1.setup.exe > > from the link on gnucash.org and use it to install GnuCash.exe using > > default settings then the icon on the Windows 11 equivalent to the > Windows > > 10 icon that is supposed to start GnuCash doesn't work? Also > > clicking on the data file icon in file manager manager doesn't work > > either? Yet if > you > > then run gnucash-4.9.setup.exe to revert to release 4.9 then that > > release starts as expected and opens the correctdata file? > > > > If you are doing something different please explain. > > > > > > > > On Sun, Sep 11, 2022, 5:36 PM Richard Clarkson via gnucash-user < > > gnucash-user@gnucash.org> wrote: > > > >> Greg > >> > >> Thank you! > >> > >> As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening > >> from apps, from shortcut, directly from the GnuCash.exe in bin. I > >> cannot open GnuCash from any version higher than 4.9. I see a > >> circle for a few > seconds > >> while windows is try to open GnuCash and then nothing. I've tried > opening > >> from PowerShell too. > >> > >> Is there any way of seeing where the exe is getting stuck or if > something > >> is > >> missing or if I need to update anything? > >> > >> I'm either go to have to stay on 4.9 or change to another program. > >> > >> Thanks you for your help. > >> > >> RIchard > >> > >> -Original Message- > >> From: gnucash-user > >> On > >> Behalf > Of > >> Greg Feneis > >> Sent: 11 September 2022 14:59 > >> To: gnucash-user@gnucash.org > >> Subject: Re: [GNC] Opening Gnucash > >> > >> Richard, > >> > >> You may want to provide a few more details. Perhaps mention the > version of > >> GnuCash you're using, which OS you're using. How do you open > >> GnuCash, > by > >> starting the application or by clicking on a saved file? And so on. > >> > >> Kind regards, > >> > >> Greg Feneis > >> > >> > >> > >> > >> On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: > >> > >>> When IO open Gnucash to make some entries in the checking account > >>> It opens a page from the past. How can I open the latest page with > >>> the entries up to date. > >>> > >>> Richard Barmann > >>> > >>> ___ > >>> gnucash-user mailing list > >>> gnucash-user@gnucash.org > >>> To update your subscription preferences or to unsubscribe: > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >>> - > >>> 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 > >> - > >> Please remember to CC th
Re: [GNC] Opening Gnucash
I am using Windows 10.When I close Gnucash and return the next day I cannot find the correct up to date file fr0m the day before. I tried to save/ and then close Gnucash. I wll see if that works. Richard On 9/12/2022 10:25 AM, David Carlson wrote: Richard, Do I understand correctly that after you download gnucash-4.11-1.setup.exe from the link on gnucash.org and use it to install GnuCash.exe using default settings then the icon on the Windows 11 equivalent to the Windows 10 icon that is supposed to start GnuCash doesn't work? Also clicking on the data file icon in file manager manager doesn't work either? Yet if you then run gnucash-4.9.setup.exe to revert to release 4.9 then that release starts as expected and opens the correctdata file? If you are doing something different please explain. On Sun, Sep 11, 2022, 5:36 PM Richard Clarkson via gnucash-user < gnucash-user@gnucash.org> wrote: Greg Thank you! As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening from apps, from shortcut, directly from the GnuCash.exe in bin. I cannot open GnuCash from any version higher than 4.9. I see a circle for a few seconds while windows is try to open GnuCash and then nothing. I've tried opening from PowerShell too. Is there any way of seeing where the exe is getting stuck or if something is missing or if I need to update anything? I'm either go to have to stay on 4.9 or change to another program. Thanks you for your help. RIchard -Original Message- From: gnucash-user On Behalf Of Greg Feneis Sent: 11 September 2022 14:59 To: gnucash-user@gnucash.org Subject: Re: [GNC] Opening Gnucash Richard, You may want to provide a few more details. Perhaps mention the version of GnuCash you're using, which OS you're using. How do you open GnuCash, by starting the application or by clicking on a saved file? And so on. Kind regards, Greg Feneis On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: When IO open Gnucash to make some entries in the checking account It opens a page from the past. How can I open the latest page with the entries up to date. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 - 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Opening Gnucash
Greg Thank you! As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening from apps, from shortcut, directly from the GnuCash.exe in bin. I cannot open GnuCash from any version higher than 4.9. I see a circle for a few seconds while windows is try to open GnuCash and then nothing. I've tried opening from PowerShell too. Is there any way of seeing where the exe is getting stuck or if something is missing or if I need to update anything? I'm either go to have to stay on 4.9 or change to another program. Thanks you for your help. RIchard -Original Message- From: gnucash-user On Behalf Of Greg Feneis Sent: 11 September 2022 14:59 To: gnucash-user@gnucash.org Subject: Re: [GNC] Opening Gnucash Richard, You may want to provide a few more details. Perhaps mention the version of GnuCash you're using, which OS you're using. How do you open GnuCash, by starting the application or by clicking on a saved file? And so on. Kind regards, Greg Feneis On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann wrote: > When IO open Gnucash to make some entries in the checking account It > opens a page from the past. How can I open the latest page with the > entries up to date. > > Richard Barmann > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Closing Gnucash
How can I close Gnucash so I can reopen it with then correct up to date file . Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
David Thank you! I’m sorry, you’re quite right. I unintentionally pressed the wrong button. Thank you for pointing it out. Richard Sent from my iPhone > On 10 Sep 2022, at 23:04, David Carlson wrote: > > > Richard, > please use reply all or whatever your mail client requires to be sure > gets a copy so others can see it. > That is important because I have to tell others that you have now gone beyond > my area of expertise as a long term user and you now need help from someone > who knows more about Gnucash on versions of windows newer than XP. > This time I am copying it to the list. > > > > >> On Sat, Sep 10, 2022 at 11:38 AM Richard Clarkson >> wrote: >> David >> >> >> >> Thanks for responding! >> >> >> >> Yes I use the windows installer and I have tried letting the installer >> delete the previous version and have also tried deleting the previous >> version myself. >> >> >> >> Richard >> >> >> >> From: David Carlson >> Sent: 10 September 2022 17:33 >> To: Gyle McCollam >> Cc: Richard Clarkson ; Gnucash Users >> >> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11 >> >> >> >> Richard, >> >> >> >> Are you using the windows installer as downloaded from the Gnucash.org >> website for each gnucash version? >> >> >> >> Do you let the installer delete the existing version or do you use another >> method? >> >> >> >> >> >> >> >> >> >> On Sat, Sep 10, 2022, 11:18 AM Gyle McCollam wrote: >> >> Does gnucash open, just not your data file? If so, once opened try file >> open and select your ???.gnucash file. I'm on windows 11 and gnucash 4.11 >> with no issues. >> >> >> >> Sent from Samsung Galaxy smartphone. >> >> >> >> Original message >> From: Richard Clarkson via gnucash-user >> Date: 9/10/22 12:04 PM (GMT-05:00) >> To: gnucash-user@gnucash.org >> Subject: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11 >> >> I previously posted (some time ago) about an issue opening GnuCash following >> upgrade to a newer version. I decided to wait to see if a newer version >> would overcome my problem. >> >> >> >> I am on a Windows 11 PC, and am able to use GnuCash 4.9. I have tried >> updating to GnuCash 4.10 and 4.11, unfortunately when I try to open the >> gnucash.exe on anything above the 4.9 version then nothing happens (it >> doesn't make any difference if I start as an Administrator or not). Windows >> thinks for 2 seconds and then does nothing. I can see no GnuCash processes >> in Task Manager. Once I revert to version 4.9 everything works as it should. >> >> >> >> I have tried downloading from sourceforge and GitHub, in case there was an >> issue. I have tried turning of my Firewall and antivirus, but same issue. >> >> >> >> Did something drastic chance be between version 4.9 and 4.10 or is there >> anything else I can to see if I can overcome this problem? It's getting to >> be quite frustrating! >> >> >> >> Richard >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
I previously posted (some time ago) about an issue opening GnuCash following upgrade to a newer version. I decided to wait to see if a newer version would overcome my problem. I am on a Windows 11 PC, and am able to use GnuCash 4.9. I have tried updating to GnuCash 4.10 and 4.11, unfortunately when I try to open the gnucash.exe on anything above the 4.9 version then nothing happens (it doesn't make any difference if I start as an Administrator or not). Windows thinks for 2 seconds and then does nothing. I can see no GnuCash processes in Task Manager. Once I revert to version 4.9 everything works as it should. I have tried downloading from sourceforge and GitHub, in case there was an issue. I have tried turning of my Firewall and antivirus, but same issue. Did something drastic chance be between version 4.9 and 4.10 or is there anything else I can to see if I can overcome this problem? It's getting to be quite frustrating! Richard ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Opening Gnucash
When IO open Gnucash to make some entries in the checking account It opens a page from the past. How can I open the latest page with the entries up to date. Richard Barmann ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Display report values in whole curremcy units
To those who responded thank you. I am aware of rounding issues. I do a fair bit of work in Excel which takes input in various formats, and still produces a correctly rounded result. This is what I was looking for. That said, no further comment is necessary. It has been kindly pointed out to me that I have had a Senior's moment. It appears I asked the same question in 2019. The answer today is the same as then. What I seek is outside the scope of GNU Cash, and there appears to be insufficient call for it to warrant the work involved in changing. Thanks 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Display report values in whole curremcy units
I would like to be able to print reports which display numbers in whole currency unit values. I have experimented with Preferences which only allow going to 1 decimal place. Even when I do that,registers and reports still display 2 decimal places. Is what I want to do achievable in Gnucash? If so what am I missing? Advice appreciated. Thanks & regards -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Uneven line spacing in Accounts list since 4.11
I've been seeing that in 4.10 on Linux. Regards, Richard \ Original Message On 1 Jul 2022, 01:00, < dull...@gmail.com> wrote: > > I think since 4.11 (am using Windows 11 and a dark theme), I notice very odd > random line spacing in Account list window (the default window when I open > Gnucash) I see the lines for each sub-accounts are not evenly distributed - > spacing seems completely random (some have space above and below, others do > not) I have attached a partial screenshot showing this uneven spacing for the > subaccounts (if the mailing list supports attachments?) Regards, Bill > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > 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. signature.asc Description: OpenPGP digital signature ___ 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] gnucash-user Digest, Vol 231, Issue 73
Hi Kalpesh, So I found a solution which I detail here: https://lists.gnucash.org/pipermail/gnucash-user/2022-June/101721.html Basically, it was all to do with the fact that I was using a Flatpak version of Gnucash (on Linux) - so yes there technically are two versions of Perl, but the one used by Gnucash is the one bundled into the Flatpak app sandbox (i.e. only Gnucash uses it). The problems were then that: 1. The version of Perl on my computer (not in the Flatpak) was working with the Quotes feature for AU stocks straight out of the box - the packaged version didn't. 2. How to update the packaged version wasn't immediately obvious However, I found out how -to update it, though it didn't update perfectly - the bundled Perl version still can't get info from the ASX, but it now can from Yahoo (JSON). So ultimately it now does work. Cheers, Richard. On Fri, Jul 1, 2022 at 1:23 AM Kalpesh Patel wrote: > Richard, can you do some digging around to see if you have multiple version > of Perl or not. Assuming you are NOT on a Windows OS (will work ok within > WSL service in Windows - ignore if you do not know what that is), execute > following command in a shell prompt: > > > find / -name perl -type f -executable -print > > > When above command finishes, it will have returned full path to all Perl > that are available on that system. The number of lines returned back is > number of locations where Perl is installed on that system. If it returns > back only one line than you only have one Perl installed on that system -- > that is good. If it is more than one then now you need to decide whether up > to upgrade the Finance::Quote on all of them or you have to find where it > is > not working correctly, which will be more complex undertaking. You can > install/upgrade Finance::Quote in all Perl as follows: > > Take first full line from the above command and append following to it: > -MCPAN -e 'install Finance::Quote' > > For example, when I run the 'find" command, my output looks like this (one > line returned which means I have only one Perl installed on my system): > > > root@my-desktop:~# find / -name perl -type f -executable -print > /usr/bin/perl > root@my-desktop:~# > > > Now I take the first entry (/usr/bin/perl) and append second part (-MCPAN > -e > 'install Finance::Quote') to get following full command to run in a shell: > > > /usr/bin/perl -MCPAN -e 'install Finance::Quote' > > > If you are running it for first time then it may ask few question for > initial configuration - feel free to accept default answers for all > questions as they are sane enough to work properly. Now you can do same > thing for the next entry until all different entries has the module > installed. I hope that it doesn't have more than two or three printed > entries as that would be the norm on the extreme case. > > Now BIG DISCLAIMER: this will install or upgrade Finance::Quote module for > all the different locations where Perl is installed. Alternative is for you > to pick and choose in which Perl location to install but that seems to be > more vexing question which is probably out of scope of GNC needs. Make sure > you take backup of the system as if something else get broken then you can > recover back by restoring back from backup should it be necessary. > > Hope this helps. > > > -- > > Message: 4 > Date: Thu, 30 Jun 2022 19:40:45 +1000 > From: Richard Spinney > To: Geoff > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] ASX Online quotes problem > Message-ID: > e9bdnpy1+u+-fh7zs4v9...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > As a note, it might be relevant that I am using a Flatpak distribution of > Gnucash, possibly explaining the "two versions" situation. Running the > Flatpak from the command line confirms that it is detecting Finance::Quotes > v1.49 even though the command line version I am using is v1.51. > > On Thu, Jun 30, 2022 at 6:43 PM Geoff wrote: > > > Hi Richard > > > > Yes, that is confusing. It is possible that this discrepancy in > > behaviour may be due to you having two instances of Perl installed - > > the later one is seen by your command line scripts and the earlier > > (out of > > date) one is seen by your GnuCash GUI. I make this suggestion as I > > recall seeing other GnuCash problems being reported due to this. I am > > mainly a Windows user so I can't really help you to trouble shoot. > > > > Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which > > should get the latest version (1.51) from CPAN: > > https://metacpan.org/pod/Finance::Quote > > > > Finally,
Re: [GNC] ASX Online quotes problem
Ok, I found a solution, helped by Geoff, which I describe here in case it is of any use to others. Note: This solution is relevant to the Flatpak distribution of Gnucash on Linux. So, Geoff rightly pointed out that my command line quotes were working using my system version of Perl, not the sandbox Flatpak version, which is what Gnucash uses. My attempts to run the quote scripts/gnucash-cli from a terminal failed as they were trying to be run outside of the Flatpak sandbox so were not dynamically linking with the appropriate, bundled, dynamic libraries. To use them you need to enter the sandbox for the Gnucash app as a command line interface by typing flatpak run --command=sh org.gnucash.GnuCash This enters a shell in the Flatpak sandbox. In this environment you can then update the relevant perl modules using "gnc-fq-update". This was a lengthy procedure and it didn't completely succeed. For instance, within the sandbox shell after the update, the command "gnc-fq-dump asx vgs" still did not work, even though it worked using by system's version of Perl. However, using Yahoo as JSON as a source did work, i.e. "gnc-fq-dump yahoo_json VGS.AX". Consequently, reloading Gnucash, and setting the stock details in the security editor to: Symbol: VGS.AX Source: Yahoo as JSON allowed the ASX stocks to get online quotes. On Thu, Jun 30, 2022 at 5:44 PM Richard Spinney wrote: > Hi All, > > I'm having some trouble fetching online quotes for Australian stocks in > Gnucash. > > My versions are: > > Gnucash Version: 4.11 > Build ID: Flathub 4.11 > Finance::Quote: 1.49 > > running on Linux. > > Every other security price fetch seems to work fine. For instance, this > works for US stocks when input into the security editor: > > Symbol: AAPL > Source: alphavantage > > as do currency quotes. > > However, I get the following error message: > > "Unable to retrieve quotes for these items ASX:VGS ..." > > where ASX is just my "type" categorisation", if I try any ASX stock/etf > (here using VGS as an example) with any permutation of > > Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON > > For reference, I have got the underlying command line scripts working and > I *can* get Australian quotes using them (in addition to currency and US > stock quotes that *do* work in Gnucash). For instance the following > commands all return sensible quotes > > > perl gnc-fq-dump -v asx vgs > perl gnc-fq-dump -v yahoo_json VGS.ax > perl gnc-fq-dump -v australia vgs > > I'm unclear if this is because of something I am doing wrong with the > details in the security editor or if there is something else I'm missing. > > Thanks in advance, > > R. > ___ 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] ASX Online quotes problem
Apologies for the spam - just trying to make the necessary info visible. So I have found a separate perl executable bundled with the Flatpak installation. The issue now appears to be that I can't run the update script with it as these executables are designed to be run independently of Flatpak. I.e. in this bundled folder is "perl", "gnucash", "gnucash-cli", "gnc-fq-dump" etc. But I can't "run" any of them - I get a runtime linking error. I was able to run the gnc-fq-* scripts as I was invoking my system version of perl to do so. I open the gnucash GUI itself with the entry to the flatpak, "org.gnucash.GnuCash". I.e. there appear to be a few issues with distributing Gnucash as a flatpak here: These quite important scripts (gnc-fq-*, gnucash-cli) are: 1. Hidden away in some horrible hidden file structure e.g. "~/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/de789f62d67a6ed3ae7fd898b9d1e05cf57cb26fc7f7743262608dfefc81bd0b/files/bin" 2. Even when you do find them, they can't simply be run - the only one that can be run is "gnucash" (i.e. the GUI), because that is the one that is hardlinked to in the Flapak run command "flatpak run org.gnucash.Gnucash" Thanks, R. On Thu, Jun 30, 2022 at 6:43 PM Geoff wrote: > Hi Richard > > Yes, that is confusing. It is possible that this discrepancy in > behaviour may be due to you having two instances of Perl installed - the > later one is seen by your command line scripts and the earlier (out of > date) one is seen by your GnuCash GUI. I make this suggestion as I > recall seeing other GnuCash problems being reported due to this. I am > mainly a Windows user so I can't really help you to trouble shoot. > > Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which > should get the latest version (1.51) from CPAN: > https://metacpan.org/pod/Finance::Quote > > Finally, I have attached a screenshot of my setup to retrieve prices for > ASX securities. > > Hope this helps. > > Regards > > Geoff > = > > On 30/06/2022 6:26 pm, Richard Spinney wrote: > > Hi Geoff, > > > > Thanks for this. > > > > I am little bit confused though, the command line perl scripts I am > > using with the ASX as a source work fine. But moreover, they work when I > > use *different* sources (e.g. yahoo as JSON), but then they don't work > > in gnucash itself - I.e. the issue is there when I specifically avoid > > the ASX as a source. Or have I missed something? > > > > If I do have to update that module do you have any links or similar you > > could point me to? > > > > Thanks, > > > > R. > > > > On Thu, 30 June 2022, 18:21 Geoff, > <mailto:cleanoutmys...@gmail.com>> wrote: > > > > Hi Richard > > > > The ASX did a major web upgrade back in 2020 that broke Version 1.49 > of > > Finance::Quote. If you want to use the ASX as your data source for > > Australian listed securities then you will need to upgrade that Perl > > module. > > > > > > Regards > > > > Geoff > > = > > > > On 30/06/2022 5:44 pm, Richard Spinney wrote: > > > Hi All, > > > > > > I'm having some trouble fetching online quotes for Australian > > stocks in > > > Gnucash. > > > > > > My versions are: > > > > > > Gnucash Version: 4.11 > > > Build ID: Flathub 4.11 > > > Finance::Quote: 1.49 > > > > > > running on Linux. > > > > > > Every other security price fetch seems to work fine. For > > instance, this > > > works for US stocks when input into the security editor: > > > > > > Symbol: AAPL > > > Source: alphavantage > > > > > > as do currency quotes. > > > > > > However, I get the following error message: > > > > > > "Unable to retrieve quotes for these items ASX:VGS ..." > > > > > > where ASX is just my "type" categorisation", if I try any ASX > > stock/etf > > > (here using VGS as an example) with any permutation of > > > > > > Symbol: VGS, VGS.AX <http://VGS.AX>, ASX:VGS, ASX.VGS > > > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as > JSON > > > > > > For reference, I have got the underlying command line scripts > > working and I > >
Re: [GNC] ASX Online quotes problem
As a note, it might be relevant that I am using a Flatpak distribution of Gnucash, possibly explaining the "two versions" situation. Running the Flatpak from the command line confirms that it is detecting Finance::Quotes v1.49 even though the command line version I am using is v1.51. On Thu, Jun 30, 2022 at 6:43 PM Geoff wrote: > Hi Richard > > Yes, that is confusing. It is possible that this discrepancy in > behaviour may be due to you having two instances of Perl installed - the > later one is seen by your command line scripts and the earlier (out of > date) one is seen by your GnuCash GUI. I make this suggestion as I > recall seeing other GnuCash problems being reported due to this. I am > mainly a Windows user so I can't really help you to trouble shoot. > > Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which > should get the latest version (1.51) from CPAN: > https://metacpan.org/pod/Finance::Quote > > Finally, I have attached a screenshot of my setup to retrieve prices for > ASX securities. > > Hope this helps. > > Regards > > Geoff > = > > On 30/06/2022 6:26 pm, Richard Spinney wrote: > > Hi Geoff, > > > > Thanks for this. > > > > I am little bit confused though, the command line perl scripts I am > > using with the ASX as a source work fine. But moreover, they work when I > > use *different* sources (e.g. yahoo as JSON), but then they don't work > > in gnucash itself - I.e. the issue is there when I specifically avoid > > the ASX as a source. Or have I missed something? > > > > If I do have to update that module do you have any links or similar you > > could point me to? > > > > Thanks, > > > > R. > > > > On Thu, 30 June 2022, 18:21 Geoff, > <mailto:cleanoutmys...@gmail.com>> wrote: > > > > Hi Richard > > > > The ASX did a major web upgrade back in 2020 that broke Version 1.49 > of > > Finance::Quote. If you want to use the ASX as your data source for > > Australian listed securities then you will need to upgrade that Perl > > module. > > > > > > Regards > > > > Geoff > > = > > > > On 30/06/2022 5:44 pm, Richard Spinney wrote: > > > Hi All, > > > > > > I'm having some trouble fetching online quotes for Australian > > stocks in > > > Gnucash. > > > > > > My versions are: > > > > > > Gnucash Version: 4.11 > > > Build ID: Flathub 4.11 > > > Finance::Quote: 1.49 > > > > > > running on Linux. > > > > > > Every other security price fetch seems to work fine. For > > instance, this > > > works for US stocks when input into the security editor: > > > > > > Symbol: AAPL > > > Source: alphavantage > > > > > > as do currency quotes. > > > > > > However, I get the following error message: > > > > > > "Unable to retrieve quotes for these items ASX:VGS ..." > > > > > > where ASX is just my "type" categorisation", if I try any ASX > > stock/etf > > > (here using VGS as an example) with any permutation of > > > > > > Symbol: VGS, VGS.AX <http://VGS.AX>, ASX:VGS, ASX.VGS > > > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as > JSON > > > > > > For reference, I have got the underlying command line scripts > > working and I > > > *can* get Australian quotes using them (in addition to currency > > and US > > > stock quotes that *do* work in Gnucash). For instance the > following > > > commands all return sensible quotes > > > > > > > > > perl gnc-fq-dump -v asx vgs > > > perl gnc-fq-dump -v yahoo_json VGS.ax > > > perl gnc-fq-dump -v australia vgs > > > > > > I'm unclear if this is because of something I am doing wrong with > the > > > details in the security editor or if there is something else I'm > > missing. > > > > > > Thanks in advance, > > > > > > R. > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > To update your su
Re: [GNC] ASX Online quotes problem
Hi Geoff, Yes, I see, that would explain the behaviour. I followed your advice and upgraded with that script to v 1.51. Unfortunately, that hasn't solved the issue, and the version reported in Help->About in Gnucash remains at 1.49, aligning with your suggestion that two versions are acting independently here. I think I might be waiting for someone who is familiar with how Gnucash plays in Linux to weigh in on how to manage the "GUI version". Thanks for your help, R. On Thu, Jun 30, 2022 at 6:43 PM Geoff wrote: > Hi Richard > > Yes, that is confusing. It is possible that this discrepancy in > behaviour may be due to you having two instances of Perl installed - the > later one is seen by your command line scripts and the earlier (out of > date) one is seen by your GnuCash GUI. I make this suggestion as I > recall seeing other GnuCash problems being reported due to this. I am > mainly a Windows user so I can't really help you to trouble shoot. > > Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which > should get the latest version (1.51) from CPAN: > https://metacpan.org/pod/Finance::Quote > > Finally, I have attached a screenshot of my setup to retrieve prices for > ASX securities. > > Hope this helps. > > Regards > > Geoff > = > > On 30/06/2022 6:26 pm, Richard Spinney wrote: > > Hi Geoff, > > > > Thanks for this. > > > > I am little bit confused though, the command line perl scripts I am > > using with the ASX as a source work fine. But moreover, they work when I > > use *different* sources (e.g. yahoo as JSON), but then they don't work > > in gnucash itself - I.e. the issue is there when I specifically avoid > > the ASX as a source. Or have I missed something? > > > > If I do have to update that module do you have any links or similar you > > could point me to? > > > > Thanks, > > > > R. > > > > On Thu, 30 June 2022, 18:21 Geoff, > <mailto:cleanoutmys...@gmail.com>> wrote: > > > > Hi Richard > > > > The ASX did a major web upgrade back in 2020 that broke Version 1.49 > of > > Finance::Quote. If you want to use the ASX as your data source for > > Australian listed securities then you will need to upgrade that Perl > > module. > > > > > > Regards > > > > Geoff > > = > > > > On 30/06/2022 5:44 pm, Richard Spinney wrote: > > > Hi All, > > > > > > I'm having some trouble fetching online quotes for Australian > > stocks in > > > Gnucash. > > > > > > My versions are: > > > > > > Gnucash Version: 4.11 > > > Build ID: Flathub 4.11 > > > Finance::Quote: 1.49 > > > > > > running on Linux. > > > > > > Every other security price fetch seems to work fine. For > > instance, this > > > works for US stocks when input into the security editor: > > > > > > Symbol: AAPL > > > Source: alphavantage > > > > > > as do currency quotes. > > > > > > However, I get the following error message: > > > > > > "Unable to retrieve quotes for these items ASX:VGS ..." > > > > > > where ASX is just my "type" categorisation", if I try any ASX > > stock/etf > > > (here using VGS as an example) with any permutation of > > > > > > Symbol: VGS, VGS.AX <http://VGS.AX>, ASX:VGS, ASX.VGS > > > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as > JSON > > > > > > For reference, I have got the underlying command line scripts > > working and I > > > *can* get Australian quotes using them (in addition to currency > > and US > > > stock quotes that *do* work in Gnucash). For instance the > following > > > commands all return sensible quotes > > > > > > > > > perl gnc-fq-dump -v asx vgs > > > perl gnc-fq-dump -v yahoo_json VGS.ax > > > perl gnc-fq-dump -v australia vgs > > > > > > I'm unclear if this is because of something I am doing wrong with > the > > > details in the security editor or if there is something else I'm > > missing. > > > > > > Thanks in advance, > > > > > > R. > > > _
Re: [GNC] ASX Online quotes problem
Hi Geoff, Thanks for this. I am little bit confused though, the command line perl scripts I am using with the ASX as a source work fine. But moreover, they work when I use *different* sources (e.g. yahoo as JSON), but then they don't work in gnucash itself - I.e. the issue is there when I specifically avoid the ASX as a source. Or have I missed something? If I do have to update that module do you have any links or similar you could point me to? Thanks, R. On Thu, 30 June 2022, 18:21 Geoff, wrote: > Hi Richard > > The ASX did a major web upgrade back in 2020 that broke Version 1.49 of > Finance::Quote. If you want to use the ASX as your data source for > Australian listed securities then you will need to upgrade that Perl > module. > > > Regards > > Geoff > = > > On 30/06/2022 5:44 pm, Richard Spinney wrote: > > Hi All, > > > > I'm having some trouble fetching online quotes for Australian stocks in > > Gnucash. > > > > My versions are: > > > > Gnucash Version: 4.11 > > Build ID: Flathub 4.11 > > Finance::Quote: 1.49 > > > > running on Linux. > > > > Every other security price fetch seems to work fine. For instance, this > > works for US stocks when input into the security editor: > > > > Symbol: AAPL > > Source: alphavantage > > > > as do currency quotes. > > > > However, I get the following error message: > > > > "Unable to retrieve quotes for these items ASX:VGS ..." > > > > where ASX is just my "type" categorisation", if I try any ASX stock/etf > > (here using VGS as an example) with any permutation of > > > > Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS > > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON > > > > For reference, I have got the underlying command line scripts working > and I > > *can* get Australian quotes using them (in addition to currency and US > > stock quotes that *do* work in Gnucash). For instance the following > > commands all return sensible quotes > > > > > > perl gnc-fq-dump -v asx vgs > > perl gnc-fq-dump -v yahoo_json VGS.ax > > perl gnc-fq-dump -v australia vgs > > > > I'm unclear if this is because of something I am doing wrong with the > > details in the security editor or if there is something else I'm missing. > > > > Thanks in advance, > > > > R. > > ___ > > 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.
[GNC] ASX Online quotes problem
Hi All, I'm having some trouble fetching online quotes for Australian stocks in Gnucash. My versions are: Gnucash Version: 4.11 Build ID: Flathub 4.11 Finance::Quote: 1.49 running on Linux. Every other security price fetch seems to work fine. For instance, this works for US stocks when input into the security editor: Symbol: AAPL Source: alphavantage as do currency quotes. However, I get the following error message: "Unable to retrieve quotes for these items ASX:VGS ..." where ASX is just my "type" categorisation", if I try any ASX stock/etf (here using VGS as an example) with any permutation of Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON For reference, I have got the underlying command line scripts working and I *can* get Australian quotes using them (in addition to currency and US stock quotes that *do* work in Gnucash). For instance the following commands all return sensible quotes perl gnc-fq-dump -v asx vgs perl gnc-fq-dump -v yahoo_json VGS.ax perl gnc-fq-dump -v australia vgs I'm unclear if this is because of something I am doing wrong with the details in the security editor or if there is something else I'm missing. Thanks in advance, R. ___ 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] Online crypto value quote
That's strange, I don't have any issues getting crypto quotes using yahoo json as the source. Regards, Richard On 17/06/2022 16:17, Adrien Monteleone wrote: The error message reports "500" as the status code. That's an Internal Server Error, so it isn't you. Unfortunately, "500" is a generic catch-all for server errors, so there isn't any further information as to what type of error. There's nothing you can do but wait. (at least for Yahoo) Try getting individual quotes in the Terminal using AlphaVantage. Regards, Adrien On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote: Thank you, Geoff, I tried and it says as in attached screenshot. ___ 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. OpenPGP_0x10E7349A8F376444.asc Description: OpenPGP public key OpenPGP_signature Description: OpenPGP digital signature signature.asc Description: OpenPGP digital signature ___ 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] GnuCash 4.10
Adrien No, I was on 4.9. I've managed to get back to 4.9 now with no problem getting the GnuCash.exe to work. I tried looking at the registry and resetting .exe etc to default settings. As soon as I try to upgrade to 4.10-1 I get the problem that the exe file doesn't work. It looks like it's trying to do something for a few seconds, then nothing... Think I will wait for the next update to see if that works for me. Thanks for your response - just wish I could do the Check and Repair on 4.10, but that's a no go as I can't open GnuCash. Thanks for telling me to do thqt qfter every update. Richard -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: 09 May 2022 21:58 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] GnuCash 4.10 So you originally jumped from 3.11 to 4.10? If 4.0 works, did you run Actions > Check & Repair > Check & Repair all after the upgrade to 4.0? (you should do that after each major version jump) Regards, Adrien On 5/9/22 1:16 PM, Richard Clarkson via gnucash-user wrote: > Reverting to GnuCash 3.11 works perfectly. Upgrading from that to GnuCash 4.0 > works but only after clicking through lots of error messages. Upgrading to > GnuCash 4.10-1 doesn’t work at all. Bizarre! > > > > Ran DISM Restore Health and sfc /scannow but no change. > > > > Will wait for next update to see if there’s any change. ___ 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] GnuCash 4.10
Reverting to GnuCash 3.11 works perfectly. Upgrading from that to GnuCash 4.0 works but only after clicking through lots of error messages. Upgrading to GnuCash 4.10-1 doesn’t work at all. Bizarre! Ran DISM Restore Health and sfc /scannow but no change. Will wait for next update to see if there’s any change. Richard From: Richard Clarkson Sent: 08 May 2022 23:02 To: 'Glenn Fowler' Subject: RE: [GNC] GnuCash 4.10 Thanks Glenn That’s what I tried and it doesn’t open. Thanks for putting your thinking cap on. Richard From: Glenn Fowler mailto:gfowl...@outlook.com> > Sent: 08 May 2022 21:01 To: Richard Clarkson mailto:rtclark...@btinternet.com> > Cc: GnuCash users group mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash 4.10 Your data file for your book which will be in the folder that you specified. Ex myfinances.gnucash vacationhome.gnucash On Sun, May 8, 2022, 1:00 PM Richard Clarkson mailto:rtclark...@btinternet.com> > wrote: Glenn Can’t see anything called book file. Are you referring to GNUData.gnucash ? If so nothing opens. Thanks Richard From: Glenn Fowler mailto:gfowl...@outlook.com> > Sent: 08 May 2022 16:34 To: Richard Clarkson mailto:rtclark...@btinternet.com> > Cc: GnuCash users group mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash 4.10 Ok try double clicking directly on your book file and see if it works. On Sun, May 8, 2022 at 11:16 AM Richard Clarkson mailto:rtclark...@btinternet.com> > wrote: Glenn When installing using the installer there was a message that GnuCash was open, so I closed GnuCash and clicked retry. Gnucash.exe didn’t work. I also tried via PowerShell and the GnuCash wasn’t found. I’ve tried in Admin mode too. I have uninstalled GnuCash and reinstalled and still have the same issue. Thanks for your help. Richard From: Glenn Fowler mailto:gfowl...@outlook.com> > Sent: 08 May 2022 15:31 To: Richard Clarkson mailto:rtclark...@btinternet.com> > Cc: GnuCash users group mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] GnuCash 4.10 Hi Richard, Do you get an error message? Did you install using the installer? On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user mailto:gnucash-user@gnucash.org> > wrote: Have just updated from previous version to GnuCash 4.10 on Windows 11. GnuCash now refuses to open (have tried from PowerShell too). I have tried reinstalling but no change. Any idea how I can rectify this issue? Many thanks Richard ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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.
[GNC] GnuCash 4.10
Have just updated from previous version to GnuCash 4.10 on Windows 11. GnuCash now refuses to open (have tried from PowerShell too). I have tried reinstalling but no change. Any idea how I can rectify this issue? Many thanks Richard ___ 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] Printing Customer List
Is there a way to print the customer list? I re contact the customer after a certain length of time and cannot print out the list.Thank you for any help. Richard Barmann ___ 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] Migrating from Linux OS to windows
I have been trying to get the migration done for a week ore more. My question. Do I have to clear all of the gnucash 4.9 before I can migrate the older version into windows.I am trying to carry on with the same numbers and style as I had in the Linux OS.Thank you for any help. Thank you for any advice. Richard Barmann ___ 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] Lost Back ground
After using GnuCash for years I suddenly have it start me with a o1 Invoice number instead of 001478, Also I cannot retrieve my STYLE of Invoice. I have some old files with the invoice style. How can I go back to them. Richard Barmann ___ 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] GNUcash 4.9 on macOS 12.1 and Apple silicon/M1
On 2022-01-05 7:31 a.m., timothy.b via gnucash-user wrote: Can anyone confirm that the pre-built binary release of GNUcash 4.9 functions properly on Apple silicon M1 based Macs and macOS Monterey 12.1 without having to resort to terminal commands or other non-standard techniques? ___ 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. Seems to work all right for me - same specs for my M1 Mac-Mini with Monterey and moving the app from the download into applications. Rick ___ 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] Reconciliation mystery - unreconciled transactions in a period that was reconciled.
Hi,
Rogier and David, I have had a situation several times where I have
completed reconciliations, and then months later in a new reconciliation
transactions show up from several years before as unreconciled. I have
no idea how this occurs.
As my accounting has no business connotations, I fudge it and just tick
them off on the basis they have been previously reconciled.
Any thoughts anyone on what my problem might be, or whether it has any
relevance to these ongoing discussions?
On 20/12/2021 09:28, davidcousen...@gmail.com wrote:
Rogier,
It would appear on the surface that somehow you did not reconcile the two
transactions which remained marked as "n" which means not cleared("c) or not
reconciled("y"). How ? Unfortunately without knowing exactly what you did
during the reconciliation process it will be hard for anyone to tell. Obvious
things are to check the dates on the two transactions to make sure they are in
the reconciliation period and check that any transactions after the end of the
reconciliation date are not marked with "y". A common error is entering the
wrong year when entering the transaction. Any unreconciled transactions from
earlier periods should show up in the reconcilation window panes.
That the balances add up with the two un reconciled transactions suggest opening
the reconciliation process again and seeing if the two unmarked transactions
appear in it.
David Cousens
On Sun, 2021-12-19 at 16:42 -0500, Rogier F. van Vlissingen wrote:
A while ago, I set up a business in Gnucash after having some outrageous
problems with QBO.
Once I got going it all worked out OK, but it appears I may have made some
mistakes in the end and I cannot comprehend how I might have done it or how
to fix them.
The primary tipoff was that I did all my reconciliations of three accounts
and as it was, the bank account ended up with a $187.37 balance on
12/31/20, however the account register shows to transactions that are still
showing "n" for unreconciled, and the balance at 12/31/20 shows $52.03 and
the two "n" transactions account for the difference, $135.34. But why do
they show "n" and is the ending balance $52.03???
I have not been able to figure out a way to fix this.
Evidently, the result is a minor error in my final reports of 2020, and
hence in my tax filing.
<
http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb
Rogier Fentener van Vlissingen
<
http://rogierfentenervanvlissingen.me?promo=email_sig_source=product_medium=email_sig_campaign=gmail_api_content=thumb
___
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] Transparent background on selected Transfer choice
On 13/05/2021 14:45, David G. Pickett via gnucash-user wrote: I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the background under the choice goes transparent, showing the transaction screen below, see attached; not at all helpful! I also see that on Arch Linux KDE Plasma. Build ID: 4.5+(2021-03-27) -- Richard ___ 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] Expense Over Time report
Hello, I moved from (originally) Bedford Accounting to Simply Accounting and can't remember when I was required to assign account numbers to all of my accounts, but I did. After getting started with Gnu Cash, I used the names of accounts to make transactions, but that got tiresome so I added my old account numbers to all of the accounts in Gnu Cash. After doing that I just used the account numbers to identify which account was needed for a transaction and all of the text stuff just came with it. When I make transactions, it's quite fast, but only for accounts for which I remember the numbers. If I forget an account number and have to remember the account names for rarely used accounts I just click on the drop down list and get it that way. It works and is quite fast. I still use placeholder accounts for category headings, but for transactions, use the numbers almost exclusively. Check to see the numbering scheme for something like Sage Simply Accounting and add the numbers to your account name and number fields, then you're away. Rick On 2021-02-20 6:32 p.m., gnu Gord wrote: Thank you to everyone that replied. I'm still a bit confused as to why I can select the accounts to include/exclude plus I can/need to select the level. It seems redundant to me but maybe in some situations it's required. In my example, it appears I have created my hierarchy incorrectly. The suggestions I received seem to say I should have no transactions in branch accounts and only in leaf accounts. (I didn't realize I needed to be a gardener to do accounting!) LOL I rearranged my example and it seems the report options work more the way I would expect, but I'm still not clear on the level vs. account selection. To summarize the way I understand it, all but the lowest level accounts should be marked as Placeholder accounts (or at least have no transactions). Is this closer to 'standard' accounting practice? Here is the way I've redone the example. With "Expenses", "L2" and "L3" all having the Placeholder option ticked: [image: image.png] On Sat, Feb 20, 2021 at 11:36 AM Dale Alspach wrote: Some accounting software, e.g., Quickbooks, use a virtual leaf "Other" in reports to remove any ambiguity when there are transactions in a branch account which are not in a leaf. Thus a report for the situation L3 $100 transaction and L4 $500 transaction would display L3 L4 500 L3 - Other 100 Dale On Sat, Feb 20, 2021 at 8:04 AM D. via gnucash-user < gnucash-user@gnucash.org> wrote: Geoff, That was an excellent answer, and explains clearly a big reason why users should strive to limit their transactions to leaf nodes in the account hierarchy. (My own books include numerous violations of this premise, BTW) Gnucash has always allowed users to put transactions in intermediate level accounts, which some in the community have felt was Not Good, although I've been a little more equivocal about it. I'm not sure, but there may be an outstanding bug request on the behavior. I *do* think Gord's final question is an interesting one. It might be useful to conduct some tests to see the interaction between account selection and level setting in the various reports that use that method of grouping, and then update the docs with information. Best, David T. Original Message From: Geoff Sent: Fri Feb 19 18:37:21 EST 2021 To: gnu Gord , gnucash-user@gnucash.org Subject: Re: [GNC] Expense Over Time report Hi Gord It appears that L3 is both a parent of L4 and has transactions worth $100 itself. Thus reporting on L3 is ambiguous - do you want only its transactions ($100), or its transactions plus the sum of its children ($100 + $500 = $600)? I suggest that you only record transactions against the lowest level children accounts in your hierarchy (the "leaves" and not the "branches"). Hope this helps. Regards Geoff = On 20/02/2021 10:07 am, gnu Gord wrote: I'm trying to understand this report and it just isn't working the way I expect. Below is a screenshot of my test chart of accounts, for reference. I have one expense of $100 in account L3 and one expense of $500 in account L4 If I ask for an Expense Over Time report and select L3 and* "Show Accounts until Level" 3*, I get $600 in the report. If I select *"Show Accounts until level" 4*, I get $100 If I select 2 or 1 in the "Show Account until level" I get nothing, which is OK. If I select 5 or 6 I get the same output as 4. This is not the way I expected it to work. I'm not really clear what the "Show Accounts until level" option is used for. If I can select the account I want to be included/excluded in the report why do I need to also specify the level? Version: 4.4 Build ID: 4.4+(2020-12-28) [image: image.png] ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:
[GNC] Volunteer
I am very interested in supporting the group and be a volunteer if I happen to have any skills that could be used. Who is the group leader? Does the group have a written set of conduct rules and operation rules? If I donate $$ what is it used for? What are the needs of the group? Where can I see a list of tasks for volunteers? Richard Hickok ___ 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] Copying reports from one machine to another
Hi, I have a number of personalised reports (using only standard GNU Cash options) on my notebook. I also have an SP3 on which I have installed GNU Cash. I use a data file stored on a NAS. Excuse ignorance, but the report options appear to be machine specific, as opposed to App specific. It seems I must recraft the many reports on the new machine. Is there some way of copying the report configs from one machine to the other? I am using Version 4.2 Build 2020 09 26 on win 10 and Win 10 Pro. Any assistance much appreciated. Thanks & regards -- ___ 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] OFX connections
I saw a long list of banks that do not support OFX connections. That being said, is there a newer bank access protocol under development for gnucash. Richard ___ 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] USAA
I spoke with USAA tech support this morning. They told me GNU software is not supported due to the software security issues. Now if any of you are still accessing USAA via the GNU online banking, there is still hope for me. I have probably made 10 or more attempts to make it work by following the info provided by John and trying something a little different each time. I receive no error messages. When I click on the retrieve account list, the dialog indicates it connected and is parsing the data. Then it says the window can be closed. No error messages but no account list. Richard ___ 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] Lists
Could someone please tell me where the memorized payee list is stored and how to add or delete one? Also, where is the category list stored and how do I edit it? ___ 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] USAA online setup
I followed the instructions at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings It did not work for me. I don't know if I missed some little input or what. I did not understand a lot of the labels for input. I did not receive an error message. It appear to go through the process of downloading the account list. It said finished. If it downloaded anything, I don't know where it is. Anyone have an additional suggestion? Richard ___ 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] Setup for downloading transactions for a financial institution
I am a new user. I have a few questions. Is there any way to change the column label on the account transaction display? Currently one of my columns is labeled Transfer. The items in that column are actually transaction categories. Next, when I attempted to link an account with a financial institution via the online setup wizard, the setup asked to select ECIBS or one of 4 other options. I am not familiar with any of these options. Could someone please help me understand what these are or suggest which on to used Thanks, Richard ___ 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] gnucash file name after move from ubuntu 20.04 to debian 10
Hello Adrien, Sorry, but I forgot (a couple of times) to reply to your advice. The backups seem to be fine and apart from not being able to make "flatpak update" work, I am happy working with GC 4.1. My dad also said "Measure twice. Cut once." However maybe it was some unknown problem with him, but I heard "Measure once. Cut twice." He is gone now, so I can't fix his grammar anymore, but maybe everyone else can be careful when giving me directions. :-) Happy Old Year. Rick On 2020-12-08 7:53 p.m., Adrien Monteleone wrote: Maybe take a good look at those backups and the main file. Make sure you didn't inadvertently enter transactions in the backups at some point! (fixable, but not pleasant in direct proportion to the number of said transactions) My uncle taught me his first rule of carpentry: "Measure twice. Cut once." Regards, Adrien On 12/8/20 4:19 PM, Richard Danielson wrote: Thanks David, That worked. I know that I've seen mention often about backup files. Guess my action in September resulted in that. I hadn't done anything in 2020 except moving the program on a new drive in September. I'm now caught up from Dec/19 to the end of Jan/20. Thanks for your help. ___ 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] Configuring Securities Editor for a Tokyo Stock Exchange listed company.
It works. Thanks! I I would never have guessed that in a million years. On 12/20/2020 3:02 PM, D. wrote: Maybe try Yahoo Json with symbol 4922.T? Original Message From: Richard Solomon Sent: Sun Dec 20 00:32:02 EST 2020 To: "gnucash-user@gnucash.org" Subject: [GNC] Configuring Securities Editor for a Tokyo Stock Exchange listed company. I am trying to retrieve automatic price quotes for the Japan listed company Kose (ticker TYO: 4922). Within the Securities Editor I’ve set the Security Information “Type” to “TYO” and entered 4922 as the Symbol. I then click “Get Online Quotes” under Quote Source Information. But I’m not sure which Quote Source to select. Whatever I try, I fail to obtain a price quote within the Price Database. What could I be doing wrong? Are Tokyo Stock Prices not retrievable? Sent from [1]Mail for Windows 10 References 1. https://go.microsoft.com/fwlink/?LinkId=550986 ___ 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.
[GNC] Configuring Securities Editor for a Tokyo Stock Exchange listed company.
I am trying to retrieve automatic price quotes for the Japan listed company Kose (ticker TYO: 4922). Within the Securities Editor I’ve set the Security Information “Type” to “TYO” and entered 4922 as the Symbol. I then click “Get Online Quotes” under Quote Source Information. But I’m not sure which Quote Source to select. Whatever I try, I fail to obtain a price quote within the Price Database. What could I be doing wrong? Are Tokyo Stock Prices not retrievable? Sent from [1]Mail for Windows 10 References 1. https://go.microsoft.com/fwlink/?LinkId=550986 ___ 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] Multinational Accounting question...
I am an American expat who operates a small overseas proprietorship. As a sole trader I must submit financial accounts domestically as well as in the US. Am I able to toggle between base currencies or must I duplicate accounting entries in two separate gnucash files in order to report both domestically as well as in the USA? ___ 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] gnucash file name after move from ubuntu 20.04 to debian 10
Thanks David, That worked. I know that I've seen mention often about backup files. Guess my action in September resulted in that. I hadn't done anything in 2020 except moving the program on a new drive in September. I'm now caught up from Dec/19 to the end of Jan/20. Thanks for your help. Rick On 2020-12-08 3:35 a.m., David H wrote: Rick, 'my name'.gnucash.20200912164616.gnucash indicates a backup file created by gnucash on 12 Sept 2020 at 16:46:16 aka 4:46:16pm - you should be looking for the 'my name'.gnucash file which will be your primary gnucash file If you haven't lost any txns since this date and time you could just open the file and do a Save As 'my name'.gnucash and continue on your merry way - I'd be double checking to ensure you don't have any missing txns tho first. Cheers David H. On Tue, 8 Dec 2020 at 18:01, Richard Danielson <mailto:rdan...@gmail.com>> wrote: Hello, I recently moved my computer system (and gnucash) from ubuntu 20.04 to debian 10. After installing debian, I copied my /home directory to the new system. Previous to the move I had upgraded to version 4.2 on flatpak. After the transition, the file name for the gnucash data file became extended to something like 'my name'.gnucash.20200912164616.gnucash. That was probably related to the last update to gnucash which I made before the change in operating system. Now the update log files are still looking like this - 'my name'.gnucash.20200912171222.gnucash. The most recent file name seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000513.gnucash and the most recent log file seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000514.log. Without doing irreparable damage to things, can I change the name of the gnucash file to 'my name.gnucash or something simple like that without wrecking things? I should note that since my original post about a year ago, and after Adrien's admonitions, I did do reconciliation of a couple of accounts (bank and credit cards) and just kept the system account going in the same file from 2019 to 2020. Therefore I would not like to shoot myself in the foot (or the eye) by destroying the data file. Thanks in advance. As an aside to my original note last year on the first rule of carpentry (...there's always time to do a job twice), I would like to offer the second rule of carpentry: If you cut a board too short, cut it again. Rick ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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.
[GNC] gnucash file name after move from ubuntu 20.04 to debian 10
Hello, I recently moved my computer system (and gnucash) from ubuntu 20.04 to debian 10. After installing debian, I copied my /home directory to the new system. Previous to the move I had upgraded to version 4.2 on flatpak. After the transition, the file name for the gnucash data file became extended to something like 'my name'.gnucash.20200912164616.gnucash. That was probably related to the last update to gnucash which I made before the change in operating system. Now the update log files are still looking like this - 'my name'.gnucash.20200912171222.gnucash. The most recent file name seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000513.gnucash and the most recent log file seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000514.log. Without doing irreparable damage to things, can I change the name of the gnucash file to 'my name.gnucash or something simple like that without wrecking things? I should note that since my original post about a year ago, and after Adrien's admonitions, I did do reconciliation of a couple of accounts (bank and credit cards) and just kept the system account going in the same file from 2019 to 2020. Therefore I would not like to shoot myself in the foot (or the eye) by destroying the data file. Thanks in advance. As an aside to my original note last year on the first rule of carpentry (...there's always time to do a job twice), I would like to offer the second rule of carpentry: If you cut a board too short, cut it again. Rick ___ 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] gnucash file name after move from ubuntu 20.04 to debian 10
Hello, I recently moved my computer system (and gnucash) from ubuntu 20.04 to debian 10. After installing debian, I copied my /home directory to the new system. Previous to the move I had upgraded to version 4.2 on flatpak. After the transition, the file name for the gnucash data file became extended to something like 'my name'.gnucash.20200912164616.gnucash. That was probably related to the last update to gnucash which I made before the change in operating system. Now the update log files are still looking like this - 'my name'.gnucash.20200912171222.gnucash. The most recent file name seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000513.gnucash and the most recent log file seems to be 'my name'.gnucash.20200912171222.gnucash.20201208000514.log. Without doing irreparable damage to things, can I change the name of the gnucash file to 'my name.gnucash or something simple like that without wrecking things? I should note that since my original post about a year ago, and after Adrien's admonitions, I did do reconciliation of a couple of accounts (bank and credit cards) and just kept the system account going in the same file from 2019 to 2020. Therefore I would not like to shoot myself in the foot (or the eye) by destroying the data file. Thanks in advance. As an aside to my original note last year on the first rule of carpentry (...there's always time to do a job twice), I would like to offer the second rule of carpentry: If you cut a board too short, cut it again. Rick ___ 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] Problem with Posting Invoice
Thanks Derek, it was the currency setting in my customer entries. Somewhere along the line I forgot to set them. Is there a way to set CDN as an across the board default? Richard On 11/12/20 5:55 PM, Derek Atkins wrote: > HI, > > My initial guess is that the Invoice currency does not match the AP > Account. Check you customer currency setting, or the global business > currency setting? You may need to re-select the customer (not edit, > literally re-select) so the invoice would reset the currency correctly. > > -derek > > > On Thu, November 12, 2020 2:09 pm, Dr. J. Richard Herbert wrote: >> Help, >> >> I cannot post invoices for new customers. The invoice enters fine but >> when I post, it will not allow me to select a "post to account". I have >> been using gnucash for about 12 months without any problems. I did not >> require new client entries for a few months so I am uncertain when this >> started. I first saw the problem when I was running Fedora 30 or 31. I >> am now running Opensuse Tumbleweed. >> >> I have attached 2 screen shots to help. >> >> >> What is wrong? >> >> Richard >> >> ___ >> 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.
[GNC] Problem with Posting Invoice
Help, I cannot post invoices for new customers. The invoice enters fine but when I post, it will not allow me to select a "post to account". I have been using gnucash for about 12 months without any problems. I did not require new client entries for a few months so I am uncertain when this started. I first saw the problem when I was running Fedora 30 or 31. I am now running Opensuse Tumbleweed. I have attached 2 screen shots to help. What is wrong? Richard ___ 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] OXF/QFX import overwrites Description and Notes fields
Hello, When I import transactions from my bank using OXF file format the Description and Notes fields keep getting overwritten. I've verified that only the C column is checked in the import window--A and U+C are unchecked--but the fields still get overwritten with the data from my bank rather than retaining the values I entered directly into GnuCash. I'm using GnuCash 4.2 (build 4.2+ (2020-09-26) on a Windows 10 PC with the latest Windows updates installed. Any help or advice would be appreciated. Many Thanks -- Rick ___ 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] OFX/QXF import overwrites memo field
Hello, When I import transactions from my bank using OFX/QFX import I notice that the imported data overwrites the Description and Notes fields. I would prefer that the matching transaction be simply marked as Cleared and leave the Description and Notes fields as the originally were entered into GnuCash register. I've verified that only the C column is checked in the Import dialog, but these two fields still are being overwritten. GnuCash did not do this in previous releases, e.g. checking the C column in the import dialog resulted in the matching transaction being cleared, but unmodified in any other way. Is this a known issue, or am I misunderstanding the use of the C column? ___ 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] Tabs Behaviors in GNC4.1
On Wed, 16 Sep 2020, 13:48 D. via gnucash-user, wrote: > Thanks for pointing this bug out. > > It's too bad that the suggestion in the bug to discuss this change on the > lists was not apparently taken up. The devs would then have at least heard > from some other users about their use cases and preferences, and users > would have had a heads up about the change. Instead, a change gets pushed > out based on one person's request, mainly because it involves "three lines > of code." I'll set aside the wisdom of making changes to software based > primarily on the complexity of the fix, or on a single user and the > opinions of three devs... > > While it might seem overkill to discuss something as seemingly minor as > this change, I think *any* change in the user interface should be discussed > more, rather than less. > > Now, we get to have that discussion. > > At the risk of repeating myself, let me re-present. In my usage of > Gnucash, I keep a core set of tabs always open. These tabs represent my > primary active accounts: my checking account, savings account, credit card > account, and a cash account. > > I leave them open because they are involved in the vast majority of my > transactions, and it is easier to click on one of the tabs than to go to > the CoA, locate the account, and open it. I like to have them at the top of > the list at all times because I can quickly locate them there. I know where > they are. > > With the latest change, I no longer can rely on this. My core tabs move > down. If I open one of my more obscure accounts to look at things, it > pushes its way in at the top. If I've opened several of them, they are all > at the top, and when I am done with those tabs, I have to carefully close > tabs, rather than close all tabs below a certain point on the screen. > > None of this is particularly catastrophic, but it does affect me and my > workflow every time I open or close an account, so I would prefer to have > the option of restoring the old tab behavior. > > The idea of pinned tabs is interesting, although it doesn't remove the > need for the preference. If I jump to a new account tab from a pinned one, > will the new tab go at the end of the list, or bury itself in the middle of > my pinned tabs? I think the user would still want the option of where the > new tabs open. > > I'll give a clear and unambiguous preference: I want to be able to choose > this behavior with a preference setting. Put this setting on the same page > as the tab location setting, and have it read: > > Open new tabs: □ At the bottom of the tab list □ After the current tab > > David T. > Exactly my sentiments Richard > ___ 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] Surprised to like dark mode on Linux
On 26/08/2020 14:07, boldstripe wrote:
The one color I have problems with is the text labeling an empty field's
contents: typically, the labels Num, Action and Notes. The default I see now
with Arc-Dark is light grey text on a light blue background, which is low
contrast.
Those are set with
/* Register selected line */
.gnc-class-user-register-cursor {
background-color: lime;
color: red;
}
___
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] Surprised to like dark mode on Linux
On 19/08/2020 16:29, boldstripe wrote:
.
.
I would use this as my default (and may experiment further with it) but for
one thing (so far): the text colors when an entry is highlighted make the
entries difficult to read because of low contrast.
You could try playing with these css settings. Just substitute your own
colours to suit.
/* Register cursor font setting */
gnc-id-cursor {
background-color: #474747;
color: #c4c6c8;
}
gnc-id-cursor entry {
background-color: #474747;
color: #c4c6c8;
}
/* Register selected line */
.gnc-class-user-register-cursor {
background-color: #474747;
color: #c4c6c8;
}
/* Register selected line splits */
.gnc-class-user-register-split {
background-color: #474747;
}
Regards,
Richard
___
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] Bug 797787 - Preference setting to open new tabs adjacent to currently active tab
On Friday, 31 July 2020 01:20:22 BST David H wrote: > Reading the bug report I'm not sure that there is an option, I can't find > one either in any of my preferences. You thought you'd explicitly enabled > it somehow ? To be honest I preferred the previous behaviour where the new > tab got added last but it seems 4.1 just opens it next to my COA as I > usually open tabs from the Accounts tab. I only usually have the Accounts > tab and 6 others open so they fit well on a 24" monitor. > I thought I did. I saw the notice 'Bug 797787 - Preference setting to open new tabs adjacent to currently active tab' in the 4.1 release notes so thought I'd give it a try. If I can't turn it off I'll have to change my workflow which sucks. Richard ___ 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] Bug 797787 - Preference setting to open new tabs adjacent to currently active tab
Hi, I enabled this new option in 4.1 and now I can't find it to turn it back off. The bug report doesn't say where it's located. Could someone give me a hint on where to find it please. Richard ___ 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] Gnucash stopped working after upgrade to macOS Catalina
Thank you David! That worked. A very simple solution. Richard On Thu, Jul 30, 2020 at 11:08 AM David Reiser wrote: > > > On Jul 30, 2020, at 9:44 AM, Richard Belshoff < > richard.belsh...@gmail.com> wrote: > > > > I upgraded my macbook pro from High Sierra 10.13.6 to Catalina 10.15.6. > Now > > when I go to applications and click on "Gnucash", nothing happens. How > can > > I get gnucash to work again? Any ideas? > > Thanks, > > Richard > What version of Gnucash? I’ve been using Gnucash on Catalina since at > least version 3.8 (5 versions ago…). > The simplest thing to try is download the current version of Gnucash (4.1) > and install that. It should work, though I always have to launch new > versions twice (for the first run) to get past the gatekeeper dialog even > though I say, yes, open it. > > Dave > -- > Dave Reiser > dbrei...@icloud.com > > > > > ___ 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] Gnucash stopped working after upgrade to macOS Catalina
I upgraded my macbook pro from High Sierra 10.13.6 to Catalina 10.15.6. Now when I go to applications and click on "Gnucash", nothing happens. How can I get gnucash to work again? Any ideas? Thanks, Richard ___ 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] GTK CSS 4.0-4.1
> Hi Chris, > > Have you been able to set the scheduled transaction editor calendar primary, > secondary and marker colours with > >#gnc-id-dense-calendar .primary > >#gnc-id-dense-calendar .secondary > >#gnc-id-dense-calendar .markers > > I can't get these to work. The primary/secondary colours are printing in > lilac and light blue. > After looking through the source code I determined that gnucash appends -dark to the class for a dark theme and so I needed to use #gnc-id-dense-calendar .primary-dark #gnc-id-dense-calendar .secondary-dark #gnc-id-dense-calendar .markers-dark Richard ___ 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] GTK CSS 4.0-4.1
On Tuesday, 28 July 2020 16:45:01 BST Chris Graves wrote: > I just tested the file on Windows 10 with GC 4.1 and it works fine. It's > located as follows: > %APPDATA%\gnucash\gtk-3.0.css > Hi Chris, Have you been able to set the scheduled transaction editor calendar primary, secondary and marker colours with #gnc-id-dense-calendar .primary #gnc-id-dense-calendar .secondary #gnc-id-dense-calendar .markers I can't get these to work. The primary/secondary colours are printing in lilac and light blue. Richard ___ 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] invisible checkboxes
On 05/04/2020 06:14, Graham Menhennitt wrote: >> Something very strange has happened to my GnuCash installation - I no >> longer have any checkboxes. In dialogs where I'd expect to see them, >> there is just blank space. In the reconcile window, when I hover my >> mouse over a line, I can see a blank white square where the checkbox >> would be. If I click the checkbox, the square changes to blue. But >> when I move the mouse away, it's invisible again. Other applications >> seem unaffected. > > Sorry, I forgot to say... I'm running GnuCash 3.8 on FreeBSD 12 with > KDE5 as my desktop. There was a problem with the gtk theme in plasma causing checkboxes not to be correctly rendered but this is fixed in more recent versions of plasma. I can't remember in which version it was fixed but it was working in plasma 5.18.3. Current version is 5.18.4 and is working there too. Richard ___ 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] The Tutorial and Concepts Guide
Thanks for the input Frank, I'll use QIF files from Quicken/Reckon, I don't know how to get CSVs out of Reckon anyway. Thanks Adrien, yeah it looks like the best way of doing it is to import each account separately. I found the reference to importing all accounts in one QIF file. It's at the bottom of page 66 of the TCG. As mentioned I'm using Reckon 2019 which is way past Quicken 98. Interestingly there is no menu item normally in the program for exporting QIF files. However after some research I found out that Ctrl Shift Z activates a sub menu of Export to produce QIF files. Nothing whatsoever in the Help. I guess they just don't want anyone to know how to export their data! Cheers, Rick > On 7 Mar 2020, at 08:40, Adrien Monteleone > wrote: > > Keeping the accounts separate should help with the duplication issues. I > recall a recent thread that a QIF import from Quicken which contained > multiple accounts caused a problem because both sides of the transaction were > represented in each account in the same file. The matcher had issues with > knowing they were the same transaction. This might have been specific to > Quicken though and not the format in general. > > Regards, > Adrien > >> On Mar 6, 2020 w10d66, at 2:51 PM, Richard Squires >> wrote: >> >> Thanks for your response. Reckon can export QIF I don't think it does CSVs. >> I thought I read somewhere that you could combine all your accounts in one >> QIF file which would make the whole process a lot quicker and easier. But I >> can't find that facility in Reckon. I just thought it might be in the >> appendices section. I have already loaded one account into GnuCash >> successfully and I'm sure as part of the process it checks for duplicate >> transactions. I've been using Quicken/Reckon for some time so there's a fair >> bit of data to load. Just trying to get a good handle on how it all works so >> I don't waste too much time. >> Thanks again for your response. >> Cheers, Rick > > > ___ > 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] The Tutorial and Concepts Guide
Thanks for your response. Reckon can export QIF I don't think it does CSVs. I thought I read somewhere that you could combine all your accounts in one QIF file which would make the whole process a lot quicker and easier. But I can't find that facility in Reckon. I just thought it might be in the appendices section. I have already loaded one account into GnuCash successfully and I'm sure as part of the process it checks for duplicate transactions. I've been using Quicken/Reckon for some time so there's a fair bit of data to load. Just trying to get a good handle on how it all works so I don't waste too much time. Thanks again for your response. Cheers, Rick > On 6 Mar 2020, at 18:10, Adrien Monteleone > wrote: > > It seems those are placeholders for sections. Perhaps they should not have > been listed in the TOC. I’m not sure what ‘discussion’ means, but my guess > would be there is a working bug report on the topic or specific list threads > the documentation will be derived from. > > But to the issue at hand, the Importing sections (not Appendices) should get > you going. > > If you can get your data in QIF, you should be okay, but that is not optimal. > (that format has issues, especially with duplication) > > I think from what I’ve been following in other import discussions, CSV has > more versatility and is easier to work with and manipulate if needed prior to > importing. > > What can Reckon export? > > Regards, > Adrien > >> On Mar 5, 2020 w10d65, at 10:35 PM, Rick Squires >> wrote: >> >> Hello, >> >> >> >> I'm just starting with GnuCash and want to migrate from Reckon Accounts >> Personal Plus 2019 Release R 1. >> >> >> >> In the Tutorial and Concepts Guide there is a section called Appendix A. >> Migration Guide. >> >> The ones I am particularly interested in are: >> >> A.2. Organization of QIF Files (Discussion) >> >> A.3. Common Duplication Issues (Discussion) >> >> A.4. Checking QIF Data (Discussion) >> >> >> >> When I try to read each of these discussions the heading loads but the page >> is blank. Am I doing something wrong? I can read the rest of the >> documentation OK. >> >> >> >> Before I move from Reckon I would really like to ensure that I can transfer >> all my data accurately. >> >> >> >> Suggestions for alternative reading would be appreciated. > > ___ > 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.
[GNC] Incorrect starting balance for 2019
Hello all, I moved my accounting from Simply Accounting 7 (something) on Win 7 to GC 2.6.19 on ubuntu linux back in January/19. For starting balances I used my trial balance from 2018 on Simply Accounting to get the values for Jan 1/19 on GC. I subsequently worked like a bionic beaver to do all my accounting for the year. Unfortunately, at this very late point in time, I discovered that I started the year with an incorrect total on one of my asset accounts. If possible, would like to edit this starting amount for Jan 1/19 so that things work out correctly afterward and all the way up to the end of the year. Being suspicious of my actions I waited to reconcile any bank or credit card accounts, so if it is possible to just change the starting balance on that one account, I will happily re-print all of my monthly reports and reconcile everything which should be reconciled before going into 2020. All my life, I have followed the carpenter's rule - "There is always time to do a job twiceif you screw up, you have to do it again." Of course, there is always at least one exception, for example - "If you cut a board too short, then cut it again!" Can someone tell me whether in this case, the rule holds or does the exception hold? Thanks. Rick ___ 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] (GNU) How to Transition to a New Year
Thank you, Adrien, for the prompt and reassuring reply. Based on your guidance, we'll just stay the course and keep adding to the current file. We're retired and use GnuCash in place of Quicken to track household spending and organize our taxes. Now retired, we have simplified our investment portfolio and don't need all the various accounts we managed in the past. Glad to learn we can keep going with the same file and format. GnuCash is working well for us and will continue as our money management application. More thanks and Happy New Year, Richard Claeys -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: Thursday, January 09, 2020 5:09 PM To: Gnucash Users Subject: Re: [GNC] (GNU) How to Transition to a New Year Do you *need* to start a new file each year? While GnuCash has a close the books procedure, it is not necessary to use it as that is a holdover from the days of pen and paper where physical limitations of bound volumes required doing so for organization purposes. (maybe some minor security purposes as well) Computers can keep everything in one file and you simply run reports for the time periods you need. If you want to proceed anyway, there are various methods and workflows, but that really depends on your reason for doing so in order to determine which will be most useful to you. Yes, you can simply save as a new file and the old one will not contain newer entries. This is the easiest and simplest way to retain your account tree and current balance info across all of your accounts and any book-specific preferences. Some people burn the old file onto a read-only disc for archival purposes along with PDF copies of year-end reports, though they can be regenerated by opening the file. You can also just keep the file going and run the close books procedure. This will close out your income and expense categories to Equity:Retained Earnings. Again, this is not necessary, but some people who ve been doing accounting for decades are more comfortable maintaining the habit. There is no real benefit, and you will lose the ability to run reports across period boundaries or even for prior periods depending on the date of your closing entries. (yearly for most people) You can do either of the above, and start with a fresh file every year, recreating your chart of accounts, adding in opening balances from last period s ending balances, etc. Note, if you use the Business Features, you ll need to export-import all of your customers, vendors and employees, and you ll have to figure out a way to handle carryover AP/AR as there is no built-in mechanism for doing so. You d lose all invoice/bill aging data. If you are tracking investments, especially if you have many of them, I d highly recommend to just stick with the current file. Other s may report decent mileage, but I d think trying to move ending balances over to a new file and then losing historical price information for still-held securities would be a nightmare. Regards, Adrien > On Jan 9, 2020 w2d9, at 6:47 PM, Richard Claeys wrote: > > I'm trying to start a new file for the new year and don't see a simple > way to make the change either in the user's manual or the FAQs. Do I > have to create a new file or can I simply save entries after 1/1/2020 > to a new destination and rename it? If the answer is in the manual, > just point me to the correct chapter; if not, let me know the simplest > way to carry over my current list of accounts and start a new and > separate file or folder. I'm sure I'm missing something and could sure use > your help. > > > > Thank you in advance, > > > > Richard Claeys ___ 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.
[GNC] (GNU) How to Transition to a New Year
I'm trying to start a new file for the new year and don't see a simple way to make the change either in the user's manual or the FAQs. Do I have to create a new file or can I simply save entries after 1/1/2020 to a new destination and rename it? If the answer is in the manual, just point me to the correct chapter; if not, let me know the simplest way to carry over my current list of accounts and start a new and separate file or folder. I'm sure I'm missing something and could sure use your help. Thank you in advance, Richard Claeys ___ 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] Setting up Gnucash for Household
I'm not an accountant by any means, so this might be bad advice. I will tell you how I handle my personal and business accounts in one Gnucash file. I have the usual set of accounts, Equity, Assets, Cash, Income, Liabilities, and Opening Balance for my personal accounts. These have the usual subaccounts for detailing transactions with in those categories. For my Rental Business I have have another account with its subaccounts for Equity, Assets, Cash, Income, Liabilities, and Opening Balance. All of this within one Gnucash file. The business files are independent of the personal files, but it is easy to transfer amounts between them when that is appropriate. Richard ___ 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: > > Which OS and perl version are you on? At the moment it is looking like > gnc might need a more recent version of strawberry perl on Win but I > can't quite work out why. If you (or anyone else) let me know your > version stuff I'll try and work it out and take it up in the dev list or > with the FQ people as appropriate. I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/ Regards, Richard ___ 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On Saturday, 23 November 2019 08:40:04 GMT Wm via gnucash-user wrote: > On 25/08/2019 00:06, Richard Ullger wrote: > > On 23/08/2019 14:26, Wm via gnucash-user wrote: > >> heads up, folks > >> > >> morningtstar.co.uk (and possibly other European versions) have changed > >> some stuff that mean some F::Q requests have stopped working. > >> > >> This isn't gnc's fault. > >> > >> If you use a quote source such as > >> mstaruk > >> expect it to fail until the F::Q folks catch up. > >> > >> Would people with appropriate access let us know if the German / French > >> / Italian / Scandinavian / etc versions of morningstar are similarly > >> affected. > > > > I'm using Morningstar, GB as it appears in the quote source dropdown > > list for a couple of funds and am not seeing any issues. Prices have > > successfully loaded up to Friday 23/08/19. > > > > Works using mstaruk in gnc-fq-dump too. > > Hmmmn. Apols for time passing, etc > > What do you (or anyone else interested) get for > === > gnc-fq-dump -v mstaruk GB00B4PQW151 > === > > I get > > === > Finance::Quote fields Gnucash uses: > symbol: GB00B4PQW151 (deduced) <=== required >date: ** missing **<=== recommended >currency: ** missing **<=== required >last: <=\ > nav: <=== one of these > price: <=/ >timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock GB00B4PQW151 > > stock field value > - - - > GB00B4PQW151 errormsg: Error - failed to retrieve fund data > MSTARUK_LOOK_UP > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB0 > 0B4PQW151 > > GB00B4PQW151 last: **missing** > GB00B4PQW151nav: **missing** > GB00B4PQW151 price: **missing** > GB00B4PQW151success: 0 > === > > Note: the extra detail in the "errormsg:" is because I worked out where > mstaruk was breaking for me and I'm trying to work out what is wrong. > > The URL without the extra dot before the ISIN works, for clarity > === > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB0 > 0B4PQW151 = vs = > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=GB00 > B4PQW151 === > > GB00B4PQW151 is Vanguard LifeStrategy 80% which I think more than one > person here might own a bit of. I get (on Saturday evening)... gnc-fq-dump -v mstaruk GB00B4PQW151 Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 <=== required date: 11/22/2019 <=== recommended currency: GBP <=== required last: 215.21 <=\ nav: 215.21 <=== one of these price: 215.21 <=/ timezone: <=== optional All fields returned by Finance::Quote for stock GB00B4PQW151 stock field value - - - GB00B4PQW151 currency: GBP GB00B4PQW151 date: 11/22/2019 GB00B4PQW151 errormsg: Success GB00B4PQW151isodate: 2019-11-22 GB00B4PQW151 last: 215.21 GB00B4PQW151 method: mstaruk GB00B4PQW151 name: Vanguard LifeStrategy 80% Equity A Acc GB00B4PQW151nav: 215.21 GB00B4PQW151net: 1.72168 GB00B4PQW151 p_change: 0.80 GB00B4PQW151 price: 215.21 GB00B4PQW151 source: http://www.morningstar.co.uk GB00B4PQW151success: 1 GB00B4PQW151 symbol: GB00B4PQW151 GB00B4PQW151 time: 12:00 Regards, Richard ___ 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
Yep. Thanks. Rick On 2019-11-18 11:44 a.m., Adrien Monteleone wrote: On Nov 18, 2019 w47d322, at 8:22 AM, Derek Atkins wrote: Rick, Richard Danielson writes: Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, snacks and restaurants in the food category) which showed up in income accounts. That is what I can't figure out in GC. I can make accounts sub-accounts for heading accounts, and get the totals for the sub-accounts to show in the income statement, but can't get the program to sum the sub-accounts into the heading accounts. Note that a parent account will only roll up the balance in sub-accounts in the CoA or Reports. If you *open* the parent account then it wont show the transactions (or balances) from the sub-accounts. It is unclear from your question how/where you are trying to view the rolled-up balances. Derek, My understanding was the OP wanted to roll-up balances on the Income Statement/P as subtotal lines on the report. Considering the reply of the OP that my advice on the report options did the trick, I’d think my guess was correct. Regards, Adrien ___ 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
Thanks David, Bruce and Adrien, Using account numbers in the name field is great. I can sort on the numbers and get my accounts to look the same as in Simply Accounting. Adrien's tip about the edit/options/display feature in income accounts allows me to get exactly what I had before. It just requires a placeholder subheading account and point all the sub-accounts to that one. Rick On 2019-11-17 2:31 p.m., Adrien Monteleone wrote: If you mean you want to roll up the sub-accounts into the parent, then go to Options > Display > Parent account balances: and set it to “Subtotal” instead of “Account Balance” Note, you should also not have any transactions in that parent account and set it to being a placeholder. If you don’t want to use the parents as placeholders you also have the option right below it: ‘Parent account subtotals:’ set it to “Show subtotals” You can do this with the options window to the side of the report and it will toggle on and off the report in real time so you can refine how you want the report to look/work. Regards, Adrien On Nov 16, 2019 w46d320, at 7:13 PM, Richard Danielson wrote: Hello David, Thanks for the tip on the arrow on the right side of the accounts window. I tapped that once but didn't notice that it was offering me a whole bunch of information options. I now have account numbers showing and can sort on that column to make things look more or less the same as in Simply Accounting. Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, snacks and restaurants in the food category) which showed up in income accounts. That is what I can't figure out in GC. I can make accounts sub-accounts for heading accounts, and get the totals for the sub-accounts to show in the income statement, but can't get the program to sum the sub-accounts into the heading accounts. Rick ___ 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] Moving from Sage Accounting and would like to keep sub-account totals viewable
Hello David, Thanks for the tip on the arrow on the right side of the accounts window. I tapped that once but didn't notice that it was offering me a whole bunch of information options. I now have account numbers showing and can sort on that column to make things look more or less the same as in Simply Accounting. Re the subtotals issue, I used to have a number of subtotals (e.g. groceries, snacks and restaurants in the food category) which showed up in income accounts. That is what I can't figure out in GC. I can make accounts sub-accounts for heading accounts, and get the totals for the sub-accounts to show in the income statement, but can't get the program to sum the sub-accounts into the heading accounts. Rick On 2019-11-16 5:01 p.m., David Carlson wrote: Richard, I do not know if importing accounts from CSV of from QIF will bring in account numbers, but they can be assigned with the account editor. If they are not showing on the Accounts window you may need to select the field from the down arrow on the far right. Sub-Accounts should nest under their parents, but iirc there are some possible account number structures that do not sort very nicely by account number. There used to be a fairly good description of this in one of the help manuals, but I have not looked for it recently. David Carlson On Sat, Nov 16, 2019 at 2:29 PM Richard Danielson <mailto:rdan...@gmail.com>> wrote: Hello, I'm moving from Sage Accounting and have set up GC from my trial balance information. In Sage I had a number of sub accounts with totals and can't seem to get the same display in GC. I am also unable to show my old account numbers on the accounts page - nor to sort them as per the setup I had before. Can anyone help? Rick ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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. -- David Carlson ___ 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.
