Re: [GNC] Description List

2023-05-22 Thread Vincent Dawans
Wait until version 5.2 before doing anything. It will most likely have a different way of sorting descriptions, with recent ones floating to the top. Hence old misspelled descriptions will be less likely to be found near the top of the list and easier to ignore. More recent misspellings are easy

Re: [GNC] Description List

2023-05-22 Thread Peter West via gnucash-user
Wouldn’t this be a case where correcting the database or XML file would be a feasible solution? — Peter West p...@pbw.id.au “I am the bread of life; whoever comes to me shall not hunger, and whoever believes in me shall never thirst.” > On 23 May 2023, at 2:29 pm, Adrien Monteleone > wrote:

Re: [GNC] Description List

2023-05-22 Thread Adrien Monteleone
You can't. It is composed of all descriptions entered. If something is spelled incorrectly, you can do a search for transactions that have that misspelling in their description field, then correct them one by one. Once a description no longer appears anywhere, such as a misspelling, it will

Re: [GNC] invoice not showing sales in income account

2023-05-22 Thread Vincent Dawans
Thelma: Could your other income accounts somehow have been flagged as placeholder accounts? This would explain why they don't show up in the invoice. If you go to the account list, and right-click on an income account that you want to use in your invoice, what does it show when you select Edit

[GNC] Gnucash 5.1 Online Quotes not working

2023-05-22 Thread Thornefamilytrust
Hi, I have re-tried by installing Gnucash v5.1 on my Win 10 machine to get online quotes to work. Upgraded from 4.XX to 5.1 uninstalled Strawberry and ran the "Install Online Price retrieval" tool for Gnucash. This reinstalled Strawberry Perl , F:Q etc but all I get when clicking Get

Re: [GNC] Including document paths in reports

2023-05-22 Thread Vincent Dawans
> I’m guessing that the links are also live so they could also be verified by selecting. Yes and in the current version that's already the case (if the other option called ¨Enable Links? is selected, which it is by default). The L anchor has a link to the document. In the updated version, the

Re: [GNC] Including document paths in reports

2023-05-22 Thread Brook Milligan
> On May 22, 2023, at 4:13 PM, Vincent Dawans wrote: > > OK I submitted a draft PR to implement this. Let's see if it makes it in the > main release otherwise I will make it as a custom report. See > https://github.com/Gnucash/gnucash/pull/1643 for a couple screenshots. Something like this

Re: [GNC] Including document paths in reports

2023-05-22 Thread Vincent Dawans
OK I submitted a draft PR to implement this. Let's see if it makes it in the main release otherwise I will make it as a custom report. See https://github.com/Gnucash/gnucash/pull/1643 for a couple screenshots. Cheers, Vincent On Mon, May 22, 2023 at 5:49 AM Brook Milligan wrote: > > > On May

Re: [GNC] Price quotes

2023-05-22 Thread Keith Bellairs
Thanks. The FQ update fixed it (for now, I guess). Keith On Mon, May 22, 2023 at 1:26 PM Kalpesh Patel wrote: > F::Q was updated to version 1.55 which has a fix in it, albeit most likely > short term until Yahoo shuts off that spigot. In any platform you can > install/upgrade F::Q manually.

Re: [GNC] Price quotes

2023-05-22 Thread R Losey
If you use Alphavantage, there is a one-minute delay for each 5 securities. Thus, when I check 12 securities, I have a delay of well over two minutes. Back when JSON was working, it only took seconds. On Mon, May 22, 2023 at 6:34 AM Keith Bellairs wrote: > I was using yahoo_json and it started

Re: [GNC] OFX transactional data downloads from FDIC insured banks

2023-05-22 Thread Kalpesh Patel
I can confirm that https://www.chase.com/ provides download of accounts (credit card, checking or saving) in QFX format from their web site. At one Chase even provided direct connect OFX download via an API call which they shuttered in 2022. If you have Plaid then you can go to Plaid+

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Kalpesh Patel
FYI - 1.55 version of F::Q module is installed, which has the yahoo_json fix. -Original Message- From: Murugan Muruganandam Sent: Monday, May 22, 2023 12:11 PM To: Bob Atwell Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Finance::Quotes stopped working before uninstalling perl, from

Re: [GNC] Price quotes

2023-05-22 Thread Kalpesh Patel
sudo should NOT be used to install perl modules at all (no elevated permissions are required in any platform). apt is an Ubuntu OS package manager; CPAN is a perl module manager which amongst many packages might be installed using the OS package manager. If you upgrade the perl version then

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Bob Atwell
I changed it from Alphavantage, US to Yahoo as JSON. On Mon, May 22, 2023 at 10:28 AM John Ralls wrote: > GnuCash crashed? What was the old source? > > Regards, > John Ralls > > > On May 22, 2023, at 12:25, Bob Atwell wrote: > > > > OK, I think I fixed it by changing the source in the

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Kalpesh Patel
Open up a CMD or shell and run following command: perl -MFinance::Quote -e "print $Finance::Quote::VERSION .\"\n\";" If F::Q module is properly installed then you should get close to version 1.55, which is the latest. Here is a run on of it on Windows platform under CMD:

Re: [GNC] Price quotes

