Re: [GNC] Importing Reports into LO Calc

2024-03-08 Thread Adrien Monteleone
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook.

Re: [GNC] Maddening!!!!!!!!

2024-03-08 Thread Jack Slater
Oh ok. Happy to. I guess I was expecting a 5.51 or something to differentiate the releases. On Fri, Mar 8, 2024 at 4:09 PM David H wrote: > Jack, > > John Ralls released an updated version of 5.5 on 21 Feb - > https://lists.gnucash.org/pipermail/gnucash-user/2024-February/110886.html > - I

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread Tom Teixeira
I did end up making time to investigate today, and the problem ended up being just one fund that no longer works with YahooWeb. This particular fund is a "stable value" fund so checking the value is somewhat superfluous. As it turns out, it does with with AlphaVantage. Again, thanks to David

Re: [GNC] Maddening!!!!!!!!

2024-03-08 Thread David H
Jack, John Ralls released an updated version of 5.5 on 21 Feb - https://lists.gnucash.org/pipermail/gnucash-user/2024-February/110886.html - I assume if you re-download the Windows version at Gncash.org you will pick it up ? Cheers David H. On Sat, 9 Mar 2024 at 04:57, Jack Slater wrote: >

[GNC] Separating tax years for payments in next year

2024-03-08 Thread David G. Pickett via gnucash-user
I recently created ExpenseAccounts/Taxes/FederalEven and ExpenseAccounts/Taxes/FederalOdd to allow me to get a meaningful report on estimated tax and various tax withholding.  The payments in Jan 2024 for 2023 estimated and later for 2-23 tax due do not clutter the reports on 2024 tax year,

Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)

2024-03-08 Thread David H
Eric, Are you sure you haven't got a more recent backup? I have multiple backups (currently 77 - e.g. .gnucash.20240208183810.gnucash) in the folder where my usual gnucash data file lives from the last time I opened it - you should be able to open the one with the most recent date and time stamp

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread Tom Teixeira
Thanks for the suggestion. I won't have time today to investigate, but will do some targeted debugging, either by removing stocks from my list to update, or by creating a new Gnucash file with only one stock. On 3/8/24 2:51 PM, David Reiser wrote: We are now into my mental weeds as far as

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread David Reiser via gnucash-user
We are now into my mental weeds as far as real knowledge goes, but I have had some success at thrashing around to fix self-induced perl challenges. Since the error happens on both architectures, that suggests something is missing. I think YahooWeb is relatively recent in the F::Q realm. And

[GNC] Importing Reports into LO Calc

2024-03-08 Thread Abe Sternberg
After a long hiatus from GnuCash and preparing reports, I find that I am back in that business.  The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc.  I have tried everything

Re: [GNC] Maddening!!!!!!!!

2024-03-08 Thread Jack Slater
Revisiting the bug log (after another rogue transaction and crash today) and I see John's notes about fixing but I'm guessing it's not in 5.5? That's what I'm running and all I see on the web site. On Thu, Feb 8, 2024 at 11:12 AM Patrick James wrote: > Save, Exit, and Reload will clear the

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread Tom Teixeira
I spoke too soon: while getting an individual quote with gnucash-cli works: /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes dump yahooweb MSFT Application Path /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli Finance::Quote fields GnuCash uses:     symbol: MSFT   

Re: [GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-08 Thread Adrien Monteleone
Chris, Once again, look into Edit > Stylesheets. For the record, I'm using defaults, and the is 12pt bold and the lines are 10pt normal weight. The total lines match the . Regards, Adrien On 3/8/24 3:41 AM, Chris Green wrote: Maybe I have set something somwhere without knowing it but

Re: [GNC] Bill total does not match real total

2024-03-08 Thread Stan Brown (using GC 4.14)
On 2024-03-08 08:27, Alan Johnson wrote: > Please refer to the attachments. One is the Amazon invoice for an order. >  This order is for Florida with a 7.5% sales tax.  > > It contains 3 items, 4.99, 34.99, and 7.99.   > > This subtotals to 47.97.  > > 47.97 *.075 = 3.5955 according to my

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-08 Thread Adrien Monteleone
But XAU no longer works with Alphavantage at least. GC=F (SI=F for silver) works fine. Regards, Adrien On 3/7/24 10:50 AM, Kalpesh Patel wrote: Oh! XAU symbol is indeed named Gold in Currencies name space which seems ... ___ gnucash-user mailing

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread Tom Teixeira
Thanks. I forgot to mention I am running on M2. But after forcing x86_64 arch for JSON::Parse, Finance::Quote was missing. Using: "sudo arch -arch x86_64 cpan -f Finance::Quote" fixed that. On 3/8/24 11:47 AM, David Reiser wrote: You could try: sudo arch -arch x86_64 cpan -f JSON::Parse You

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread David Reiser via gnucash-user
You could try: sudo arch -arch x86_64 cpan -f JSON::Parse You definitely need the x86_64 version of Perl modules for use with gnucash on Macs with Apple silicon cpus (M1, M2, M3) because gnucash is running in rosetta. I think if you tried the gnc-fq-udate first, you may have satisfied the

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread Tom Teixeira
Just upgraded to MacOS 14.4 release version. I had not previously installed the beta version. I'm unable to get Finance::Quote working. I updated Finance::Quote -- tried both gnc-fq-update found inside the Gnucash.app package, and also using sudo cpan -i Finance::Quote.

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread David Reiser via gnucash-user
Gnucash 5.5 and 5.4 work fine for me under MacOS 14.4 release version. I did have to completely reinstall the Finance::Quote and dependency batch (and JSON::Parse separately). -- Dave Reiser dbrei...@icloud.com > On Mar 8, 2024, at 12:56 AM, john wrote: > > Have any other Mac users

[GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)

2024-03-08 Thread Eric H. Bowen via gnucash-user
I use two separate GnuCash books, one for my personal funds and another for my LLC. These files are saved on a cloud drive and I access them from a few different computers. Some of the computers run Windows 10, while some run Ubuntu Studio 22.04 LTS. The computer on which this first happened

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-08 Thread pete hopkins
John I am running MacOS 14.4 on an intel chip with Gnucash Build 5.5+(2023-12-16) and no crashes so far. If I can help with diagnostics please let me know. If I do hit any snags I will throw them in to aid any subsequent diagnosis. Regards peter hopkins pete.hopkins...@outlook.com On 8

Re: [GNC] Bill total does not match real total

2024-03-08 Thread Liz
On Wed, 6 Mar 2024 17:11:29 -0500 Michael or Penny Novack wrote: > FOR EXAMPLE --- many (most?) US states that have sales tax do NOT use > rounding if you are worrying about cents. The tax is a cent for any > fraction of a cent (round up the cents) > > Michael D Novack I recommend this

[GNC] Setting font sizes in reports (specifically in Transaction Report)

2024-03-08 Thread Chris Green
Maybe I have set something somwhere without knowing it but the font sizes for headings in the Transaction Report seem odd to me. Each account is shown as follows:- ... ... Total for The oddity is that the uses the same font size as the list of