Re: [GNC] Fetch rate crashing gnucash

2022-08-15 Thread Samantha Payn
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

2022-08-15 Thread Samantha Payn
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

[GNC] Fetch rate crashing gnucash

2022-08-15 Thread Samantha Payn
"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

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

2021-08-07 Thread Samantha Payn
d to enter 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

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

2021-08-06 Thread Samantha Payn
only guessing >>> 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 ? >>> >>> Che

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

2021-08-06 Thread Samantha Payn
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

Re: [GNC] Creating a customer report by location

2021-08-06 Thread Samantha Payn
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

2021-08-06 Thread Samantha Payn
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

2021-08-05 Thread Samantha Payn
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

2021-01-27 Thread Samantha Payn
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 ver

[GNC] Version 4.3 update

2021-01-27 Thread Samantha Payn
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

2021-01-15 Thread Samantha Payn
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.u

Re: [GNC] bulk operations?

2020-12-07 Thread Samantha Payn
exchange 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 d

Re: [GNC] bulk operations?

2020-12-07 Thread Samantha Payn
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 to

Re: [GNC] bulk operations?

2020-12-07 Thread Samantha Payn
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 short

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

2020-08-26 Thread Samantha Payn
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

2020-08-26 Thread Samantha Payn
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

2020-08-26 Thread Samantha Payn
d - 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

2020-08-25 Thread Samantha Payn
xplaining 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

2020-08-25 Thread Samantha Payn
quot; "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' echo '(currency "GBP" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' I have attached a screenshot of the same commands on my Wi

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
e odd if gnc-fq-dump works and this doesn't: $Env:ALPHAVANTAGE_API_KEY = 'xxx' '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper Should produce something like (("USD" (symbol . "

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
t; "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 . "GBP"))) Regards,

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

2020-08-24 Thread Samantha Payn
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

2020-08-17 Thread Samantha Payn
gnucash.trace.VEQEP0.log (That's the file name from last time, you'll replace VEQEP0 with whatever is in the latest 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...@boorertran

Re: [GNC] Difficulty with online price retrieval

2020-08-15 Thread Samantha Payn
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

2020-08-12 Thread Samantha Payn
tarting 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, Sa

Re: [GNC] Difficulty with online price retrieval

2020-08-11 Thread Samantha Payn
on. Was 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.V

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread Samantha Payn
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

2020-08-10 Thread Samantha Payn
name from your listing) Get-Content $Env:USERPROFILE\AppData\Local\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 brou

Re: [GNC] Difficulty with online price retrieval

2020-08-08 Thread Samantha Payn
020 20:08 John Ralls < [1]jra...@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 pati

Re: [GNC] Difficulty with online price retrieval

2020-08-07 Thread Samantha Payn
t with a space. To set an environment 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...@b

Re: [GNC] Difficulty with online price retrieval

2020-08-05 Thread Samantha Payn
ill fill in the (x86)\' 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)\gnuca

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

2020-08-04 Thread Samantha Payn
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

2020-07-27 Thread Samantha Payn
errors in red on black, variables 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 yo

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread Samantha Payn
e is a Poweshell, please 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...@boorertranslatio

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread Samantha Payn
ason for a system error 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

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread Samantha Payn
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

2020-07-24 Thread Samantha Payn
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 c

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

2020-07-21 Thread Samantha Payn
enter prices manually 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 h

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

2020-07-16 Thread Samantha Payn
ning 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...@gn

[GNC] Difficulty with online price retrieval

2020-07-15 Thread Samantha Payn
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 menu

Re: [GNC] Accessing online currency rates

2020-07-04 Thread Samantha Payn
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 remem

[GNC] Accessing online currency rates

2020-07-02 Thread Samantha Payn
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

2020-04-05 Thread Samantha Payn
irm an exchange 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

Re: [GNC] Batch posting of foreign currency invoices

2020-04-04 Thread Samantha Payn
8, Samantha 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

[GNC] Batch posting of foreign currency invoices

2020-04-02 Thread Samantha Payn
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

2018-07-23 Thread Samantha Payn
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. However

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

2018-07-23 Thread Samantha Payn
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

2018-04-23 Thread Samantha Payn
Thank you! > On 23 April 2018 at 15:11 John Ralls wrote: > > > > > > On Apr 23, 2018, at 5:40 AM, Samantha Payn wrote: > > > > I am running GNUcash 3 on Windows 10. seem to have done something to > > corrupt my experiment

[GNC] Crash on start up

2018-04-23 Thread Samantha Payn
[qof_print_date_buff()] Error processing time64 527765583310712933: Time value is outside the supported year range. * 07:42:10 WARN invalid cast from '(NULL)' to 'QofInstance'" After that all the trace files say the sam

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

2018-04-15 Thread Samantha Payn
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