Re: [GNC] Fetch rate crashing gnucash

Thank you, Frank! --- Samantha Payn On 2022-08-15 16:32, Frank H. Ellenberger wrote: Hi Samantha, usually Bruce sends teh announcement to the list. The last has been https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101772.html Regards Frank Am 15.08.22 um 17:24 schrieb Samantha

Re: [GNC] Fetch rate crashing gnucash

Thanks Frank! I only joined the list just now so didn't see John's earlier post. Will the fix be flagged here, do you know? --- Samantha Payn On 2022-08-15 16:21, Frank H. Ellenberger wrote: Hello Samantha, John mentioned already this morning the by alphavantage broken online update

[GNC] Fetch rate crashing gnucash

;test" lines said "skipped", but I don't really know what I'm doing. And I'm still having the same problem. Very grateful for any assistance you can offer! -- Samantha Payn ___ gnucash-user mailing list gnucash-user@gnucash.org To upda

Re: [GNC] Fwd: Re: Creating a customer report by location

the right region when building the invoice instead of having it automated. -derek Sent using my mobile device. Please excuse any typos. On August 6, 2021 5:44:19 PM Samantha Payn wrote: As there are comprehensive address fields for the customer database it would be wonderful

Re: [GNC] Fwd: Re: Creating a customer report by location

gt;> here but can you setup your customers or Sales in a heirarchy - i.e >>> Customers, Customers UK, Customers Local, Customers Non UK OR Sales, >> Sales >>> UK, Sales Local, Sales Non UK and report on them that way ? >>> >>> Cheers David H. >>

[GNC] Fwd: Re: Creating a customer report by location

Sorry, I replied to Derek only and I meant to include the list. Here is my response to Derek's question. -- Original Message -- From: Samantha Payn To: Derek Atkins Date: 06/08/2021 16:26 Subject: Re: [GNC] Creating a customer report by location I

Re: [GNC] Creating a customer report by location

t. You would > have to somehow manually add appropriate information in a text field, but > reports generally only have rudimentary sorting on text fields, so maybe at > best you could come up with a manually implemented zip code scheme. > > Short answer, no. > >>

Re: [GNC] Creating a customer report by location

Is this not possible, or has this request slipped through unnoticed? Cheers On 05/08/2021 14:26 Samantha Payn <[1]saman...@boorertranslations.com> wrote: Can anyone tell me how to set up a report on income by customer location, please? Many thanks Samanth

[GNC] Creating a customer report by location

Can anyone tell me how to set up a report on income by customer location, please? Many thanks Samantha Payn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https

Re: [GNC] Version 4.3 update

Have just found the .exe of version 4.4 online. Sorry to have troubled you all :) Thank you! On 27/01/2021 15:17 Samantha Payn <[1]saman...@boorertranslations.com> wrote: Hello, I'm just catching up with updates. Is there a reason why the update to versi

[GNC] Version 4.3 update

Hello, I'm just catching up with updates. Is there a reason why the update to version 4.3 is "gnucash-4.3.tar.bz2"? All my previous updates were just .exe files. Or can you please advise what I need to unzip a file like this. Many thanks Samantha

Re: [GNC] UK specific: MTD - Making Tax Digital

If this is relevant to someone running a small business in the UK then I'm interested. -- Samantha Payn [1]www.boorertranslations.com http://www.proz.com/profile/947767 [2]https://uk.linkedin.com/in/samanthapayn On 15/01/2021 11:19 Alain D D Williams <[3]a...@phcomp.co.uk>

Re: [GNC] bulk operations?

nge rate - and IIUC you are encouraged >to use >https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly > >On Mon, 7 Dec 2020 at 22:47, Samantha Payn >wrote: > >> >> Thanks for the suggestion, Adrien. I’ve got entering the invoice data i

Re: [GNC] bulk operations?

an invoice which is the time consuming point. Samantha Payn > On 7 Dec 2020, at 22:25, Adrien Monteleone > wrote: > > Samantha, you can import invoice data. > > Thus, if you have a way to easily create that data in a spreadsheet, you can > save it as CSV, then import them

Re: [GNC] bulk operations?

” for all the others, but that’s still three clicks per invoice (I think). Please could Santa bring me a “batch post invoice” function for Christmas? Samantha PAYN Mob: +44 7977 150053 > On 7 Dec 2020, at 22:01, Weiwu Zhang wrote: > > This issue comes up regularly with new users. The sho

