[GNC] Can't complete "To-Create" scheduled transaction in "Since Last Run"

2023-03-01 Thread rsbrux via gnucash-user
I have a scheduled transaction involving two currencies: a charge in EUR 
which is charged to  a CHF credit card.


This has worked in the past.

When the "Since Last Run" dialog appears, it lists this transaction 
under "To-Create" and shows:

EUR <-> CHF    (Need value)

When I click on "(Need value)", it turns into what appears to be a text 
edit field, where I usually enter an exchange rate.


However, today, no value was accepted, leaving me unable to close the 
"Since Last Run" dialog with "OK".


I couldn't find any relevant information in the online 
 help in 
the included help or on the wiki 
.


How is this supposed to work?

The exchange rate is one of those which is automatically updated each 
time the computer starts.


Why can't GnuCash simply use the most recent exchange rate from the 
Price Database?


BTW, the included help  has a self-reference in the topic "Since Last 
Run Assistant": the link "Scheduled Transactions " 
links back to the same topic.


According to KDE Discover, I am running GnuCash 4.13+ released on 
2022-12-17 as a flatpak under Ubuntu Studio 22.04 LTS.


Running:

>>

flatpak run --command=sh org.gnucash.GnuCash
[ org.gnucash.GnuCash ~]$ gnucash --version << as documented on the 
wiki  produces: >> GnuCash 4.13 
Build ID: Flathub 4.13 <<

___
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] Using Plaid

2023-03-01 Thread Steve Brown
This is interesting.

https://www.plaidsettlement.com/

This prompted me to look at a Quicken OFX log after downloading
investment transactions from Raymond James. That log stays traffic
comes from 

https://directconnect.rjf.com/eftxweb/access.ofx

but the traffic really comes from

https://services.quicken.com/ofx-secure-plus

Third parties collecting your bank credentials and sniffing your
financial traffic, what can go wrong?

Steve

On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote:
> To me it's very different.  You're not giving a user name and a
> password 
> to AQBanking. I started using Plaid, then got really spooked by the
> fact 
> that they do have access to your account as if they were you. Removed
> my 
> account and canceled my keys.
> There are no current alternatives at the moment, unlike in Europe
> where 
> there seem to be, I believe mandated by the EU.
> I wrote automated scripts to scrape my banks for the OFX files, but 
> that's a royal pain in the butt, and it's not robust at all.
> 
> Jean
> 
> On 2/28/23 3:44 PM, Ben Pracht wrote:
> >   I read that disclaimer. It says to keep the token secure and yes,
> > the
> > bearer of that token gets access. As they said:
> > "The access token generated by using this tool is sensitive
> > material as it
> > grants access to your accounts. It should be handled with care and
> > protected from unauthorized access. You must be sure to store it in
> > such a
> > way that makes it impossible for others to gain access. The
> > creators and
> > maintainers of Plaid2QIF are in no way responsible if you mishandle
> > your
> > access token."
> > 
> > GIving Plaid2QIF this token is no different than me giving a
> > username and
> > password to AQBanking, except that Plaid has a chance of working. I
> > don't
> > like having an intermediary, in this case Plaid and Plaid2QIF, but
> > OFX is
> > unusable, and at the moment, AQBanking isn't even showing the list
> > of banks
> > anymore. Does anyone know of a US bank or credit union that uses a
> > modern
> > REST based API that they actually share with developers?
> > 
> > Regards,
> > Ben
> > 
> > On 2/22/23 23:08, john wrote:
> > 
> > On Feb 22, 2023, at 2:01 PM, Ben Pracht
> >   wrote:
> > 
> > I'd like to use Plaid with GnuCash. There is a plaid2qif project
> > that
> > claims to have been extensively tested with GnuCash and Plaid.
> > However,
> > when I created the Plaid account, it asks for either a limited
> > developer
> > account or a production account with a compliance audit. What
> > account type
> > should I use? Anything else helpful to know?
> > 
> > 
> > Neither. See
> > https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md
> > ,
> > 
> > Pay particular attention to the disclaimer at the bottom of that
> > page.
> > 
> > Regards,
> > John Ralls
> > ___
> > 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] Using Plaid

