Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Adrien Monteleone
The easier way to approach this is to ask yourself, "what happens in the 
real world?"


Then model that in your accounts and transactions.

Thus, do you transmit funds in advance to the PayPal account?

If so, make that transaction, with PayPal as an asset (just like another 
Bank account) then make payments from it as you finalize purchases.


If not, and PayPal auto-debits in some fashion as you make purchases, 
then you have the option to do so as separate or in the same 
transaction, or simply putting 'via PayPal' in the Description, Notes or 
Memo as preferred.


If PayPal extends credit that you then have to 'cover', then treat that 
as a Liability account, similar to a credit card.


If the answer is, "it depends on the situation, but one or more of the 
above" then put the account wherever you 'normally' have a non-contra 
balance and proceed as above.


That way, if ever you end up with a contra-balance, you'd know things 
are not 'normal', though that condition may be expected depending on 
circumstances.



-

I would only use Bills for actual vendors that I routinely owe for a 
particular purpose, not occasional or one-off purchases/charges.


Utilities, Rent, Professional Services, Insurances, Inventory, et cetera 
are good candidates here.


Even regular 'grocery' or other purchases don't quite fit the concept of 
'vendor'. (an accountant can give you actual guidance for your 
particular use case—I'm speaking in very generic terms.)


You don't have to stick to a hard and fast rule concerning accruals, 
just keep it simple.


For example, I pay my insurance in advance, but treat them as a 'vendor'.

But when I buy from Wal-Mart, that's just an expense, even though it may 
happen more frequently than the insurance payment. (and in that case, 
without accrual either)


If you regularly pay your Internet service for example with PayPal, the 
ISP would be the vendor for which you raise a Bill, not PayPal. (and in 
that case 'PayPal' would be equivalent to 'VISA' or 'Checking' as an 
example - the source of funds, but not a vendor)



Regards,
Adrien

On 12/10/22 12:25 PM, Dr. David Kirkby wrote:

I'm intending to use the Vendors and Customers under the Business menu. Do
I need to make two totally separate transactions (one bill, one invoice) to
fund the PayPal account from the bank account, and the other for PayPal to
pay the vendor? In which case, does PayPal need to be entered as a vendor
so I can pay PayPal?

Sorry, I'm really confused, and it seems multiple people have different
ways of doing this - most not using the Customer/Vendor facility.


___
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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Adrien Monteleone
That is not categorically true. Sellers (some at least) have the option 
to pass on the fees. Not sure if that is relevant to the OP's case, but 
the possibility does exist.


Regards,
Adrien

On 12/10/22 11:09 AM, Chris Skudder wrote:

When you BUY something using paypal, the SELLER pays their fees, not
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.


Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Phyllis Bruce
I'm looking at paypal as identical to venmo.  If I do not pull payments out
immediately, venmo will use the balance to pay anyone I owe.

That said, I continue to use venmo as a method of payment or cost in the
checking account which pays the bills.  I see no reason to treat paypal
differently.

If I pay someone using venmo, I go to the checking account and use venmo as
the "check number" , enter the debit and I'm done.  If someone pays me on
venmo I use venmo as the "check number" and enter the credit in the
checking account that accepts the deposit.  Voila.  KISS!

On Sat, Dec 10, 2022 at 7:29 PM David Cousens 
wrote:

>
> Dave,
>
> The different approaches with this mainly reflect different circumstances.
>
> PayPal to some extent acts a bit like a bank so my first thought would be
> to
> treat them the same as you would treat a bank account, but the appropriate
> way
> to treat it depends on how you actually use your account with them.
>
> If you maintain a positive balance in the Paypal account from which
> payments are
> made to vendors then it is reasonable to treat a PayPal account as an asset
> account of type bank as they are not extending credit to you.
>
> If they extend credit to you, i.e. they pay the vendors immediately and
> then you
> pay out the balance owing to them at the end of the month, i.e. the account
> balance is negative the majority of the time, then they are functioning
> more as
> a credit provider and a Liability account is a more appropriate way to
> treat the
> account.
>
> I chose to treat my Paypal account as a liability account, more for
> historical
> reasons than the current use of the account, but I could equally have
> treated it
> as an asset account for my purposes ( All that does is reverse the debit
> and
> credit entries to the relevant accounts), as I indicate in my reply to
> Michael.
> The function for me is primarily to make reconciliation and matching to
> receipts
> simpler.
>
> You wouldn't necessarily need to raise an invoice to cover a payment to
> PayPal
> just as you wouldn't when you pay off your credit card with a bank.
>
> The main purpose of Customers and Vendors and the business features around
> them
> is to avoid having to maintain individual accounts receivable and accounts
> payable accounts for each customer or vendor you interact with and to
> provide
> the information to manage the credit that is extended to you by vendors
> and the
> credit you extend to your customers and the effect it has on cash flow.
>
> Hope this clarifies things a bit.
>
> David
>
>
>
>
> On Sat, 2022-12-10 at 18:25 +, Dr. David Kirkby wrote:
> > On Sat, 10 Dec 2022 at 17:09, Chris Skudder 
> wrote:
> >
> > >When you BUY something using paypal, the SELLER pays their fees, not
> > >you.
> > >So recording a purchase for which you paid using paypal is no
> different
> > >than any other purchase:
> > >Debit: expense (or asset, if you're buying something that you'll
> > >recognize as an asset on your balance sheet)
> > >Credit: your paypal asset account if you carry a balance in it; or
> > >credit a credit card account if your paypal purchases pull money
> > >directly from a credit card.
> > >Chris
> > >
> >
> > I'm intending to use the Vendors and Customers under the Business menu.
> Do
> > I need to make two totally separate transactions (one bill, one invoice)
> to
> > fund the PayPal account from the bank account, and the other for PayPal
> to
> > pay the vendor? In which case, does PayPal need to be entered as a vendor
> > so I can pay PayPal?
> >
> > Sorry, I'm really confused, and it seems multiple people have different
> > ways of doing this - most not using the Customer/Vendor facility.
> >
> > Dave
> > ___
> > 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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread David Cousens

Dave,

The different approaches with this mainly reflect different circumstances.

PayPal to some extent acts a bit like a bank so my first thought would be to
treat them the same as you would treat a bank account, but the appropriate way
to treat it depends on how you actually use your account with them.

If you maintain a positive balance in the Paypal account from which payments are
made to vendors then it is reasonable to treat a PayPal account as an asset
account of type bank as they are not extending credit to you. 

If they extend credit to you, i.e. they pay the vendors immediately and then you
pay out the balance owing to them at the end of the month, i.e. the account
balance is negative the majority of the time, then they are functioning more as
a credit provider and a Liability account is a more appropriate way to treat the
account.

I chose to treat my Paypal account as a liability account, more for historical
reasons than the current use of the account, but I could equally have treated it
as an asset account for my purposes ( All that does is reverse the debit and
credit entries to the relevant accounts), as I indicate in my reply to Michael.
The function for me is primarily to make reconciliation and matching to receipts
simpler.

You wouldn't necessarily need to raise an invoice to cover a payment to PayPal
just as you wouldn't when you pay off your credit card with a bank. 

The main purpose of Customers and Vendors and the business features around them
is to avoid having to maintain individual accounts receivable and accounts
payable accounts for each customer or vendor you interact with and to provide
the information to manage the credit that is extended to you by vendors and the
credit you extend to your customers and the effect it has on cash flow.

Hope this clarifies things a bit.

David


 

On Sat, 2022-12-10 at 18:25 +, Dr. David Kirkby wrote:
> On Sat, 10 Dec 2022 at 17:09, Chris Skudder  wrote:
> 
> >    When you BUY something using paypal, the SELLER pays their fees, not
> >    you.
> >    So recording a purchase for which you paid using paypal is no different
> >    than any other purchase:
> >    Debit: expense (or asset, if you're buying something that you'll
> >    recognize as an asset on your balance sheet)
> >    Credit: your paypal asset account if you carry a balance in it; or
> >    credit a credit card account if your paypal purchases pull money
> >    directly from a credit card.
> >    Chris
> > 
> 
> I'm intending to use the Vendors and Customers under the Business menu. Do
> I need to make two totally separate transactions (one bill, one invoice) to
> fund the PayPal account from the bank account, and the other for PayPal to
> pay the vendor? In which case, does PayPal need to be entered as a vendor
> so I can pay PayPal?
> 
> Sorry, I'm really confused, and it seems multiple people have different
> ways of doing this - most not using the Customer/Vendor facility.
> 
> Dave
> ___
> 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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Dr. David Kirkby
On Sat, 10 Dec 2022 at 17:09, Chris Skudder  wrote:

>When you BUY something using paypal, the SELLER pays their fees, not
>you.
>So recording a purchase for which you paid using paypal is no different
>than any other purchase:
>Debit: expense (or asset, if you're buying something that you'll
>recognize as an asset on your balance sheet)
>Credit: your paypal asset account if you carry a balance in it; or
>credit a credit card account if your paypal purchases pull money
>directly from a credit card.
>Chris
>

I'm intending to use the Vendors and Customers under the Business menu. Do
I need to make two totally separate transactions (one bill, one invoice) to
fund the PayPal account from the bank account, and the other for PayPal to
pay the vendor? In which case, does PayPal need to be entered as a vendor
so I can pay PayPal?

Sorry, I'm really confused, and it seems multiple people have different
ways of doing this - most not using the Customer/Vendor facility.

Dave
___
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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Chris Skudder
   When you BUY something using paypal, the SELLER pays their fees, not
   you.
   So recording a purchase for which you paid using paypal is no different
   than any other purchase:
   Debit: expense (or asset, if you're buying something that you'll
   recognize as an asset on your balance sheet)
   Credit: your paypal asset account if you carry a balance in it; or
   credit a credit card account if your paypal purchases pull money
   directly from a credit card.
   Chris
 __

   From: [1]gnucash-user-requ...@gnucash.org
   Sent: Saturday, December 10, 2022, 12:00 PM
   To: [2]gnucash-user@gnucash.org
   Subject: gnucash-user Digest, Vol 237, Issue 31

Message: 2
Date: Sat, 10 Dec 2022 14:50:05 +
From: "Dr. David Kirkby" [3]
To: [4]stepbystepf...@comcast.net
Cc: [5]gnucash-user@gnucash.org
Subject: Re: [GNC] Buying with PayPal - how do I split the
transaction?
Message-ID:
[6]
Content-Type: text/plain; charset="UTF-8"

On Sat, 10 Dec 2022 at 01:19, Michael or Penny Novack <
[7]stepbystepf...@comcast.net> wrote:


On 12/9/2022 7:01 PM, David Cousens wrote:

However, I do NOT understand why you were treating your Paypal account
as a liability. AFAIK, Paypal does not offer credit.

PayPal do offer credit

[8]https://www.paypal.com/uk/webapps/mpp/paypal-virtual-credit

although I consider the PayPal account an asset. It's much like a bank
account - money goes in and out. It's a bit more complicated though, as
often transactions involve another currency.

Selling things with PayPal obviously adds another bit of complexity as
there are fees then, but for now I just want to sort out how to record
purchases - I will worry about sales later.

Michael D Novack

Dave

References

   1. mailto:gnucash-user-requ...@gnucash.org
   2. mailto:gnucash-user@gnucash.org
   3. mailto:drkir...@kirkbymicrowave.co.uk
   4. mailto:stepbystepf...@comcast.net
   5. mailto:gnucash-user@gnucash.org
   6. mailto:canx10hafdo7ipn4xzyvmghsaa250yk4vofbcxr5jx4a-gt3...@mail.gmail.com
   7. mailto:stepbystepf...@comcast.net
   8. https://www.paypal.com/uk/webapps/mpp/paypal-virtual-credit
___
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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Dr. David Kirkby
On Sat, 10 Dec 2022 at 00:01, David Cousens 
wrote:

> David
>
> I treat my Paypal account as a Liability account,


As I wrote earlier, I treat mine as an Asset.

To use the business features, so you have the vendor record, I would have a
> separate PayPal Liability account. On purchase record the bill to  credit
> Accounts payable and debit the appropriate expense account as normal. To
> record
> PayPal paying the vendor, debit the Accounts Payable and credit the Paypal
> Liability, essential make a payment from the Paypal Liability account.  I
> don't
> know if the account checking on the business features payment process will
> prevent this or not.
>
> Then to record the transfer of funds from your bank account to Paypal
> credit the
> bank account and debit the Paypal liability account.
>

Thank you for the suggestion. I tried that, by creating

Liabilities -> Accounts Payable -> PayPal (GBP)

Then I created a billl, and posted it to that account. However, when I paid
the bill from my bank account, there's no record of the transaction in
Assets -> PayPal (GBP) account. The only record of the transaction is in
the bank account. All I have achieved is creating another Accounts Payable
account, with a different name. There's no connection whatsoever between
that and the PayPal account.

I must be doing something wrong.


> David Cousens
>

Dave
___
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] URGENT: Fake gnucash website with fake download, most likely compromised file