Re: [GNC] New User - can't modify inoice notes.

I have modified and saved the invoice format to suit my requirements as a Saved Report. Unfortunately when I upgrade to the newest version of Gnucash it loses all my saved reports. How can I prevent this happening in future, please? Samantha > On 26 Aug 2020, at 21:17, Derek Atkins wrote: >

Re: [GNC] Difficulty with online price retrieval

PI_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter a problem trying to enter my API key at the CMD prompt. Way (way!) back John gave me two routes to start investigating the problem and t

Re: [GNC] Difficulty with online price retrieval

ommand - it should show you your key: echo %ALPHAVANTAGE_API_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter a problem trying to enter my API key at the CMD prompt. Way (way!) back John gave

Re: [GNC] Difficulty with online price retrieval

Explaining how to fix this will take a bit of effort, and as it is now bedtime in my part of the world, I will try to knock up some instructions for you tomorrow. Stay tuned. Geoff = On 25/08/2020 9:24 pm, Samantha Payn wrote: Hi Geoff Thanks for your suggestoins. Th

Re: [GNC] Difficulty with online price retrieval

; "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' I have attached a screenshot of the same commands on my Windows 10 PC. Fingers crossed they work on yours! Thanks for your patience. Geoff = On 25/08/2020 8:44 pm, Samantha Payn wrote:

Re: [GNC] Difficulty with online price retrieval

TAGE_API_KEY = 'xxx' '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper Should produce something like (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") (last . #e0.7658) (currency

Re: [GNC] Difficulty with online price retrieval

Should produce something like (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") (last . #e0.7658) (currency . "GBP"))) Regards, John Ralls On Aug 24, 2020, at 3:16 AM, Samantha Payn < [2]saman...@boorertranslation

[GNC] Fwd: Re: Difficulty with online price retrieval

Dear John and list I think this response of mine from a week ago must have fallen through the net? Any assistance gratefully received Samantha Payn -- Original Message -- From: Samantha Payn To: John Ralls CC: Gnucash Users Date: 17 August

Re: [GNC] Difficulty with online price retrieval

st file's name.) And copy and paste them into a reply. Regards, John Ralls On Aug 15, 2020, at 6:42 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: I am sorry John, do what? I am afraid I just do not understand "Please run from the PowerShell command li

Re: [GNC] Difficulty with online price retrieval

n Aug 12, 2020, at 6:54 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which returns the error message. I only use Gnucash for my business accounts and have no need of the "Get Q

Re: [GNC] Difficulty with online price retrieval

ng from an account denominated in, say, EUR.) Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file. Regards, John Ralls On Aug 11, 2020, at 5:00 AM, Samanth

Re: [GNC] Difficulty with online price retrieval

as it enabled? Regards, John Ralls On Aug 10, 2020, at 12:06 PM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Hi John I did what you suggest and this is what I got: PS C:\Users\User> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0

Re: [GNC] Difficulty with online price retrieval

t; [1]jra...@ceridwen.us> wrote: On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger < [2]frank.h.ellenber...@gmail.com> wrote: Samanta, Am 10.08.20 um 12:53 schrieb Samantha Payn: But you lost me at the next bit. PS C:\Users\User> Get-ChildItem -Path $Env:USERPROFI

Re: [GNC] Difficulty with online price retrieval

cal\Temp\gnucash.trace.RSHPO0.log Regards, John Ralls On Aug 8, 2020, at 6:00 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, thank you for these corrections. In Powershell they brought results as below: PS C:\Users\User> cd "C:\Program

Re: [GNC] Difficulty with online price retrieval

ra...@ceridwen.us> wrote: Samantha, Pardon the inlining: On Aug 7, 2020, at 6:00 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, I appreciate why you wish to keep this on list and so thank you and everyone for your patience while I stumble throu

Re: [GNC] Difficulty with online price retrieval

variable in CMD you do SET ALPHAVANTAGE_API_KEY making the obvious substitution. No quotes are needed, and the angle braces are part of the substitution. Regards, John Ralls On Aug 5, 2020, at 2:17 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Hi

Re: [GNC] Difficulty with online price retrieval

)\' for you. Regards, John Ralls On Jul 27, 2020, at 12:01 PM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Sorry John (and everyone). I can't get it to accept (x86) now: C:\Users\User> cd C:\Program Files (x86)\gnucash\bin x86 : The term 'x86

Re: [GNC] Bravo! 4.x type-ahead search enhancement

