Re: [GNC] Report question
I have two classes of Expenses, "Ordinary" and "Exceptional"; I want the full breakdown of the Exceptional expenses (which is provided) but I only need the total for the Ordinary expenses. After a few hours of clicking check boxes I've not been able to get what I want - is it possible? You have given a perfect example why it can be better to run the report (in Gnucash) and then export the raw re[port to a document you can edit as needed. I used to vary detail by area all the time, but I didn't ask gnucash to do that for me. Thus as treasurer, needed full breakdowns, how much went to each intern, how much was time and how much mileage reimbursement << for tax filing >> but on their copy of the quarterly report the board of directors just care about the total spent on interns . Or for an event, the postage and mailing expense separate (line item on 990/990-EZ) but for the BoD just expense total for the event. Note that even if you HAD "boxes to click on and off" this would be slower than editing out unwanted detail using a full capability editor. 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.
Re: [GNC] Finance::Quote currency update not working on Windows 10
Thank you Murugan, I found the answer in the archive here: https://lists.gnucash.org/pipermail/gnucash-user/2020-September/093106.html. Eset AV was blocking Alphavantage. F::Q now works. Karel pá 10. 2. 2023 v 20:31 odesílatel Murugan Muruganandam < m.muruganan...@hotmail.com> napsal: > I just checked and it is working fine for me Windows 4.13 F:Q: 1.54 > > Is this the first time you are getting this error? > > can you check online quote is selected with Currency as the option for USD > and EUR and your Alphavantage API key is updated > > > > Saludos Cordiales > > > Murugan > -- > *From:* gnucash-user hotmail@gnucash.org> on behalf of Karel Kadlubiec < > karel.kadlub...@gmail.com> > *Sent:* Friday, February 10, 2023 11:04 AM > *To:* gnucash-user@gnucash.org > *Subject:* [GNC] Finance::Quote currency update not working on Windows 10 > > Hello, > could anyone help me with finance::quote? F::Q seems to be working fine on > stocks but doesn't update currencies. Error message is something like: > Can't get update for CURRENCY:EUR. Continue with good prices? Yes/No. Same > for USD. Home currency is CZK. > I am getting error only on Windows. It even works if I set new security > EURCZK=X on Yahoo as JSON. Same book opened on Ubuntu works fine. > GnuCash 4.10 > F::Q: 1.54 > Windows 10 > Standard installation using Windows installer. > Thank you > Karel > ___ > 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] Saved Report Configurations
I'm glad it's not just me that was confused by the OP; I thought he was unable to get the rename function to work properly; I don't know what to say to that, as it has always worked for me. On Fri, Feb 10, 2023 at 1:07 PM wrote: > On Fri, 10 Feb 2023 17:28:04 +0100 > Mahon Finbar wrote: > > > However, it doesn't seem to work, I now have a list of 'saved report > > configurations' from those terminating with no number at all to 21, > > all called profit & loss, in a sort of random order. > > You can delete reports that you don't want any more, is that what you > want? > > Liz > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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 currency update not working on Windows 10
I just checked and it is working fine for me Windows 4.13 F:Q: 1.54 Is this the first time you are getting this error? can you check online quote is selected with Currency as the option for USD and EUR and your Alphavantage API key is updated Saludos Cordiales Murugan From: gnucash-user on behalf of Karel Kadlubiec Sent: Friday, February 10, 2023 11:04 AM To: gnucash-user@gnucash.org Subject: [GNC] Finance::Quote currency update not working on Windows 10 Hello, could anyone help me with finance::quote? F::Q seems to be working fine on stocks but doesn't update currencies. Error message is something like: Can't get update for CURRENCY:EUR. Continue with good prices? Yes/No. Same for USD. Home currency is CZK. I am getting error only on Windows. It even works if I set new security EURCZK=X on Yahoo as JSON. Same book opened on Ubuntu works fine. GnuCash 4.10 F::Q: 1.54 Windows 10 Standard installation using Windows installer. Thank you Karel ___ 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] Finance::Quote currency update not working on Windows 10
Hello, could anyone help me with finance::quote? F::Q seems to be working fine on stocks but doesn't update currencies. Error message is something like: Can't get update for CURRENCY:EUR. Continue with good prices? Yes/No. Same for USD. Home currency is CZK. I am getting error only on Windows. It even works if I set new security EURCZK=X on Yahoo as JSON. Same book opened on Ubuntu works fine. GnuCash 4.10 F::Q: 1.54 Windows 10 Standard installation using Windows installer. Thank you Karel ___ 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] Saved Report Configurations
On Fri, 10 Feb 2023 17:28:04 +0100 Mahon Finbar wrote: > However, it doesn't seem to work, I now have a list of 'saved report > configurations' from those terminating with no number at all to 21, > all called profit & loss, in a sort of random order. You can delete reports that you don't want any more, is that what you want? Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report question
Noted; however, there comes a time for everyone when the work involved in the more complex solution is not worth just adopting the simple solution. If you did get it to work as a single report, it is likely to be multi-page anyway... I think you've probably hit the limit of the reports; I'm not aware of any way to have one report in which some accounts are just summarized and others have detailed information, unless you change how the data is entered somehow. But best wishes with your project. On Fri, Feb 10, 2023 at 12:23 PM Eric Coates via gnucash-user < gnucash-user@gnucash.org> wrote: > Adrien wrote: > > "When starting a new topic, rather than replying to an existing one, > simply send a new message to the list address. Otherwise, it might not > get noticed > > Sorry. Although I did start with an existing post I changed the Subject > and I thought that would have removed the antecedents of the original > message. I live and learn! > > Richard asked: > > "... why not have two reports; one with Ordinary Expense accounts > selected, and the other with the Exceptional account selected. For the > latter, you can have it show the full breakdown" > > Indeed that would be simple but as I said I'm exploring the reports ie > pushing the limits of my knowledge. It has the disadvantage that I would > need multiple reports to get what I want which basically boils down to > "everything on one sheet of paper". Yes I'm aware of the spreadsheet > work around but "why do it easy when you can do it Eric" as a friend of > mine often asked! > > > > Adrien suggested using the multi column report. I have tried this but, > having got a Profit & Loss report in each of the two columns I cannot > see any way of trimming them down. There is no information as how to do > this in the manual (9.3.5.2). Suggestions would be welcomed. (I'm using > GnuCash 4.8 on Ubuntu Mate 22.04, is the full functionality only > available in a later version/elsewhere?) > > For completeness: My account structure structure is not the one Adrien > suggested; our expenses are separated into ""Ordinary" and "Exceptional" > according to our requirements (to other people it probably looks > arbitrary!) and both classes are top level accounts of Type Expense. > > Thank you for your patience > > Eric > > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Report question
Adrien wrote: "When starting a new topic, rather than replying to an existing one, simply send a new message to the list address. Otherwise, it might not get noticed Sorry. Although I did start with an existing post I changed the Subject and I thought that would have removed the antecedents of the original message. I live and learn! Richard asked: "... why not have two reports; one with Ordinary Expense accounts selected, and the other with the Exceptional account selected. For the latter, you can have it show the full breakdown" Indeed that would be simple but as I said I'm exploring the reports ie pushing the limits of my knowledge. It has the disadvantage that I would need multiple reports to get what I want which basically boils down to "everything on one sheet of paper". Yes I'm aware of the spreadsheet work around but "why do it easy when you can do it Eric" as a friend of mine often asked! Adrien suggested using the multi column report. I have tried this but, having got a Profit & Loss report in each of the two columns I cannot see any way of trimming them down. There is no information as how to do this in the manual (9.3.5.2). Suggestions would be welcomed. (I'm using GnuCash 4.8 on Ubuntu Mate 22.04, is the full functionality only available in a later version/elsewhere?) For completeness: My account structure structure is not the one Adrien suggested; our expenses are separated into ""Ordinary" and "Exceptional" according to our requirements (to other people it probably looks arbitrary!) and both classes are top level accounts of Type Expense. Thank you for your patience Eric ___ 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] Saved Report Configurations
have you tried renaming the report in the saved report configuration dialog box? by the way i tried the way you had mentioned and it works as expected for me. Can you detail the operating system and version Saludos Cordiales Murugan From: gnucash-user on behalf of Mahon Finbar Sent: Friday, February 10, 2023 1:28 PM To: Gnucash Users Subject: [GNC] Saved Report Configurations OK, here we go again, my last query on here produced zero responses,never mind. Now, I am trying to rationalise my Report Configurations. Under reports>saved report configurations I have a mish mash of titles and dates of reports. I have tried the "help" suggested change of name by locating the reported report and saving it as 'save config as' and giving it the "correct" dates as a name. However, it doesn't seem to work, I now have a list of 'saved report configurations' from those terminating with no number at all to 21, all called profit & loss, in a sort of random order. I wouldn't mind, since they are mostly gone to the tax man, but I have to root around to find the latest one. Barry ___ 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] Saved Report Configurations
OK, here we go again, my last query on here produced zero responses,never mind. Now, I am trying to rationalise my Report Configurations. Under reports>saved report configurations I have a mish mash of titles and dates of reports. I have tried the "help" suggested change of name by locating the reported report and saving it as 'save config as' and giving it the "correct" dates as a name. However, it doesn't seem to work, I now have a list of 'saved report configurations' from those terminating with no number at all to 21, all called profit & loss, in a sort of random order. I wouldn't mind, since they are mostly gone to the tax man, but I have to root around to find the latest one. Barry ___ 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.