Re: Filtered account report

2018-01-16 Thread AC
Thanks but not exactly simple in my case as there are over 1000 transactions to the loan interest expense account. The report was mainly for my own curiosity which is why I'd rather use an algorithmic method to generate the report. With the distinct lack of global search and replace, it would ta

Re: Filtered account report

2018-01-16 Thread David T. via gnucash-user
Sure. I understand. My experience with my own accounts was different (even with multiple loans over multiple years). Personally, I find the burden of changing transactions--evens hundreds of them--to be minor.  And the results have been consistent and reliable ever since. But you do what you hav

Re: Filtered account report

2018-01-16 Thread Mike or Penny Novack
On 1/16/2018 3:04 AM, AC wrote: Thanks but not exactly simple in my case as there are over 1000 transactions to the loan interest expense account. The report was mainly for my own curiosity which is why I'd rather use an algorithmic method to generate the report. This is an important point (wha

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread John Ralls
> On Jan 15, 2018, at 10:34 PM, Jim_S wrote: > > I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We > also use GoDaddy for our WordPress web page, so I already have the hosting > account. GnCash keeps giving me an error "The server at URL > mysql://gnuc...@gnucash.db.

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread Jim_S
Yes. GoDaddy provides a tool From StarField Techologoies called "phpMyAdmin". ...j... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailm

Re: NUM Column Defaults

2018-01-16 Thread Ken Schneider
On 01/15/2018 12:13 PM, Jack Slater wrote: Is there a place/method I should use to request? On Jan 15, 2018, at 11:12 AM, Kenneth Schneider wrote: Auto fill is not enabled for the NUM column. Maybe a feature request would get it added in a future release. Ken Schneider I was wrong, ther

Re: Correcting Opening Balances

2018-01-16 Thread Tommy Trussell
On Mon, Jan 15, 2018 at 11:32 AM, Richard Claeys wrote: > Here is an example of what I am encountering: One of the accounts that > popped up after the conversion from Quicken is a credit card that I dropped > in 1998; when I click on "Delete Account" I receive a response along the > lines of "Do

Re: Filtered account report

2018-01-16 Thread Adrien Monteleone
On that note, if only one loan has 1000 interests splits but the other loans are more manageable, then Michael just provided a workable solution. Rename the current ‘loan interest’ account to match the name of the loan with the most interest splits. (yes, everything will still be in it) Then cr

RE: Correcting Opening Balances

2018-01-16 Thread Richard Claeys
Tommy, this is very helpful and confirms some of my hunches going into tax time. So far I have only moved six or so years of Quicken to my GnuCash archives. I want to go through tax season before adding anything else. Renaming and moving the older files should work best for me, although I a

Re: NUM Column Defaults

2018-01-16 Thread Jack Slater
Its not in the NUM cell though which is where I want to input that type of transaction detail. Maybe I'll try it and see how the process flows. On Tue, Jan 16, 2018 at 10:54 AM, Ken Schneider wrote: > On 01/15/2018 12:13 PM, Jack Slater wrote: > >> Is there a place/method I should use to request

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread Jim_S
John Ralls-2 wrote >> On Jan 15, 2018, at 10:34 PM, Jim_S < > James@ > > wrote: >> > You do realize, though, that by using a remote database and then > advertising your database URI you’ve invited the whole net to try to break > your password and mess with your financial data. The names have be

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread Jim_S
The database is created, but there are no tables in it. Did I miss an install step to actually create tables in the database?? If there is not table, it cannot INSERT, correct? Or does GnuCash actually do that itself?? TIA, ...J... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread Jim_S
When you say to check the database logs, is that on the server or on the PC? TIA, ...J... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/ma

Re: Filtered account report

2018-01-16 Thread AC
On 2018-01-16 05:48, Mike or Penny Novack wrote: > On 1/16/2018 3:04 AM, AC wrote: >> Thanks but not exactly simple in my case as there are over 1000 >> transactions to the loan interest expense account.  The report was >> mainly for my own curiosity which is why I'd rather use an algorithmic >> me

Re: Filtered account report

2018-01-16 Thread AC
No, it's a roughly even distribution across the loans but, as mentioned in my other email, transactions look different at different dates in history because the majority were imported from other software before switching to GnuCash. On 2018-01-16 09:44, Adrien Monteleone wrote: > On that note, if

Can't edit currencies in security editor

2018-01-16 Thread rob
When i open the security editor and want to edit a currency than almost everything is greyed out, exept: display symbol, get online quotes and timezone. Whats wrong and how to solve this? ___ gnucash-user mailing list gnucash-user@gnucash.org https://lis

Re: Can't edit currencies in security editor

2018-01-16 Thread David Carlson
Those are only items that you can change when you select a pre-defined currency. You can choose whether to track exchange rates and that is about it. If you click on Help in the security editor window there is more information. David C On Tue, Jan 16, 2018 at 9:25 PM, rob wrote: > When i open

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-16 Thread John Ralls
> On Jan 16, 2018, at 2:45 PM, Jim_S wrote: > > When you say to check the database logs, is that on the server or on the PC? I guess that depends on how you’ve configured your database logging, eh? You’re the DBA, not me. Reminder: Users of the MySQL and Postgresql backends are expected to b