Wow! Sounds brilliant! Samantha Payn > On 4 Aug 2020, at 21:03, Jeff Albrecht wrote: > > Thank you GNU developers! > > This feature is saving me so much time in my workflow. > > "New type-ahead search added to sequential search when selecting an account > in th

Re: [GNC] Difficulty with online price retrieval

bles and special values (e.g. $true, $false) in green, and command names in yellow. Regards, John Ralls On Jul 27, 2020, at 2:30 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Hi John I am sorry to have to come back to you for more support on this and

Re: [GNC] Difficulty with online price retrieval

excuse my hasty typing. Since you use only those 3 currencies try all three combinations, i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. Regards, John Ralls On Jul 25, 2020, at 10:27 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Joh

Re: [GNC] Difficulty with online price retrieval

ror message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls On Jul 25, 2020, at 5:2

Re: [GNC] Difficulty with online price retrieval

to do now? Very many thanks! Samantha On 24 July 2020 21:12 John Ralls < [1]jra...@ceridwen.us> wrote: On Jul 24, 2020, at 4:33 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Sorry to repeat myself but can anyone help me or shall I have to rely on m

Re: [GNC] Difficulty with online price retrieval

Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently computer literate to

Re: [GNC] Difficulty with online price retrieval (John Ralls)

ly as a temporary measure until you get online quotes working properly. Regards, John Ralls On Jul 16, 2020, at 5:08 AM, Samantha Payn < [3]saman...@boorertranslations.com> wrote: Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation an

[GNC] Difficulty with online price retrieval (John Ralls)

to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. -- Samantha Payn On 16 July 2020 11:38 [1]gnucash-user-requ...@gnucash

[GNC] Difficulty with online price retrieval

I did post this question before but am still having the same problem. I have successfully used Gnucash for a couple of years for multicurrency invoice processing using the Strawberry perl plug in (by clicking on Install online price retrieval in the Gnucash section of the start

Re: [GNC] Accessing online currency rates

Thanks for your interest and suggestion. Yes, I did that (it installs the strawberry perl program, I think?). But still no joy. -- Samantha Payn Tel: 01852 300723 Mob: 07977 150053 On 3 July 2020 00:14 John Ralls < [1]jra...@ceridwen.us> wrote: Did you re

[GNC] Accessing online currency rates

I have had to change computers and have installed my existing Gnucash set-up (in which I could access online currency rates using the "fetch rate" button) on my new computer but I cannot now access online currency rates. I have installed Strawberry Perl, and added my API key at the

Re: [GNC] Batch posting of foreign currency invoices

rate once per currency per run. Regards, Adrien On Apr 4, 2020 w14d95, at 9:09 AM, Samantha Payn < [11]saman...@boorertranslations.com> wrote: Hi Rob No, I'm not referring to importing bills. I issue invoices in various currencies. If I am issuing a number of invoi

Re: [GNC] Batch posting of foreign currency invoices

mantha Payn < [2]saman...@boorertranslations.com> wrote: Is it possible to batch post foreign currency invoices instead of having to review and confirm the exchange rate for each invoice? Thanks for any guidance you can give. -- Samantha Payn Tel: 01852 300723 Mob:

[GNC] Batch posting of foreign currency invoices

Is it possible to batch post foreign currency invoices instead of having to review and confirm the exchange rate for each invoice? Thanks for any guidance you can give. -- Samantha Payn Tel: 01852 300723 Mob: 07977 150053

Re: [GNC] Finance::Quote still not working with alphavantage

received. -- Samantha On 23 July 2018 at 16:24 "Maf. King" wrote: On Monday, 23 July 2018 15:55:01 BST Samantha Payn wrote: Hello all! I see the thread about online currency quotes not working in the mailing list archive and the helpful replies. Ho

[GNC] Finance::Quote still not working with alphavantage

spell it out to me in words of one syllable please? Very many thanks :) -- Samantha Payn Tel: 01770 820655 Mob: 07977 150053 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] Crash on start up

Thank you! > On 23 April 2018 at 15:11 John Ralls <jra...@ceridwen.us> wrote: > > > > > > On Apr 23, 2018, at 5:40 AM, Samantha Payn <saman...@boorertranslations.com> wrote: > > > > I am running GNUcash 3 on Windows 10. see

[GNC] "Unable to retrieve quotes for these items: CURRENCY:USD"

UR which I have set up in the same way as a currency. Can anyone help, please? -- Samantha Payn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailma