Re: Could not obtain the lock

2017-11-20 Thread Maf. King 
Hi Moira,

What about the folder that the GC data file is in - is that read-only?  can you 
create a file in that folder using some other program, say notepad or word?

Don't know how windows manages username permissions - I know that some files 
can only be touched by an administrator.  You didn't specify windows in your 
OP, it would certainly be possible on linux that the new user ID would not 
have permissions to the files of an old ID...

Maf.


On Tuesday, 21 November 2017 02:49:30 GMT you wrote:
> No, the files are not "Read-Only".
> 
> My username for Windows??? Yes, it is different on the new computer. Does
> that matter?
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Two different sets of accounts

2017-11-20 Thread Jean-David Beyer 
On 11/20/2017 09:47 AM, Mike or Penny Novack wrote:
> Guncash, opening in its default mode, will always open the last file you
> had opened.
> a) You can "tell" gnucash not to do this, but instead open "nofile" and
> then you have to choose which file you want to open (there is even a
> drop down list for the last several you had open). That is what those of
> us who are using gnucash to keep several sets of books usually choose to
> do << there is no reason for us to expect that the books we want are the
> same as last open >>
> b) Even when gnucash has opened the "wrong" set of books (you have two)
> you can at that point tell it to open the other. See that "file" button
> on the top left? That will let you open another, either from the list OR
> by explicitly entering the name.

I have an additional solution, practical since I am the administrator of
this computer.

I have my own private accounts, and if I am logged into my machine as
me, if I run GnuCash, I get those.

I also am treasurer for a small non-profit outfit, and I gave that
outfit its own login. If I log in as that and run GnuCash, I get those.
Both are under /home, but otherwise separate.

I can also login as myself, do an su - nonprofitlogin
and then run Gnucash to access those other accounts. That way, I can
have both open at the same time, though I usually do not need to do that.

-- 
  .~.  Jean-David Beyer  Registered Linux User 85642.
  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
 /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
 ^^-^^ 21:10:01 up 6 days, 4:25, 2 users, load average: 4.14, 4.36, 4.46
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson 
I forgot to answer your second question.

There is a problem with mucking about in the underlying register view while
the import assistant is running, because if you accidentally touch one of
the new incoming transactions you trigger warning messages that you really
do not want to see.  If you can move the import window far enough out of
the way to see what you are doing and never touch any of the incoming
transactions, you can edit existing transactions, but never touch new
transactions even just to go by to the next transaction.  If you really do
want to experiment, be extra sure to save the file before starting the
import. I recommend saving first in every case.

David C

On Mon, Nov 20, 2017 at 6:57 PM, David Carlson 
wrote:

> AAK,
>
> Yes, that is the way Gnucash behaves when you select the Update +
> Reconcile option while matching transactions.  I rarely use that option for
> that very reason.  I mostly use the Reconcile option.
>
> I will get on my soapbox here, since I think that the word Reconcile is
> not used correctly in this context.  In this context the word Match fits
> better in my opinion.
>
> David C
>
> On Mon, Nov 20, 2017 at 8:03 AM, AAK  wrote:
>
>> I download transaction activity from my bank in a QFX format. When I match
>> them with pre-existing transaction and finalize the import process I see
>> that GC overrides the payee names i have in the register with the cryptic
>> names downloaded from the bank. Is there a way to prevent that?
>> Also, when there are new transactions to be added is there a way to edit
>> the
>> payee name and category from the transaction matcher window? Thanks in
>> advance.
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.
>> html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
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: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson 
AAK,

Yes, that is the way Gnucash behaves when you select the Update + Reconcile
option while matching transactions.  I rarely use that option for that very
reason.  I mostly use the Reconcile option.

I will get on my soapbox here, since I think that the word Reconcile is not
used correctly in this context.  In this context the word Match fits better
in my opinion.

David C

On Mon, Nov 20, 2017 at 8:03 AM, AAK  wrote:

> I download transaction activity from my bank in a QFX format. When I match
> them with pre-existing transaction and finalize the import process I see
> that GC overrides the payee names i have in the register with the cryptic
> names downloaded from the bank. Is there a way to prevent that?
> Also, when there are new transactions to be added is there a way to edit
> the
> payee name and category from the transaction matcher window? Thanks in
> advance.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

Reconciling Manually Downloaded Transactions

2017-11-20 Thread AAK 
I download transaction activity from my bank in a QFX format. When I match
them with pre-existing transaction and finalize the import process I see
that GC overrides the payee names i have in the register with the cryptic
names downloaded from the bank. Is there a way to prevent that?
Also, when there are new transactions to be added is there a way to edit the
payee name and category from the transaction matcher window? Thanks in
advance.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Check & Repair All