2022-12-10 Thread Dr. David Kirkby
I'm not seeing it in the UK. But when I did a lookup of the domain using

https://www.namesilo.com/

one gets some limited information. It looks like it was registered in
Germany in October 2022. I changed the domain name to BAD.org to stop
search engines finding it in my post. I don't know if there's any point in
emailing compliance_ab...@webnic.cc to report this. I suspect it is.

Domain Name: BAD.org
Registry Domain ID: 9a42474dfe5d4a8e9e50e0c56e101812-LROR
Registrar WHOIS Server: https://iwhois.webnic.cc
Registrar URL: https://www.webnic.cc/
Updated Date: 2022-10-25T22:39:36Z
Creation Date: 2022-10-20T22:39:13Z
Registry Expiry Date: 2023-10-20T22:39:13Z
Registrar: Web Commerce Communications Limited dba WebNic.cc
Registrar IANA ID: 460
Registrar Abuse Contact Email: compliance_ab...@webnic.cc
Registrar Abuse Contact Phone: +603.89966799
Domain Status: clientDeleteProhibited
https://icann.org/epp#clientDeleteProhibited
Domain Status: clientTransferProhibited
https://icann.org/epp#clientTransferProhibited
Domain Status: clientUpdateProhibited
https://icann.org/epp#clientUpdateProhibited
Registry Registrant ID: REDACTED FOR PRIVACY
Registrant Name: REDACTED FOR PRIVACY
Registrant Organization: unknown
Registrant Street: REDACTED FOR PRIVACY
Registrant City: REDACTED FOR PRIVACY
Registrant State/Province: Berlin
Registrant Postal Code: REDACTED FOR PRIVACY
Registrant Country: DE