2023-05-22 Thread Jour Maken
Thank you for the F::Q update method. On Ubuntu Linux 22.04 LTS, would this need to be run with sudo, and would future apt updates be affected? Regards, Divakar On 22/05/23 22:56, Kalpesh Patel wrote: F::Q was updated to version 1.55 which has a fix in it, albeit most likely short term until

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread John Ralls
GnuCash crashed? What was the old source? Regards, John Ralls > On May 22, 2023, at 12:25, Bob Atwell wrote: > > OK, I think I fixed it by changing the source in the Securities Editor. > > Bob. > > > On Mon, May 22, 2023 at 10:19 AM Bob Atwell wrote: > >> I uninstalled and reinstalled

Re: [GNC] Price quotes

2023-05-22 Thread Kalpesh Patel
F::Q was updated to version 1.55 which has a fix in it, albeit most likely short term until Yahoo shuts off that spigot. In any platform you can install/upgrade F::Q manually. Just run following two commands in CMD or shell perl -MCPAN -e shell install Finance::Quote # first command will

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Bob Atwell
OK, I think I fixed it by changing the source in the Securities Editor. Bob. On Mon, May 22, 2023 at 10:19 AM Bob Atwell wrote: > I uninstalled and reinstalled Perl. I ran Install Online Price Retrieval > for GnuCash and everything seemed fine. I opened GnuCash and ran Get Quote, > seemed to

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Bob Atwell
I uninstalled and reinstalled Perl. I ran Install Online Price Retrieval for GnuCash and everything seemed fine. I opened GnuCash and ran Get Quote, seemed to go OK for a bit and then crashed. Re-tried with the same result. Not a happy camper. Bob. On Mon, May 22, 2023 at 9:11 AM Murugan

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Murugan Muruganandam
before uninstalling perl, from the windows - Start menu - Gnucash - Install Online Price Retrieval for GnuCash this should automatically fetch and install Finance quote 1.54 if this works for you then you need not re install perl. uninstalling perl you can do it from control panel - Program

Re: [GNC] invoice not showing sales in income account

2023-05-22 Thread Murugan Muruganandam
Thelma you can use Flatpak to install the latest version https://wiki.debian.org/GnuCash Saludos Cordiales Murugan From: Thelma Sabim Sent: Monday, May 22, 2023 11:37 AM To: gnucash-user@gnucash.org Cc: Murugan Muruganandam Subject: Re: [GNC] invoice

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Bob Atwell
I am on Windows 11 and I think I will need to uninstall and reinstall Perl. What is the right procedure for doing that? Bob. On Mon, May 22, 2023 at 7:50 AM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > > Bob > > please detail your operating system and the Finance Quote. > > Did

Re: [GNC] invoice not showing sales in income account

2023-05-22 Thread Thelma Sabim
Hi, I am still searching what went wrong with my invoice screen causing only one account to show in the Income Account field. Since Debian repository does not offer newer version - still 4.4 - I am considering downloading a new version from GnuCash site. I do not feel very confident in doing so. I

Re: [GNC] Price quotes

2023-05-22 Thread Murugan Muruganandam
Keith you need to give more details on the GNU version and also the Finance quote version. if you have not updated, you need to get the latest version where the yahoo issue is fixed Saludos Cordiales Murugan From: gnucash-user on behalf of Keith

Re: [GNC] Finance::Quotes stopped working

2023-05-22 Thread Murugan Muruganandam
Bob please detail your operating system and the Finance Quote. Did you install finance quote again after installing 5.1 version Saludos Cordiales Murugan From: gnucash-user on behalf of Bob Atwell Sent: Sunday, May 21, 2023 2:17 PM To:

Re: [GNC] cost of goods sold, unsold inventory

2023-05-22 Thread Michael or Penny Novack
On 5/21/2023 7:26 PM, Jamie Tolbert wrote: I am slowly wrapping my head around things, kinda stuck on a question about accounting for unsold inventory. Say I bought 10 widgets, for 100 each, my cost of good sold is 1000; I sold 6 for 140 each. My sales is 840, but my cost of good sold is only

Re: [GNC] Including document paths in reports

2023-05-22 Thread Brook Milligan
> On May 21, 2023, at 9:16 PM, Vincent Dawans wrote: > > Are you aware that the transaction report already has the option to display > not the document path itself but a mark that there is a linked document? It > just shows L to the left of the amount column when there is a document (with >

[GNC] Price quotes

2023-05-22 Thread Keith Bellairs
I was using yahoo_json and it started failing to return anything. I switched my securities over to Alphavantage and it works. But it is an order of magnitude slower.Any word on Yahoo? Keith ___ gnucash-user mailing list gnucash-user@gnucash.org To

[GNC] Description List

2023-05-22 Thread Phillip Walsh
How can I edit the list that drops down in the Description 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 - Please

[GNC] Finance::Quotes stopped working

2023-05-22 Thread Bob Atwell
A couple of weeks ago I started getting an error message when I tried to get quotes. (Everything worked fine prior to that.) After updating to 5.1 I got the same or similar message saying I needed an AlphaVantage API I got one and put it into the preferences but then I got a different error

Re: [GNC] cost of goods sold, unsold inventory

2023-05-22 Thread Stephen M. Butler
For my inventory I assign a cost per unit (looks like yours is $100/unit).  That is a valid "expense" and can show up either as an expense item or as a reduction of sales.  I assigned mine as a reduction against sales (sub-account called COGS).  The other side of that entry is against