Re: [GNC] GnuCash Theme Library

2018-08-13 Thread Peter Jackson
Michael, I think this is a good idea. There certainly is much more to be discovered, and there are conflicts and associations that could be unravelled. It's a matter of time and inclination, and needs the participation of someone like Adrien who knows his way around the code. As for me, I can toler

Re: [GNC] keeping entities separate

2018-08-13 Thread patrushkha via gnucash-user
Thanks for responding. I am clear that I want to have all the entities separate- I thought I had set them up that way, but cannot discern how to access them individually, and that's why I think I might have missed something in the initial set up and that they are combined. -Original Messag

[GNC] Budgets (was [GNC-dev] Re: Training)

2018-08-13 Thread Adrien Monteleone
{from gnucash-devel since this is more user stuff than dev related} David, After creating a budget, have you not tried the Budget Report? That can show you actual vs. budgeted by period with variance and include yearly totals. The report also now lets you choose what periods you want to show d

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread azalea4va
>> I addressed this in the file I provided. There is one and only one >> correct >> answer mathematically. > > Not true.Depends, for example, on how many decimal places in the > calculations and whether only final rounding or rounding at multiple > places during the calculations. This was a t

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-13 Thread Megagrumpy
That is what I have done. I am testing now with only one commodity - Associated British Food. I have the id set in the security editor as ABF.L. I have tried setting this on the CSV file to ABF.L. I have also tried ABF. Still get the message "Commodity From could not be recognised". I have changed

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-13 Thread Megagrumpy
I was specifically referring to the the CSV price import tool in Version 3.2. I am trying to import the stock prices using this tool. Cannot get the Share ID to be recognised whatever I do. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Column widths again

2018-08-13 Thread Colin Law
On Mon, 13 Aug 2018 at 19:37, Graham Balin wrote: > ... > Once I have made the error of re-sizing one of the columns -bang, I have to > keep horizontal scrolling to see what is going on. > All you have to do is to set the column sizes (apart from description) as you want then double click the de

Re: [GNC] Column widths again

2018-08-13 Thread David T. via gnucash-user
Nope, that “feature” is still intact. The Tutorial & Concepts Guide notes this behavior at 2.3.3. To date, no developer has felt the need to change the behavior of the Description column, as idiosyncratic as it may be. Personally, I’d welcome a change to make this column behave as most users h

Re: [GNC] Reconciliation flag revision

2018-08-13 Thread Adrien Monteleone
Just to be clear, I did test the Action field both with and without the “Use Split Action field for number” setting. Neither case resulted in clearing the reconcile flag. This was tested on 3.2 on MacOS High Sierra. In both cases, trying to change the NUM field DID clear the fire the warning an

Re: [GNC] Unable to save to database. Build ID: 3.2+ (2018-06-24)

2018-08-13 Thread John Ralls
> On Aug 13, 2018, at 11:20 AM, mike wrote: > > Hi, > > I have recently upgraded from Fedora 25 to Fedora 28 and that > has upgraded gnucash to 3.2. Build ID: 3.2+ (2018-06-24) > > Everything worked OK on Fedora 25 - sorry I don't know what > version on gnucash that was. > >

[GNC] GnuCash Theme Library

2018-08-13 Thread Fross, Michael
Hello everyone, GnuCash, via GTK, has a very rich ability to change the fonts and colors and customize how GnuCash looks. However, I think it's safe to say that it's not a trivial exercise for the average user. However, the recent discussions between Adrien, GTI, Peter, and others have made a lo

Re: [GNC] Reconciliation flag revision

2018-08-13 Thread David Carlson
Dale Watch that other thread about release 3.2 possibly different from 2.6.x. So far I have not seen any comments about whether editing the action field does or does not unreconcile a particular split line. David C On Mon, Aug 13, 2018, 1:03 PM Adrien Monteleone < adrien.montele...@lusfiber.net

[GNC] Column widths again

2018-08-13 Thread Graham Balin
Hi all, Recent convert from Quicken and pleased overall...BUT... version 2.6.12 on a windows machine and 24" monitor-fine; on a HP laptop...almost unusable due to description column auto-widening to screen width. I have tried trawling through the many posts, dating back 8 years!, and cannot believe

Re: [GNC] Reconciliation flag revision

2018-08-13 Thread D
While I certainly understand the concern that editing a transaction dereconciles it, there are a couple of points I'd raise. First, if you are editing a reconciled transaction, you are probably pretty aware of it (and the dialog message Gnucash puts up should make it obvious). Second, editing

[GNC] Unable to save to database. Build ID: 3.2+ (2018-06-24)

2018-08-13 Thread mike
Hi, I have recently upgraded from Fedora 25 to Fedora 28 and that has upgraded gnucash to 3.2. Build ID: 3.2+ (2018-06-24) Everything worked OK on Fedora 25 - sorry I don't know what version on gnucash that was. Everything seemed OK with this new version of gnucash, until

Re: [GNC] Reconciliation flag revision

2018-08-13 Thread Adrien Monteleone
There is a warning. You get to continue to edit the transaction and thus clear the flag, or cancel and don’t edit the transaction. There is not an option to both edit and not clear the flag. Note, the flag only clears for amounts, accounts, NUM, and I suspect dates, but I didn’t test that last

Re: [GNC] Mouse and cursor misalignment

2018-08-13 Thread Adrien Monteleone
There are several threads on this issue and at least one bug report. For some, the target of the mouse is not the tip of the arrow, but it’s tail, which is why you have to ’seemingly’ click above where you want to access. This is not a GnuCash bug but a Gtk+ bug (specifically on MacOS). Some peo

Re: [GNC] keeping entities separate

2018-08-13 Thread Stephen M. Butler
On 08/13/2018 08:28 AM, Adrien Monteleone wrote: > The learning curve is infinite, it just flattens out with occasional small > bumps. > > Before proceeding any further - talk to a local CPA about your specific > situation. And chat with your attorney about how much asset protection you need bet

[GNC] Reconciliation flag revision

2018-08-13 Thread Dale Alspach
I have not switched to the 3.x version so I have no experience with the implementation. However I find the notion of unreconciling a transaction to be strange. Reconciliation is normally about matching a group of transaction to an external document such as a bank or credit card statement. Changing

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Adrien Monteleone
> On Aug 13, 2018, at 11:17 AM, George Riner wrote: > > So... question: > > If one edits the transaction by changing an account, should that un-reconcile > it? > > Say I make a credit card donation to a business and charge the expense to > home repairs. Then I go back and change it from home

Re: [GNC] keeping entities separate

2018-08-13 Thread Adrien Monteleone
The learning curve is infinite, it just flattens out with occasional small bumps. Before proceeding any further - talk to a local CPA about your specific situation. Generally though, are they legally separate entities that you file separate tax returns for? Then you likely want to separate the

Re: [GNC] keeping entities separate

2018-08-13 Thread Stephen M. Butler
On 08/13/2018 05:52 AM, patrushkha via gnucash-user wrote: > I just started using Gnucash and thought I'd gotten through the learning > curve; I have 2 small businesses and entered both of them as well as my > personal data, but discovered they are all mixed together. At least I think > so, I'm

[GNC] Mouse and cursor misalignment

2018-08-13 Thread Geoff Jankowski via gnucash-user
Gnucash 3.2 on MacBook Pro running 10.13.6 High Sierra. I have not seen any other comments in the mailing list but I have a variable and occasionally annoying displacement between the mouse icon on the screen and the actual position of the cursor on the screen. For example, in ledgers, I have t

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread George Riner
So... question: If one edits the transaction by changing an account, should that un-reconcile it? Say I make a credit card donation to a business and charge the expense to home repairs.  Then I go back and change it from home repairs to charitable donation.  Should that un-reconcile it? If

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
Thanks so much for the work-arounds. I'll investigate tomorrow. -Original Message- From: gnucash-user On Behalf Of Adrien Monteleone Sent: 13 August 2018 15:56 To: gnucash-user Subject: Re: [GNC] Reconciliation being undone without warning As a work around, how long is the time lag be

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Adrien Monteleone
As a work around, how long is the time lag between when you normally reconcile and when you find out what the voucher #s are? Would waiting until you have them all to reconcile work? (simply marking them ‘c’ for cleared in the interim, but not doing the final reconcile without the voucher info)

Re: [GNC] keeping entities separate

2018-08-13 Thread Mike or Penny Novack
On 8/13/2018 8:52 AM, patrushkha via gnucash-user wrote: I just started using Gnucash and thought I'd gotten through the learning curve; I have 2 small businesses and entered both of them as well as my personal data, but discovered they are all mixed together. At least I think so, I'm not verse

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread Mike or Penny Novack
On 8/12/2018 12:58 PM, azalea4va wrote: Sorry, I missed this reply. So a little late, but ... I should perhaps have indicated that writing this sort of thing used to be "my line of country". I have written these things. Mike or Penny Novack-3 wrote a) method? << by "present value" of series o

[GNC] keeping entities separate

2018-08-13 Thread patrushkha via gnucash-user
I just started using Gnucash and thought I'd gotten through the learning curve; I have 2 small businesses and entered both of them as well as my personal data, but discovered they are all mixed together. At least I think so, I'm not versed enough to understand how I got there or how to untangle

Re: [GNC] Change text color

2018-08-13 Thread Fross, Michael
Thank you Peter! This is really helpful. Having a template to tweak is so much more usable than going at this from scratch. I think it would be great to have a sharing area in the Wiki where people can share their color creations. I'll have to look at creating that. Michael On Mon, Aug 13, 20

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-13 Thread Deva -
I assume stock id is the commodity in question here… I have my stock id set to a commodity code (based on the code provided by the exchange) in the Security Editor->Symbol/abbreviation field. When I use the same Symbol/abbreviation field in the CSV price file, the importer seems to find the com

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
Apologies. I’m wondering if I should go back to a 2.x version. In general, I don’t like doing that, preferring to stick with updates as the bugs are ironed out, but this limitation will probably be a deal-breaker for me. From: Colin Law Sent: 13 August 2018 11:10 To: Anthony Marrian Cc: Adrie

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Colin Law
On Mon, 13 Aug 2018 at 11:05, Anthony Marrian wrote: > I’m 3.2 > You replied to my post that said that it did not happen on 2.6.19 with a post saying that it did happen for you, hence the confusion. Colin > > > *From:* Colin Law > *Sent:* 13 August 2018 10:04 > *To:* Anthony Marrian > *Cc:*

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
I’m 3.2 From: Colin Law Sent: 13 August 2018 10:04 To: Anthony Marrian Cc: Adrien Monteleone ; gnucash-user Subject: Re: [GNC] Reconciliation being undone without warning On Mon, 13 Aug 2018 at 09:32, Anthony Marrian mailto:anth...@gardensmontessori.com>> wrote: Actually, it does. I've just

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Colin Law
On Mon, 13 Aug 2018 at 09:32, Anthony Marrian wrote: > Actually, it does. I've just done it. It's entirely reproducible. When you > click out of the row having entered a number, the y changes to n. The only > niggle (if you like) is that I am manipulating GnuCash via an RDP session. > I have no i

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
I see. So, it only affects the NUM field. Wouldn't it be more sensible to put up the warning, but allow the user to edit without the transaction becoming unreconciled? I don't use that field for cheque numbers. I use it for voucher numbers. Often vouchers come to light long after the reconciliat

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
I'm not sure this happened prior to version 3. I constantly update reconciled transactions. I'm not altering the values, just the reference number (in the NUM field) or the description. It cannot possibly be sensible that adjusting descriptive, or reference, data in a reconciled transaction lead

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-13 Thread Graham Balin
Hi Don't know if this will help, but in 2.6 I used Morningstar GB, the ISIN code and the .L suffix and that worked for most quotes. Have never yet had every quote work first time. Cheerio Graham On Mon, 13 Aug 2018 at 09:27, Megagrumpy wrote: > Very pleased to see this feature in 3.2 as I have b

Re: [GNC] Reconciliation being undone without warning

2018-08-13 Thread Anthony Marrian
Actually, it does. I've just done it. It's entirely reproducible. When you click out of the row having entered a number, the y changes to n. The only niggle (if you like) is that I am manipulating GnuCash via an RDP session. I have no idea whether that affects things. -Original Message-

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread azalea4va
Sorry, I missed this reply. So a little late, but ... Mike or Penny Novack-3 wrote > a) method? << by "present value" of series of "rents" or by "trial and > error" >> I am not sure what ""present value" of series of "rents"" means, but the answer is by math. This is just a mathematical calcu

[GNC] GC 3.2 Import Price File CSV

2018-08-13 Thread Megagrumpy
Very pleased to see this feature in 3.2 as I have been getting problems importing with F:Q. Unfortunately I am having a problem with getting the tool to recognise the stock ID. I have tried the normal version eg ABF. GVC, ITV etc and I get the reddish colour with the message Commodity From could no

Re: [GNC] Getting CAGR for stocks/accounts

2018-08-13 Thread Megagrumpy
I probably did not explain myself very well. I get the dividends included in the Income column in the Advanced Portfolio but in order to calculate a true return I need to have a separate spreadsheet that breaks the dividends down with the date they were paid. The same is true for any Sell or buy tr

Re: [GNC] Get Quote is Not Working?

2018-08-13 Thread Megagrumpy
Thanks Geert Janssens for your informative reply. I was not aware of the environmental variable you mention. I have updated to GC 3.2 now as I am interested in using the import facility you mention if I cannot get Alphvantage to work. Do I need to set anything other than the Alphavantage key in Set

Re: [GNC] Change text color

2018-08-13 Thread Peter Jackson
G'dday, I agree. My feeling is that, now we have the basic parameters, tiddling around with the css file, in terms of degree of difficulty, doesn't begin to challenge learning how to get the best out of Gnucash. I attach my final GTK-3.0.css, which I first posted in draft form on 5th August. This p