Dr David Kirkby Ph.D
Email: drkir...@kirkbymicrowave.co.uk Web:
https://www.kirkbymicrowave.co.uk/
Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.





On Fri, 9 Dec 2022 at 23:24, Vincent Dawans  wrote:

> I just typed gnucash in google and the first hit was an ad pointing to
> gnu-cash.org (with a dash). It is a fake site that is a carbon copy of the
> official site but the download link goes to a setup.exe that is most likely
> a corrupted virus file.
>
> We need this removed ASAP. There is an option in google to report the site
> and mark it as spam/phishing. I imagine if more people do this it will get
> removed faster hopefully.
> ___
> 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] Buying with PayPal - how do I split the transaction?

2022-12-10 Thread Dr. David Kirkby
On Sat, 10 Dec 2022 at 01:19, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 12/9/2022 7:01 PM, David Cousens wrote:
>
> However, I do NOT understand why you were treating your Paypal account
> as a liability. AFAIK, Paypal does not offer credit.


PayPal do offer credit

https://www.paypal.com/uk/webapps/mpp/paypal-virtual-credit

although I consider the PayPal account an asset. It's much like a bank
account - money goes in and out. It's a bit more complicated though, as
often transactions involve another currency.

Selling things with PayPal obviously adds another bit of complexity as
there are fees then, but for now I just want to sort out how to record
purchases - I will worry about sales later.

Michael D Novack
>

Dave
___
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] Overflow menus in invoices/bills not working in latest release on MacOS Ventura

2022-12-10 Thread R. Victor Klassen
Adrian has it right.  I’m going to restart and see if it’s transitory.  

Sent from my iPhone

> On Dec 10, 2022, at 1:07 AM, Adrien Monteleone 
>  wrote:
> 
> John,
> 
> It sounds like Victor is describing the ToolBar overflow 'menu'.
> 
> I can get this menu when I narrow my window width such that icons would be 
> 'off window' to the right.
> 
> But I can't reproduce the behavior described. My overflow entries appear to 
> work properly. (4.12 on Monterey)
> 
> Regards,
> Adrien
> 
>> On 12/9/22 10:05 PM, john wrote:
>> Um, on macOS there aren't supposed to be menus on the window, they go on the 
>> menubar at the top of the screen. If it's too wide macOS is supposed to make 
>> room for it by hiding  as many of the "menubar extra" icons on the right 
>> side.
>> So is there somewhere that I've missed setting up the integration to put the 
>> menus on the menubar or are you using a self-built GnuCash?
> 
> ___
> 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] Installing or updating Finance::Quote

2022-12-10 Thread Murugan Muruganandam
hi Alan

best way is what Geoff advised. Try re installing the finance quote.  make sure 
you see the folder and sub folder called quotes under finance