2017-11-20 Thread Geert Janssens 
Op zondag 19 november 2017 16:38:20 CET schreef John Ralls:
> > On Nov 19, 2017, at 6:34 AM, Fross, Michael  wrote:
> > 
> > Hello everyone,
> > 
> > I occasionally run Check & Repair all just to get a good feeling that
> > everything is in good running order.  Is this the right thing to do?  I've
> > never detected a problem and it has never provided any feedback of any
> > kind.
> > 
> > I thought I would see if I'm doing harm in any way and if this was a good,
> > bad, or unnecessary practice.
> 
> It’s harmless and generally unnecessary. The checks get run every time you
> start GnuCash or open a file.

I'm not sure this is true for all checks that get run by Check & Repair. I'd 
have to dig deeper into the code, but I can't remember for example the lot 
link cleanups run automatically during start up.

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: I applied payment to wrong customer

2017-11-20 Thread Tim Quinn 
Nelson, thanks for the response.

It turned out that this was an incorrect duplicate entry, so just the deletion 
part from your suggestion #1 was the solution.

In my case the payment was a check that I had logged in GC as depositing into 
my bank checking account, so (naturally) the bank checking account was the GC 
account from which I needed to delete the payment.

I am also am pretty sure that I had not yet applied the payment to any 
invoices. If there had been splits involving that payment I don’t know if 
things would have been so easy to clean up. I hope not to find out in the 
future.

Thanks again.

- Tim

> On Nov 17, 2017, at 8:21 PM, Nelson Handcock  
> wrote:
> 
> I think there's a couple of ways...
> 
> 1) Delete the payment from the account and re-enter it
> 
> or
> 
> 2) Find the payment in the account - then choose "Assign as payment" from the 
> context menu and select the correct customer.
> 
> Hope this helps!
> 
> 
> 
> 
> On Sat, Nov 18, 2017 at 10:40 AM, Tim Quinn  > wrote:
> Hi.
> 
> I looked but did not see (or recognize) this same question asked.
> 
> Using 2.6.18 I incorrectly processed a payment to the wrong customer.
> 
> Can I easily recover from this?
> 
> In my mind, I need to “unapply” the payment from the wrong customer and apply 
> it to the correct customer.
> 
> Any help, or pointers to this same question posed a different way, would be 
> welcomed.
> 
> Thanks.
> 
> - Tim
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> 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
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.

Error - possibly caused by incorrect F::Q update

2017-11-20 Thread Eric Coates 

Hi

First off: I would like to pay tribute to all those who have worked on 
GnuCash to provide a valuable tool and to those who have worked to 
circumvent the recent problems caused by Yahoo. To all of them, my thanks.



But I have a problem (probably caused by my own ignorance). I am running 
GnuCash 2.6.17 on Ubuntu 16.04. Like many others I found that 
Finance::Quote was failing. Following advice from this forum I updated 
F::Q to version 1.45 by running

sudo gnc-fq-update
but did not try to update any stock prices (I only do this once a 
month). Shortly afterwards it became apparent that F::Q 1.45 had some 
problems (no criticism intended) so I have not upgraded further. 
(Neither have I obtained a key from Alphavantage nor – obviously - added 
the key to the environment file.)


However, since doing the upgrade whenever I run the Ubuntu Backup 
utility from its GUI I get an error message that certain files cannot be 
accessed (and are therefore not backed up). The files are:


/home/eric/.cache/dconf

/home/eric/.dbus
/home/eric/.gnupg/pubring.gpg
/home/eric/.gnupg/pubring.gpg~
/home/eric/.gnupg/secring.gpg

I have checked and all these files are owned by root. I suspect that the 
cause is that I was in the wrong directory when I ran the fq-update – 
but what do I know?


This is not a big issue but it upsets my tiny tidy mind. Is there a way 
to correct any errors I caused? And, as the end of the month is 
approaching and I will need to upgrade to F::Q 1.47, will these errors 
interfere with that upgrade.


Thanks in advance


Eric
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Two different sets of accounts

2017-11-20 Thread Maf. King 
On Monday, 20 November 2017 01:33:11 GMT adamandeve club wrote:
> Hello, experts,
> I am Treasurer of two clubs. I have used Gnucash for both, but up to now I
> have had two different Macintosh computers, one for each club.
 Now I have
> traded my old computers for one fancy new MacBook Pro. My two sets of
> accounts are currently held on a USB stick for each. But even with the
> newest version of Gnucash (2.6.18-Intel) only the first set of accounts
> opens, the one that was initially opened on the new computer. No matter
> which account of the other set I double-click on, with Gnucash closed, the
> other set of accounts is opened. How can I keep both sets of accounts
> separately – and they cannot be put together, being totally different clubs
> with different financial dealings – using Gnucash? Thank you,
> John Nightingale,
> Secretary/Treasurer,
> Adam and Eve Social Club Inc
>