2023-03-01 Thread Jean L
And now, vanguard apparently no longer offers OFX as a download option, 
just csv files. >:(

hopefully this is temporary, but I'm not holding my breath.

The entire download-you-data landscape for finances in the US is just broken

Jean

On 3/1/2023 2:51 AM, Steve Brown wrote:

This is interesting.

https://www.plaidsettlement.com/

This prompted me to look at a Quicken OFX log after downloading
investment transactions from Raymond James. That log stays traffic
comes from

https://directconnect.rjf.com/eftxweb/access.ofx

but the traffic really comes from

https://services.quicken.com/ofx-secure-plus

Third parties collecting your bank credentials and sniffing your
financial traffic, what can go wrong?

Steve

On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote:

To me it's very different.  You're not giving a user name and a
password
to AQBanking. I started using Plaid, then got really spooked by the
fact
that they do have access to your account as if they were you. Removed
my
account and canceled my keys.
There are no current alternatives at the moment, unlike in Europe
where
there seem to be, I believe mandated by the EU.
I wrote automated scripts to scrape my banks for the OFX files, but
that's a royal pain in the butt, and it's not robust at all.

Jean

On 2/28/23 3:44 PM, Ben Pracht wrote:

   I read that disclaimer. It says to keep the token secure and yes,
the
bearer of that token gets access. As they said:
"The access token generated by using this tool is sensitive
material as it
grants access to your accounts. It should be handled with care and
protected from unauthorized access. You must be sure to store it in
such a
way that makes it impossible for others to gain access. The
creators and
maintainers of Plaid2QIF are in no way responsible if you mishandle
your
access token."

GIving Plaid2QIF this token is no different than me giving a
username and
password to AQBanking, except that Plaid has a chance of working. I
don't
like having an intermediary, in this case Plaid and Plaid2QIF, but
OFX is
unusable, and at the moment, AQBanking isn't even showing the list
of banks
anymore. Does anyone know of a US bank or credit union that uses a
modern
REST based API that they actually share with developers?

Regards,
Ben

On 2/22/23 23:08, john wrote:

On Feb 22, 2023, at 2:01 PM, Ben Pracht
   wrote:

I'd like to use Plaid with GnuCash. There is a plaid2qif project
that
claims to have been extensively tested with GnuCash and Plaid.
However,
when I created the Plaid account, it asks for either a limited
developer
account or a production account with a compliance audit. What
account type
should I use? Anything else helpful to know?


Neither. See
https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md
,

Pay particular attention to the disclaimer at the bottom of that
page.

Regards,
John Ralls
___
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.


[GNC] Looking for setup and/or bookkeeping help

2023-03-01 Thread Bob Treumann
Are there any accountants or bookkeepers who specialize in gnucash?
Or other power users who would help me out?I would expect to pay.

I have my small business ( S-Corp ) gnucash account set up in a cloud
database so the person could work remotely, either to get me started or to
do the bookkeeping and taxes including payroll taxes.

Bob Treumann


Virus-free.www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
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.


[GNC] File locked ?

2023-03-01 Thread TimR via gnucash-user
I am a new user having just switched to GnuCash by importing from a Quicken
QIF file. All seemed to be going well for several sessions. Today in trying
to open Gnucash I have received the following error message:

"GnuCash could not obtain the lock for D:\Raymond.Current.gnucash."

How do I solve this?

___
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] File locked ?

2023-03-01 Thread edodd
On Wed, 1 Mar 2023 19:59:04 -
TimR via gnucash-user  wrote:

> I am a new user having just switched to GnuCash by importing from a
> Quicken QIF file. All seemed to be going well for several sessions.
> Today in trying to open Gnucash I have received the following error
> message:
> 
> "GnuCash could not obtain the lock for D:\Raymond.Current.gnucash."
> 
> How do I solve this?

Check that you have not got another copy of Gnucash open with your
database and then select "Open Anyway".


Liz
___
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] File locked ?

2023-03-01 Thread David Cousens
Tim,

Go to the directory your data file is located in. There should be a file with
the same name as the data file but with a".LCK" file extension. If there is if
you delete it you should be able to open the main daya file. The other
possibility is that your username does not have the permissions necessary to
open the file in that location, particularly if you have it in a location which
can be opened by multiple user's. If another user has previously opened the file
you may have to login as that user to delete thelogfile (or as an
administrator). The ".LCK" file is to prevent the data file being opened 
simulataneously by more than a single user.

David Cousens


On Wed, 2023-03-01 at 19:59 +, TimR via gnucash-user wrote:
> I am a new user having just switched to GnuCash by importing from a Quicken
> QIF file. All seemed to be going well for several sessions. Today in trying
> to open Gnucash I have received the following error message:
> 
> "GnuCash could not obtain the lock for D:\Raymond.Current.gnucash."
> 
> How do I solve this?
> 
> ___
> 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] File locked ?

2023-03-01 Thread Derek Atkins

are you sure another GnuCash isn't running? If you are sure then Open anyways
Generally this happens because GnuCash was not shut down cleanly.  Either 
that or there is a permission problem.

-derek
Sent using my mobile device. Please excuse any typos.
On March 1, 2023 15:00:35 TimR via gnucash-user  
wrote:



I am a new user having just switched to GnuCash by importing from a Quicken
QIF file. All seemed to be going well for several sessions. Today in trying
to open Gnucash I have received the following error message:

"GnuCash could not obtain the lock for D:\Raymond.Current.gnucash."

How do I solve this?

___
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.