please check if the alphavantage key is updated.




[cid:317807f5-d37d-4aa6-9461-a7a8a6c6fc13]


Saludos Cordiales


Murugan


From: aeg 
Sent: Saturday, December 10, 2022 5:59 AM
To: gnucash-user@gnucash.org ; Geoff 

Cc: Murugan Muruganandam 
Subject: Re: [GNC] Installing or updating Finance::Quote

Hi Geoff,

Thank you for your input.
Following advice from Murugan, I created a Finance folder at the correct 
location and put a copy of the latest version of quote.pm into it.

When I now run perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update", this is 
what I see in cmd:

C:\WINDOWS\system32>perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update"
Database was generated on Sat, 10 Dec 2022 08:13:54 GMT
Test2 is up to date (1.302191).
Date::Manip is up to date (6.90).
Finance::Quote is up to date (1.5301).

C:\WINDOWS\system32>



This looked promising, so I then ran "Install Online Price Retrieval for 
Gnucash" from the Start menu again, and this was the result:

* Check Perl
* Check Perl version
* Install required perl modules
Database was generated on Sat, 10 Dec 2022 08:13:54 GMT
Test2 is up to date (1.302191).
Date::Manip is up to date (6.90).
Finance::Quote is up to date (1.5301).

* Check environment variable ALPHAVANTAGE_API_KEY

  ***
  *** You need an API key (from https://www.alphavantage.co)
  ***   to run the Perl module Finance::Quote.
  ***
  *** Make it available to GnuCash by
  ***- setting the environment variable ALPHAVANTAGE_API_KEY or
  ***- starting GnuCash and adding the Alpha Vantage api key in
  ***Edit->Preferences->Online Quotes
  ***

* Run gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

An error occurred, see above.




It appears that these two are returning conflicting reports, so I'm now 
wondering whether I should uninstall Strawberry perl again and reinstall it, 
but I'm also wondering why it didn't fully install in the first place.

Regards,
Alan



On Friday, 9 December 2022 at 23:26:12 GMT, Geoff  
wrote:


Hi Alan

It looks like the install has failed for some reason as the modules
should be under: C:\Strawberry\perl\site\lib\Finance\

The entries under "perl\vendor" are not related to Finance::Quote and
are irrelevant.

I suggest that you try to install it again.  The installation can be a
bit fiddly as there are a number of dependencies, and some modules take
a while.

You can do this with the GnuCash installer.  Open a command prompt as
administrator and type:-
perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update

Or directly by downloading from here:-
https://metacpan.org/pod/Finance::Quote


Good luck!

Regards

Geoff
=



On 10/12/2022 6:01 am, aeg via gnucash-user wrote:
>  Murugan,
>
> Thank you for your suggestion.There is no folder named "Finance" at that 
> location, but I searched for quote.pm within Strawberry and found it at each 
> of these 
> locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance 
> (version 1.5301)
>  C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301)
> C:\Strawberry\perl\vendor\lib\Sub (version 2.006006)
> C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270)
>
> I don't know whether that helps to clarify the problem.
> Regards,Alan
>
>  On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam 
> mailto:m.muruganan...@hotmail.com>> wrote:
>
>  Alan
> Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the 
> version. if it is not 1.52, you may need to download and replace the file
> Saludos Cordiales
> Murugan
>
> From: gnucash-user 
> mailto:hotmail@gnucash.org>>
>  on behalf of aeg via gnucash-user 
> mailto:gnucash-user@gnucash.org>>
> Sent: Friday, December 9, 2022 2:40 PM
> To: gnucash-user@gnucash.org 
> mailto:gnucash-user@gnucash.org>>
> Subject: [GNC] Installing or updating Finance::Quote I've started this thread 
> separately from "[GNC] getting price quotes" (from which I gained helpful 
> advice last week), as it's a more specific problem I now face.
> Following the advice from David H and others last week, I eventually decided 
> to upgrade from GC version 3.5 to 4.12, in the hope that it would 
> automatically install the latest version of Finance::Quote and enable me to 
> resume downloading stock prices again. I'm using Windows 10 and the 
> previously installed version of F::Q was 1.47, which had worked without 
> problems until the first week of November.
> The upgrade to GC v4.12 turned out to be more straightforward than I'd 
> previously feared, but I then found that F::Q was still on 1.47, and attempts 
> to update or run "Install OnlinePrice Retrieval for Gnucash" from 

