[GNC] Yahoo json unauthorized
I recently had to change to "Yahoo as JSON" quotes when Alphavantage changed their access rules, and for a while it worked no problem. Today it doesn't. For each security I get an error message of the form " ... Attempt to fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=[...] resulted in HTTP response 401 (Unauthorized)". Can anyone suggest a solution? Ruaraidh ___ 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] Yahoo json unauthorized
(Correction. It seems to work for most but not all funds; and has failed for all LSE securities) On Wed, 6 Mar 2024 at 08:25, Ruaraidh Sackville Hamilton < ruaraidh...@gmail.com> wrote: > I recently had to change to "Yahoo as JSON" quotes when > Alphavantage changed their access rules, and for a while it worked no > problem. Today it doesn't. For each security I get an error message of the > form " ... Attempt to fetch the URL > https://query1.finance.yahoo.com/v7/finance/quote?symbols=[...] resulted > in HTTP response 401 (Unauthorized)". > > Can anyone suggest a solution? > > Ruaraidh > ___ 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] How to get a report in a format which is easy to edit?
Chris Are you "printing to file" or are you doing something else? As Adrien has pointed out, you have not really given us enough info to help you. Most Linux systems I am aware of allow printing to file & selecting file type as pdf. I have not encountered a pdf from this method which couldn't be edited - try something like MasterPDFEditor - it was free for basic editing. As you are using Linux & libreoffice you can just export the HTML & import into Writer, adjust as required, then export to pdf. But, again as Adrien noted, you might achieve what you want via the Report Options pathway. If you provide all info on the OS system & the version of GnuCash you are using & steps you have taken, you might just find a GnuCash user on this list who can help you more directly. Cheers A. On Wed, 6 Mar 2024, 6:58 pm Chris Green, wrote: > On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: > > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can > > pull it off. > > > Which PDFs? All the ones I have produced are images. What's the > 'standard' route from a GnuCash report to PDF (on Linux, so > LibreOffice etc. are here by default). > > -- > Chris Green > ___ > 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] How to get a report in a format which is easy to edit?
As an afterthought Chris, check to see if you have Ghostscript installed - it effectively provides a pdf printer (with editable files) On Wed, 6 Mar 2024, 8:01 pm Alan Hopkins, wrote: > Chris > > Are you "printing to file" or are you doing something else? As Adrien has > pointed out, you have not really given us enough info to help you. > > Most Linux systems I am aware of allow printing to file & selecting file > type as pdf. I have not encountered a pdf from this method which couldn't > be edited - try something like MasterPDFEditor - it was free for basic > editing. > > As you are using Linux & libreoffice you can just export the HTML & import > into Writer, adjust as required, then export to pdf. > > But, again as Adrien noted, you might achieve what you want via the Report > Options pathway. > > If you provide all info on the OS system & the version of GnuCash you are > using & steps you have taken, you might just find a GnuCash user on this > list who can help you more directly. > > Cheers > > A. > > On Wed, 6 Mar 2024, 6:58 pm Chris Green, wrote: > >> On Tue, Mar 05, 2024 at 11:54:35PM -0600, Adrien Monteleone wrote: >> > Yes, those PDFs are indeed reasonably editable. Even LibreOffice can >> > pull it off. >> > >> Which PDFs? All the ones I have produced are images. What's the >> 'standard' route from a GnuCash report to PDF (on Linux, so >> LibreOffice etc. are here by default). >> >> -- >> Chris Green >> ___ >> 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] How to get a report in a format which is easy to edit?
On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: > Chris > > Are you "printing to file" or are you doing something else? As Adrien has > pointed out, you have not really given us enough info to help you. > I tried various ways. > > If you provide all info on the OS system & the version of GnuCash you are > using & steps you have taken, you might just find a GnuCash user on this > list who can help you more directly. > It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. However I have spotted my basic problem, opening a PDF file with libreoffice opens it in lodraw and thus it *looks like* I have a PDF with images. I don't seem to be able to force libreoffice to open a PDF in lowriter. I have managed a way round this now, pandoc will convert from HTML directly to an loffice ODT file which gets me to the result I want, a report I can edit reasonably easily in lowriter. -- Chris Green ___ 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] How to get a report in a format which is easy to edit?
Glad to hear it On Wed, 6 Mar 2024, 8:43 pm Chris Green, wrote: > On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: > > Chris > > > > Are you "printing to file" or are you doing something else? As Adrien has > > pointed out, you have not really given us enough info to help you. > > > I tried various ways. > > > > > If you provide all info on the OS system & the version of GnuCash you are > > using & steps you have taken, you might just find a GnuCash user on this > > list who can help you more directly. > > > It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. > > However I have spotted my basic problem, opening a PDF file with > libreoffice opens it in lodraw and thus it *looks like* I have a PDF > with images. I don't seem to be able to force libreoffice to open a > PDF in lowriter. > > I have managed a way round this now, pandoc will convert from HTML > directly to an loffice ODT file which gets me to the result I want, a > report I can edit reasonably easily in lowriter. > > -- > Chris Green > ___ > 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] How to get a report in a format which is easy to edit?
You just need CUPS-PDF installed as a print driver for producing pdf files. On Wed, 6 Mar 2024, 9:12 pm Alan Hopkins, wrote: > Glad to hear it > > On Wed, 6 Mar 2024, 8:43 pm Chris Green, wrote: > >> On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: >> > Chris >> > >> > Are you "printing to file" or are you doing something else? As Adrien >> has >> > pointed out, you have not really given us enough info to help you. >> > >> I tried various ways. >> >> > >> > If you provide all info on the OS system & the version of GnuCash you >> are >> > using & steps you have taken, you might just find a GnuCash user on this >> > list who can help you more directly. >> > >> It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. >> >> However I have spotted my basic problem, opening a PDF file with >> libreoffice opens it in lodraw and thus it *looks like* I have a PDF >> with images. I don't seem to be able to force libreoffice to open a >> PDF in lowriter. >> >> I have managed a way round this now, pandoc will convert from HTML >> directly to an loffice ODT file which gets me to the result I want, a >> report I can edit reasonably easily in lowriter. >> >> -- >> Chris Green >> ___ >> 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] How to get a report in a format which is easy to edit?
If are you going from HTML to PDF then that sounds like the method employed by that converter and not GNC itself. Once you run the report, if you look at the top of the report window, there is 'Make PDF' button/icon (at least I see it on Windows version of it). Pressing that should save it as a true PDF formatted file. On Windows platform, I just ran a report, saved it as PDF using afore-said method and was able to edit individual "cells" in ABBYY FineReader PDF app. Since GNC is cross-platform, I don't think that behavior is likely to be different between Windows, Linux or Mac. Platform might customize how the dialogues are displayed at each step but the underlying facility is like to function in same manner. -Original Message- From: Chris Green Sent: Wednesday, March 06, 2024 2:56 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] How to get a report in a format which is easy to edit? On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote: > > Additionally, there are pdf editors out there that do a good job (some > are > cross-platform) - my pdf's produced from GnuCash are all editable (I > use > Linux) - not graphic images - maybe look for another driver/app to > achieve what you need? This is what I'm after. I'm all Linux based but so far whatever route I take to get from GnuCash's HTML to PDF I end up with a PDF file with images rather than text in it. What do you use to convert to PDF? -- Chris Green ___ 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 Options: Unexpected Behavior
Thank you for the reply. Since my use of GnuCash has been experimental rather than operational, I defer to the GnuCash Community to escalate this scenario as a Bug to the GnuCash Development Team if so desired. Regards, Dave On Mon, Mar 4, 2024 at 8:25 AM Adrien Monteleone wrote: > > When the income statement is first run, it is including the hidden > account. (but is not supposed to) Toggling the radio button is > apparently 'fixing' this to work as intended. > > Therefore since the initial behavior is not as designed, I'd call it a bug. > > I just tested this on a Mac and it is working as you describe, so not > specific to OS. > > Regards, > Adrien > > On 3/4/24 8:21 AM, Old Sawmill wrote: > > I am a new GnuCash user, and I successfully exported more than 10,000 > > transactions in several hundred multi-level accounts from QuickBooks > > and imported that dataset into GnuCash Version 5.5 (Build ID: > > 5.5+2023-12-16) running on Windows 11. > > > > While applying GnuCash capabilities to this imported dataset, I > > encountered an unexpected behavior with Reports Options, which I have > > distilled into the scenario below (feel free to follow along with the > > attached GnuCash data file and associated screenshots image): > > > > 1. The data file contains three accounts (MyBank, MyHiddenIncome, and > > MyExpense), one $708.00 transaction between MyBank and MyHiddenIncome > > (a hidden account), and one $666.00 transaction between MyBank and > > MyExpense. > > > > 2. After opening the data file, go directly to the Reports menu and > > select (the built-in) Income Statement, which creates an Income > > Statement that shows $42.00 of net income, the expected difference > > between $708.00 of income and $666.00 of expense. > > > > 3. Next, select Report Options, and select the General tab. Note that > > the dates are "Start of accounting period" and "End of accounting > > period" (corresponding to the current calendar year). > > > > 4. Then, select the radio button for entering a custom Start Date, but > > do not change that custom Start Date value. Instead, just immediately > > re-select the radio button for "Start of accounting period", and click > > OK to apply and close the Options dialog. > > > > 5. Note that the Income Statement now shows a $666.00 net loss, merely > > because of back-and-forth radio button changes on the Options/General > > tab. > > > > > > Now, I have come to understand what GnuCash is doing in this scenario > > and in various real-world scenarios from which this scenario was > > distilled. So, I have just one question for the GnuCash Community: > > > > Is the behavior that occurs in this scenario a Feature, or a 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. ___ 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] Yahoo json unauthorized
Is your F::Q up to date? Last version released is 1.59. Version can be displayed by navigating to 'Help' --> 'About' window. It should say "Finance::Quote x.xx" somewhere in the middle of the window. What ever number is x.xx is the version of the installed F::Q. It also could be that it is a transient error due to Yahoo taking a maintenance window if it is the version that is latest and greatest. If not then time to update it, to keep up with Yahoo constantly moving the goal post. -Original Message- From: Ruaraidh Sackville Hamilton Sent: Wednesday, March 06, 2024 3:33 AM To: Gnucash Users Subject: Re: [GNC] Yahoo json unauthorized (Correction. It seems to work for most but not all funds; and has failed for all LSE securities) On Wed, 6 Mar 2024 at 08:25, Ruaraidh Sackville Hamilton < ruaraidh...@gmail.com> wrote: > I recently had to change to "Yahoo as JSON" quotes when Alphavantage > changed their access rules, and for a while it worked no problem. > Today it doesn't. For each security I get an error message of the form > " ... Attempt to fetch the URL > https://query1.finance.yahoo.com/v7/finance/quote?symbols=[...] > resulted in HTTP response 401 (Unauthorized)". > > Can anyone suggest a solution? > > Ruaraidh > ___ 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] How to get a report in a format which is easy to edit?
Chris, LibreOffice uses Draw for PDF editing, not Writer. That doesn't mean the text isn't text. Everything is essentially in various text boxes. But having used it quite a bit, I can attest it is way more of a pain for large edits than either HTML or using Calc. For a small change though, it is just fine. I've edited many GnuCash reports using Calc. It is by far the easiest route and the most useful. (you can do additional math if needed) But of course, use whatever tool you prefer. Also, as I mentioned, investigate stylesheets in GnuCash. You might achieve what you want without using an outside tool at all. Regards, Adrien On 3/6/24 3:42 AM, Chris Green wrote: On Wed, Mar 06, 2024 at 08:01:36PM +1100, Alan Hopkins wrote: Chris Are you "printing to file" or are you doing something else? As Adrien has pointed out, you have not really given us enough info to help you. I tried various ways. If you provide all info on the OS system & the version of GnuCash you are using & steps you have taken, you might just find a GnuCash user on this list who can help you more directly. It's xubuntu and I'm running GnuCash 4.8 and LibreOffice 7.3.7.2. However I have spotted my basic problem, opening a PDF file with libreoffice opens it in lodraw and thus it *looks like* I have a PDF with images. I don't seem to be able to force libreoffice to open a PDF in lowriter. I have managed a way round this now, pandoc will convert from HTML directly to an loffice ODT file which gets me to the result I want, a report I can edit reasonably easily in lowriter. ___ 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] How to get a report in a format which is easy to edit?
That is installed by default in Ubuntu for many years now. I would suspect the same is true of its various flavors. Regards, Adrien On 3/6/24 4:17 AM, Alan Hopkins wrote: You just need CUPS-PDF installed as a print driver for producing pdf files. ___ 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] Yahoo json unauthorized
Thanks Kalpesh! I should have been more patient ... it was a transient error. It's working again now. On Wed, 6 Mar 2024 at 13:59, Kalpesh Patel wrote: > Is your F::Q up to date? Last version released is 1.59. Version can be > displayed by navigating to 'Help' --> 'About' window. It should say > "Finance::Quote x.xx" somewhere in the middle of the window. What ever > number is x.xx is the version of the installed F::Q. > > It also could be that it is a transient error due to Yahoo taking a > maintenance window if it is the version that is latest and greatest. If not > then time to update it, to keep up with Yahoo constantly moving the goal > post. > > > -Original Message- > From: Ruaraidh Sackville Hamilton > Sent: Wednesday, March 06, 2024 3:33 AM > To: Gnucash Users > Subject: Re: [GNC] Yahoo json unauthorized > > (Correction. It seems to work for most but not all funds; and has failed > for all LSE securities) > > On Wed, 6 Mar 2024 at 08:25, Ruaraidh Sackville Hamilton < > ruaraidh...@gmail.com> wrote: > > > I recently had to change to "Yahoo as JSON" quotes when Alphavantage > > changed their access rules, and for a while it worked no problem. > > Today it doesn't. For each security I get an error message of the form > > " ... Attempt to fetch the URL > > https://query1.finance.yahoo.com/v7/finance/quote?symbols=[...] > > resulted in HTTP response 401 (Unauthorized)". > > > > Can anyone suggest a solution? > > > > Ruaraidh > > > > > ___ 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] How to get a report in a format which is easy to edit?
You might export as CSV and print it from excel, Google Sheets, libreOffice Sheets or as a spreadsheet into table in a word processing document. ___ 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] Defining Keyboard shortcuts for Menu Functions
Hi I've just spent 45 minutes searching the web, and GC docs for how to a new keyboard shortcut. The shortcut I want define would be to File->Import->Import OFX/QFX Can someone provide me with enough information so that I can do this? I have no problem editing text configuration files. I would need to know the function-name for this action, and how to bind a key to that function in a configuration file GC will read. TIA, Lincoln ___ 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] Bill total does not match real total
I am entering a bill. I have 2 entries (65.62 and 374.10). It says that the total is 493.73. I am sorry, but the total should be 439.72. The issue is persistent and appears to be related to the 65.62 number. If I remove it and put another entry in, the total is correct. I have Taxable? and Tax Included both checked. GnuCash 5.5 on Ubuntu 22.04.3 Peter Carl Linkletter VMware Consultant and VMware Certified Instructor Pair-a-Links Consulting Inc. Swift Current, Saskatchewan, Canada Email: pairali...@protonmail.com Phone: 306-315-3926 Linked-in: [https://www.linkedin.com/in/plinkletter/](https://www.linkedin.com/in/plinkletter) Sent with [Proton Mail](https://proton.me/) secure email. ___ 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] Defining Keyboard shortcuts for Menu Functions
As shown in https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_Keyboard_Shortcuts You need to find and edit the file accelerator-map Then uncomment the line (gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" "") And modify to this (for example, for Ctrl-shift-o to import ofx). (gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" "o") Jean On 3/6/24 9:14 AM, Lincoln A Baxter wrote: Hi I've just spent 45 minutes searching the web, and GC docs for how to a new keyboard shortcut. The shortcut I want define would be to File->Import->Import OFX/QFX Can someone provide me with enough information so that I can do this? I have no problem editing text configuration files. I would need to know the function-name for this action, and how to bind a key to that function in a configuration file GC will read. TIA, Lincoln ___ 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] Bill total does not match real total
OK, Found the bug. The problem is that the tax is totaled up using sub-penny calculations. That causes a 1.004 + 1.004 to equal 2.008 which is then rounded to 2.01. Each line should be rounded to the penny first, then rounded up. So if 1.004 is first rounded to 1.00, then that would cause this calculation to total 2.00, not 2.01. If that makes any sense :-) Guess I will enter a bug on this. Peter Carl Linkletter VMware Consultant and VMware Certified Instructor Pair-a-Links Consulting Inc. Swift Current, Saskatchewan, Canada Email: pairali...@protonmail.com Phone: 306-315-3926 Linked-in: https://www.linkedin.com/in/plinkletter/ Sent with Proton Mail secure email. On Wednesday, March 6th, 2024 at 11:20 AM, Carl Linkletter via gnucash-user wrote: > I am entering a bill. I have 2 entries (65.62 and 374.10). It says that the > total is 493.73. I am sorry, but the total should be 439.72. The issue is > persistent and appears to be related to the 65.62 number. If I remove it and > put another entry in, the total is correct. I have Taxable? and Tax Included > both checked. > > GnuCash 5.5 on Ubuntu 22.04.3 > > Peter Carl Linkletter > VMware Consultant and VMware Certified Instructor > > Pair-a-Links Consulting Inc. > Swift Current, Saskatchewan, Canada > Email: pairali...@protonmail.com > Phone: 306-315-3926 > Linked-in: https://www.linkedin.com/in/plinkletter/ > > Sent with Proton Mail secure email. > ___ > 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] Bill total does not match real total
Hi, On Wed, March 6, 2024 12:20 pm, Carl Linkletter via gnucash-user wrote: > I am entering a bill. I have 2 entries (65.62 and 374.10). It says that > the total is 493.73. I am sorry, but the total should be 439.72. The issue > is persistent and appears to be related to the 65.62 number. If I remove > it and put another entry in, the total is correct. I have Taxable? and Tax > Included both checked. This last part is the key to the issue. It's a rounding error. The issue is that each line-item is rounded, but the invoice sums the natural number and rounds at the end. So what's happening here is that you have 374.1x which rounds to 374.10, and you have 65.6y which rounds to 65.62, but when you add x + y you get a sum that rounds up to the next penny. E.g., 65.624 + 372.104 = 437.728 which rounds to 437.73 > GnuCash 5.5 on Ubuntu 22.04.3 > > Peter Carl Linkletter > VMware Consultant and VMware Certified Instructor > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bill total does not match real total
Looks like it is related to bug https://bugs.gnucash.org/show_bug.cgi?id=612957 Carl L. Peter Carl Linkletter VMware Consultant and VMware Certified Instructor Pair-a-Links Consulting Inc. Swift Current, Saskatchewan, Canada Email: pairali...@protonmail.com Phone: 306-315-3926 Linked-in: https://www.linkedin.com/in/plinkletter/ Sent with Proton Mail secure email. On Wednesday, March 6th, 2024 at 12:31 PM, Derek Atkins wrote: > Hi, > > On Wed, March 6, 2024 12:20 pm, Carl Linkletter via gnucash-user wrote: > > > I am entering a bill. I have 2 entries (65.62 and 374.10). It says that > > the total is 493.73. I am sorry, but the total should be 439.72. The issue > > is persistent and appears to be related to the 65.62 number. If I remove > > it and put another entry in, the total is correct. I have Taxable? and Tax > > Included both checked. > > > This last part is the key to the issue. It's a rounding error. The issue > is that each line-item is rounded, but the invoice sums the natural number > and rounds at the end. So what's happening here is that you have 374.1x > which rounds to 374.10, and you have 65.6y which rounds to 65.62, but when > you add x + y you get a sum that rounds up to the next penny. > > E.g., 65.624 + 372.104 = 437.728 which rounds to 437.73 > > > GnuCash 5.5 on Ubuntu 22.04.3 > > > > Peter Carl Linkletter > > VMware Consultant and VMware Certified Instructor > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bill total does not match real total
OK, Found the bug. The problem is that the tax is totaled up using sub-penny calculations. That causes a 1.004 + 1.004 to equal 2.008 which is then rounded to 2.01. Each line should be rounded to the penny first, then rounded up. So if 1.004 is first rounded to 1.00, then that would cause this calculation to total 2.00, not 2.01. If that makes any sense :-) Guess I will enter a bug on this. Speaking as somebody who spent decades in the cypher mines (a rather senior systems analyst/business analyst) a) There is no rule in mathematics how/where rounding should take place. It is simply true that rounded A + rounded B does not necessarily = rounded (A+B) b) So a program might be defined to be correct (or wrong) depending on what it does during rounding COMPARED TO THE FORMAL PROGRAM DEFINITION. I other words, during the "requirements phase" of the project when a committee of "clients" sat with business analysts and this formal document was created << this process normally budgeted for about 20% of project time -- "people-hours" >> c) OH --- this is software produced by volunteer designers/coders. There was NO formal definition of what was t be done in all situations because no corresponding team of volunteer "clients" (program users) for that phase of the project, coming up with the formal definition. THEN this sort of thing CAN'T be a "bug". Can't be because there never was a defined "should do". Understand what I am saying? The "client community" can most certainly request a change to what has now been decided. That is not one person. Instead of filing a "bug report" ask fellow gnucash users to volunteer for a TEAM to get together and decide what the program SHOULD do, and once decided, ask for that change. Wearing my old business analyst hat for a moment, sitting at a meeting of that committee I'd ask ":what are the sales tax rules for YOUR jurisdiction?" < when multiple items are bought at the same time> That's what we do, ASK QUESTIONS (based on what our experience tells us will likely be a problem -- that there will NOT be uniformity about that. 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 ___ 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] 5.5-1 crashing on macOS 14.3
GnuCash 5.5-1 wouldn't open after OS update. Same version ran fine on previous OS versions. Multiple fresh download/install of new 5.5 GnuCash didn't fix. GnuCash 5.5-1 won't open on macOS 14.3 Anything I can do to assist troubleshoot/repair the issue? Anon20 ___ 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] Error Retrieving Gold Price for Price Database
I installed GnuCash from flathub. I'm running GnuCash v5.5. Finance::Quote is v1.58. In the security editor, in the "currencies" namespace, gold is listed under symbol XAU. I have the box checked for "Get Online Quotes." "Type of quote source" is Single --> Currency Whenever I click "Get Quotes" in the price database, the price for gold fails with this error: "Quotes for the following commodities were unavailable or unusable: * CURRENCY:XAU Finance::Quote reported failure set no error." I have quotes for Canadian dollars set up identically and those work fine when I update the quotes. Does anyone know how to configure this to retrieve gold prices? If it helps, I do have an Alphavantage API key and use that all the time to update stock prices. Thank you! ___ 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] 5.5-1 crashing on macOS 14.3
GnuCash 5.5-1 wouldn't open after OS update. Same version ran fine on previous OS versions. Multiple fresh download/install of new 5.5 GnuCash didn't fix. Anything I can do to assist troubleshoot/repair the issue? Anon20 ___ 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.