Hi John,

Sounds like you've found a limitation of GC on the MAC.  For some complicated, 
technical reason, no matter which GC data file you click on to open on a Mac, 
GC always starts with the last file that was running.

You need to File ->  Open to get the correct file.

HTH,
Maf.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Could not obtain the lock

2017-11-20 Thread Maf. King 
On Monday, 20 November 2017 01:13:50 GMT Moira wrote:
> Hi, I am getting this same message, but I cannot locate an .LCK or .LNK file
> in the relevant folder.
> 
> I moved my files from an old laptop to a new one, by simply copying them and
> then installing the program on the new computer. I opened GnuCash after
> transferring the files with no problem.  Since then, however, I get this
> "could not obtain the lock" message, and if I click on "Open Anyway" it
> will not exit cleanly, it asks me to save the file as a new file.  Which I
> have declined to do because i don't know if that will mess things up.
> 
> I read this thread and looked for the lock files to delete, don't see them.
> I tried "Open Anyway" followed immediately by Quit, and that didn't help.
> 
> help!?
> 

Hi,

Check if you have copied the file and made it read-only (or put it in a read-
only directory).  MAybe your username is different or something?

HTH,
Maf.


___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

wiki correction related to Finance::Quote

2017-11-20 Thread uhopfer@gmail 

https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

The windows version for running gnc-fq-check omits the fact these are 
perl scripts.


IMHO, the lines should be modified to include "perl":

*To determine the version of Finance::Quote you have installed:* Open a 
command/terminal window and run gnc-fq-check (C:\"Program Files 
(x86)\gnucash\bin_*>*__*perl *_gnc-fq-check" on Windows). The first 
number in the result list is the Finance::Quote version.


--
Ulrich Hopfer
uhop...@gmail.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

interface problem between gnucash and finance::quote

2017-11-20 Thread uhopfer@gmail 
I have problems retrieving quotes with gnucash even though gnc-fq-dump 
retrieves quotes when I use yahoo_json or yahoo_yql or alphavantage. For 
example,


xx>perl gnc-fq-dump yahoo_json FBIOX FBGRX FCNTX FEMEX FARNX FDSVX FISMX FOSFX 
FSCSX FTRNX
Finance::Quote fields Gnucash uses:
 symbol: FBIOX<=== required
 date: 00/00/2000   <=== recommended
 currency: USD  <=== required
 last: 214.7<=\
 nav:  <=== one of these
 price:  <=/
 timezone:  <=== optional
=

Finance::Quote fields Gnucash uses:
 symbol: FBGRX<=== required
 date: 00/00/2000   <=== recommended
 currency: USD  <=== required
 last: 88.28<=\
 nav:  <=== one of these
 price:  <=/
 timezone:  <=== optional
=

etc.

When I use gnucash, regardless of the source, I get

There was an unknown error while retrieving the price quotes!

or
Unable to retrieve quotes for these items:
  FUND:FBGRX
  CURRENCY:XDR
  CURRENCY:EUR

I have windows 8.1 and FQ 1.47 and gnucash 2.6.18.
I suspect that there is problem in the interface with alphavantage, yahoo_json, 
and yahoo_yql.
Has anyone solved this problem?

--
Ulrich Hopfer
uhop...@gmail.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Could not obtain the lock

2017-11-20 Thread Moira 
Hi, I am getting this same message, but I cannot locate an .LCK or .LNK file
in the relevant folder.

I moved my files from an old laptop to a new one, by simply copying them and
then installing the program on the new computer. I opened GnuCash after
transferring the files with no problem.  Since then, however, I get this
"could not obtain the lock" message, and if I click on "Open Anyway" it will
not exit cleanly, it asks me to save the file as a new file.  Which I have
declined to do because i don't know if that will mess things up.

I read this thread and looked for the lock files to delete, don't see them.
I tried "Open Anyway" followed immediately by Quit, and that didn't help.

help!?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Two different sets of accounts

2017-11-20 Thread adamandeve club 
Hello, experts,
I am Treasurer of two clubs. I have used Gnucash for both, but up to now I have 
had two different Macintosh computers, one for each club.
Now I have traded my old computers for one fancy new MacBook Pro.
My two sets of accounts are currently held on a USB stick for each. But even 
with the newest version of Gnucash (2.6.18-Intel) only the first set of 
accounts opens, the one that was initially opened on the new computer. No 
matter which account of the other set I double-click on, with Gnucash closed, 
the other set of accounts is opened.
How can I keep both sets of accounts separately – and they cannot be put 
together, being totally different clubs with different financial dealings – 
using Gnucash?
Thank you,
John Nightingale,
Secretary/Treasurer,
Adam and Eve Social Club Inc


___
gnucash-user mailing list
gnucash-user@gnucash.org
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.