Re: [GNC] Installing or updating Finance::Quote

2022-12-10 Thread aeg via gnucash-user
 Hi Geoff,
Thank you for your input.Following advice from Murugan, I created a Finance 
folder at the correct location and put a copy of the latest version of quote.pm 
into it.
When I now run perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update", this is 
what I see in cmd:
C:\WINDOWS\system32>perl "C:\Program Files 
(x86)\gnucash\bin\gnc-fq-update"Database was generated on Sat, 10 Dec 2022 
08:13:54 GMTTest2 is up to date (1.302191).Date::Manip is up to date 
(6.90).Finance::Quote is up to date (1.5301).
C:\WINDOWS\system32>


This looked promising, so I then ran "Install Online Price Retrieval for 
Gnucash" from the Start menu again, and this was the result:
* Check Perl* Check Perl version* Install required perl modulesDatabase was 
generated on Sat, 10 Dec 2022 08:13:54 GMTTest2 is up to date 
(1.302191).Date::Manip is up to date (6.90).Finance::Quote is up to date 
(1.5301).
* Check environment variable ALPHAVANTAGE_API_KEY
  ***  *** You need an API key (from https://www.alphavantage.co)  ***   to run 
the Perl module Finance::Quote.  ***  *** Make it available to GnuCash by  ***  
  - setting the environment variable ALPHAVANTAGE_API_KEY or  ***    - starting 
GnuCash and adding the Alpha Vantage api key in  ***        
Edit->Preferences->Online Quotes  ***
* Run gnc-fq-check
You need to install the following Perl modules:  Finance::Quote
Use your system's package manager to install them,or run 'gnc-fq-update' as 
root.missing-lib
An error occurred, see above.



It appears that these two are returning conflicting reports, so I'm now 
wondering whether I should uninstall Strawberry perl again and reinstall it, 
but I'm also wondering why it didn't fully install in the first place.
Regards,Alan


On Friday, 9 December 2022 at 23:26:12 GMT, Geoff 
 wrote:  
 
 Hi Alan

It looks like the install has failed for some reason as the modules 
should be under: C:\Strawberry\perl\site\lib\Finance\

The entries under "perl\vendor" are not related to Finance::Quote and 
are irrelevant.

I suggest that you try to install it again.  The installation can be a 
bit fiddly as there are a number of dependencies, and some modules take 
a while.

You can do this with the GnuCash installer.  Open a command prompt as 
administrator and type:-
perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update

Or directly by downloading from here:-
https://metacpan.org/pod/Finance::Quote


Good luck!

Regards

Geoff
=



On 10/12/2022 6:01 am, aeg via gnucash-user wrote:
>  Murugan,
> 
> Thank you for your suggestion.There is no folder named "Finance" at that 
> location, but I searched for quote.pm within Strawberry and found it at each 
> of these 
> locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance 
> (version 1.5301)
>  C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301)
> C:\Strawberry\perl\vendor\lib\Sub (version 2.006006)
> C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270)
> 
> I don't know whether that helps to clarify the problem.
> Regards,Alan
> 
>      On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam 
> wrote:
>  
>  Alan
> Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the 
> version. if it is not 1.52, you may need to download and replace the file
> Saludos Cordiales
> Murugan
> 
> From: gnucash-user 
>  on behalf of 
> aeg via gnucash-user 
> Sent: Friday, December 9, 2022 2:40 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Installing or updating Finance::Quote I've started this thread 
> separately from "[GNC] getting price quotes" (from which I gained helpful 
> advice last week), as it's a more specific problem I now face.
> Following the advice from David H and others last week, I eventually decided 
> to upgrade from GC version 3.5 to 4.12, in the hope that it would 
> automatically install the latest version of Finance::Quote and enable me to 
> resume downloading stock prices again. I'm using Windows 10 and the 
> previously installed version of F::Q was 1.47, which had worked without 
> problems until the first week of November.
> The upgrade to GC v4.12 turned out to be more straightforward than I'd 
> previously feared, but I then found that F::Q was still on 1.47, and attempts 
> to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start 
> menu have been unsuccessful, so I'm hoping someone can point me in the 
> direction of a solution.
> I should add that, prior to the GC update, I installed the latest version of 
> Strawberry Perl (v5.32.1), after first removing the previous version 
> (v5.18.2).
> Regards,Alan
> 
> 
> 
> ___
> 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.
>    
> __