Re: [GNC] Change text color

[Adrien Monteleone]

Yes,

See here: 
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/078745.html

Regards,
Adrien

> On Aug 6, 2018, at 7:32 PM, GT-I9070 H  wrote:
> 
> Em seg, 6 de ago de 2018 às 13:30, Adrien Monteleone 
>  escreveu:
> It should be there too. I’m looking at it when I view the link. (second image)
> 
> Regards,
> Adrien
> 
> > On Aug 6, 2018, at 11:49 AM, GT-I9070 H  wrote:
> > 
> > Em seg, 6 de ago de 2018 às 12:29, Adrien Monteleone 
> >  escreveu:
> > Thanks, I thought I needed an account. That was my next step.
> > 
> > I’ve put both screenshots here: https://imgur.com/a/9tlCWbE
> > 
> > Regards,
> > Adrien
> > 
> > And tree for the bar on the register sheet?
> > 
> > 
> > Regards
> > GTI
> 
> If the second image is from the register sheet total bar, then where is the 
> tree for the Summary bar on account sheet? On the first image?
> 
> 
> Regards
> GTI
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Upgrade to 3.2, or stay with 2.6?

[Adrien Monteleone]

The tour simply hasn’t been updated yet for 3.x series. I have to say, I agree 
that it is confusing.

Hopefully, those who contributed major changes have some of their volunteer 
time they can dedicate to showcasing new features.

Until then, release notes are always available.

Regards,
Adrien

> On Aug 7, 2018, at 9:22 PM, Eric Haszlakiewicz  
> wrote:
> 
> Most of the links on the home page point at 3.2, but right below where
> it says "Download GnuCash 3.2" it says "GnuCash 2.6 release tour".
> huh?
> Should I stay with 2.6 for now, or is 3.2 ok to upgrade to?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Here are some rather garish colors to see what controls what:

/* button’s container - ‘behind’ and ‘around’ it */
.GncAccountPage { background-color: red;}

/* another layer of a container for the button  - exposed only left and right 
sides */
.summary-bar { background-color: yellow;}

/* the button - note you need to override background-image and/or the border */
.combo {
  background-color: green;
  color: orange;
  background-image: none;
  border: 5px solid purple;
}

/* the text on the button */
.summary-bar cellview {
 font-size: 2em;
}

Regards,
Adrien

p.s.—I’m off to drink homebrew—till next time...

> On Aug 7, 2018, at 4:24 PM, GT-I9070 H  wrote:
> 
> Adrien, Any idea?
> 
> 
> Regards
> GTI
> 
> Em ter, 7 de ago de 2018 às 15:58, GT-I9070 H  escreveu:
> Em ter, 7 de ago de 2018 às 14:40, Adrien Monteleone 
>  escreveu:
> .GncAccountPage should be the area ‘behind’ the summary bar and extends past 
> it a bit as well - it is the container that holds the summary bar which is 
> slightly smaller. .summary-bar, being a child element, might inherit 
> properties that you set here.
> 
> .summary-bar has child labels.  In some cases, the color property (which is 
> the foreground, or text color) can be applied to a parent element that itself 
> doesn’t contain text and it still gets inherited by the children and other 
> descendants—sometimes, not. The font-size and color properties *should* 
> however work on ‘.summary-bar label’. Check earlier messages in the thread 
> where we first went over the .summary-bar. One of my replies should have the 
> specific selector for the label.
> 
> So you would have:
> 
> /* area-container of summary bar */
> 
> .GncAccountPage {}
> 
> /* summary bar itself */
> 
> .summary-bar {}
> 
> /* labels on the summary bar */
> 
> .summary-bar label {}
> 
> 
> Regards,
> Adrien
> 
> I had already tested this for a long time and none of this worked for me.
> 
> Peter,
> Did it work for you?
> 
> Regards
> GTI

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reconcile column

[Adrien Monteleone]

I think the ‘y’ is only possible by going through the reconcile process in 
GnuCash. If a ‘c’ is there, when you click reconcile, it will automatically be 
checked as cleared. Simply click the reconcile button and go through it again. 
Likely the only transaction not reconciled is that one.

Regards,
Adrien

> On Aug 7, 2018, at 2:49 PM, hal  wrote:
> 
> I was reconciling my bank account and it didn't reconcile. I could see the
> amount that it was off from reconciling so I clicked on the y in the
> reconcile column of a transaction that matched the amount that I was off to
> see if that would change my reconciliation. The y changed to a c. It turned
> out that particular transaction should have a y in the reconciliation
> column. How do I get it back to being reconciled?
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Sorry, by ‘in front’ I thought you meant ‘left-to-right’ I didn’t think of 
‘towards the viewer’. Yes, you can style .combo box directly, but that doesn’t 
affect the entire button. The button also has a border and a background image. 
(which fills the area around that box) If you want to style the entire button 
the same, you can skip .combo box and just style .combo and override the 
background-image.

See my previous post with garish colors.

So you’d do this:

.combo {
  background-color: dimgray;
  background-image: none;
}


Regards,
Adrien


> On Aug 8, 2018, at 10:31 AM, GT-I9070 H  wrote:
> 
> Em ter, 7 de ago de 2018 às 15:56, GT-I9070 H  escreveu:
> Very good!
> 
> And the color of the bar?
> 
> 
> Regards
> GTI
> 
> Since nobody found the color of the summary bar, I searched and found here 
> https://imgur.com/a/9tlCWbE in the first image.
> (I understand very much of css )
> 
> Adrien, this is the child element in front of the bar I was looking for:
> 
> .combo box {
>   background-color: dimgray;
> }
> 
> This is the beautiful result:
> 
> 
> Now it's just missing this dark frame (red arrow in figure) to dominate the 
> entire summary bar.
> 
> Does anyone know what the selector is for this element?
> 
> 
> Regards
> GTI


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Text alignment

[Adrien Monteleone]

Not without editing the code and building it yourself.

Text-align is not even listed as a changeable Gtk+3 property for CSS. So it 
can’t even just be given a class for styling. This is hard coded.

Regards,
Adrien

> On Aug 8, 2018, at 1:43 AM, Tony Vanson  wrote:
> 
> Hi all,
> Is it possible to left-align text in the Transfer columns of GnuCash 2.6.18
> on Windows 10?
> Thanks in advance.
> 
> -- 
> *Tony Vanson*
> 
> *The older I get,*
> *the better I was*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Correction,

tabs label {
  margin-left: -3em;
}

will shift the label and thus then entire tab to the left enough to cover the 
invisible image. (you can alter the margin to suit of course)

Also notice I use ’tabs’ here instead of ’notebook’.

They are interchangeable but I like ’tabs’ better because it makes the CSS 
self-documenting.

So the previous rule would be:

tabs box > image {
 opacity: 0;
}

(and you can drop the .GncMainWindow class as it’s superfluous)

Regards,
Adrien

> On Aug 8, 2018, at 11:08 AM, Adrien Monteleone 
>  wrote:
> 
> Peter,
> 
> If you mean the icon which indicates if the tab is an account, report, et 
> cetera, then try this:
> 
> .GncMainWindow notebook box > image {
>  opacity: 0;
> }
> 
> Is the best I can muster.
> 
> The ‘display’ property is not exposed in Gtk it seems. (or else ‘display: 
> none’ would work)
> 
> There is a ‘visible’ property in the inspector which I can toggle there, but 
> it isn’t exposed in CSS either. (likely would tie to ‘display’)
> 
> If you don’t include the ‘>’ child selector, you’ll also make the close icon 
> on the tab disappear, but it still might function.
> 
> The above rule doesn’t reclaim the blank space, however.
> 
> Regards,
> Adrien
> 
>> On Aug 8, 2018, at 3:59 AM, Peter Jackson  wrote:
>> 
>> On each Notebook Tab, to the left of the Account Name, is an irritating 
>> little icon. Any idea how to remove it?
>> pj
>> 
>> 
>> On 8 August 2018 at 07:10, Peter Jackson  wrote:
>> Adrien, well done. It all works on mine.
>> Thanks
>> Peter
>> 
>> 
>> On 7 August 2018 at 23:10, Adrien Monteleone 
>>  wrote:
>> Here are some rather garish colors to see what controls what:
>> 
>> /* button’s container - ‘behind’ and ‘around’ it */
>> .GncAccountPage { background-color: red;}
>> 
>> /* another layer of a container for the button  - exposed only left and 
>> right sides */
>> .summary-bar { background-color: yellow;}
>> 
>> /* the button - note you need to override background-image and/or the border 
>> */
>> .combo {
>>  background-color: green;
>>  color: orange;
>>  background-image: none;
>>  border: 5px solid purple;
>> }
>> 
>> /* the text on the button */
>> .summary-bar cellview {
>> font-size: 2em;
>> }
>> 
>> Regards,
>> Adrien
>> 
>> p.s.—I’m off to drink homebrew—till next time...
>> 
>>> On Aug 7, 2018, at 4:24 PM, GT-I9070 H  wrote:
>>> 
>>> Adrien, Any idea?
>>> 
>>> 
>>> Regards
>>> GTI
>>> 
>>> Em ter, 7 de ago de 2018 às 15:58, GT-I9070 H  escreveu:
>>> Em ter, 7 de ago de 2018 às 14:40, Adrien Monteleone 
>>>  escreveu:
>>> .GncAccountPage should be the area ‘behind’ the summary bar and extends 
>>> past it a bit as well - it is the container that holds the summary bar 
>>> which is slightly smaller. .summary-bar, being a child element, might 
>>> inherit properties that you set here.
>>> 
>>> .summary-bar has child labels.  In some cases, the color property (which is 
>>> the foreground, or text color) can be applied to a parent element that 
>>> itself doesn’t contain text and it still gets inherited by the children and 
>>> other descendants—sometimes, not. The font-size and color properties 
>>> *should* however work on ‘.summary-bar label’. Check earlier messages in 
>>> the thread where we first went over the .summary-bar. One of my replies 
>>> should have the specific selector for the label.
>>> 
>>> So you would have:
>>> 
>>> /* area-container of summary bar */
>>> 
>>> .GncAccountPage {}
>>> 
>>> /* summary bar itself */
>>> 
>>> .summary-bar {}
>>> 
>>> /* labels on the summary bar */
>>> 
>>> .summary-bar label {}
>>> 
>>> 
>>> Regards,
>>> Adrien
>>> 
>>> I had already tested this for a long time and none of this worked for me.
>>> 
>>> Peter,
>>> Did it work for you?
>>> 
>>> Regards
>>> GTI
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Looking at the available properties, I didn’t see one that would work on the 
image directly. I tried margin but it didn’t seem to work. I see there are 
other properties not related to CSS. It would be nice if Gnome added them to 
their spec.

Regards,
Adrien

> On Aug 8, 2018, at 11:42 AM, Geert Janssens  
> wrote:
> 
> Op woensdag 8 augustus 2018 18:31:07 CEST schreef Adrien Monteleone:
>> Correction,
>> 
>> tabs label {
>>  margin-left: -3em;
>> }
>> 
>> will shift the label and thus then entire tab to the left enough to cover
>> the invisible image. (you can alter the margin to suit of course)
>> 
>> Also notice I use ’tabs’ here instead of ’notebook’.
>> 
>> They are interchangeable but I like ’tabs’ better because it makes the CSS
>> self-documenting.
>> 
>> So the previous rule would be:
>> 
>> tabs box > image {
>> opacity: 0;
>> }
> 
> Would a negative position work to hide the image ? Gtk internally uses -32000 
> to hide windows. I have no idea if this also works for other widgets.
> 
> Geert
> 
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Peter,

If you mean the icon which indicates if the tab is an account, report, et 
cetera, then try this:

.GncMainWindow notebook box > image {
  opacity: 0;
}

Is the best I can muster.

The ‘display’ property is not exposed in Gtk it seems. (or else ‘display: none’ 
would work)

There is a ‘visible’ property in the inspector which I can toggle there, but it 
isn’t exposed in CSS either. (likely would tie to ‘display’)

If you don’t include the ‘>’ child selector, you’ll also make the close icon on 
the tab disappear, but it still might function.

The above rule doesn’t reclaim the blank space, however.

Regards,
Adrien

> On Aug 8, 2018, at 3:59 AM, Peter Jackson  wrote:
> 
> On each Notebook Tab, to the left of the Account Name, is an irritating 
> little icon. Any idea how to remove it?
> pj
> 
> 
> On 8 August 2018 at 07:10, Peter Jackson  wrote:
> Adrien, well done. It all works on mine.
> Thanks
> Peter
> 
> 
> On 7 August 2018 at 23:10, Adrien Monteleone  
> wrote:
> Here are some rather garish colors to see what controls what:
> 
> /* button’s container - ‘behind’ and ‘around’ it */
> .GncAccountPage { background-color: red;}
> 
> /* another layer of a container for the button  - exposed only left and right 
> sides */
> .summary-bar { background-color: yellow;}
> 
> /* the button - note you need to override background-image and/or the border 
> */
> .combo {
>   background-color: green;
>   color: orange;
>   background-image: none;
>   border: 5px solid purple;
> }
> 
> /* the text on the button */
> .summary-bar cellview {
>  font-size: 2em;
> }
> 
> Regards,
> Adrien
> 
> p.s.—I’m off to drink homebrew—till next time...
> 
> > On Aug 7, 2018, at 4:24 PM, GT-I9070 H  wrote:
> > 
> > Adrien, Any idea?
> > 
> > 
> > Regards
> > GTI
> > 
> > Em ter, 7 de ago de 2018 às 15:58, GT-I9070 H  escreveu:
> > Em ter, 7 de ago de 2018 às 14:40, Adrien Monteleone 
> >  escreveu:
> > .GncAccountPage should be the area ‘behind’ the summary bar and extends 
> > past it a bit as well - it is the container that holds the summary bar 
> > which is slightly smaller. .summary-bar, being a child element, might 
> > inherit properties that you set here.
> > 
> > .summary-bar has child labels.  In some cases, the color property (which is 
> > the foreground, or text color) can be applied to a parent element that 
> > itself doesn’t contain text and it still gets inherited by the children and 
> > other descendants—sometimes, not. The font-size and color properties 
> > *should* however work on ‘.summary-bar label’. Check earlier messages in 
> > the thread where we first went over the .summary-bar. One of my replies 
> > should have the specific selector for the label.
> > 
> > So you would have:
> > 
> > /* area-container of summary bar */
> > 
> > .GncAccountPage {}
> > 
> > /* summary bar itself */
> > 
> > .summary-bar {}
> > 
> > /* labels on the summary bar */
> > 
> > .summary-bar label {}
> > 
> > 
> > Regards,
> > Adrien
> > 
> > I had already tested this for a long time and none of this worked for me.
> > 
> > Peter,
> > Did it work for you?
> > 
> > Regards
> > GTI
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation flag revision

[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 one yet.

As John Ralls noted in an earlier reply, NUM was added as a trigger for this in 
response to a bug report. NUM might be a check number, which should not be 
changed once reconciled. (at least not without confirming this by 
re-reconciling)

The casual user simply should re-reconcile the account if you really need to 
change one of these fields. If you don’t want to do it on the spot, simply mark 
that split as cleared ‘c’ and it will be checked off for you on the next 
reconciliation. Since you aren’t changing the amounts, this will not throw off 
the reconciliation calculations. It will just be ‘cleaning up’ and confirming 
that transaction is now correct.

Regards,
Adrien

> On Aug 13, 2018, at 12:42 PM, Dale Alspach  wrote:
> 
> 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 the flag from y to n of one or more transactions breaks
> the reconciliation. What is the casual user supposed to do at this point?
> 
> At minimum the user should be given the option of preserving the
> reconciliation flag. Popping up a warning puts the user on notice that
> there may be a material change but the user is responsible for deciding
> this and what to do about it.
> 
> Dale
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation flag revision

[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 
and clear the flag. (if proceeding with the edit)

Since this was a change introduce in 3.0, the 2.6 series should not be affected 
and you can edit the NUM field to your content without clearing the flag.

Regards,
Adrien

> On Aug 13, 2018, at 1:34 PM, David Carlson  
> wrote:
> 
> 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 
>  wrote:
> 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 one yet.
> 
> As John Ralls noted in an earlier reply, NUM was added as a trigger for this 
> in response to a bug report. NUM might be a check number, which should not be 
> changed once reconciled. (at least not without confirming this by 
> re-reconciling)
> 
> The casual user simply should re-reconcile the account if you really need to 
> change one of these fields. If you don’t want to do it on the spot, simply 
> mark that split as cleared ‘c’ and it will be checked off for you on the next 
> reconciliation. Since you aren’t changing the amounts, this will not throw 
> off the reconciliation calculations. It will just be ‘cleaning up’ and 
> confirming that transaction is now correct.
> 
> Regards,
> Adrien
> 
> > On Aug 13, 2018, at 12:42 PM, Dale Alspach  wrote:
> > 
> > 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 the flag from y to n of one or more transactions breaks
> > the reconciliation. What is the casual user supposed to do at this point?
> > 
> > At minimum the user should be given the option of preserving the
> > reconciliation flag. Popping up a warning puts the user on notice that
> > there may be a material change but the user is responsible for deciding
> > this and what to do about it.
> > 
> > Dale
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation (Bug 777893)

[Adrien Monteleone]

Looks pretty clear.

Though I’m noticing sqlite does generate log files too. Note, these are 
transaction replay logs from what I understand in case of a crash. As I believe 
John Ralls noted, any of these past the last successful save are useless. I’m 
not sure if this is what you are referring to by ‘Uses log files.’  I don’t 
know if sqlite can even utilize them at all. I’ve never had to try. You might 
want to get clarification on that point.

Also, I’d get clarification about the state of GnuCash sqlite on Windows. It 
may or may not be packaged with GnuCash by default and may or may not need some 
additional software. (if so, you might need a footnote) On Mac & Linux, it’s 
just a file format choice without any other effort.

Regards,
Adrien 

> On Aug 15, 2018, at 12:49 PM, David T.  wrote:
> 
> Here is a newer version of the table:
> 
> Storage Comparison Table
>   XML SQLite  MySQL   PostgreSQL
> Installation  Default Default libdbi  libdbi
> File extensiongnucash gnucash N/A N/A
> Additional software   NoneNoneMySQL   PostgreSQL
> Additional expertise  NoneNoneDBMSDBMS 
> Compression   Y   N   N   N
> Save on command   Y   N   N   N
> Save on commitN   Y   Y   Y
> Uses log filesY   N   N   N
> Multi-userN   N   N   N
> 
> How does that seem?
> 
>> On Aug 15, 2018, at 10:34 AM, Adrien Monteleone 
>>  wrote:
>> 
>> 
>> 
>>> On Aug 15, 2018, at 12:11 PM, David T.  wrote:
>>> 
>>> 
>>> 
>>>> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone 
>>>>  wrote:
>>>> 
>>>> But it’s not a ‘plain file’ as it is XML formatted. Someone expecting 
>>>> plain text and trying to view it is going to be met with tag soup they’ve 
>>>> never seen before and might very well not know how to read it.
>>> 
>>> Not to mention that it’s compressed.
>> 
>> True, forgot about that. Certainly, they’ll see gibberish mostly.
>> 
>>> 
>>>> 
>>>> It also carries an .xml extension. So specifying the format is very 
>>>> specific and informative, even for users who aren’t familiar with XML. 
>>>> They’ll see in their file manager the extension, and/or the OS’s 
>>>> interpretation of the file type itself. (in this case both XML)
>>> 
>>> However, the file extension used is “gnucash” and not “xml”
>> 
>> Facepalm. I forgot about that. (I honestly rarely even look at the location 
>> where it’s stored anyway) I’d suspect unless Win10 uses the file descriptor 
>> for file type instead of the extension as was the practice through at least 
>> Win7, then no, those users won’t see XML anywhere. (if the descriptor is set 
>> as XML that is)
>> 
>> So I just checked on both MacOS and Ubuntu, MacOS reports the ‘Kind’ as 
>> ‘Gnucash Document’ regardless if sqlite or xml, and at least with xml, 
>> Ubuntu reports the file type as ’spreadsheet’. (yes, it’s registered to open 
>> with GnuCash, but this was built from source, so perhaps the file type was 
>> not registered properly, repo versions may vary)
>> 
>> So I guess on that point I was way off.
>> 
>> 
>>> Perhaps the save process needs to be refactored to identify clearly and 
>>> separately the name of the data file AND its format?
>> 
>> Since .gnucash is not really proprietary or somehow a special format from 
>> XML then I agree, the extension should be .xml.
>> 
>> Combine this with the fact that the sqlite version of the file ALSO uses the 
>> .gnucash extension can make for some confusion. At a glance, you can’t tell 
>> what the format is. You can’t even tell until you try to open it with 
>> something other than GnuCash. (or you notice that GnuCash doesn’t offer a 
>> Save option) The only reason I know which is which is I had to use 
>> filename.xml.gnucash to tell them apart. That’s a usability bug in my 
>> opinion. I don’t know how hard that is to change, but I’d support the move.
>> 
>> On that note, the documentation somewhere (I suppose in the ‘file > 
>> save/save as’ section) should document that the extension is currently 
>> ‘.gnucash’. A new user shouldn’t have to go to a wiki or website FAQ after 
>> reading the documentation for something this basic.
>> 
>> Would it be out of order to include in your table that both use this 
>> extension? If you expand the table to show MySQL and Postgres, I suppose 
>> that row would have some other note since their data stores are very 
>> different than

Re: [GNC] File Format Documentation (Bug 777893)

[Adrien Monteleone]

But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain 
text and trying to view it is going to be met with tag soup they’ve never seen 
before and might very well not know how to read it.

It also carries an .xml extension. So specifying the format is very specific 
and informative, even for users who aren’t familiar with XML. They’ll see in 
their file manager the extension, and/or the OS’s interpretation of the file 
type itself. (in this case both XML)

Knowing this might very well help them find their file if they know the format 
they are looking for.

But I do agree, the documentation should cover where files are stored. Ideally, 
this should be made part of the Help or Guide in the Getting Started section. 
It is certainly a common enough issue on the list.

Regards,
Adrien

> On Aug 15, 2018, at 10:24 AM, Christoph R  
> wrote:
> 
> Hi David,
> 
>> The default file storage format is XML
> 
> I would not call this “XML" but "plain file”. From a user perspective it is 
> not important in which internal format it is stored. But it makes a big 
> difference if it is a simple file created by Gnucash or if Gnucash needs to 
> connect to a DBMS.
> 
> And one of the biggest confusion for users on the mailing list is the 
> question: “Where is my data?”. Pointing out that all your accounts and 
> transactions are in a simple file might reduce that problem.
> 
> Cheers,
> Christoph
> 
>> Am 15.08.2018 um 00:05 schrieb David T. via gnucash-user 
>> :
>> 
>> Hello,
>> 
>> In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 
>> ), I have written a more 
>> detailed description of the storage choices available to users for insertion 
>> into the Tutorial & Concepts Guide at section 2.5. Given the extent of the 
>> text, I am including it here so that the broader community can offer 
>> suggestions for improvement. Note that I will insert appropriate encoding 
>> once I finalize the content.
>> 
>> Thanks,
>> David T.
>> 
>> 
>> Proposed text for Tutorial & Concepts Guide section 2.5
>> 
>> 
>> 2.5 Storing your financial data
>> 2.5.1 Overview
>> GnuCash offers several formats for storing your financial data. The default 
>> file storage format is XML, while a number of flavors of SQL storage are 
>> available. Users can choose a file format from the File Save and File Save 
>> As dialogs.
>> The primary GnuCash storage format is an XML file. The file is by default 
>> compressed with gzip, which is a preference that is set at 
>> Edit→Preferences→General→Use file compression. 
>> GnuCash also supports SQL storage via the DBI back end. It supports 
>> PostgreSQL, MySQL and SQLite3 databases.
>> 
>> Storage Comparison
>> As noted, GnuCash allows storage in either XML or SQL formats. Each of these 
>> formats has benefits and shortcomings that the user should consider for 
>> their needs and abilities. 
>> The XML format is the most stable and established format, and for this 
>> reason, it is the recommended format for most users. SQL storage was added 
>> for the 2.4 release and has become an increasingly popular choice for users.
>> Use of SQL formats for storage implies to many that GnuCash is database 
>> management software (DBMS). While that is a long term goal of the 
>> development team, GnuCash as currently designed is not DBMS. It is a 
>> financial application that can store its data in SQL files.
>> Many features that users of DBMS expect from a DBMS are not implemented in 
>> GnuCash. The GnuCash data schema is not normalized. Significant elements of 
>> the data logic is implemented in code, rather than data structure.
>> Gnucash uses the SQL back end to load the entire data store into memory in 
>> the same manner as the XML back end. Consequently, use of the SQL back end 
>> does not enable simultaneous multi-user access to a GnuCash file, although 
>> that is one long term goal.
>> One benefit of the SQL back end is that it saves changes incrementally, and 
>> every change is committed to the back end as it happens. This is in contrast 
>> to the XML back end, which only writes to the data file when the user 
>> invokes the Save command. 
>> The SQL back end does allow users with SQL experience to write queries 
>> against the data to create custom reports without using Gnucash’s internal 
>> report system. It is important to note that modification of GnuCash data 
>> using external access modes is strongly discouraged by the development team, 
>> and damages to a GnuCash data file that result from such modifications are 
>> strictly the responsibility of the user.
>> 
>> Storage Comparison Table
>> 
>> XML  SQL
>> Default  Optional
>> Requires no additional software  Requires additional software
>> Requires no additional expertise Requires expertise with DBMS 
>> 

Re: [GNC] File Format Documentation (Bug 777893)

[Adrien Monteleone]

> On Aug 15, 2018, at 10:59 AM, David T.  wrote:
> 
>> 
>> Additionally, the comparison table might serve better with each SQL backend 
>> represented, since that’s the next question for someone contemplating that 
>> route. And in that case, sqlite does not necessarily require additional 
>> software, or expertise with a DBMS. (it’s included in the default 
>> distribution of the software on Mac and Linux, you just have to choose it on 
>> save, and you don’t really need to know how it works, unlike the other two.) 
>> Finally, perhaps presenting the table as a list of features/factors with 
>> check marks or Xs, could be easier to scan and digest.
> 
> I’ll look into this modification as well.
> 

Now that I ponder it more, perhaps your original version of the table is best 
for simplicity. Can the docs point to the wiki? In that case, maybe reference 
the SQL page instead for those who want to find more info.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation (Bug 777893)

[Adrien Monteleone]

Additional sections?

What you have here is the overview.

So perhaps sections which cover those details are in order for further reading. 
The overview though should allow someone to make a quick decision at least to 
determine if they want to investigate further or not without bogging them down 
in terminology or issues that might not pertain to them.

I’m not sure if the better organization would be sections for each of the 2 
main (and then 3 sub) backends or by issue/comparison point. The question there 
might be, “What is the next logical question after reading the overview?” But 
of course, this answer will vary. (which is why hypertext is maybe better for 
this than a static typeset document, but the info does need to be included 
somehow)

As I noted on the table suggestion, maybe the docs simply reference the 
relevant wiki pages for more reading, as they can be more easily updated and 
can easily cross link to other info.

Regards,
Adrien

> On Aug 15, 2018, at 11:42 AM, David T.  wrote:
> 
> Adrien,
> 
> As I look at implementing your suggestion of a brief comment paired with the 
> table, I encounter a problem. Specifically, many elements of comparison are 
> entirely unexplained anywhere else (indeed, this was the inspiration to take 
> this on in the first place). It seems to me that some kind of discursive 
> explanation is necessary for many of the points. For example, simply noting 
> in a table that additional software is needed for MySQL, for example, leaves 
> the question of what software to install open—never mind discussing the 
> additional responsibilities that managing a MySQL instance incurs. I am not 
> sure how to include this, if not in the text of the Guide.
> 
> While I see your point about summarizing this information, I must ask how 
> (and where) we should address these other issues? 
> 
> David
> 
>> On Aug 15, 2018, at 8:59 AM, David T. via gnucash-user 
>>  wrote:
>> 
>> Adrrien,
>> 
>> Thanks for the additional input.
>> 
>>> On Aug 14, 2018, at 11:00 PM, Adrien Monteleone 
>>>  wrote:
>>> 
>>> Are the dirty details really necessary?
>>> 
>>> I don’t see that they help the user (who may not be well versed in the 
>>> issues) to make a decision. I would think simpler in this case would be 
>>> better. If it is clear that GnuCash does not yet take full advantage of SQL 
>>> and that specifically, you can’t directly edit the db or have multi-user, I 
>>> think that gets the point across. Normalization, or the app not adhering to 
>>> an MVC type pattern aren’t going to be issues I think most people looking 
>>> at this explanation are going to be immediately concerned about. (and many 
>>> might not even know what they mean) Stephen’s suggestion seems much less 
>>> confusing overall.
>> 
>> I will leave the technical details for the wiki. Currently, there is a 
>> (rather dated) page delineating the XML format; I will create a parallel 
>> page for the SQL format(s) that can collect many of these pieces of 
>> information.
>> 
>> 
>>> 
>>> Really, a simple overview paired with the comparison table would do the 
>>> trick.
>>> 
>>> Additionally, the comparison table might serve better with each SQL backend 
>>> represented, since that’s the next question for someone contemplating that 
>>> route. And in that case, sqlite does not necessarily require additional 
>>> software, or expertise with a DBMS. (it’s included in the default 
>>> distribution of the software on Mac and Linux, you just have to choose it 
>>> on save, and you don’t really need to know how it works, unlike the other 
>>> two.) Finally, perhaps presenting the table as a list of features/factors 
>>> with check marks or Xs, could be easier to scan and digest.
>> 
>> I’ll look into this modification as well.
>> 
>>> 
>>> Regards,
>>> Adrien
>>> 
>>>> On Aug 15, 2018, at 12:09 AM, David T. via gnucash-user 
>>>>  wrote:
>>>> 
>>>> Stephen,
>>>> 
>>>> 
>>>>> On Aug 14, 2018, at 4:50 PM, Stephen M. Butler  wrote:
>>>>> 
>>>>> On 08/14/2018 04:24 PM, David T. wrote:
>>>>>> Steve,
>>>>>> 
>>>>>> Thanks for your input. I believe we’re in agreement here; I wasn’t 
>>>>>> trying to suggest that GC become a DBMS, but rather it would learn to 
>>>>>> utilize DBMS features that many seem to expect.
>>>>>> 
>>>>>> I’m not great with the appropriate t

Re: [GNC] File Format Documentation (Bug 777893)

[Adrien Monteleone]

> On Aug 15, 2018, at 12:11 PM, David T.  wrote:
> 
> 
> 
>> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone 
>>  wrote:
>> 
>> But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain 
>> text and trying to view it is going to be met with tag soup they’ve never 
>> seen before and might very well not know how to read it.
> 
> Not to mention that it’s compressed.

True, forgot about that. Certainly, they’ll see gibberish mostly.

> 
>> 
>> It also carries an .xml extension. So specifying the format is very specific 
>> and informative, even for users who aren’t familiar with XML. They’ll see in 
>> their file manager the extension, and/or the OS’s interpretation of the file 
>> type itself. (in this case both XML)
> 
> However, the file extension used is “gnucash” and not “xml”

Facepalm. I forgot about that. (I honestly rarely even look at the location 
where it’s stored anyway) I’d suspect unless Win10 uses the file descriptor for 
file type instead of the extension as was the practice through at least Win7, 
then no, those users won’t see XML anywhere. (if the descriptor is set as XML 
that is)

So I just checked on both MacOS and Ubuntu, MacOS reports the ‘Kind’ as 
‘Gnucash Document’ regardless if sqlite or xml, and at least with xml, Ubuntu 
reports the file type as ’spreadsheet’. (yes, it’s registered to open with 
GnuCash, but this was built from source, so perhaps the file type was not 
registered properly, repo versions may vary)

So I guess on that point I was way off.


> Perhaps the save process needs to be refactored to identify clearly and 
> separately the name of the data file AND its format?

Since .gnucash is not really proprietary or somehow a special format from XML 
then I agree, the extension should be .xml.

Combine this with the fact that the sqlite version of the file ALSO uses the 
.gnucash extension can make for some confusion. At a glance, you can’t tell 
what the format is. You can’t even tell until you try to open it with something 
other than GnuCash. (or you notice that GnuCash doesn’t offer a Save option) 
The only reason I know which is which is I had to use filename.xml.gnucash to 
tell them apart. That’s a usability bug in my opinion. I don’t know how hard 
that is to change, but I’d support the move.

On that note, the documentation somewhere (I suppose in the ‘file > save/save 
as’ section) should document that the extension is currently ‘.gnucash’. A new 
user shouldn’t have to go to a wiki or website FAQ after reading the 
documentation for something this basic.

Would it be out of order to include in your table that both use this extension? 
If you expand the table to show MySQL and Postgres, I suppose that row would 
have some other note since their data stores are very different than single 
files. (though in this case they might store it that way, I haven’t used either 
to know)

Regards,
Adrien


> 
>> 
>> Knowing this might very well help them find their file if they know the 
>> format they are looking for.
>> 
>> But I do agree, the documentation should cover where files are stored. 
>> Ideally, this should be made part of the Help or Guide in the Getting 
>> Started section. It is certainly a common enough issue on the list.
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 15, 2018, at 10:24 AM, Christoph R 
>>>  wrote:
>>> 
>>> Hi David,
>>> 
>>>> The default file storage format is XML
>>> 
>>> I would not call this “XML" but "plain file”. From a user perspective it is 
>>> not important in which internal format it is stored. But it makes a big 
>>> difference if it is a simple file created by Gnucash or if Gnucash needs to 
>>> connect to a DBMS.
>>> 
>>> And one of the biggest confusion for users on the mailing list is the 
>>> question: “Where is my data?”. Pointing out that all your accounts and 
>>> transactions are in a simple file might reduce that problem.
>>> 
>>> Cheers,
>>> Christoph
>>> 
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation (Bug 777893)

[Adrien Monteleone]

Roger that. Curious though if this issue should be addressed in documentation, 
or bugzilla. It’s probably a bug if the format can’t make use of them. They 
likely should not be generated at all.

Regards,
Adrien

> On Aug 15, 2018, at 7:22 PM, David T.  wrote:
> 
> 
> 
>> On Aug 15, 2018, at 1:35 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Looks pretty clear.
>> 
>> Though I’m noticing sqlite does generate log files too. Note, these are 
>> transaction replay logs from what I understand in case of a crash. As I 
>> believe John Ralls noted, any of these past the last successful save are 
>> useless. I’m not sure if this is what you are referring to by ‘Uses log 
>> files.’  I don’t know if sqlite can even utilize them at all. I’ve never had 
>> to try. You might want to get clarification on that point.
> 
> I am no expert at the SQL back ends, but I was given to understand that the 
> log files are generated regardless of the back end being used—but that for 
> the SQL back ends, they aren’t useful, since changes are written to the file 
> immediately.
> 
>> 
>> Also, I’d get clarification about the state of GnuCash sqlite on Windows. It 
>> may or may not be packaged with GnuCash by default and may or may not need 
>> some additional software. (if so, you might need a footnote) On Mac & Linux, 
>> it’s just a file format choice without any other effort.
>> 
>> Regards,
>> Adrien 
>> 
>>> On Aug 15, 2018, at 12:49 PM, David T.  wrote:
>>> 
>>> Here is a newer version of the table:
>>> 
>>> Storage Comparison Table
>>> XML SQLite  MySQL   PostgreSQL
>>> InstallationDefault Default libdbi  libdbi
>>> File extension  gnucash gnucash N/A N/A
>>> Additional software NoneNoneMySQL   PostgreSQL
>>> Additional expertiseNoneNoneDBMSDBMS 
>>> Compression Y   N   N   N
>>> Save on command Y   N   N   N
>>> Save on commit  N   Y   Y   Y
>>> Uses log files  Y   N   N   N
>>> Multi-user  N   N   N   N
>>> 
>>> How does that seem?
>>> 
>>>> On Aug 15, 2018, at 10:34 AM, Adrien Monteleone 
>>>>  wrote:
>>>> 
>>>> 
>>>> 
>>>>> On Aug 15, 2018, at 12:11 PM, David T.  wrote:
>>>>> 
>>>>> 
>>>>> 
>>>>>> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone 
>>>>>>  wrote:
>>>>>> 
>>>>>> But it’s not a ‘plain file’ as it is XML formatted. Someone expecting 
>>>>>> plain text and trying to view it is going to be met with tag soup 
>>>>>> they’ve never seen before and might very well not know how to read it.
>>>>> 
>>>>> Not to mention that it’s compressed.
>>>> 
>>>> True, forgot about that. Certainly, they’ll see gibberish mostly.
>>>> 
>>>>> 
>>>>>> 
>>>>>> It also carries an .xml extension. So specifying the format is very 
>>>>>> specific and informative, even for users who aren’t familiar with XML. 
>>>>>> They’ll see in their file manager the extension, and/or the OS’s 
>>>>>> interpretation of the file type itself. (in this case both XML)
>>>>> 
>>>>> However, the file extension used is “gnucash” and not “xml”
>>>> 
>>>> Facepalm. I forgot about that. (I honestly rarely even look at the 
>>>> location where it’s stored anyway) I’d suspect unless Win10 uses the file 
>>>> descriptor for file type instead of the extension as was the practice 
>>>> through at least Win7, then no, those users won’t see XML anywhere. (if 
>>>> the descriptor is set as XML that is)
>>>> 
>>>> So I just checked on both MacOS and Ubuntu, MacOS reports the ‘Kind’ as 
>>>> ‘Gnucash Document’ regardless if sqlite or xml, and at least with xml, 
>>>> Ubuntu reports the file type as ’spreadsheet’. (yes, it’s registered to 
>>>> open with GnuCash, but this was built from source, so perhaps the file 
>>>> type was not registered properly, repo versions may vary)
>>>> 
>>>> So I guess on that point I was way off.
>>>> 
>>>> 
>>>>> Perhaps the save process needs to be refactored to identify clearly and 
>>>>> separately the name of the data file AND its format?
>>>> 
>

Re: [GNC] File Format Documentation (Bug 777893)

[Adrien Monteleone]

As a linux user trying to use the repo version, I’ve never had to separately 
install sqlite to my recollection. Certainly, it’s part of the preps for 
building if sqlite support is intended. But even then, I don’t recall separate 
installation. It was already there when I checked. I can certainly attest that 
MacOS does not require separate installation of software.

Regards,
Adrien

> On Aug 15, 2018, at 7:37 PM, Derek Atkins  wrote:
> 
> I am a developer and Linux user.
> I have had to manually install the sqlite dbd.
> 
> -derek
> Sent using my mobile device. Please excuse any typos.
> On August 15, 2018 8:35:35 PM "David T."  wrote:
> 
>> Can a developer or linux user confirm this for me? I am neither.
>> 
>>> On Aug 15, 2018, at 5:33 PM, Derek Atkins  wrote:
>>> 
>>> Depends on the platform.
>>> On Linux the sqlite dbd may not come installed.
>>> 
>>> -derek
>>> Sent using my mobile device. Please excuse any typos.
>>> On August 15, 2018 8:20:03 PM "David T."  wrote:
>>> 
>>>> Derek,
>>>> 
>>>> I understand the point, but my intention on this is to indicate that a 
>>>> user must separately install libdbi libraries in order to use MySQL and 
>>>> PostgreSQL. As I understand it (and from personal experience) I do not 
>>>> have to perform any additional driver installations when I choose either 
>>>> XML or SQLite. Your note that SQLite is also available in Windows makes it 
>>>> a clean sweep for availability by default.
>>>> 
>>>> David
>>>> 
>>>>> On Aug 15, 2018, at 11:27 AM, Derek Atkins  wrote:
>>>>> 
>>>>> SQLite uses libdbi, too.
>>>>> 
>>>>> -derek
>>>>> 
>>>>> On Wed, August 15, 2018 1:49 pm, David T. via gnucash-user wrote:
>>>>>> Here is a newer version of the table:
>>>>>> 
>>>>>> Storage Comparison Table
>>>>>>  XML SQLite  MySQL   PostgreSQL
>>>>>> Installation Default Default libdbi  libdbi
>>>>>> File extension   gnucash gnucash N/A N/A
>>>>>> Additional software  NoneNoneMySQL   PostgreSQL
>>>>>> Additional expertise NoneNoneDBMSDBMS
>>>>>> Compression  Y   N   N   N
>>>>>> Save on command  Y   N   N   N
>>>>>> Save on commit   N   Y   Y   Y
>>>>>> Uses log files   Y   N   N   N
>>>>>> Multi-user   N   N   N   N
>>>>>> 
>>>>>> How does that seem?
>>>>>> 
>>>>>>> On Aug 15, 2018, at 10:34 AM, Adrien Monteleone
>>>>>>>  wrote:
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>>> On Aug 15, 2018, at 12:11 PM, David T.  wrote:
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>>> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone
>>>>>>>>>  wrote:
>>>>>>>>> 
>>>>>>>>> But it’s not a ‘plain file’ as it is XML formatted. Someone expecting
>>>>>>>>> plain text and trying to view it is going to be met with tag soup
>>>>>>>>> they’ve never seen before and might very well not know how to read it.
>>>>>>>> 
>>>>>>>> Not to mention that it’s compressed.
>>>>>>> 
>>>>>>> True, forgot about that. Certainly, they’ll see gibberish mostly.
>>>>>>> 
>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> It also carries an .xml extension. So specifying the format is very
>>>>>>>>> specific and informative, even for users who aren’t familiar with XML.
>>>>>>>>> They’ll see in their file manager the extension, and/or the OS’s
>>>>>>>>> interpretation of the file type itself. (in this case both XML)
>>>>>>>> 
>>>>>>>> However, the file extension used is “gnucash” and not “xml”
>>>>>>> 
>>>>>>> Facepalm. I forgot about that. (I honestly rarely even look at the
>>>>>>> location where it’s stored anyway) I’d suspect unless Win10 uses the
>>>>>>> file desc

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

[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 detail for or report on at all. (vs. the old 12 periods and that’s it) You 
can choose for example to only show August, or you can show Jan-June as 
consolidated, with July, August, and September broken out, and then Q4 
consolidated. (or any combination of periods you like or not at all) Just play 
with the settings to get a feel for it.

You can use the estimating feature when first setting up a budget to set the 
initial budget figures as averages based on prior transaction history. This is 
a nice starting point to use to populate your budget based on your actual 
spending habits.

The transfer line is for money into and out of assets and liabilities rather 
than income and expenses.

So if you budget to put say $100 in savings and $400 towards a mortgage, those 
will show up in the transfer line. (neither are income or expense)

Note, there is a bug (sorry, no bug number handy) concerning at least income 
totals for the actual column. If your invoice is dated on the first of the 
month, it will likely be counted in the prior month. I think it’s 
time-stamp/time-zone related but I have to investigate more. Other than that, 
it works reasonably well.

Note too, parts of the budget module (not all) do NOT honor the ‘reverse 
balanced accounts’ settings. So some accounts you normally may not be used to 
seeing as negative, will be negative. (I think the budget itself shows credit 
accounts as negative, but the budget report shows them as positive)

I find the budget module and report to be much more useful when used in 
combination with the transaction comparison report. If you’re trying to get a 
handle on a particular spending area discipline wise, the comparison report can 
show you the ‘direction’ you are headed, not just a variance from budgets.

Regards,

Adrien

> On Aug 13, 2018, at 10:52 PM, Christopher Lam  
> wrote:
> 
> It's customary here to keep discussions public. I don't use the budgets
> feature at all and cannot help sorry.
> 
> My preference is to implement envelope budgeting, and the inbuilt budget is
> not envelope budgeting at all.
> 
> On Tue, 14 Aug 2018, 00:08 David Tinoco  wrote:
> 
>> Hi Christopher,
>> 
>> Thanks for getting back to me. Yes, I know the basics. I have been using
>> it for about 2 years now.
>> 
>> I have really wanted to get into the budget feature but I simply cannot
>> figure it out.
>> 
>> I am trying to figure out a way to create a budget and then report on the
>> categories to show how much I have spent on an expense account compared to
>> my budget.
>> 
>> Currently, the only thing I can figure out is making a budget and then
>> separately running an expenses report.
>> 
>> But if there was a way to calculate the expenses automatically for that
>> budget it would be great. Can this be done?
>> 
>> Also, I don't understand the transfer row in the budget window and how
>> that works with accounts.
>> 
>> There are so many great features to this program--wish I could work with a
>> guru and make a bunch of videos for you guys.
>> 
>> Thanks,
>> David
>> 
>> On Mon, Aug 13, 2018 at 2:28 AM Christopher Lam 
>> wrote:
>> 
>>> Hi David
>>> 
>>> There is definitely a gap in this space. The old video
>>> https://youtu.be/aqAaScYVeRQ is still covering the basics. Perhaps you
>>> can focus on more more modern aspects?
>>> 
>>> On Thu, 9 Aug 2018, 22:18 David Tinoco  wrote:
>>> 
 I am very interested in learning the ins and outs of GnuCash.
 
 I am also a professional videographer/animator and web developer.
 
 I was wondering if there is an interest in creating video tutorials for
 the
 various aspects of GnuCash. I think this would be very useful; even if
 the
 basics were covered (accounts setup, transaction entry, budget feature,
 reports, etc.)
 
 I would be willing to undertake the videos if I could have another person
 on the team that got me through the ropes on this.
 
 Is there a need for/interest in this?
 ___
 gnucash-devel mailing list
 gnucash-de...@gnucash.org
 https://lists.gnucash.org/mailman/listinfo/gnucash-devel
 
>>> 
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC 

Re: [GNC] Reconciliation being undone without warning

[Adrien Monteleone]

Editing a reconciled transaction sets the status to ’n’. That is intended 
behavior.

Concerning the warning dialog you either told it not to warn you for the 
session, or forever. If closing and restarting GnuCash doesn’t bring back the 
warning, check the Actions > Reset Warnings dialog and you’ll see it there. You 
can check the box for it and Apply and it will show next time you edit a 
reconciled transaction.

Regards,
Adrien

> On Aug 12, 2018, at 7:19 AM, Anthony Marrian  
> wrote:
> 
> What a prat I am. Sorry: from y to n
> 
> From: Colin Law 
> Sent: 12 August 2018 11:32
> To: Anthony Marrian 
> Cc: gnucash-user 
> Subject: Re: [GNC] Reconciliation being undone without warning
> 
> On Sun, 12 Aug 2018 at 11:07, Anthony Marrian 
> mailto:anth...@gardensmontessori.com>> wrote:
> I'm running version 3.2. I reconciled a bank account to the end of July, and 
> then added voucher numbers (in the NUM column) to a number of the 
> transactions, as I have habitually done with all versions before 3. No 
> warning appeared, BUT I have just noticed when trying to reconcile July that 
> the all the transactions which had numbers added to their NUM field also had 
> their reconciliation flag moved from n to y. I imagine this behaviour is not 
> by design.
> 
> If it is now y then they are still reconciled, or do you mean they changed 
> from y to n?
> 
> Colin
> 
> 
> Best wishes - Anthony
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Tips & CSS rule for navigating the Budget window with the keyboard

[Adrien Monteleone]

While investigating bug 760194: https://bugs.gnucash.org/show_bug.cgi?id=760194


I figured this out:


With a cell in focus, enter a value. If you want to move right or left, first 
press TAB to set the value, then use left/right arrow keys to move the focus.

If you want to move up or down, simply use the up/down arrow keys after 
entering a value. (you can press TAB if you like, but it isn't necessary)

In both cases, you need to press the spacebar to begin editing a cell.

By default, the outline of the focused cell is very faint and so this process 
is difficult as it is hard to tell if you accidentally pressed TAB too many 
times and changed focus to other parts of the screen. (it seems to cycle to the 
summary bar and then the toolbar and back)

To make the focus outline more visible, add this rule to your custom css file:

.GncBudgetPage #account_tree {
  outline-color: white; /* default = rgba(50,50,50,0.3)
  outline-width: 2px; /* default = 1px
}

Play with these values as desired. You can also change these other default 
settings to your liking:

outline-offset: -3px;
outline-style: dashed;

Note, leaving off the .GncBudgetPage class will make the rule also affect the 
CoA tab since it also uses the #account_tree ID.

I’ve attempted to attach a screenshot below to illustrate the result of the CSS 
rule.

I’ll also take a look at the wiki pages to see if there’s a good place to put 
this.

Regards,
Adrien




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation (Bug 777893)

[Adrien Monteleone]

David,

Here are a few things I noticed. They’re really personal preferences, but 
making these changes should help this read a little more clearly.
--


The second sentence of 2.5.1 is superfluous.

> “The default file storage format is XML, while a number of flavors of SQL 
> storage are available.”

You immediately repeat the info with slightly more detail. I’d just leave it 
out.

The first sentence of the Storage Comparison (section number 2.5.2?) is 
repetitive.

> “As noted, GnuCash allows storage in either XML or SQL formats.”


A small correction for ’number’ agreement:

> Significant elements of the data logic ~~is~~ _are_ implemented in code, 
> rather than _the_ data structure.

The last clause “although that is one long term goal” of the following sentence 
is also repetitive:

> Consequently, use of the SQL back end does not enable simultaneous multi-user 
> access to a GnuCash file, although that is one long term goal.


I’d either drop it, and/or edit this earlier sentence:

> Use of SQL formats for storage implies to many that GnuCash is _multi-user_ 
> database management software (DBMS).


Otherwise, this looks very clear and to the point.

Regards,

Adrien

> On Aug 14, 2018, at 5:05 PM, David T. via gnucash-user 
>  wrote:
> 
> Hello,
> 
> In response to Bug 777893 (https://bugs.gnucash.org/show_bug.cgi?id=777893 
> ), I have written a more 
> detailed description of the storage choices available to users for insertion 
> into the Tutorial & Concepts Guide at section 2.5. Given the extent of the 
> text, I am including it here so that the broader community can offer 
> suggestions for improvement. Note that I will insert appropriate encoding 
> once I finalize the content.
> 
> Thanks,
> David T.
> 
> 
> Proposed text for Tutorial & Concepts Guide section 2.5
> 
> 
> 2.5 Storing your financial data
> 2.5.1 Overview
> GnuCash offers several formats for storing your financial data. The default 
> file storage format is XML, while a number of flavors of SQL storage are 
> available. Users can choose a file format from the File Save and File Save As 
> dialogs.
> The primary GnuCash storage format is an XML file. The file is by default 
> compressed with gzip, which is a preference that is set at 
> Edit→Preferences→General→Use file compression. 
> GnuCash also supports SQL storage via the DBI back end. It supports 
> PostgreSQL, MySQL and SQLite3 databases.
> 
> Storage Comparison
> As noted, GnuCash allows storage in either XML or SQL formats. Each of these 
> formats has benefits and shortcomings that the user should consider for their 
> needs and abilities. 
> The XML format is the most stable and established format, and for this 
> reason, it is the recommended format for most users. SQL storage was added 
> for the 2.4 release and has become an increasingly popular choice for users.
> Use of SQL formats for storage implies to many that GnuCash is database 
> management software (DBMS). While that is a long term goal of the development 
> team, GnuCash as currently designed is not DBMS. It is a financial 
> application that can store its data in SQL files.
> Many features that users of DBMS expect from a DBMS are not implemented in 
> GnuCash. The GnuCash data schema is not normalized. Significant elements of 
> the data logic is implemented in code, rather than data structure.
> Gnucash uses the SQL back end to load the entire data store into memory in 
> the same manner as the XML back end. Consequently, use of the SQL back end 
> does not enable simultaneous multi-user access to a GnuCash file, although 
> that is one long term goal.
> One benefit of the SQL back end is that it saves changes incrementally, and 
> every change is committed to the back end as it happens. This is in contrast 
> to the XML back end, which only writes to the data file when the user invokes 
> the Save command. 
> The SQL back end does allow users with SQL experience to write queries 
> against the data to create custom reports without using Gnucash’s internal 
> report system. It is important to note that modification of GnuCash data 
> using external access modes is strongly discouraged by the development team, 
> and damages to a GnuCash data file that result from such modifications are 
> strictly the responsibility of the user.
> 
> Storage Comparison Table
> 
> XML   SQL
> Default   Optional
> Requires no additional software   Requires additional software
> Requires no additional expertise  Requires expertise with DBMS 
> CompressedUncompressed
> Save on command   Save on commit
> Uses log filesDoes not use log files
> Not multi-userNot multi-user
> Limited 

Re: [GNC] Disconnect between balance on client list and account statement

[Adrien Monteleone]

ing terms and reports and in Spanish so I’m guessing at what the names 
> are in English. I couldn’t figure out which report was the aging report 
> because of that. The best I can guess is the following:
>  
> Previsión de Clientes = Customer overview
> Estado de cliente = Customer Report 
> Calendario de cobros pendientes = Receivable aging 
>  
> This last may or may not be the receivable aging report. They are not in the 
> same order on the menu. 
>  
> I tracked down an open invoice that had not been paid. Somehow in the switch 
> to GnuCash from Quicken we missed a payment. Posting a payment to a current 
> asset cash/checking account would have messed up those balances. 
> Nevertheless, that is what I did by accident. 
>  
> I moved that payment elsewhere, to an income/returns account so it would not 
> effect the cash balances. That fixed the balance on the Customer Overview but 
> left a credit balance on the Customer Report. The calendario de cobros 
> pendients (Receivable aging?) report shows the customer with the same credit 
> balance as the Customer Report/Estado de Cliente even though the Customer 
> overview shows the correct balance. 
>  
> I had tried this before with the same result. I even tried issuing a credit 
> note using it to pay the open invoice and got the same result. Either the 
> Customer Overview shows the correct balance or the Customer Report shows the 
> correct balance but I can’t get them to match. All the other customers match. 
> I’m missing something but can’t figure it out for the life of me.
>  
> Thanks for the effort,
> Roger
>  
> Message: 8
> Date: Tue, 14 Aug 2018 20:30:31 -0500
> From: Adrien Monteleone 
> To: Gnucash Users 
> Subject: Re: [GNC] Disconnect between balance on client list and
> account statement
> Message-ID: <91a3e255-86da-47db-92ee-528ec976b...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
>  
> I think this is fixable. You should not need to create a new customer account.
>  
> By ?Customer Statement? I?m presuming you mean the ?Customer Report? correct?
>  
> If so, change the dates to reflect the entire time she?s been a customer. If 
> everything is paid and there are no remaining pre-payments (deposits) it 
> should balance to zero. You can check for remaining deposits by trying to 
> Process Payment on her account. If any pre-payment still shows up, then it 
> has not been applied. (same with any invoices that show up)
>  
> Now, run a Reports > Business > Receivable Aging report. It should show she 
> has a zero balance. If not, double check the options to make sure the ?To? 
> date matches the end date of the Customer Report. (usually ?Today?) These 
> numbers *should* match what is shown on the Customer Overview Balance column.
>  
> If when these dates match, you still have non-zero balances, then there are 
> one or more invoices posted for her that aren?t paid. You?ll have to track 
> them down. Do an invoice find with her as the customer and check them all to 
> make sure they are paid. (one possibility is you might have a duplicate 
> somewhere.)
>  
> If the balances are zero when the dates match, but non-zero when you extend 
> the ?to? past ?today? then you?ve posted a future invoice to her account and 
> your report option for the Aging Report (and possibly the overview does this 
> as well) is set to that later date. She might be current ?today? but based on 
> what is posted, does (or will) owe $1500.
>  
> So the end result is there is likely a misapplied payment or not-applied 
> payment, or a future dated invoice. If you posted and un-posted an invoice, 
> it is possible the payment was not successfully re-applied and you need to 
> re-associate it to the proper invoice.
>  
> Regards,
> Adrien
>  
> > On Aug 14, 2018, at 7:38 PM,   wrote:
> > 
> > I have a customer who ended the last fiscal year (school year) with a zero
> > balance owed but still shows owing $1500 in the customer overview but her
> > statement shows zero balance. I use the customer overview to manage overdue
> > accounts by sorting according to the balance due. In her case it should be
> > zero but isn't. If I give her a credit note the customer overview will show
> > the correct amount but the statement will be off by the same amount. She
> > paid ahead last year and I posted the total amount she paid against the
> > invoice due at that time leaving a balance in her favor. I paid each
> > following invoice with the credit balance. In every other case this works
> > perfectly. 
> > 
> > 
> > 
> > I can't find where the error is or how to correct it.  If I can't figure out
> > how to correct

Re: [GNC] File Format Documentation (Bug 777893)

[Adrien Monteleone]

Are the dirty details really necessary?

I don’t see that they help the user (who may not be well versed in the issues) 
to make a decision. I would think simpler in this case would be better. If it 
is clear that GnuCash does not yet take full advantage of SQL and that 
specifically, you can’t directly edit the db or have multi-user, I think that 
gets the point across. Normalization, or the app not adhering to an MVC type 
pattern aren’t going to be issues I think most people looking at this 
explanation are going to be immediately concerned about. (and many might not 
even know what they mean) Stephen’s suggestion seems much less confusing 
overall.

Really, a simple overview paired with the comparison table would do the trick.

Additionally, the comparison table might serve better with each SQL backend 
represented, since that’s the next question for someone contemplating that 
route. And in that case, sqlite does not necessarily require additional 
software, or expertise with a DBMS. (it’s included in the default distribution 
of the software on Mac and Linux, you just have to choose it on save, and you 
don’t really need to know how it works, unlike the other two.) Finally, perhaps 
presenting the table as a list of features/factors with check marks or Xs, 
could be easier to scan and digest.

Regards,
Adrien

> On Aug 15, 2018, at 12:09 AM, David T. via gnucash-user 
>  wrote:
> 
> Stephen,
> 
> 
>> On Aug 14, 2018, at 4:50 PM, Stephen M. Butler  wrote:
>> 
>> On 08/14/2018 04:24 PM, David T. wrote:
>>> Steve,
>>> 
>>> Thanks for your input. I believe we’re in agreement here; I wasn’t trying 
>>> to suggest that GC become a DBMS, but rather it would learn to utilize DBMS 
>>> features that many seem to expect.
>>> 
>>> I’m not great with the appropriate terminology to use. Do you have language 
>>> I could use that would more accurately reflect the direction that GC is 
>>> headed?
>>> 
>>> David
>> 
>> I hoped as much.  Let's take this pair of sentences:
>> 
>> Use of SQL formats for storage implies to many that GnuCash is database 
>> management software (DBMS). While that is a long term goal of the 
>> development team, GnuCash as currently designed is not DBMS.
>> 
>> And change them to this:
>> 
>> Use of a SQL back-end engine for storage implies to many that GnuCash
>> has fully implemented DBMS features including multi-user and incremental
>> data manipulation.  That is a long-term goal of the development team. 
>> However GnuCash does not currently implement these features.
>> 
> 
> This is great; I will use it.
> 
>> Then I think this next section can disappear entirely:
>> 
>> Many features that users of DBMS expect from a DBMS are not implemented in 
>> GnuCash. The GnuCash data schema is not normalized. Significant elements of 
>> the data logic is implemented in code, rather than data structure.
>> Gnucash uses the SQL back end to load the entire data store into memory in 
>> the same manner as the XML back end. Consequently, use of the SQL back end 
>> does not enable simultaneous multi-user access to a GnuCash file, although 
>> that is one long term goal.
>> 
> 
> I’m not sure I want to remove these comments, as they are issues of 
> significance that have come up on the lists over the years. How about this:
> 
> The GnuCash data schema is not normalized. Moreover, significant elements of 
> the data logic is implemented in code, rather than data structure. Finally, 
> Gnucash uses the SQL back end to load the entire data store into memory in 
> the same manner as the XML back end. Consequently, use of the SQL back end 
> does not enable simultaneous multi-user access to a GnuCash file.
> 
>> 
>> And I will change this piece:
>> 
>> One benefit of the SQL back end is that it saves changes incrementally, and 
>> every change is committed to the back end as it happens. This is in contrast 
>> to the XML back end, which only writes to the data file when the user 
>> invokes the Save command.
>> 
>> To say:
>> One benefit of the SQL back end is that it saves changes to the back end as 
>> they happen. This is in contrast to the XML back end, which only writes to 
>> the data file when the user invokes the Save command. 
> 
> How about:
> One benefit of the SQL back end is that it commits changes to the file 
> immediately. This is in contrast to the XML back end, which only writes to 
> the data file when the user invokes the Save command.
> 
> The final result for this section is this:
> ———  
> Use of a SQL back-end engine for storage implies to many that GnuCash has 
> fully implemented DBMS features including multi-user and incremental data 
> manipulation.  That is a long-term goal of the development team. However 
> GnuCash does not currently implement these features.
> The GnuCash data schema is not normalized. Moreover, significant elements of 
> the data logic is implemented in code, rather than data structure. Finally, 
> Gnucash uses the SQL back end to load the entire 

Re: [GNC] File Format Documentation, v. 2

[Adrien Monteleone]

Looks good to me.

Regards,
Adrien

> On Aug 16, 2018, at 3:00 PM, David T. via gnucash-user 
>  wrote:
> 
> I’ve attempted to incorporate the suggestions that others have made for the 
> section on file storage formats, and I attach the resulting version 2 for 
> further consideration. Keep in mind that this is not meant to be an 
> encyclopedic coverage of the topic; it’s meant to outline the choices. I 
> expect further detail to reside on the wiki, or be placed in other places in 
> the documentation.
> 
> Cheers,
> David
> 
> P.S. The table layout doesn’t come through, but will be in the final version…
> 
> 
> 
> 
> 2.5 Storing your financial data
> 2.5.1 Overview
> GnuCash offers several formats for storing your financial data. The default 
> file storage format is XML, while SQL storage is available in SQLite, MySQL, 
> and PostgreSQL formats. Users can choose a file format from the File→Save and 
> File→Save As dialogs.
> The XML storage format is a text file that is compressed with gzip, which is 
> a preference that is set at Edit→Preferences→General→Use file compression. 
> SQL storage is available via the DBI back end; use of MySQL and PostgreSQL 
> requires installation of those DBMS packages as well as additional DBI 
> drivers.
> Note: users can change the format at any time by using File→Save As. This 
> will create a copy of the data file in the selected format.
> 
> Storage Comparison
> Each storage format has benefits and shortcomings that the user should 
> consider for their needs and abilities. See the Storage Comparison Table 
> below for further details.
> The XML format is the most stable and established, and for this reason, it is 
> recommended for most users. SQL storage was added for the 2.4 release and has 
> become an increasingly popular choice for users, but can require experience 
> with DBMS applications.
> Note: Use of a SQL back end for storage implies to many that GnuCash has 
> fully implemented DBMS features, including multi-user and incremental data 
> manipulation.  However, GnuCash does not currently implement these features, 
> although it is a long term goal of the development team. 
> 
> Storage Comparison Table
> 
>   
> XML
> SQLite
> MySQL
> PostgreSQL
> Installation
> Default
> libdbi - 1
> libdbi
> libdbi
> File extension
> gnucash
> gnucash
> N/A - 2
> N/A - 2
> Additional software
> None
> None
> MySQL
> PostgreSQL
> Additional expertise 
> None
> None
> DBMS
> DBMS
> Compression
> Y
> N
> N
> N
> Save on command
> Y
> N
> N
> N
> Save on commit
> N
> Y
> Y
> Y
> Uses log files
> Y
> N
> N
> N
> Multi-user
> N
> N
> N
> N
> 
> 1 - SQLite relies on libdbi, but is available by default on Mac OS and 
> Windows. Linux users may need to manually install libdbi drivers for SQLite.
> 2 - MySQL and PostgreSQL place data in their own storage.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation, v. 2

[Adrien Monteleone]

I thought that’s what his chart did. (though it may not format correctly in the 
previous reply)

The default is XML.

Regards,
Adrien

> On Aug 16, 2018, at 8:51 PM, John C  wrote:
> 
> Please tell the reader the default file format right after installation.
> 
> regards,
> John
> 
> On 8/16/2018 5:06 PM, Adrien Monteleone wrote:
>> Looks good to me.
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 16, 2018, at 3:00 PM, David T. via gnucash-user 
>>>  wrote:
>>> 
>>> I’ve attempted to incorporate the suggestions that others have made for the 
>>> section on file storage formats, and I attach the resulting version 2 for 
>>> further consideration. Keep in mind that this is not meant to be an 
>>> encyclopedic coverage of the topic; it’s meant to outline the choices. I 
>>> expect further detail to reside on the wiki, or be placed in other places 
>>> in the documentation.
>>> 
>>> Cheers,
>>> David
>>> 
>>> P.S. The table layout doesn’t come through, but will be in the final 
>>> version…
>>> 
>>> 
>>> 
>>> 
>>> 2.5 Storing your financial data
>>> 2.5.1 Overview
>>> GnuCash offers several formats for storing your financial data. The default 
>>> file storage format is XML, while SQL storage is available in SQLite, 
>>> MySQL, and PostgreSQL formats. Users can choose a file format from the 
>>> File→Save and File→Save As dialogs.
>>> The XML storage format is a text file that is compressed with gzip, which 
>>> is a preference that is set at Edit→Preferences→General→Use file 
>>> compression. SQL storage is available via the DBI back end; use of MySQL 
>>> and PostgreSQL requires installation of those DBMS packages as well as 
>>> additional DBI drivers.
>>> Note: users can change the format at any time by using File→Save As. This 
>>> will create a copy of the data file in the selected format.
>>> 
>>> Storage Comparison
>>> Each storage format has benefits and shortcomings that the user should 
>>> consider for their needs and abilities. See the Storage Comparison Table 
>>> below for further details.
>>> The XML format is the most stable and established, and for this reason, it 
>>> is recommended for most users. SQL storage was added for the 2.4 release 
>>> and has become an increasingly popular choice for users, but can require 
>>> experience with DBMS applications.
>>> Note: Use of a SQL back end for storage implies to many that GnuCash has 
>>> fully implemented DBMS features, including multi-user and incremental data 
>>> manipulation.  However, GnuCash does not currently implement these 
>>> features, although it is a long term goal of the development team.
>>> 
>>> Storage Comparison Table
>>> 
>>> 
>>> XML
>>> SQLite
>>> MySQL
>>> PostgreSQL
>>> Installation
>>> Default
>>> libdbi - 1
>>> libdbi
>>> libdbi
>>> File extension
>>> gnucash
>>> gnucash
>>> N/A - 2
>>> N/A - 2
>>> Additional software
>>> None
>>> None
>>> MySQL
>>> PostgreSQL
>>> Additional expertise
>>> None
>>> None
>>> DBMS
>>> DBMS
>>> Compression
>>> Y
>>> N
>>> N
>>> N
>>> Save on command
>>> Y
>>> N
>>> N
>>> N
>>> Save on commit
>>> N
>>> Y
>>> Y
>>> Y
>>> Uses log files
>>> Y
>>> N
>>> N
>>> N
>>> Multi-user
>>> N
>>> N
>>> N
>>> N
>>> 
>>> 1 - SQLite relies on libdbi, but is available by default on Mac OS and 
>>> Windows. Linux users may need to manually install libdbi drivers for SQLite.
>>> 2 - MySQL and PostgreSQL place data in their own storage.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> _

Re: [GNC] Cannot change preferences

[Adrien Monteleone]

Ken, always use reply-all or reply-to-list so that others can participate in 
the conversation and offer assistance.

I can’t get to the specifics at the moment for the preference permissions 
issue, but maybe someone else can in the interim.

Your preferences I think should be stored in ~/.gnucash or a .gnucash directory 
that is a sub of ~/.config or ~/.local. (I don’t recall exactly) The FAQ on the 
website should have the details of where this is stored. (this changed recently 
with version 3.0, so be certain you are referencing info for the version you 
have installed)

Regards,
Adrien

> On Aug 16, 2018, at 6:49 PM, Ken Heard  wrote:
> 
> Adrien,
> 
> Thank you for your reply.  It arrived in my inbox just before I left Canada 
> for France.  I returned to Canada yesterday and saw it for the first time 
> today.
> 
> On 2018-07-26 02:11, Adrien Monteleone wrote:
>> Ken,
>> Sorry, I saw this when you originally posted it (twice) but wasn’t able to 
>> reply at the time and I see you haven’t heard from anyone yet.
>> Although seemingly unhelpful, the error message is telling you how to fix 
>> the problem.
>> Apparently, after changing the separator to a backslash “\” (which is also a 
>> file path separator in Windows, not a safe choice!) you named about 50 
>> accounts to include the old path separator “:” as part of the actual name. 
>> If you re-institute the “:” as path separator, GnuCash is going to freak out 
>> because it will appear you have a bunch of new accounts that don’t exist 
>> yet. (and likely attempt at some point to get you to create them as you 
>> tab/enter through transactions, if not just totally blow up or freeze as it 
>> seems to have done.)
>> The solution is to FIRST, change all of your accounts names to NOT use “:” 
>> in the name itself, perhaps substituting hyphen “-“ or something reasonably 
>> similar. (Commas are unsafe choices also due to CSV import/export issues 
>> with various software - you don’t want to deal with comma delimited files if 
>> fields contain commas themselves unless specially handled)
> 
> Yes, today I did remove all the colons in the names and codes of my account 
> which had them.  Now when I open GnuCash the list of account names and codes 
> does not appear.  I still however have another problem, see below.
> 
>> Once you’ve eliminated all instances of “:” in your account names, then the 
>> error/warning won’t appear and you can change the account separator back to 
>> it.
>> As long as you stick to a single OS, you can choose to use either \, or / 
>> accordingly for separators, but commas are usually bad news. (Windows uses 
>> backslashes for file paths and *nix uses backslashes) Pipes and periods even 
>> can be an issue, though more rarely so. (Pipes redirect output and periods 
>> are usually extension separators, but this only an issue in Windows)
> 
> I only use Linux, currently the Stretch iteration of Debian; so I would use 
> only the backslash.  For the reason which you state using a slash -- or pipes 
> or periods -- is not wise.  I think that if I were to abandon the colon -- 
> which I may not do in any event -- I would use the tilde, single or double.  
> I would never use those symbols in an account name or code.
> 
>> That really limits things a bit. But you can likely safely use hyphen “-“, 
>> underscore”_”, semi-colon “;”, tilde “~”, middle dot “•”, small middle dot 
>> “·”, double left arrow “«”, double right arrow “»”, equivalent “≈”, diamond 
>> “◊”, en-dash “–“, and em-dash “—“. (those last two are sometimes 
>> indistinguishable from each other or even from hyphen in some fonts)
>> On that note, while you’re replacing your copious use of “:” as part of 
>> account names, consider hyphens “-“ and underscores “_” as replacements. 
>> Some coding conventions use underscores to separate words—e.g., “camel_case” 
>> instead of "camelCase", and hyphens to indicated sub-levels or more specific 
>> information—e.g., “Rent-Apartment_A” and "Rent-Apartment_B".
>> I too experimented with other separators, but found the colon to be a well 
>> thought out default as it is easy to quickly step through the account 
>> hierarchy one letter and colon at a time. Other choices are farther away and 
>> harder to tap easily. (some of the above suggestions require 3rd & 4th level 
>> modifier keys) Also, muscle memory is a consideration.
>> Regards,
>> Adrien
> 
> Now the other problem I referred to above, and which I also mentioned in my 
> original post, is that I cannot change GnuCash preferences.  I think I am not 
> mistaken in assuming that the file containing

Re: [GNC] 3.2 and missing colors on accounts page

[Adrien Monteleone]

Look under Preferences > Accounts > Account Colors. (at the bottom) One 
preference controls the tab, one the background on the CoA.

There was a discussion about also coloring the register itself with a generated 
palette based on the account color, but I don’t think it went too far.

Regards,
Adrien

> On Aug 16, 2018, at 11:18 AM, Tim Kallmer  wrote:
> 
> After I upgraded to 3.2 from 2.8 and 2.6, I notice there are no longer
> account colors shown on the accounts page. Is this by design or is there a
> way to bring that back? I couldn't find it in settings. I miss being able
> to color code my accounts. I realize the tab is colored when I open a
> register.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Format Documentation, v. 2

[Adrien Monteleone]

I would think that is a ‘mileage varies’ sort of issue based on your computer 
specs and in the case of remote access, network latency, which is variable for 
anyone. I don’t think a hard comparison is possible as a generalized statement, 
there are just too many variables.

If you’re looking for personal anecdotes, I prefer sqlite3 over xml on MacOS, 
but that’s for the ability to query the db. I suppose it performs equally well 
best I can tell. I never shut the app down save for rare occasion or 
experimentation, so I can’t attest to load times.

Regards,
Adrien

> On Aug 16, 2018, at 10:19 PM, MycoGeo  wrote:
> 
> Do people have experience with different load/save times with the different 
> formats?
> 
> A long while back, I experimented with storing gnucash data on a MySQL server 
> on a NAS, so it was over the LAN.  I didn’t find the save/load times 
> different than saving/loading from the compressed XML format on the local 
> machine.
> 
> Gnucash 2.x.16
> Windows 10
> 
> 
> Sent from my iPad
> 
>> On Aug 16, 2018, at 7:20 PM, David T. via gnucash-user 
>>  wrote:
>> 
>> John, 
>> I don't understand your statement. 
>> Insofar as a user might open the Guide immediately after installation (I'm 
>> not that self-aggrandizing as that), they would see in the second sentence 
>> of this section that xml is the default file format. 
>> Or did you have some other concern? 
>> David
>> 
>> 
>> 
>> On Thu, Aug 16, 2018 at 18:53, John C wrote:   Please tell 
>> the reader the default file format right after installation.
>> 
>> regards,
>> John
>> 
>>> On 8/16/2018 5:06 PM, Adrien Monteleone wrote:
>>> Looks good to me.
>>> 
>>> Regards,
>>> Adrien
>>> 
>>>> On Aug 16, 2018, at 3:00 PM, David T. via gnucash-user 
>>>>  wrote:
>>>> 
>>>> I’ve attempted to incorporate the suggestions that others have made for 
>>>> the section on file storage formats, and I attach the resulting version 2 
>>>> for further consideration. Keep in mind that this is not meant to be an 
>>>> encyclopedic coverage of the topic; it’s meant to outline the choices. I 
>>>> expect further detail to reside on the wiki, or be placed in other places 
>>>> in the documentation.
>>>> 
>>>> Cheers,
>>>> David
>>>> 
>>>> P.S. The table layout doesn’t come through, but will be in the final 
>>>> version…
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 2.5 Storing your financial data
>>>> 2.5.1 Overview
>>>> GnuCash offers several formats for storing your financial data. The 
>>>> default file storage format is XML, while SQL storage is available in 
>>>> SQLite, MySQL, and PostgreSQL formats. Users can choose a file format from 
>>>> the File→Save and File→Save As dialogs.
>>>> The XML storage format is a text file that is compressed with gzip, which 
>>>> is a preference that is set at Edit→Preferences→General→Use file 
>>>> compression. SQL storage is available via the DBI back end; use of MySQL 
>>>> and PostgreSQL requires installation of those DBMS packages as well as 
>>>> additional DBI drivers.
>>>> Note: users can change the format at any time by using File→Save As. This 
>>>> will create a copy of the data file in the selected format.
>>>> 
>>>> Storage Comparison
>>>> Each storage format has benefits and shortcomings that the user should 
>>>> consider for their needs and abilities. See the Storage Comparison Table 
>>>> below for further details.
>>>> The XML format is the most stable and established, and for this reason, it 
>>>> is recommended for most users. SQL stora
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 3.2 and missing colors on accounts page

[Adrien Monteleone]

I thought so too and almost replied to that effect, but it works for me using 
3.2 on MacOS. (I don’t normally use it, but I just turned it back on to test 
for my earlier reply)

Regards,
Adrien

> On Aug 16, 2018, at 10:38 PM, David Carlson  
> wrote:
> 
> That was broken in some of the early beta releases.  Has it been fixed?
> 
> David  C
> 
> On Thu, Aug 16, 2018, 5:14 PM Adrien Monteleone 
>  wrote:
> Look under Preferences > Accounts > Account Colors. (at the bottom) One 
> preference controls the tab, one the background on the CoA.
> 
> There was a discussion about also coloring the register itself with a 
> generated palette based on the account color, but I don’t think it went too 
> far.
> 
> Regards,
> Adrien
> 
> > On Aug 16, 2018, at 11:18 AM, Tim Kallmer  wrote:
> > 
> > After I upgraded to 3.2 from 2.8 and 2.6, I notice there are no longer
> > account colors shown on the accounts page. Is this by design or is there a
> > way to bring that back? I couldn't find it in settings. I miss being able
> > to color code my accounts. I realize the tab is colored when I open a
> > register.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

I don’t see anything that will allow a text/font rule as I suspected. (not yet 
anyway)

But I managed to shrink the bar somewhat with negative margins like so:

frame {
  margin-top: -10px;
  margin-bottom: -10px;
}

Give that a shot and play around with it to your liking.

Regards,
Adrien

> On Aug 7, 2018, at 3:21 AM, Peter Jackson  wrote:
> 
> Thanks, but remember that I know nothing.
> How do you suggest I write this for intance to change height to add to the 
> css?
> Regards
> pj
> 
> 
> 
> On 7 August 2018 at 09:03, Adrien Monteleone  
> wrote:
> Certainly,
> 
> I see there is a GtkStatusBar (name=“GtkStatusBar”). You can try that. It 
> seems to be for the entire bar. (likely you can style colors, padding and 
> margins here)
> 
> It contains GtkFrame (name=“frame”) and GtkProgressBar as children.
> 
> The frame contains a GtkBox (name=“message_area”) which also contains a 
> GtkLabel (name=“label”) The text/font rules will likely have to apply to 
> either the label directly or the GtkBox#message_area.
> 
> Regards,
> Adrien
> 
> 
> > On Aug 7, 2018, at 2:51 AM, Peter Jackson  wrote:
> > 
> > One question before I retire.
> > Can you tell me how I address the Status Bar at the foot of the Gnucash 
> > window? Specifically the bar that shows Date last opened.
> > I would like to reduce the height of said bar.
> > Regards
> > pj
> > 
> > On 7 August 2018 at 08:31, Adrien Monteleone 
> >  wrote:
> > The linked message was my first attachment attempt. (I think it’s my ISP 
> > stripping them off) The first image on the imgur link is it.
> > 
> > I’m not sure what you mean by child element in front.
> > 
> > Do you mean the small space to the left of the bar? (and also slightly 
> > surrounding it) I referenced that way back when we were looking at the 
> > #account_tree header.
> > 
> > It’s .GncAccountPage that handles it. I tested that one. It didn’t affect 
> > the summary bar for me at all. I had to use a rule with .summary-bar to do 
> > so.
> > 
> > Regards,
> > Adrien
> > 
> > 
> > 
> > > On Aug 6, 2018, at 11:28 PM, GT-I9070 H  wrote:
> > > 
> > > .GncAccountPage {
> > > }
> > > 
> > > and
> > > 
> > > .summary-bar {
> > > }
> > > 
> > > affects the summary bar, but has a child element in front.
> > > What is this element?
> > > 
> > > The attached image you said here 
> > > (https://lists.gnucash.org/pipermail/gnucash-user/2018-August/078745.html)
> > >  did not come, could you put the link to it too? Or do not need this?
> > > 
> > > 
> > > Regards
> > > GTI
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Certainly,

I see there is a GtkStatusBar (name=“GtkStatusBar”). You can try that. It seems 
to be for the entire bar. (likely you can style colors, padding and margins 
here)

It contains GtkFrame (name=“frame”) and GtkProgressBar as children.

The frame contains a GtkBox (name=“message_area”) which also contains a 
GtkLabel (name=“label”) The text/font rules will likely have to apply to either 
the label directly or the GtkBox#message_area.

Regards,
Adrien


> On Aug 7, 2018, at 2:51 AM, Peter Jackson  wrote:
> 
> One question before I retire.
> Can you tell me how I address the Status Bar at the foot of the Gnucash 
> window? Specifically the bar that shows Date last opened.
> I would like to reduce the height of said bar.
> Regards
> pj
> 
> On 7 August 2018 at 08:31, Adrien Monteleone  
> wrote:
> The linked message was my first attachment attempt. (I think it’s my ISP 
> stripping them off) The first image on the imgur link is it.
> 
> I’m not sure what you mean by child element in front.
> 
> Do you mean the small space to the left of the bar? (and also slightly 
> surrounding it) I referenced that way back when we were looking at the 
> #account_tree header.
> 
> It’s .GncAccountPage that handles it. I tested that one. It didn’t affect the 
> summary bar for me at all. I had to use a rule with .summary-bar to do so.
> 
> Regards,
> Adrien
> 
> 
> 
> > On Aug 6, 2018, at 11:28 PM, GT-I9070 H  wrote:
> > 
> > .GncAccountPage {
> > }
> > 
> > and
> > 
> > .summary-bar {
> > }
> > 
> > affects the summary bar, but has a child element in front.
> > What is this element?
> > 
> > The attached image you said here 
> > (https://lists.gnucash.org/pipermail/gnucash-user/2018-August/078745.html) 
> > did not come, could you put the link to it too? Or do not need this?
> > 
> > 
> > Regards
> > GTI
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

I’m not sure. I’ve seen and even sent attachments in the past. So I know they 
are possible. It might be a size issue. I’ll see about cropping as much as 
possible and resending.

Regards,
Adrien

> On Aug 6, 2018, at 2:35 AM, Peter Jackson  wrote:
> 
> Adrien, still no joy.
> Is this why?
> https://support.tigertech.net/mailman-attachments
> pj
> 
> 
> 
> On 6 August 2018 at 08:03, Adrien Monteleone  
> wrote:
> Twice, but it seems Mailman doesn’t like png, so here it is again in jpg.
> 
> Regards,
> Adrien
> 
> 
> > On Aug 6, 2018, at 12:27 AM, Peter Jackson  wrote:
> > 
> > Thanks Adrien, but did you attach the attachment?
> > 
> > Peter
> > 
> > 
> > 
> > On 6 August 2018 at 06:09, Adrien Monteleone 
> >  wrote:
> > I realized Mail.app shrunk the attachment. Here it is again, hopefully more 
> > readable.
> > 
> > Regards,
> > Adrien
> > 
> > 
> > > On Aug 6, 2018, at 12:08 AM, Adrien Monteleone 
> > >  wrote:
> > > 
> > > The Summary/Totals bar can appear at the top or bottom of the CoA window 
> > > depending on a preference setting. It shows a Grand Total, Net Assets & 
> > > Profit line summary for the entire book on a running basis. (I presume 
> > > the Profit at least would reset if you use the ‘close book’ function, but 
> > > since I don’t, I’m not certain)
> > > 
> > > If you want to style it, I’ve attached a screenshot of the node tree. 
> > > Sorry the text is so small, I haven’t yet figured out how to enlarge it. 
> > > (the entire app and inspector seem to scale to a small font) If you can’t 
> > > manage to enlarge the screenshot enough to read it, let me know and I’ll 
> > > see what I can do.
> > > 
> > > Note, you should probably preface any styling for the bar (and labels) 
> > > with the .GncAccountPage class to avoid bringing the styling elsewhere. 
> > > (unless that’s what you want)
> > > 
> > > The bar also has a class .summary-bar as you can see that you might use 
> > > for specificity. So a rule like so:
> > > 
> > > .GncAccountPage .summary-bar {}
> > > 
> > > might do the trick. (though you may need to specify children elements or 
> > > classes here)
> > > 
> > > For me, the tabs follow the main page. So the first GtkBox is the main 
> > > page, the later GtkBox siblings are my tabs in order. They are all 
> > > children of GtkNotebook so if your styling is bleeding through elsewhere, 
> > > perhaps use child and sibling selectors to narrow the rule down.
> > > 
> > > Regards,
> > > Adrien
> > > 
> > > 
> > > 
> > > 
> > > 
> > >> On Aug 5, 2018, at 5:24 PM, GT-I9070 H  wrote:
> > >> 
> > >> Em dom, 5 de ago de 2018 às 06:20, Peter Jackson 
> > >> escreveu:
> > >> 
> > >>> I am keen to reduce the screen real estate occupied by The Totals Bar 
> > >>> and
> > >>> the Summary Bar, and to customise them.
> > >>> 
> > >> 
> > >> What is the Totals Bar that you refer to? The ones on the bottom in the
> > >> records sheets?
> > >> 
> > >> 
> > >> Regards
> > >> GTI
> > >> ___
> > >> gnucash-user mailing list
> > >> gnucash-user@gnucash.org
> > >> To update your subscription preferences or to unsubscribe:
> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >> If you are using Nabble or Gmane, please see 
> > >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > >> -
> > >> 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
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Peter & GTI,

How familiar are you with CSS for the web?

If not very much, it would help tremendously to do some tutorials online on how 
that works.

Gtk CSS follows some of the same rules, but not in exactly the same way. The 
basic principles are the same however.

The screenshots are showing you the Gtk version of a ‘DOM tree’ which is a tree 
of the HTML elements on a web page that you can style.

The app’s window is the main node in the tree. Each major element in that 
window will be a child element and so on. Nodes of type GtkBox seem to be 
widely used and are probably analogous to HTML’s  elements as generic 
blocks.

The Classes column will allow you to target multiple items in multiple places. 
(if they have that class assigned to them) This would be like a rule for 
footnotes such as ‘p.footnote {}’ or just ‘.footnote {}’

The Name column is analogous to ‘id’ in HTML. So you can target a very specific 
element—e.g., ‘div#main_nav {}’ or just ‘#main_nav {}) especially since there 
can be only one of each id on a page. (HTML also uses ’name’ and it is I think 
interchangeable with ‘id’ and I believe ‘id’ is being deprecated in favor of 
’name’)

Otherwise, you use the node types like GtkBox and Gtklabel similar to how you 
would style  or  HTML elements.

If you want to target a generic node type or widely used class for an element, 
but only on a certain page (tab) then you need to preface this rule with the 
class or id for that tab—e.g., '.GncRegisterPage’ as the first selector in a 
rule that you want to ONLY apply on register pages, but ‘#account-tree’ id for 
rules you only want to apply on the CoA page. (if the CoA had a specific class 
to target, you could use that, but the devs chose to name it instead, the 
reverse for the GncRegisterPage, but that’s probably because there is only one 
CoA but you can have multiple registers open at once)

If there are no other general methods, you might have to get very specific and 
use one or more of the child selectors. So '.GncRegisterPage > GtkBox {}' will 
target a GtkBox element that is a direct descendent (child) of any element with 
the class ‘.GncRegisterPage’. If you don’t use the ‘>’ selector, then the rule 
would apply to ANY descendent (even grandchildren and beyond) that is of type 
GtkBox.

The major issue I’ve discovered in this thread per John Rall’s comment last 
week was that Gtk CSS is not like Web CSS. On the web, if your rule CAN be 
implemented, it will, even if the browser has to guess or extrapolate the 
result. But for Gtk, either you get it exactly right, or you see no change. 
Compound this with not every element can have every property altered (and there 
doesn’t seem to be a list of what is implemented yet) and most of it becomes a 
guessing game of trial and error. (with the Web, you can set a font property on 
a div, not just the  elements within it. But it seems with Gtk, you can only 
adjust font properties on ‘label’ and not the ‘button’ or ‘GtkBox’ which 
contains the labels)

Since you are both using Windows, your path is not as easy. I don’t see any 
helpful info on using GtkInspector on Windows even though you have Gtk 
installed there via GnuCash. There are ways to install Gtk directly by itself, 
but this will most likely involve the Windows Subsystem for Linux, and maybe 
even running GnuCash in that same subsystem since it’s a sandbox. It is 
probably easier to just install a virtual machine running a very up to date 
Linux distro and install GnuCash there and inspect it accordingly. To have a 
fair shot at your rules working in both Linux and Windows, you’d need to make 
sure your Linux Gtk version is the same, which in this case is 3.22.30. And 
after all that work, probably just easier to run GnuCash in that vm all the 
time.

I hope that helps sheds some light on the task.

Regards,
Adrien

> On Aug 6, 2018, at 12:03 PM, Peter Jackson  wrote:
> 
> This works for me on the Totals bar at the foot of a register:-
> 
> .GncRegisterPage  {
>  background-color: aliceblue;
>  color: green;
> }
> 
> As for the screenshots, they are beyond my comprehension.
> Thanks
> pj
> 
> 
> 
> On 6 August 2018 at 17:25, Adrien Monteleone  
> wrote:
> By definition, a class is not particularly specific. It applies to multiple 
> elements.
> 
> You’d need to use a rule that targets the desired element(s) better.
> 
> If you mean the bar that has “Present” “Future” “Cleared” “Reconciled” and 
> “Projected Minimum” then I’ve attached a screenshot for that node tree.
> 
> In my case, it’s at the top. (I don’t see a preference for reversing this)
> 
> GtkBox.GncRegisterPage has two children, the first is a GtkBox that holds the 
> totals bar (if on top) and the second is the GNCSplitReg which holds the 
> actual register.
> 
> Under the first GtkBox are the five child GtkBox nodes that hold each total. 
> And each of 

Re: [GNC] Post invoice still wants to be paid

[Adrien Monteleone]

Thanks Geert,

> On Aug 1, 2018, at 7:29 AM, Geert Janssens  wrote:
> 
> 
> I presume you went straight to Business->Vendor/Customer->Process Payment ?
> 
> As explained below this does behave differently from selecting Edit payment 
> on 
> a payment transaction.

No, I missed that nuance. I was using ‘Edit payment’ which did change the date 
to current day.  I’ll use the Process Payment approach next time and see how it 
goes.

> 
> In your example the pre-existing payment transaction itself will remain 
> unaltered. (It could be altered if the total amounts don't add up, but I 
> believe even in that case date and num values are retained).

Reassuring.

> 
> Edit Payment on the other hand will decompose the payment you have selected 
> and prefill all the fields in the payment window based on what it found. So 
> yes, it does look slightly different indeed. The clue to see in which 
> situation you are is in whether the payment is still listed in the documents 
> view as a pre-payment or not.
> 

In the immediate case, I think it was listed as a pre-payment, but I have 
noticed some times when it is not. I’ll be more attentive next time to see the 
behavior difference based on this.

Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash Flow Report Question

[Adrien Monteleone]

Honestly, I’ve yet to make heads or tails of that report and have it even 
remotely look useful to tell me anything about my financial activity. 
Certainly, the default account selections produce some odd results as you 
noticed. Perhaps I have to play with the account selection to get something 
useful.

Specifically, there might be reasons money goes ’to’ A/R. Possibly a refund 
situation, maybe something with a credit note is involved. I don’t think an 
unlinked payment would be the issue because that would be a credit to A/R not a 
debit. Payments are credits to A/R and debits to the payment method—checking, 
cash, etc. The fact that it gets unlinked to clear an invoice doesn’t change 
the transaction itself.

Regards,
Adrien

> On Aug 1, 2018, at 9:55 AM, Martijn Heuts  wrote:
> 
> Hello,
> On the Cash Flow report:"Money out of selected accounts goes to"I have a 
> listing of "Assets:Accounts Receivable"
> Am I incorrect that this should not be there?
> Is it possible an invoice got un-posted, a change was made,
> the invoice was posted again, but the money did not got re-applied?
> If not, why would it show here, and is there any way I can tracewhere this 
> amount comes from? It looks like it might be a sum of differentamounts 
> together.
> Any help/insight is appreciated. Thanks and have a blessed day!
> Martijn
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Customer Summary not working

[Adrien Monteleone]

It’s been working for me. Can you provide some more details to help narrow down 
the problem?

1. Which backend are you using?
2. What Operating System?
3. Does it not run at all, or just doesn’t give expected figures?
4. Are some figures obviously incorrect?

Regards,
Adrien

> On Aug 7, 2018, at 2:36 AM, Bilal Arshad  wrote:
> 
> since the update of the version to 3.2 , the customer summary report is not
> working.
> any solution
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

.GncAccountPage .summary-bar

Regards,
Adrien



> On Aug 7, 2018, at 11:38 AM, GT-I9070 H  wrote:
> 
> Em ter, 7 de ago de 2018 às 12:17, GT-I9070 H  escreveu:
> This 
> 
> .GncRegisterPage {
>  background-color: aliceblue;
>  color: green;
> } 
> 
> has not stylized my summary bar, what's wrong? 
> 
> 
> Regards
> GTI
> 
> 
> I found out what happened.
> 
> This is for the totals bar on the register sheet
> 
> What I said and I need is to the summary bar on the accounts sheet. 
> 
> 
> Regards
> GTI

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

I’ll have to get back to you on that one. 

Regards,
Adrien

> On Aug 7, 2018, at 10:28 AM, GT-I9070 H  wrote:
> 
> Em ter, 7 de ago de 2018 às 03:31, Adrien Monteleone 
>  escreveu:
> I’m not sure what you mean by child element in front.
> 
> This is what I have with
> 
> .summary-bar { 
>   background-color: red;
>   color: lime;
> }
> 
> I refer to the black element here:
> 
> 
> Do you mean the small space to the left of the bar? (and also slightly 
> surrounding it) I referenced that way back when we were looking at the 
> #account_tree header.
> 
> It’s .GncAccountPage that handles it. I tested that one. It didn’t affect the 
> summary bar for me at all. I had to use a rule with .summary-bar to do so.
> 
> No.
> I saw this and that is not good for much.
> 
> 
> Regards
> GTI

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Going Back to Go Forward?

[Adrien Monteleone]

You may not get a warning or alert!

Also, yes, at the very least the date/time stamps are different and this is 
particularly an issue with the MySQL backend if I recall correctly. I wouldn’t 
attempt to step back any further than 2.6.21, but I’d ask, what in particular 
are you finding that you need to step back for?

There were some early issues with data but those seem to have been solved by 
3.2. (I’m using the sqlite3 backend, and had to switch to XML during the 
interim but am back to normal with the 3.2 release) Sure there are a few 
annoyances with the 3.x series so far, but those are being worked out.

Regards,
Adrien

> On Aug 6, 2018, at 10:15 AM, Thomas Forrester  wrote:
> 
> Thanks, Mike.
> 
> So from what you are saying, there is some sort of data structures check
> that would alert me if I am using a version of the program that is
> incompatible with the data version.  Checking my downloads, I find I have
> the .21 installer which I wouldn't have unless I had installed that
> version.  So Looks like I may be good to take a step back.
> 
> Maybe a corollary question then -  although backward compatible with a .21
> database, does 3.x introduce any new changes to the data structures that
> would make this a really bad idea?
> 
> On Mon, Aug 6, 2018 at 9:26 AM Michael  wrote:
> 
>> It is my understanding that 2.6.21 is the only 2.6.x that is compatible
>> with the 3.2 data structure.  I have used 2.6.21 successfully with 3.2
>> data, but older 2.6.x report that they are not compatible.  I believe that
>> is true of xml and sql databases.  Mike
>> 
>> On Mon, Aug 6, 2018 at 4:17 AM, Thomas Forrester 
>> wrote:
>> 
>> On a Windows computer, I upgraded to 3.2 from 2.6.20 I think it was back
>> when I first noticed version 3 had been released. Took me till 3.2 to
>> notice, but I think it was within a few days of the 3.2 release Having now
>> used 3.2 for a short while, I'm wondering if there's any issue with going
>> back to 2.6.x? In other words, are there any underlying data structure
>> changes, or other file changes, that would make this a huge mistake? I am
>> using the MySQL database backend. I just feel at this point that, if I
>> can't further edit anything after pasting something in from the clipboard,
>> that it may be a better idea to go back so I can go forward.
>> ___ gnucash-user mailing list
>> gnucash-user@gnucash.org To update your subscription preferences or to
>> unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If
>> you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

It should be there too. I’m looking at it when I view the link. (second image)

Regards,
Adrien

> On Aug 6, 2018, at 11:49 AM, GT-I9070 H  wrote:
> 
> Em seg, 6 de ago de 2018 às 12:29, Adrien Monteleone 
>  escreveu:
> Thanks, I thought I needed an account. That was my next step.
> 
> I’ve put both screenshots here: https://imgur.com/a/9tlCWbE
> 
> Regards,
> Adrien
> 
> And tree for the bar on the register sheet?
> 
> 
> Regards
> GTI


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help with Reports Please!

[Adrien Monteleone]

Diane,

I could be misunderstanding, but the report you seem to describe sounds more to 
me like an Income Statement. (Reports > Income & Expense > Income Statement - 
same as Profit & Loss)

Does it look something like what is in this PDF? 
https://wia.unl.edu/Quicken%20Cash%20Flow%20Report.pdf or here? 
https://www.quicken.com/how-project-balances-and-cash-flow

While that report is called ‘Cash Flow’ in Quicken and uses the terms ‘inflows’ 
and ‘outflows’ looking at how it is organized and what accounts it shows, that 
really is more like an income statement. 

An income statement will show the totals of each of your income accounts with 
an income total for the report period, followed by the totals of each of your 
expense accounts, followed by an expense total for the period and a difference 
line. (net profit/loss)

You choose how deep you want the sub-accounts to appear (from none to ALL) And 
you can choose to roll sub-accounts into parent totals if desired. (usually 
works well, but if you have transactions in the parent accounts, the subs won’t 
add up to the parent of course)

You choose the period, monthly, quarterly, annually if you like. (or any date 
range)

Unfortunately there is not presently a clean solution to see multiple periods 
on one report. You can use the multi-column report for this and have multiple 
income statements, one for each period. But it will repeat the account names, 
not just the amounts. There is a proper multi-period statement being worked on 
for a future release. Until then, you can also run the reports individually, 
(or using multi-column) and then copy/paste to or save/open in a spreadsheet 
that you can then manipulate to display how you want.

The GnuCash Cash Flow Report is different. It will show you the movement of 
money between accounts. So a refund of an expense would appear as an inflow to 
your assets, perhaps not what you’re looking for.


Regards,
Adrien

> On Aug 11, 2018, at 1:22 PM, Diane Forrest  wrote:
> 
> Hello out there:  1) Am a former user of Quicken, finally "moved"  to try a
> new system.  2)  I have spent a huge amount of time getting acclimated to
> double-entry, importing QIF data, etc.  I finally feel like I get the
> system, even like the system, after ignoring my community for more than a
> week of vacation. 2) Am using what purports to be the recent, updated
> version:   *Version: 3.2  Build ID: 3.2+ (2018-06-24)  *
> 
> 3) MY ISSUE:   Imagine my (gulp) extreme disappointment to find that *after
> all that effort* ... cleaning up & entering about 7 months of Income,
> Expense, Liability, Asset Data... but for the life of me, I can't seem to
> get anything even close to a Quicken style cashflow report. What I used to
> do was print *monthly, numerical, income/expense reports*.  All those
> transactions nicely summed under all my expense subaccounts I could
> really tell what was going on.  I do not use (or even like) piecharts,
> scatterplots, or tables of little color bars.  I do not want Grand Account
> Totals (Jan to June), I want a table by month, for each Account, with it's
> sub-account "children" below it.
> 
> 4) I really have studied various GNUcash documentation,  manuals, looked at
> a few videos,  searched on line.  I think I'm smart enough, been patient
> enough, I'm really working hard... but to what end?  What on earth is the
> deal?  What am I missing here?  Is it the version I'm using, and if so, can
> someone tell me what to do, please.  Thx in advance,   DF
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation being undone without warning

[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)

Another option would be to use the Action field for the voucher #s on the 
particular split for the account of the register you are in. I just tested this 
and it does not clear the reconcile flag.

Finally, If you do this and have “Use Split Action Field for Number” set in 
File > Properties > Accounts, this number put into the action field will 
auto-populate the original NUM field, and this it can be changed and still 
visible in the same spot but not clear the flag. I just tested this also. 
(however, if you try to change it IN the NUM field itself, it WILL trigger the 
warning and clear the flag if you proceed) However, with this setting, the 
voucher will only appear in the NUM field for the register that matches the 
split you entered the number in. If you want it in more or all of them, you’d 
need to enter that voucher in the Action field of other or all splits.

Regards,
Adrien

> On Aug 13, 2018, at 5:32 AM, Anthony Marrian  
> wrote:
> 
> 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: Adrien Monteleone ; gnucash-user 
> 
> Subject: Re: [GNC] Reconciliation being undone without warning
>  
> 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: Adrien Monteleone ; gnucash-user 
> 
> Subject: Re: [GNC] Reconciliation being undone without warning
>  
> 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 idea whether that affects things.
>  
> On 2.6.19?  It certainly doesn't for me, entering a value in the Num field 
> does not change the reconcile state.
>  
> Colin
>  
> 
> -Original Message-
> From: gnucash-user 
>  On Behalf Of 
> Colin Law
> Sent: 12 August 2018 21:45
> To: Adrien Monteleone 
> Cc: gnucash-user 
> Subject: Re: [GNC] Reconciliation being undone without warning
> 
> On Sun, 12 Aug 2018 at 17:50, Adrien Monteleone < 
> adrien.montele...@lusfiber.net> wrote:
> 
> > Editing a reconciled transaction sets the status to ’n’. That is 
> > intended behavior.
> >
> 
> Changing the Num field in 2.6.19 does not un-reconcile the transaction.  I 
> believe that only if the amount is changed will it be un-reconciled.
> 
> Colin
> 
> 
> >
> > Concerning the warning dialog you either told it not to warn you for 
> > the session, or forever. If closing and restarting GnuCash doesn’t 
> > bring back the warning, check the Actions > Reset Warnings dialog and 
> > you’ll see it there. You can check the box for it and Apply and it 
> > will show next time you edit a reconciled transaction.
> >
> > Regards,
> > Adrien
> >
> > > On Aug 12, 2018, at 7:19 AM, Anthony Marrian <
> > anth...@gardensmontessori.com> wrote:
> > >
> > > What a prat I am. Sorry: from y to n
> > >
> > > From: Colin Law 
> > > Sent: 12 August 2018 11:32
> > > To: Anthony Marrian 
> > > Cc: gnucash-user 
> > > Subject: Re: [GNC] Reconciliation being undone without warning
> > >
> > > On Sun, 12 Aug 2018 at 11:07, Anthony Marrian <
> > anth...@gardensmontessori.com<mailto:anth...@gardensmontessori.com>>
> > wrote:
> > > I'm running version 3.2. I reconciled a bank account to the end of 
> > > July,
> > and then added voucher numbers (in the NUM column) to a number of the 
> > transactions, as I have habitually done with all versions before 3. No 
> > warning appeared, BUT I have just noticed when trying to reconcile 
> > July that the all the transactions which had numbers added to their 
> > NUM field also had their reconciliation flag moved from n to y. I 
> > imagine this behaviour is not by design.
>

Re: [GNC] Summarizing cash flow report w.r.t. entries and exits (discounts)

[Adrien Monteleone]

Which is why everyone should speak to a local CPA for official guidance.

Regards,
Adrien

> On Aug 9, 2018, at 2:25 PM, Christian Kluge  wrote:
> 
> Hi,
> 
> under certain circumstances VAT can be treated as expense/income,
> e. g. in Germany when one’s only required to do cash based accounting.
> 
> In that case payable output tax and refunds would be treated as income
> and input tax and vat payments are treated as expense.
> 
> Kind regards
> 
> Christian Kluge
> 
> Am 09.08.2018 um 17:57 schrieb Adrien Monteleone:
>> By all means, talk to a local CPA, but usually a pass through is treated as 
>> a liability.
>> 
>> So you’d have this account:
>> 
>> Liabilities:VAT payable
>> 
>> The invoice transaction would look like this:
>> 
>> Dr. Cash/Checking/etc.
>> Cr. Income
>> Cr. Liabilities:VAT payable
>> 
>> The debit would be for the full amount received.
>> 
>> The credit to income is just for your services/products.
>> 
>> The VAT is strictly a liability. Those funds don’t belong to you and you 
>> didn’t earn them so they are not income.
>> 
>> If you pay estimated VAT in advance and then get refunds, that should simply 
>> reduce your actual liability. So when paying the estimated amount, you’d 
>> enter a debit to that Liability account, and then each invoice will reduce 
>> that pre-payment as they are posted. If you receive a refund for excess 
>> pre-payment you’d enter something like this:
>> 
>> Dr. Cash/Checking/etc.
>> Cr. Liabilities:VAT payable
>> 
>> Income shouldn’t enter the picture here. Had you estimated exactly, there 
>> would have been no refund.
>> 
>> If you receive ‘vendor compensation’ for collecting and remitting the tax 
>> for the state, that is probably income, but get a professional opinion. 
>> (Usually a small percentage of the tax due and subtracted when filing.) It’s 
>> usually not actually paid-back to you, you just get to keep it, though your 
>> jurisdiction may do otherwise.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Aug 9, 2018, at 8:54 AM, brainwash  wrote:
>>> 
>>> I don't know how it should be set up as I'm using this only for personal
>>> bookkeeping.
>>> To answer the question: the VAT is a liability(?) in that I receive it from
>>> the customers and have to give it back to the state.
>>> There's is also some VAT on expenses but it would be too tedious too track
>>> that for each small purchase.
>>> 
>>> With regard to that, the VAT is self-reported and predicted, so I sometimes
>>> end up receiving discounts (kickbacks?) from the state. This shows up as
>>> income under the "Cash flow", but I guess in that case it makes sense.
>>> 
>>> Regards
>>> 
>>> 
>>> 
>>> --
>>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Thanks John,

I was putting the image at the end, but I didn’t consider the quote.

Regards,
Adrien

> On Aug 6, 2018, at 9:39 AM, John Ralls  wrote:
> 
> Adrien,
> 
> IIUC mailman insists that attachments be at the end of the message, not 
> inlined. Since you’re top-posting that means after all of the quoted text, 
> not just after your post.
> 
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

By definition, a class is not particularly specific. It applies to multiple 
elements.

You’d need to use a rule that targets the desired element(s) better.

If you mean the bar that has “Present” “Future” “Cleared” “Reconciled” and 
“Projected Minimum” then I’ve attached a screenshot for that node tree.

In my case, it’s at the top. (I don’t see a preference for reversing this)

GtkBox.GncRegisterPage has two children, the first is a GtkBox that holds the 
totals bar (if on top) and the second is the GNCSplitReg which holds the actual 
register.

Under the first GtkBox are the five child GtkBox nodes that hold each total. 
And each of those has two GtkLabel children, one for the title and one for the 
actual total.

So you probably want to do something like:

.GncRegisterPage > GtkBox label {}

for the text of the bar and for the bar itself (colors perhaps):

.GncRegisterPage > GtkBox {}

Regards,
Adrien

> On Aug 6, 2018, at 11:02 AM, GT-I9070 H  wrote:
> 
> Em seg, 6 de ago de 2018 às 10:43, Peter Jackson 
> escreveu:
> 
>> Thanks, but is there not something missing here? to specify the bar.
>> Regards
>> pj
>> 
> 
> Apparently yes, but for me it works, test and report your results.
> Some selectors are like that, appear to be unspecific, see some for the
> register, something seems to be missing.
> 
> 
> Regards
> GTI
> 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Another attempt at attaching the CSS Node Tree...

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Thanks, I thought I needed an account. That was my next step.

I’ve put both screenshots here: https://imgur.com/a/9tlCWbE

Regards,
Adrien

> On Aug 6, 2018, at 11:14 AM, GT-I9070 H  wrote:
> 
> Em seg, 6 de ago de 2018 às 12:07, Adrien Monteleone 
>  escreveu:
> Another attempt at attaching the CSS Node Tree...
> 
> Regards,
> Adrien
> 
> Thank you Adrien, but . . . 
> Nothing here again.
> 
> Post the image here https://imgur.com/ , no need to sign in, and post the 
> link of the image here in the list.
> 
> Regards
> GTI
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Projecting the future

[Adrien Monteleone]

I don’t think there is a way to do these currently, but does the Future 
Scheduled Transactions Summary report give you something of what you are 
looking for? (not ideal, I know)

I too would like to know for example, that what I’ve scheduled will put me 
’negative’ on a certain date, something like a date-level budgeting tool. Other 
money management tools I’ve used had this feature in a graph. Of course, 
GnuCash isn’t a money management app, it’s a double-entry bookkeeping app.

Regards,
Adrien

> On Aug 5, 2018, at 2:23 PM, J Johnson  wrote:
> 
> 
> As I was playing around with the scheduled transactions, I noticed the 
> running balance is not displayed in the calendar. The calendar is just a 
> visual representation of the table. Is there a way to
> display the running balance for each day?Also, is there a way to set the 
> future date of the projected minimum balance?
> 
> 
> Thanks
> Jay
> 
> Sent from Mail for Windows 10
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Edit Report options> Fancy Invoice > Default stylesheet

[Adrien Monteleone]

Directly to your last question, no there isn’t.

Your only options (I’m not sure why) in Preferences > Business are:

Printable Invoice
Tax Invoice
Easy Invoice
Fancy Invoice

It seems ‘Printable’ defaults to ‘default’ stylesheet and can’t be changed 
without editing the report code itself as Geert noted. I would think the 
ability to set a default stylesheet in the app other than ‘default’ would be 
very useful.

But maybe you could edit ‘Easy’ or ‘Fancy’ to achieve what you want and get 
there in one click. I haven’t tried. I don’t see a way to edit ’Tax Invoice’ 
without touching code.

However, you can get there in fewer clicks than you initially describe if you 
are already viewing the invoice in question.

Hit the print button, then choose options and set the stylesheet to technicolor.

As for finding and viewing the desired invoice in advance, you can use the 
Business > Customer > Find Invoice dialog, but that’s cumbersome.

Personally, I keep tabs open with both the Receivables Aging & Payables Aging 
reports at all times. (set to show zero balance items, so all customers/vendors 
are always visible, but not necessary)

If I need to pull up an invoice after initial creation, I click the total link 
for that customer in the aging report and it gives me a customer report, where 
I can then click the invoice in question and proceed to print from there. (the 
customer report gives me enough info such as date, amount, and maybe even a 
memo to decide which one I want)

This is much faster than going through the Find dialog over and over, and much 
faster than starting from Reports > Business > Invoice and then selecting the 
proper customer/invoice.

If you like the Find Invoice dialog better, perhaps you can set an accelerator 
for it. (shortcut key combo) It would be nice if one existed by default since 
it take several clicks to get there.

Regards,
Adrien


> On Aug 5, 2018, at 6:00 AM, Andres Muniz Piniella 
>  wrote:
> 
> Hi Adrien,
> Thanks this helps but my costume style sheet that needs changing on my
> Fancy Invoice window. Maybe I got my work flow wrong and there is a
> more efficient way?
> 
> Work flow as follows:
> Report> Business> Fancy Invoice
> 
> A new empty tap is open so I press the gear button to edit report
> options.
> This new pop up title "fancy invoice" has a drop down menu for
> stylesheet that is set to "default" I want it to set to a style sheet
> "Technicolor".
> 
> Then the only thing I would need to do is look for the invoice number. 
> 
> Unless there is a way to go from "Post invoice to chart to accounts"
> directly to open the ready to print Technicolor stiled fancy invoice?
> 
> quote:
> "
> Does ?GnuCash > Preferences > Business > Report for Printing:? not
> allow you to select your custom invoice?
> 
> This should control what is the default as far as I can tell.
> 
> Regards,
> Adrien
> 
> "
>> On Jul 19, 2018, at 9:46 AM, Andres Muniz Piniella  nun.es> wrote:
>>  
>> Hopefully an easy one:
>> I am running GnuCash 2.6.12 on ubuntu 16.04
>>  
>> I have edited /usr/share/gnucash/scm/gnucash/report/fancy-invoice.scm
>> such that I don't have to manually change almost any value when I
> click
>> "edit Report options". 
>>  
>> The last thing I can't manage is for it to default to my stylesheet
> and
>> not to default. 
>>  
>> At first I thought it only picked the first one in alphabetical order
>> but I created A-technicolor but still "default" was selected. 
>>  
>> Is it one of these two lines?
>>  
>>(define gnc:*report-options* (gnc:new-options))
>>  
>>(define (gnc:register-inv-option new-option)
>>  (gnc:register-option gnc:*report-options* new-option))
>>  
>> Thanks for your time!
> 
> -- 
> Andres (he/him/his)
> 
> HUG Director
> 
> RML Founding Member 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Projecting the future

[Adrien Monteleone]

Jay,

Have you tackled the Budget module yet?

It works on a ‘period’ basis, but might achieve some of the same info. (you can 
compare budget to actual, but not the way David does with specific transactions)

You can also budget flows to savings accounts, paying liabilities, etc.

There are some nuances and parts of the workflow is a little cumbersome, but it 
is overall, useful.

Do be aware I noticed and filed a bug where automatically time-stamped 
transactions, Specifically posted invoices on the first of the month, are 
getting the wrong date/time-stamp and the budget report is interpreting them as 
the prior period throwing off my revenue actual comparisons to budget. 
(probably some sort of time-zone issue) Other than that I’m happy with it.

The budget window will show you your running budgeted balance at the bottom for 
each period as you add revenue/income and then budget expenses or paying off 
liabilities. This was useful for me to budget savings and to budget advancing 
liability payments.

Regards,
Adrien

> On Aug 6, 2018, at 1:54 PM, David Carlson  wrote:
> 
> My method to predict future bank account balances is to enter scheduled 
> transactions for all large expenditures and incomes, even if they are 
> estimates out to between one and three months in advance.  I flag these 
> estimates with a keyword in the number field, so I can tell if I have 
> replaced the estimated value with a real value.  I also have a couple of 
> miscellaneous aggregates to estimate the effect of the little things like 
> Starbucks.
> 
> This comes close enough to see when my cushion balance is running low.
> 
> David C
> 
> On Mon, Aug 6, 2018 at 1:27 PM, Adrien Monteleone 
>  wrote:
> I don’t think there is a way to do these currently, but does the Future 
> Scheduled Transactions Summary report give you something of what you are 
> looking for? (not ideal, I know)
> 
> I too would like to know for example, that what I’ve scheduled will put me 
> ’negative’ on a certain date, something like a date-level budgeting tool. 
> Other money management tools I’ve used had this feature in a graph. Of 
> course, GnuCash isn’t a money management app, it’s a double-entry bookkeeping 
> app.
> 
> Regards,
> Adrien
> 
> > On Aug 5, 2018, at 2:23 PM, J Johnson  wrote:
> > 
> > 
> > As I was playing around with the scheduled transactions, I noticed the 
> > running balance is not displayed in the calendar. The calendar is just a 
> > visual representation of the table. Is there a way to
> > display the running balance for each day?Also, is there a way to set 
> > the future date of the projected minimum balance?
> > 
> > 
> > Thanks
> > Jay
> > 
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 
> > 10
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Projecting the future

[Adrien Monteleone]

Nice approach. I like the idea of being able to see if you were off on a 
budgeted transaction specifically rather than the whole account on a period 
basis.

Regards,
Adrien

> On Aug 6, 2018, at 1:54 PM, David Carlson  wrote:
> 
> My method to predict future bank account balances is to enter scheduled 
> transactions for all large expenditures and incomes, even if they are 
> estimates out to between one and three months in advance.  I flag these 
> estimates with a keyword in the number field, so I can tell if I have 
> replaced the estimated value with a real value.  I also have a couple of 
> miscellaneous aggregates to estimate the effect of the little things like 
> Starbucks.
> 
> This comes close enough to see when my cushion balance is running low.
> 
> David C
> 
> On Mon, Aug 6, 2018 at 1:27 PM, Adrien Monteleone 
>  wrote:
> I don’t think there is a way to do these currently, but does the Future 
> Scheduled Transactions Summary report give you something of what you are 
> looking for? (not ideal, I know)
> 
> I too would like to know for example, that what I’ve scheduled will put me 
> ’negative’ on a certain date, something like a date-level budgeting tool. 
> Other money management tools I’ve used had this feature in a graph. Of 
> course, GnuCash isn’t a money management app, it’s a double-entry bookkeeping 
> app.
> 
> Regards,
> Adrien
> 
> > On Aug 5, 2018, at 2:23 PM, J Johnson  wrote:
> > 
> > 
> > As I was playing around with the scheduled transactions, I noticed the 
> > running balance is not displayed in the calendar. The calendar is just a 
> > visual representation of the table. Is there a way to
> > display the running balance for each day?Also, is there a way to set 
> > the future date of the projected minimum balance?
> > 
> > 
> > Thanks
> > Jay
> > 
> > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 
> > 10
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change text color

[Adrien Monteleone]

Does that not affect the entire page?

Perhaps the specific classes for primary, secondary et cetera are taking 
precedence.

.GncRegisterPage > GtkBox {}

would probably be safer if it works.

Regards,
Adrien

> On Aug 6, 2018, at 12:03 PM, Peter Jackson  wrote:
> 
> This works for me on the Totals bar at the foot of a register:-
> 
> .GncRegisterPage  {
>  background-color: aliceblue;
>  color: green;
> }
> 
> As for the screenshots, they are beyond my comprehension.
> Thanks
> pj
> 
> 
> 
> On 6 August 2018 at 17:25, Adrien Monteleone  
> wrote:
> By definition, a class is not particularly specific. It applies to multiple 
> elements.
> 
> You’d need to use a rule that targets the desired element(s) better.
> 
> If you mean the bar that has “Present” “Future” “Cleared” “Reconciled” and 
> “Projected Minimum” then I’ve attached a screenshot for that node tree.
> 
> In my case, it’s at the top. (I don’t see a preference for reversing this)
> 
> GtkBox.GncRegisterPage has two children, the first is a GtkBox that holds the 
> totals bar (if on top) and the second is the GNCSplitReg which holds the 
> actual register.
> 
> Under the first GtkBox are the five child GtkBox nodes that hold each total. 
> And each of those has two GtkLabel children, one for the title and one for 
> the actual total.
> 
> So you probably want to do something like:
> 
> .GncRegisterPage > GtkBox label {}
> 
> for the text of the bar and for the bar itself (colors perhaps):
> 
> .GncRegisterPage > GtkBox {}
> 
> Regards,
> Adrien
> 
> > On Aug 6, 2018, at 11:02 AM, GT-I9070 H  wrote:
> > 
> > Em seg, 6 de ago de 2018 às 10:43, Peter Jackson 
> > escreveu:
> > 
> >> Thanks, but is there not something missing here? to specify the bar.
> >> Regards
> >> pj
> >> 
> > 
> > Apparently yes, but for me it works, test and report your results.
> > Some selectors are like that, appear to be unspecific, see some for the
> > register, something seems to be missing.
> > 
> > 
> > Regards
> > GTI
> > 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cannot change preferences

[Adrien Monteleone]

Ken,

You might also want to investigate this page, particularly the section on 
locks. I doubt you’ll find one for GnuCash, but somehow that system might have 
an overall lock on it.

https://developer.gnome.org/dconf/unstable/dconf-overview.html

Regards,
Adrien

> On Aug 18, 2018, at 9:42 AM, Colin Law  wrote:
> 
> On Sat, 18 Aug 2018 at 15:19, Adrien Monteleone 
>  wrote:
> I think Ken mentioned GnuCash 2.6.15 in Debian Stretch in the OP.
> 
> I missed that.  Thanks.
> 
> Ken, dconf not working can be caused by corrupted dconf config files.  This 
> can happen if there is power fail apparently.  Try this in a terminal after 
> closing all apps down.
> mv .config/dconf  .config/dconf.save
> which will move that folder out of the way,  dconf should recreate it.  Log 
> out and back in again (this may not be necessary in fact, not sure), then try 
> dconf-editor again and see if it saves things now.
> You may well find that other apps that use dconf will have gone back to 
> default values.
> 
> If doing this messes things up then you can always restore the orginal using
> mv .config/dconf .config/dconf.regenerated
> mv .config/dconf.save .config/dconf
> If the first command says it can't find .config/dconf then that is ok, it 
> just means it had not been recreated.
> 
> Colin
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Column widths again

[Adrien Monteleone]

A reasonable consideration.

Keep in mind, there have been only 2 inquiries about this column before now, 
back in 2009. (on IRC)

It seems the discoverability by accident, even with people trying to resize the 
balance column (and expanding the rate column instead) is very low.

And since this is “use at your own risk” free software, the devs are exempt 
from blame anyway.

Perhaps there can be something on the wiki as a reference should someone go 
searching for it specifically, but not made prominent so as not to encourage 
fiddling.

Regards,
Adrien

> On Aug 20, 2018, at 1:49 PM, GT-I9070 H  wrote:
> 
> Em seg, 20 de ago de 2018 às 14:01, Derek Atkins  escreveu:
> 
>> IMHO, the column does not need to be documented becuase it is a
>> non-servicible part.  It exists the way it does because that was the
>> easiest way to get the register to store the meta-information about a
>> rate.  It exists as a 1-pixel column because that's the narrowest you can
>> make it.  There's no way to hide it absolutely completely, and duplicating
>> the functionality in a different way didn't make sense when this way was
>> available.
>> 
>> I see no reason to document it, because it should not be editable by a
>> user.
>> I see no reason to document it, because in 99.9% of use cases, a user will
>> not even be aware that it's there.
>> I see no reason to document it, becuase if someone DOES see it in the
>> documentation and does try to look for it and does find it and does try to
>> meddle with it, they can do some pretty strange damage to their data.
>> 
>> Anyways, that's my $0.02.
>> 
>> Don't bother to even mention it; it's not worth your time to document
>> something that users wont (and shouldn't) see or touch.
>> 
>> -derek
>> 
> 
> Here are my $0.0001,
> 
> I use this rate column for a long time and I particularly find it very
> useful to be able to see it to know quickly if it are filled correctly.
> 
> If the column is there and can be displayed and it has already been
> discovered, it poses a risk to the uninformed user.
> 
> Perhaps the information should be documented with Derek's important and
> critical observations. That would be better than a misinformation accident.
> Myself even took the risk of damaging my data, and I just learned that now.
> 
> The information exempts the devs from blame.
> 
> 
> Regards
> GTI
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Column widths again

[Adrien Monteleone]

I’ve never seen any documentation on it. I only confirmed it’s there after I 
read Derek’s comment and expanded the column myself to see it.

I just did a search of the GnuCash site, wiki and html docs and I don’t see 
anything on the column, other than a pair of IRC logs from 2009 where someone 
asked what it was for, and a couple of hits (appears duplicated) documenting 
commits from 2017-09-4. I didn’t read the commit itself, but it was summarized 
by Robert Fewell as “Add a heading for the Rate column.”

Concerning where to put the info, I’m not sure the Tutorial is the right place. 
(there is no 4.2, for example)

However, the help guide has 4.3.5 List of Transactions which documents the 
column headings. I think if that section were more detailed with screenshots, 
lots of questions could be answered or even avoided.

Some things to add here:

The ability to resize columns and an explanation of how the Description column 
is special and how resizing works.

An explanation with screenshots of the different types of registers showing the 
respective columns. (unless they are all the same, save terminology choices, 
then you’d only need one screenshot)

An explanation of the formal vs. non-formal labels for each account type. (a 
full listing of what the non-formal labels are for each type)

Screenshots depicting each of the modes: single-line, double-line, transaction 
journal.

An explanation of what each cell in the transaction is for. (many don’t know 
the utilit(ies) of NUM or Action for example.) Not everything is self-evident. 
Perhaps here include a link to a special wiki page or to Using GnuCash where 
the different ’tricks’ for using those and other fields to accomplish user 
specific goals are (or should be) documented.

I would be happy to get set up for editing and start on this unless you already 
planned on running with it.

Finally, “Tutorial & Concepts Guide” is a bit winded. Could it simply be 
“Tutorial” or “Using GnuCash”? (and then incorporate any ‘official’ methods 
from that wiki page into the document, with a link to that page for the 
non-standard methods)

Regards,
Adrien

> On Aug 20, 2018, at 10:57 AM, David Carlson  
> wrote:
> 
> I just tried to find reference to the rate field in the Tutorial and I found 
> nothing.
> 
> I think it should probably be mentioned in chapter 4 section 4.2.  That 
> section even fails to explain single line vs two line view or dragging around 
> field widths, so it has a long way to go before it could describe the 
> presence of the rate field and how to access it.
> 
> Is this information posted elsewhere? 
> 
> David C 
> 
> On Mon, Aug 20, 2018, 9:44 AM Adrien Monteleone 
>  wrote:
> It’s still there as of 3.2.
> 
> Regards,
> Adrien
> 
> > On Aug 20, 2018, at 9:17 AM, Derek Atkins  wrote:
> > 
> > John Ralls  writes:
> > 
> >> Graham,
> >> 
> >> "Transfer" is short for "Transfer Account" and is the field where the
> >> "other" account--other than the one in the current register--is
> >> set. It's often called the "account" field in casual use.
> >> 
> >> I think GTI made a translation error, the "rate" field is probably
> >> "price" on a stock/mutual fund register, which has two more columns
> >> than the other registers.
> > 
> > No, there is (unless it was removed) a "RATE" field to the right of the
> > balance column.  It's a "hidden" column, with a default width of one
> > pixel, which is (was?) used for the exchange-rate handling of
> > multi-currency transactions/splits.
> > 
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > 
> > -derek
> > 
> > -- 
> >   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >   Member, MIT Student Information Processing Board  (SIPB)
> >   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
> >   warl...@mit.eduPGP key available
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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 subscripti

Re: [GNC] Column widths again

[Adrien Monteleone]

Of course, that all makes sense.

The other improvements, specifically how to resize columns, particularly the 
Description column I think should be documented. There are enough questions on 
the list about it to address the topic.

Regards,
Adrien

> On Aug 20, 2018, at 1:01 PM, Derek Atkins  wrote:
> 
> IMHO, the column does not need to be documented becuase it is a
> non-servicible part.  It exists the way it does because that was the
> easiest way to get the register to store the meta-information about a
> rate.  It exists as a 1-pixel column because that's the narrowest you can
> make it.  There's no way to hide it absolutely completely, and duplicating
> the functionality in a different way didn't make sense when this way was
> available.
> 
> I see no reason to document it, because it should not be editable by a user.
> I see no reason to document it, because in 99.9% of use cases, a user will
> not even be aware that it's there.
> I see no reason to document it, becuase if someone DOES see it in the
> documentation and does try to look for it and does find it and does try to
> meddle with it, they can do some pretty strange damage to their data.
> 
> Anyways, that's my $0.02.
> 
> Don't bother to even mention it; it's not worth your time to document
> something that users wont (and shouldn't) see or touch.
> 
> -derek
> 
> On Mon, August 20, 2018 1:04 pm, David Carlson wrote:
>> Adrien,
>> 
>> Thank you for your research and detailed response. 
>> I fully agree with your conclusions.
>> 
>> 
>> I got the reference to section 4.2 directly from
>> https://www.gnucash.org/docs/v3/C/gnucash-guide/txns-register-oview.html#txns-regstyle1
>> which I arrived at when I followed the link called " Tutorial and Concepts
>> Guide, Choosing a Register Style
>> <https://www.gnucash.org/docs/v3/C/gnucash-guide/txns-register-oview.html#txns-regstyle1>).
>> " in https://www.gnucash.org/viewdoc.phtml?doc=help.  Naturally, I thought
>> I was in the Tutorial...
>> 
>> David C
>> 
>> On Mon, Aug 20, 2018 at 11:45 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> 
>>> I’ve never seen any documentation on it. I only confirmed it’s there
>>> after
>>> I read Derek’s comment and expanded the column myself to see it.
>>> 
>>> I just did a search of the GnuCash site, wiki and html docs and I don’t
>>> see anything on the column, other than a pair of IRC logs from 2009
>>> where
>>> someone asked what it was for, and a couple of hits (appears duplicated)
>>> documenting commits from 2017-09-4. I didn’t read the commit itself, but
>>> it
>>> was summarized by Robert Fewell as “Add a heading for the Rate column.”
>>> 
>>> Concerning where to put the info, I’m not sure the Tutorial is the right
>>> place. (there is no 4.2, for example)
>>> 
>>> However, the help guide has 4.3.5 List of Transactions which documents
>>> the
>>> column headings. I think if that section were more detailed with
>>> screenshots, lots of questions could be answered or even avoided.
>>> 
>>> Some things to add here:
>>> 
>>> The ability to resize columns and an explanation of how the Description
>>> column is special and how resizing works.
>>> 
>>> An explanation with screenshots of the different types of registers
>>> showing the respective columns. (unless they are all the same, save
>>> terminology choices, then you’d only need one screenshot)
>>> 
>>> An explanation of the formal vs. non-formal labels for each account
>>> type.
>>> (a full listing of what the non-formal labels are for each type)
>>> 
>>> Screenshots depicting each of the modes: single-line, double-line,
>>> transaction journal.
>>> 
>>> An explanation of what each cell in the transaction is for. (many don’t
>>> know the utilit(ies) of NUM or Action for example.) Not everything is
>>> self-evident. Perhaps here include a link to a special wiki page or to
>>> Using GnuCash where the different ’tricks’ for using those and other
>>> fields
>>> to accomplish user specific goals are (or should be) documented.
>>> 
>>> I would be happy to get set up for editing and start on this unless you
>>> already planned on running with it.
>>> 
>>> Finally, “Tutorial & Concepts Guide” is a bit winded. Could it simply be
>>> “Tutorial” or “Using GnuCash”? (and then incorporate any ‘official’
>>> methods
>>> from that wiki page i

Re: [GNC] Column widths again

[Adrien Monteleone]

Already several messages in - but it’s on the devel list here: 
https://lists.gnucash.org/pipermail/gnucash-devel/2018-August/042479.html

I wasn’t sure if I should have copied this thread when I did that, but I didn’t 
want to end up with this one still going off topic. (I see that was going to 
happen anyway)

Is there a best practice for this?

Regards,
Adrien

> On Aug 20, 2018, at 3:58 PM, Colin Law  wrote:
> 
> On Mon, 20 Aug 2018 at 18:17, David Carlson  
> wrote:
> I think that I technically hijacked the thread by digressing to
> documentation issues.
> 
> No technically about it, actually would be a better word I think.  I was 
> thoroughly confused about what was going on.
> 
> Could a new thread be started for the documentation aspects of this please?
> 
> Colin
>  
>   Unfortunately, I do not see the thread title or a
> way to rename it in my Gmail window.  If Adrien or another user can detach
> this , I would appreciate it.
> 
> David C
> 
> On Mon, Aug 20, 2018 at 12:04 PM, David Carlson  > wrote:
> 
> > Adrien,
> >
> > Thank you for your research and detailed response. 
> > I fully agree with your conclusions.
> >
> >
> > I got the reference to section 4.2 directly from
> > https://www.gnucash.org/docs/v3/C/gnucash-guide/txns-
> > register-oview.html#txns-regstyle1 which I arrived at when I followed the
> > link called " Tutorial and Concepts Guide, Choosing a Register Style
> > <https://www.gnucash.org/docs/v3/C/gnucash-guide/txns-register-oview.html#txns-regstyle1>).
> > " in https://www.gnucash.org/viewdoc.phtml?doc=help.  Naturally, I
> > thought I was in the Tutorial...
> >
> > David C
> >
> > On Mon, Aug 20, 2018 at 11:45 AM, Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> I’ve never seen any documentation on it. I only confirmed it’s there
> >> after I read Derek’s comment and expanded the column myself to see it.
> >>
> >> I just did a search of the GnuCash site, wiki and html docs and I don’t
> >> see anything on the column, other than a pair of IRC logs from 2009 where
> >> someone asked what it was for, and a couple of hits (appears duplicated)
> >> documenting commits from 2017-09-4. I didn’t read the commit itself, but it
> >> was summarized by Robert Fewell as “Add a heading for the Rate column.”
> >>
> >> Concerning where to put the info, I’m not sure the Tutorial is the right
> >> place. (there is no 4.2, for example)
> >>
> >> However, the help guide has 4.3.5 List of Transactions which documents
> >> the column headings. I think if that section were more detailed with
> >> screenshots, lots of questions could be answered or even avoided.
> >>
> >> Some things to add here:
> >>
> >> The ability to resize columns and an explanation of how the Description
> >> column is special and how resizing works.
> >>
> >> An explanation with screenshots of the different types of registers
> >> showing the respective columns. (unless they are all the same, save
> >> terminology choices, then you’d only need one screenshot)
> >>
> >> An explanation of the formal vs. non-formal labels for each account type.
> >> (a full listing of what the non-formal labels are for each type)
> >>
> >> Screenshots depicting each of the modes: single-line, double-line,
> >> transaction journal.
> >>
> >> An explanation of what each cell in the transaction is for. (many don’t
> >> know the utilit(ies) of NUM or Action for example.) Not everything is
> >> self-evident. Perhaps here include a link to a special wiki page or to
> >> Using GnuCash where the different ’tricks’ for using those and other fields
> >> to accomplish user specific goals are (or should be) documented.
> >>
> >> I would be happy to get set up for editing and start on this unless you
> >> already planned on running with it.
> >>
> >> Finally, “Tutorial & Concepts Guide” is a bit winded. Could it simply be
> >> “Tutorial” or “Using GnuCash”? (and then incorporate any ‘official’ methods
> >> from that wiki page into the document, with a link to that page for the
> >> non-standard methods)
> >>
> >> Regards,
> >> Adrien
> >>
> >> > On Aug 20, 2018, at 10:57 AM, David Carlson <
> >> david.carlson@gmail.com> wrote:
> >> >
> >> > I just tried to find reference to the rate field in the Tutorial and I
> >

Re: [GNC] Transaction reports with only debits or credits

[Adrien Monteleone]

There are two ways. One involves adding a ’tag’ to each transaction, the other 
involves using a spreadsheet.

If you want GnuCash to produce the report directly, you would need some sort of 
’tag’ (this if figurative here, GnuCash doesn’t have a ’tag’ feature) in either 
the Description, Notes, or Memo of each transaction that you can use to set a 
filter for the report. So you could tag debit transactions with the word 
“Debit” or “Dr.” or simply “D”, similar for credit transactions.

When you run the transactions report, use the Transaction Filter option on the 
Filter tab to include only transactions with the desired tag.

The downside here is you need to edit all historical transactions to add this 
tag. (but this won’t un-reconcile any since you can change those fields safely.)

If you don’t mind using a spreadsheet to manipulate the data, you can instead 
use the Sorting tab of the report. Set your primary key to Amount. (the 
secondary can be anything you want). Apply or run the report again.

Now your transactions will be sorted by debit and credit. Depending on the 
account type, for example an Asset account like Checking, the negative amounts 
will be credits and the positive amounts, debits. (Assets & Expenses work this 
way, Income, Liabilities & Equity are the opposite) Copy and paste the entire 
report into a spreadsheet and simply delete the rows with the set of accounts 
you don’t want. (you can alternately save the report as is, and then open it 
with a spreadsheet app)

Regards,
Adrien

> On Aug 15, 2018, at 5:56 PM, AC  wrote:
> 
> Is there a way to configure a transaction report (or any of the
> available reports) to show only the debits or the credits (but not both)
> of an account?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Business Account Set Up Question & Customer Billing Question

[Adrien Monteleone]

Welcome to GnuCash!

Capital Equity investments should be like so:

Dr. Assets:Checking
Cr. Equity:Paid-in-capital:Partner A/B

Or using some similar accounts. You want to record the receipt of an asset, and 
you want to balance that against a specific partner’s equity.

Opening balances are for when you have a balance pre-existing from older books 
(or no books) for a particular account.

If you do this for both initial investments, Equity should show 1440 total 
paid-in.

The client re-billing issue however is a different matter.

There is a ‘jobs’ feature in GnuCash, but it is very limited at the moment. 
Each vendor can have only one job. So if you buy ‘parts’ or multiple items on 
the same invoice from a single vendor and then in some fashion, direct, 
recombined, or further process or manufacture, you can’t tie that job to 
multiple clients.

That would be more of an inventory system and GnuCash doesn’t have that at 
present. (and may not, its purpose is to be an accounting system, not inventory 
control, point of sale, etc cetera, but external modules are possible, just no 
one has written this yet.)

At the very least you could use a spreadsheet for tracking what to bill 
customers, but I’m sure there is better software out there to handle the task. 
You’d then import the resulting transaction into GnuCash for the accounting.

Sorry, I know that wasn’t the answer you were looking for.

It might be possible, using either directly entered transactions, downloaded 
transactions from a card issuer, or maybe even via invoices to ’tag’ 
transactions or splits for particular customers. (likely using the Description, 
Notes or Memo fields) You can then use this to generate a transaction report 
that can be used to then bill customers — not simple, I know.

But if that’s the present hangup/issue, be patient and ask for more help 
specifically on those points and someone will be able to guide you through.

If you are using one of the SQL backends (sqlite3 has the lowest barrier for 
new users) you have the option of using SQL queries on the data directly 
outside of  GnuCash or via something called PieCash which gives a python 
scripting interface to those backends. (without having to learn SQL) This way, 
you could run a python script or SQL query to create a CSV of the needed items 
to be re-billed, even including your markup, all generated in a format to be 
imported directly into GnuCash as an invoice that you can track in GnuCash and 
print/send to your client. This is probably the most likely solution for you 
though others may offer other suggestions.

Just remember NOT to *write* back to the database using SQL for the foreseeable 
future. GnuCash is not yet a ‘full’ database driven application. Use the 
importers for bringing in data you don’t want to enter directly.

Regards,
Adrien

> On Aug 21, 2018, at 9:31 PM, Khristine Ann Ramella  wrote:
> 
> OK, so trying to use gnu for business. Have a two person llc. I set up the 
> equity accounts like shown based on all the research on gnuhelp and general 
> accounting I could find.
> 
> Each member contributed 720 to start the business. The first person 720 was 
> put in checking immediately. I put it under Opening Balances and sent it to 
> checking. So far so good. The second 720 came in a month later. When I go to 
> make the deposit to the checking account how do categorize it?
> 
> Also, why does Equity only show as 740 ? Shouldn't it be 1440 to represent 
> the 720 from each member?
> 
> [cid:image001.jpg@01D4399E.B10A5F50]
> 
> I also have a billing question. When I enter a credit card charge or checking 
> account debit, I want to be able to assign a customer & their specific job  
> to the purchase. We buy & bill out a lot of supplies for each client-most 
> with an upcharge so it isn't an even swap. In  Qbooks you can just check a 
> box and assign the purchase or invoice to the customer job, so I can see 
> expenses versus billing right away for the customer and their job. I did some 
> gnusearch on this and didn't really get a clear cut answer.
> 
> I would hate to have to go back to QB but this is a deal breaker-lots of 
> parts for each customer and each customer has lots of jobs (installs/service 
> calls)
> 
> Thanks so much for your expertise!!!
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or 

Re: [GNC] Cannot change preferences -- see bug 555187?

[Adrien Monteleone]

This page is almost 3 years old: 
https://wiki.gnome.org/Initiatives/GnomeGoals/GSettingsMigration

But it does offer a list of potential apps to check that might still be using 
gconf. I’m pretty sure Chromium has completed their migration as of early this 
year.

Ubuntu stopped installing it as of 17.04. So if your system doesn’t have 
anything on it that isn’t on 17.04, it is probably safe to delete. And if you 
do have extra software as most people do, then the list to check is smaller.

Regards,
Adrien

> On Aug 23, 2018, at 9:13 AM, Geert Janssens  
> wrote:
> 
> Op donderdag 23 augustus 2018 16:00:24 CEST schreef Ken Heard:
>> On 2018-08-18 13:38, Geert Janssens wrote:
>>> Op zaterdag 18 augustus 2018 16:34:14 CEST schreef Ken Heard:
 Last evening I was thinking of filing a bug report for my problem.  In
 the process I found a previous bug report 555187 dealing with the same
 one (1).  This bug was originally filed on 2008-10-16, but the last
 comment on it by André Klapper was filed on 2018-08-17 13:58:19 UTC --
 yesterday!
>>> 
>>> That bug is about GConf, which was used for preferences before we switched
>>> to dconf. GConf and dconf are completely different tools and your problem
>>> is with dconf so this bug is irrelevant here.
>>> 
>>> The only thing André added yesterday was a message indicating that the
>>> (old) GConf tool should be considered dead and burried. Which is fine
>>> because gnucash has not been using it since version 2.6.0.
>> 
>> Does the foregoing mean that directory ~/.gconf can be safely deleted?
>> The most recent dates of the files in its subdirecties date from 2014 or
>> earlier.
>> 
>> Regards, Ken
> 
> I don't know. I know gnucash is no longer using gconf, but perhaps other 
> applications on your system still are (though unlikely).
> 
> The fact the most recent date in that directory is from 2014 means no 
> application you have run since that time has made changes in gconf, but some 
> may still read the current state.
> 
> Having said all that, it's unlikely there are still currently maintained 
> applications using GConf though. And if you remove the directory, worst case 
> is for those applications the default preferences are reset. You  won't loose 
> your data because of this.
> 
> If in doubt, archive a copy of the directory somewhere before removing. If 
> you 
> find one of your applications starts behaving oddly (in the sense it's no 
> longer configured as you expected) you may check if it's still using gconf.
> 
> Regards,
> 
> Geert
> 
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)

[Adrien Monteleone]

Aha!

‘Purchase Order’ is easier to grok for this.

Would that be a terribly difficult fix? Would a bug report be welcome or are 
there messy implications by changing it? At least one I can think of would be 
users wanting to create a single ‘PO’ document (with line items) independent of 
bills/invoices. I think I’ve seen that question already on the list.

And thank you for the clarifications!

Regards,
Adrien

> On Aug 23, 2018, at 8:23 AM, Derek Atkins  wrote:
> 
> Adrien Monteleone  writes:
> 
>> Yes, thank you Derek,
>> 
>> I was describing it backwards.
>> 
>> A single invoice can have only one job and a single job can’t be used
>> with multiple vendors. (or multiple customers, but I would think that
>> to be a very rare case)
>> 
>> So in addition to the first case, there is also the limitation that
>> you also can’t buy supplies from multiple vendors on the same job.
>> 
>> Or did I confuse that as well?
> 
> No, you go it right.   Think of a job as a "vendor contract", a way to
> link multiple vendor bills together for some purpose.  I suppose I
> should have named it "Purchase Order".
> 
>> The other part I never could understand was not being able to use the
>> same ‘job’ for both a customer and a vendor. So even following the
>> above limitations, I can’t use a job on a vendor bill to rebill a
>> customer AND assign that job on the customer’s invoice?
> 
> See above.  A "job" is really a misnomer.  The idea was more like a
> "Purchase Order" (PO).  A PO is a way to link multiple invoices
> together, but a PO is only valid to a single customer or single vendor.
> 
>> I’m also not quite understanding your last caveat. So the Job is then
>> not an extra layer of info, but replaces the Vendor/Customer? I think
>> I’m truly lost now on the feature and its purpose.
> 
> Internally that is correct.  Because a Job (PO) has only a single
> customer (or vendor), you can use a Job instead -- so the "Owner" of an
> invoice can be a Job (which implies a customer).
> 
>> Regards,
>> Adrien
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

[Adrien Monteleone]

Originally I had typed ’simple’ in quotes and thought better of it. Certainly 
no, it won’t be simple or easy. But I do hope by then, either myself or someone 
else with nothing better to do will write a Cocoa native version. (or whatever 
Mac is using at the time) I have to say though, the present Gtk+3 version is 
much better than the old Gtk+2 iteration. (even with the quirks and bugs)

Regards,
Adrien

> On Aug 22, 2018, at 11:17 PM, John Ralls  wrote:
> 
> 
> 
>> On Aug 22, 2018, at 3:41 PM, Adrien Monteleone 
>>  wrote:
>> 
>> 
>>> On Aug 22, 2018, at 4:04 PM, GWB  wrote:
>>> 
>>> 
>>> Why is gnucash in the Gnome ghetto for program categories?  Am I able
>>> to run it in xfce because I already have the gnome dependencies
>>> installed already?
>>> 
>> 
>> That is probably an historical artifact. You can run it in XFCE as that is 
>> built on Gtk. If you try to run it on KDE, you can still run it, but it will 
>> pull in the Gtk dependencies. (that is, it won’t use QT which is native to 
>> KDE)
>> 
>> Somewhere long in the future, when/if GnuCash abides the MVC pattern, it 
>> will be easier to port the interface using a native toolkit such as QT, 
>> Cocoa, etc. At present, the functional code is very tied to the UI which is 
>> built using Gtk.
> 
> We do hope so, but easier != easy. Writing a GUI is a lot of work, and aside 
> from the general design one must pretty much start from scratch every time. I 
> don’t anticipate that core GnuCash will ever provide multiple GUI toolkit 
> implementations.
> 
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to open new version

[Adrien Monteleone]

> On Aug 28, 2018, at 4:58 AM, Ian Lancaster  wrote:
> 
> Colin
>   Thanks for your very quick reply to my problem.
>   I have tried the File>Open but the new app seems to overrule the 
> original program.
>   The Apple techs tell me that the accounts seem to be contained in the 
> app and not with my other documents.  
>   I had reconciled my accounts up until the end of last month so I was 
> prepared to start again even though it was unfortunate to loose all that 
> information that is why I was urged to contact GnuCash to see if it was 
> possible to find a way to retrieve the original information.
>   You reminded me of something I had forgotten.  I have backups of all my 
> data so I have the answer.
>   One thing, the Apple techs showed me was, that in the System 
> Preferences, HQ has reduced the acceptable apps to; 1 From the App Store, and 
> 2From recognised developers.  They have removed unrecognised developers; 
> without the option of you being able to open the program .  They say HQ has 
> done this in the name of Security.
Ian,

You need to solve the ‘installation’ issue first. It should copy over and 
launch normally without bypassing GateKeeper. Not only will you have some 
issues opening your file, you may see some issues with Dock icons. There have 
been threads on both issues on this list.

The app IS signed by a recognized developer. If GateKeeper is telling you it 
isn’t, you need to verify the app itself. Perhaps you have a corrupt download? 
Where did you get it from? (should have been GnuCash.org which sends you to 
SourceForge) Are you copying the app to /Applications or 
/user/your-user/Applications? (and *not* trying to run it from the dmg)

Regards,
Adrien



> 
>> On 28 Aug 2018, at 17:06, Colin Law  wrote:
>> 
>> You should be able to use File > Open and browse to your accounts
>> file, wherever you originally saved it.
>> If you have lost that for some reason then hopefully you have a recent 
>> backup.
>> 
>> Colin
>> On Tue, 28 Aug 2018 at 06:31, Ian Lancaster  wrote:
>>> 
>>>   For years (2011?) I have used GnuCash to keep my personal accounts.  
>>> A few years ago I could not open the program and had to download the new 
>>> version.
>>>   A few days ago again I could not open the program to update some 
>>> information, and again it would not load.  So I thought a similar thing had 
>>> occurred and downloaded the latest version.  Like a fool I deleted the old 
>>> app.
>>>   When I tried to open the app, Apple would not open the program 
>>> because “the program was not purchased from the Apple App Store”.  I fixed 
>>> that problem but now when I open the program I get a new blank page not my 
>>> usual accounts.
>>>   Everything has been corrected with the Apple techs and they say to 
>>> contact you to see if there is someway to resurrect the accounts.
>>> Ian Lancaster.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcilliation deferal

[Adrien Monteleone]

Rich,

That might be a bug, not sure, you could file one or maybe a developer will 
chime in. But if you click the reconcile column in the transactions themselves 
until they change from ’n’ to ‘c’ they will be checked off the next time you 
attempt reconciliation and even cancelling that should not change their status. 
(unless perhaps you uncheck and re-check, I don’t know)

Regards,
Adrien

> On Aug 17, 2018, at 3:01 PM, Rich Shepard  wrote:
> 
>  Perhaps I've missed something. If not I ask for a fix in the next release.
> 
>  When reconciling my bank accounts I sometimes need to go back to account
> registers and fix an error so I elect to defer the reconciliation process
> until later. However, when I return all previously checked transactions have
> been cleared and I need to start over. It would save time and hassle to have
> filled checkboxes saved as such when the reconciliation process is deferred.
> 
>  An alternative is to drop that option and either finish or cancel the
> process.
> 
> Regards,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcilliation deferal

[Adrien Monteleone]

I do the same, I understood you needed to cancel the reconciliation for a long 
period due to lack of info. Really, the only time I’ve ever cancelled a 
reconciliation, was when I was testing something.

If I’m not mistaken, if you enter other transactions while the reconcile window 
is open, they will appear there as well. If you don’t shut down GnuCash, you 
could conceivably leave the reconcile ‘in progress’ for as long as you need to.

Regards,
Adrien

> On Aug 17, 2018, at 4:12 PM, Rich Shepard  wrote:
> 
> On Fri, 17 Aug 2018, mdfor...@forbii.com wrote:
> 
>> I've always been able to just edit the transaction while the reconcile
>> window is still open.  I just switch over to the register window, make my
>> changes and switch back.  I believe there might even be an option to edit
>> the transaction in the reconcile dialog.
> 
> Matt,
> 
>  Hadn't thought to try that.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcilliation deferal

[Adrien Monteleone]

That still works. I think it was noted below.

Regards,
Adrien

> On Aug 17, 2018, at 6:43 PM, David Carlson  
> wrote:
> 
> In earlier (2.6.x) versions of GnuCash one could highlight any transaction in 
> the reconcile window and either click the edit button i the title bar or 
> double click the transaction in the reconcile window to go directly to that 
> transaction in the register, edit it and return to resume reconciling.  I 
> doubt that has changed, it it has, it would be a serious regression in my 
> opinion.
> 
> David C
> 
> 
> 
> On Fri, Aug 17, 2018 at 5:59 PM, D via gnucash-user 
>  wrote:
> I was going to note that one can edit transactions during the reconcile 
> process by double clicking the transaction, making your changes, and 
> returning.
> 
> On August 17, 2018, at 1:38 PM, Adrien Monteleone 
>  wrote:
> 
> Rich,
> 
> That might be a bug, not sure, you could file one or maybe a developer will 
> chime in. But if you click the reconcile column in the transactions 
> themselves until they change from ’n’ to ‘c’ they will be checked off the 
> next time you attempt reconciliation and even cancelling that should not 
> change their status. (unless perhaps you uncheck and re-check, I don’t know)
> 
> Regards,
> Adrien
> 
> > On Aug 17, 2018, at 3:01 PM, Rich Shepard  wrote:
> > 
> >  Perhaps I've missed something. If not I ask for a fix in the next release.
> > 
> >  When reconciling my bank accounts I sometimes need to go back to account
> > registers and fix an error so I elect to defer the reconciliation process
> > until later. However, when I return all previously checked transactions have
> > been cleared and I need to start over. It would save time and hassle to have
> > filled checkboxes saved as such when the reconciliation process is deferred.
> > 
> >  An alternative is to drop that option and either finish or cancel the
> > process.
> > 
> > Regards,
> > 
> > Rich
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cannot change preferences

[Adrien Monteleone]

I think Ken mentioned GnuCash 2.6.15 in Debian Stretch in the OP.

Regards,
Adrien

> On Aug 18, 2018, at 8:57 AM, Colin Law  wrote:
> 
> On Sat, 18 Aug 2018 at 14:52, Geert Janssens 
> wrote:
> 
>> Op zaterdag 18 augustus 2018 15:47:06 CEST schreef Ken Heard:
>>> On 2018-08-18 02:07, Colin Law wrote:
 On Fri, 17 Aug 2018, 22:59 Ken Heard,  wrote:
> On 2018-08-17 17:26, Colin Law wrote:
>> The apply button doesn't really popup (for me on Ubuntu 18.040) it
>> just
>> appears in the bottom bar of the window.
>> 
>> Colin
> 
> I don't even see it there.  The bottom bar has this text "The change
> will be applied on such request or if you quit this view." followed by
> two buttons. The first is blue with a check mark in it.
 
 That is the Apply button. My version has the text, apparently you have
>> a
 different version.
>>> 
>>> If that button is supposed to be the apply button, it does not apply the
>>> changes.  Clicking on is restores the defaults.
>>> 
>>> Clicking on the text line itself does nothing.
>>> 
>> That means dconf is not working properly on your system. And that explains
>> why
>> it's not working in gnucash either.
>> 
>> Is the dconf package installed on your system ? This is separate from the
>> dconf-editor package.
>> 
> 
> @Ken have you told us which OS and version you are using?  I can't find it
> in the thread.
> On my Ubuntu 18.04 there isn't a package dconf, but there are a number of
> other dconf packages.
> If it is an Ubuntu or Debian system what does this command show:
> apt-cache policy dconf*
> 
> Colin
> 
> 
>> 
>> Regards,
>> 
>> Geert
>> 
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Column widths again

[Adrien Monteleone]

The first place I’d go is ubuntuforums.org and check out the Hardware forum, 
asking for help there with specifics on your system will probably get you the 
fastest solution.

Regards,
Adrien

> On Aug 18, 2018, at 11:34 AM, Graham Balin  wrote:
> 
> So , forgive me if this is a basic stupid newbie question, but where do I
> find the screen driver? Do I look in HP or Ubuntu libraries?
> --
> 
> Cheerio,
> 
> Graham
> 
> 
> On Sat, 18 Aug 2018 at 00:36, David Carlson 
> wrote:
> 
>> I think that some installations of Debian and Ubuntu (and probably most
>> other flavors of Linux) default to 600x800 pixels if there is not a good
>> screen driver installed.  The Dell Inspiron may need a non-free driver.
>> That could cause what Graham is seeing.  I thought that GnuCash could deal
>> with that, but it would not look nice.  I am not sure in that case if it
>> would help to temporarily switch to two line view and drag the right edge
>> of the Description title leftward to see the Balance.
>> 
>> David C
>> 
>> On Fri, Aug 17, 2018 at 4:00 PM, Colin Law  wrote:
>> 
>>> On Fri, 17 Aug 2018 at 19:11, Graham Balin 
>>> wrote:
>>> 
 Sorry guys if there is any misunderstanding here. There is no account
>>> field
 or rate field . in the basic ledger view i have
 date-num-description-transfer-R-receive-spend-balance.
 Double clicking the Balance header moves it right out of view!
>>> Description
 takes up almost the whole screen.
 This is in basic ledger view for asset accounts but the same thing
>>> happens
 with expense and stock accounts as well. Balance is always off screen.
 
>>> 
>>> I wonder if there is an issue with how big gnucash thinks the window is.
>>> I
>>> don't think you replied to my question asking which version of Ubuntu you
>>> are using and also why you can't unmaximise the window.  You should be
>>> able
>>> to make the window any size you like but you said you could not do that.
>>> 
>>> Colin
>>> 
>>> 
 
 Cheerio
 
 Graham
 
 On Thu, 16 Aug 2018, 10:53 pm GT-I9070 H,  wrote:
 
> Em qui, 16 de ago de 2018 às 13:34, David T. via gnucash-user <
> gnucash-user@gnucash.org> escreveu:
> 
>> Graham,
>> 
>> If your problem is specifically that the Balance column is too
>>> narrow,
>> then you’ve encountered a Known Idiosyncrasy: the Balance column is
>>> a
>> challenge to resize. In fact, the only way I know to get it to
>>> resize
 is
> to
>> double-click the column heading. This is documented in a note in the
> Guide
>> at 2.3.3.
>> 
>> David T.
>> 
> 
> I resize the Balance column with ease by dragging in the header its
>>> right
> divider to the right/left, I can even add/remove the "RATE" field in
>>> the
> records sheets so.
> 
> Regads
> GTI
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
 If you are using Nabble or Gmane, please see
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 -
 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
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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

Re: [GNC] Process Payment and convenience fees

[Adrien Monteleone]

Where to record the expense is likely a personal preference. Talk to your CPA 
if you have concerns, especially if you’re itemizing deductions and calculating 
percentages for a home business.

While you can edit the transaction in the A/P (and A/R) register, just to be 
safe, I always use the other register. So in this case, the credit card 
register. (you can always use the ‘jump’ feature to save some time getting 
there if needed)

It is safe to edit the main split, in this case, the credit card amount to 
reflect its actual total. I do this frequently with no issues.

If you edit the individual payments that are posted against A/P then you’ll 
have to edit the payment (right-click menu) and re-apply them.

Regards,
Adrien

> On Aug 27, 2018, at 9:22 AM, Justin H Haynes  wrote:
> 
> 
> 
>> On Aug 27, 2018, at 3:54 AM, elvis  wrote:
>> 
>> On 27/08/18 03:16, Justin H Haynes wrote:
>>> I have two invoices to pay to a utility company.  Let’s say the amounts of 
>>> the invoices are $200 and $300 for a total of $500.  I have paid $600, so 
>>> the payment correctly is applied to those two invoices, and $100 to the 
>>> Accounts Payable account.  I can see the three transactions in Account 
>>> payable.  Actually 3 splits - 1 for each of the amounts of the 2 invoices, 
>>> and 1 for the remainder, then on the other side of the transaction the $600 
>>> from Liabilities:Credit Card.
>>> 
>>> However, there was a convenience fee charged by the payment processor for 
>>> the city utilities.  So, the amount charged to my credit card was $603.49.
>>> 
>>> Will the best way to deal with this be to edit the split from the 
>>> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?
>> 
>> If it a fee that is incurred solely for paying the bill then it is part of 
>> your utility bill.
> 
> In this case, I suppose I could create a separate bill with only the 
> convenience of $3.49 and include that as one of the bills I pay with he 
> 603.49 payment, since that fee appears on no written statement I have 
> received.
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS gnc 3.2

[Adrien Monteleone]

Interesting, is this recent? I was switching between 3.0/2.6.19 and then 
3.1/2.6.21 and I never noticed them change. Since moving to 3.2 I haven’t tried 
a 2.6.x version again.

Regards,
Adrien

> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user 
>  wrote:
> 
> Just note that if you use 3.x and go back to 2.6.x, the program and your data 
> will still work together, but your key bindings will get changed (Command-S 
> will be Ctrl-S, etc.). It’s a little disconcerting at first.
> 
>> On Aug 27, 2018, at 4:00 PM, John Ralls  wrote:
>> 
>> It's a personal decision but there are only a few weeks till 3.3 so you 
>> might wait. On the other hand since you have a Mac you have the luxury of 
>> being able to have as many GnuCash versions as you like, just make sure that 
>> they either have different names or are in different folders. As long as you 
>> don't use any of the new 3.2 features that affect the data file you can 
>> switch back and forth at will.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
>>> 
>>> After 20 years on a linux desktop, I find myself in an iMac. I have gnc
>>> 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
>>> package as a download. But it seems like I saw a lot of folks with issues
>>> with 3.2. Should I upgrade?
>>> 
>>> Keith
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Associate file with transaction path

[Adrien Monteleone]

Anthony,

Did you find a solution?

What OS and is this a local path, external drive, network location?

Also, if Linux is your OS, did you by chance install using the flatpak?

Regards,
Adrien

> On Aug 11, 2018, at 5:24 AM, Anthony Marrian  
> wrote:
> 
> So sorry: version 3.2
> 
> From: Anthony Marrian
> Sent: 11 August 2018 11:23
> To: 'gnucash-user@gnucash.org' 
> Subject: Associate file with transaction path
> 
> The preference I've set under Edit / Preferences / General / Path Head for 
> Transaction Associated Files is ignored. Any tips, please?
> 
> With best wishes - Anthony
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

[Adrien Monteleone]

> On Aug 22, 2018, at 4:04 PM, GWB  wrote:
> 
> 
> Why is gnucash in the Gnome ghetto for program categories?  Am I able
> to run it in xfce because I already have the gnome dependencies
> installed already?
> 

That is probably an historical artifact. You can run it in XFCE as that is 
built on Gtk. If you try to run it on KDE, you can still run it, but it will 
pull in the Gtk dependencies. (that is, it won’t use QT which is native to KDE)

Somewhere long in the future, when/if GnuCash abides the MVC pattern, it will 
be easier to port the interface using a native toolkit such as QT, Cocoa, etc. 
At present, the functional code is very tied to the UI which is built using Gtk.

Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)

[Adrien Monteleone]

Yes, thank you Derek,

I was describing it backwards.

A single invoice can have only one job and a single job can’t be used with 
multiple vendors. (or multiple customers, but I would think that to be a very 
rare case)

So in addition to the first case, there is also the limitation that you also 
can’t buy supplies from multiple vendors on the same job.

Or did I confuse that as well?

The other part I never could understand was not being able to use the same 
‘job’ for both a customer and a vendor. So even following the above 
limitations, I can’t use a job on a vendor bill to rebill a customer AND assign 
that job on the customer’s invoice?

I’m also not quite understanding your last caveat. So the Job is then not an 
extra layer of info, but replaces the Vendor/Customer? I think I’m truly lost 
now on the feature and its purpose.

Regards,
Adrien

> On Aug 22, 2018, at 9:59 AM, Derek Atkins  wrote:
> 
> Adrien Monteleone  writes:
> 
>> There is a ‘jobs’ feature in GnuCash, but it is very limited at the
>> moment. Each vendor can have only one job. So if you buy ‘parts’ or
>> multiple items on the same invoice from a single vendor and then in
>> some fashion, direct, recombined, or further process or manufacture,
>> you can’t tie that job to multiple clients.
> 
> Just to clarify -- I think you have this backwards a bit.  A Customer
> (or Vendor) can have multiple jobs associated with them.  On the other
> hand, a Job can only have one Customer or Vendor that owns the job.
> Moreover, an Invoice or Bill can only have one "owner" (which can be a
> Customer/Vendor or a Job).
> 
> So yes, if you buy parts or multiple items on one bill from a single
> vendor, that can only be applied to a single job.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> -- 
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>   warl...@mit.eduPGP key available
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

[Adrien Monteleone]

I know at least one uses Fedora, so they won’t be building a .deb for you. (an 
.rpm perhaps?)

But building a .deb package is what you’re going to find in a repository. 
(Debian/Ubuntu/derivative repositories are collections of .deb packages)

3.2 has not made it out of Sid because of several issues, all noted on the 
page: https://tracker.debian.org/pkg/gnucash originally linked by Lincoln 
earlier in the thread.

That page seems to indicate 2 main issues (the others will likely auto-resolve):

1. Three Debian core supported architectures don’t have a successful GnuCash 
build for them: armel, mips, s390x (the last two had automated builds fail as 
of today even, producing segfaults when building, noted here: 
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=906609)

2. GnuCash has a dependency on guile-2.2-dev, but it seems this can’t be 
satisfied on armel (and why it can’t build).

Once those builds are successful, it will likely come out of Sid and move to 
Testing.

So, unless you’re running one of those architectures, the short term solution 
is build yourself. (which really isn’t difficult, especially since the 
instructions have just been clarified and revised on the wiki)

Regards,
Adrien

> On Aug 22, 2018, at 12:14 AM, Stephen M. Butler  wrote:
> 
> On 08/21/2018 08:32 PM, GWB wrote:
>> Yes, thank you, I may try building from source.  Has there ever been a
>> standalone .deb package for GnuCash?  I don't know what the flatpack
>> is, but it occurs to me that for linux, debian, etc., a 3.x .deb might
>> be worthwhile.  But I don't think I have seen a .deb package on the
>> download links at GnuCash.org.
>> 
>> If not, is that intentional?  Some distros are good with
>> "automagically" finding and installing dependencies when using .deb
>> packages, and some are not.  Source may be less hassle anyway on some
>> distros.
>> 
> I'm not sure which distro the developers use.  So there may not be one
> that could create a deb package.  I'm not sure what would be involved to
> do that.
> 
> -- 
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3 in the Debian / Ubuntu pipeline?

[Adrien Monteleone]

I’m not sure what you mean by ’not getting too far ahead of your distribution.’

I’ve successfully compiled and used 3.2 (and 2.6.17 and 2.6.19) on Ubuntu 16.04 
which has 2.6.12 in its repo.

Unless you’re using a dedicated PPA (which doesn’t exist for GnuCash), 
certainly changing repos to debian/unstable or trying to change to a different 
ubuntu repo (like using the bionic repo on xenial) can be dangerous.

But building from source, which is not all that complicated, is generally fine. 
(problems arise if you have dependency conflicts with other software)

Regards,
Adrien

> On Aug 21, 2018, at 4:55 PM, GWB  wrote:
> 
> I'm not sure how the version history works in Ubuntu or Debian, but I
> installed GnuCash 2.6.7 from getdeb.org quite a while ago, and
> "pinned" it (so that apt-get upgrade would not go to the version up)
> to that version hoping that gnucash in Ubuntu 14 would catch up with
> 2.6.7.  Ubuntu 14 ("Trusty Tahr") still only has 2.6.1, but 18.04
> ("Bionic Beaver" really? who comes up with these names?) has indeed
> included 2.16.19, as John recalled.  18.04 is my next upgrade.
> 
> Every time I run "apt-get update" I am reminded that getdeb.org is
> gone, and has been for some time.  Did getdeb.org have gnucash 3.0 at
> some point before it went dark?
> 
> I don't see either the Ubuntu or Debian package maintainers (perhaps
> the same person or team in this case) moving too quickly to upgrade
> gnucash in their package repos.  But maybe I'm wrong, which would be
> nice.  But if you do find a repository with 3.x.x, I would pin it (or
> "version lock") to a lower version in order not to get too far ahead
> of the main repos for your linux distribution.
> 
> Alas, 18.10 ("Cosmic Cuttlefish") lists:
> 
> gnucash (1:2.6.19-1)
>[universe]personal and small-business financial-accounting software
> 
> at https://packages.ubuntu.com/cosmic/gnome/
> 
> Perhaps 19 ("Vomiting Vole") will have gnucash 3.  Until then, check
> for other repos, look in unstable and testing to see if some
> adventurous soul decided to be creative, and unless you absolutely
> need some feature in the latest release, pin your version and don't
> get too far ahead of the main repo for your distribution.
> 
> Gordon
> 
> On Mon, Aug 20, 2018 at 7:41 PM, Lincoln A Baxter  
> wrote:
>> Just curious...  It has been almost a year since Gnucash was removed to
>> Debian testing.
>> 
>> It has (re)entered SID on 7/4, and there it sits...
>> 
>> Who is responsible for working on the "excuses" for why is stays in
>> SID: https://tracker.debian.org/pkg/gnucash, and has not migrated to
>> Testing?
>> 
>> Lincoln
>> 
>> 
>> On Thu, 2018-07-05 at 00:39 -0600, Bert Riding wrote:
>>> I spoke too soon.  1:3.2-1 is now out in the unstable Debian repo.
>>> 
>>> On Thu, 5 Jul 2018 12:52:51 +0800
>>> Plutocrat  wrote:
>>> 
 Hi,
 
 I've been troubled by the lack of Gnucash activity in Debian/Ubuntu
 repositories. I previously used getdeb, which went silent around
 September 2017. I tried contacting the owners, but no reply. There
 was also an attempt on Launchpad to provided more recent versions via
 a PPA, but that also went inactive a few years back. Again I tried to
 contact the owners, but no response. And the main repos are stuck on
 2.6
 
 So for the last week or so I've been looking around, trying to figure
 out if I can start a PPA of my own, and looking for info on what are
 the necessary steps to fill it with .deb files. I was initially just
 looking to do 3.x on Ubuntu 18.04. Still haven't figured out exactly
 how this works.
 
 However I just came across this in my research. If I read it
 correctly, then it seems that 3.2 is being added to Debian Sid and
 so, eventually, to Ubuntu 18.10. Possibly it will be backported then
 to 18.04 and maybe even 16.x
 https://launchpad.net/ubuntu/+source/gnucash/1:3.2-1
 
 Here's hoping.
 
 P.
 
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 - 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
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> 

Re: [GNC] No Disk error

[Adrien Monteleone]

Were either of you at any time storing your GnuCash files on an SD card?

If so, I’d suggest using a card to load the file, then doing a Save As 
elsewhere (with the card still in the drive). Then close and re-open GnuCash to 
load from the new location. THEN Safely Eject and remove the SD card.

Otherwise, some sort of bug is at play.

Regards,
Adrien

> On Aug 22, 2018, at 7:30 AM, Mike stagl  wrote:
> 
> I have the same issue on Windows 7 and GnuCash 3.2, and I believe its because 
> I have several SD card readers on my machine and no cards installed in them.
> 
> 
> I haven't looked into a work around yet, but I agree its highly annoying.
> 
> 
> I figure I'll need to uninstall my SD card readers in order to stop the 
> alerts.
> 
> 
> Anyone else have any thoughts?
> 
> 
> Mike
> 
> 
> 
> From: Patrick Murez 
> Sent: Wednesday, August 22, 2018 1:34 AM
> To: gnucash-user@gnucash.org
> Subject: [GNC] No Disk error
> 
> Dear all I want to report a problem already submitted in this mailing list
> with no answer so far:
> 
> Hi!
> 
> I am starting over with gnucash, and thought I'd do a clean re-install.
> Note, I am on windows, and have removed all the gnucash files I could
> find before installing 3.1.
> 
> However, now I am getting an annoying error message every time I try to
> look at the preferences, as well as when I do "save as":
> 
> Gnucash.exe - No Disk
> There is no disk in the drive. Please insert a disk into drive
> \Device\Harddisk1\DR1.
> 
> I have the options Cancel, Try Again and Continue. Try Again just pops
> up the message again, so do the other two too. However, if I click
> enough times on Cancel or Continue, the message goes away.
> 
> Note, when I change something in Preferences, that change stays when I
> quit and restart.
> 
> This is quite annoying, and if anybody could shed some light on what has
> happened and how to get rid of said message, I'd be very happy.
> 
> Karin
> 
> your help will great.
> 
> Thanks
> 
> --
> 
> --
> Patrick Murez, Ch. Eng.
> Unit Manager Technical Trainings
> Ruashi mining
> Cel.:+243816179054
>   +243995601060
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Veihicle mileage cost such in HomeBank?

[Adrien Monteleone]

I would think it possible to do this in your regular books, with a bit of care.

I would favor using equity accounts only, but I suppose using Income/Expense 
(as you noted are really Equity anyway) is probably easier for many to wrap 
their head around.

The care would come in that you’d need to create new parent accounts of your 
fundamental type choice, and be sure not to include that part of your tree in 
’normal’ reports.

Regards,
Adrien

> On Aug 25, 2018, at 5:16 PM, Mike or Penny Novack 
>  wrote:
> 
> On 8/25/2018 2:32 PM, Riccardo Delpopolo Carciopolo wrote:
>> Hello Rich,
>> 
>> thank you for the extended explanation!
>> I think I would end to use a simple spreadsheet as you suggest.
>> 
>> Regards
>> 
> HOWEVER (since this might be useful for others)
> 
> I use a spreadsheet for mileage since we want to be able to have totals by 
> category. Medical and non-profit for taxes and we track civic and political 
> too just to see how much driving we do for those. That few number of columns 
> easy to do/print from a spread sheet.
> 
> In spite of the fact that gnucash is an accounting package, this could 
> provide a simple example of using  "virtual books". Imagine for just a moment 
> that there was a country whose currency was "miles". You could set up a very 
> funny partial set of books. Instead of fundamental types asset, liability, 
> equity, income, and expense suppose you did away with all but income and 
> expense (technically those are of fundamental type equity). Under Income 
> would be just a single account called "total miles". Under Expense would be 
> an account for each mileage category you wanted to track plus one 
> miscellaneous for other trips. The only report you would run would be the 
> income statement. Your transactions are just total miles (income) allocated 
> to the category (expense) << a single trip MIGHT need a split if for more 
> than one purpose >>
> 
> If you only have a few categories, I'd use a spread sheet. But those can be 
> annoying when MANY columns wide. Let's suppose that you did contracting jobs, 
> perhaps a dozen or two every year, or even more. And suppose each of these 
> had mileage associated with it. And suppose you wanted to track all of this 
> << see how much mileage for each job" >>  Now using gnucash in the "funny" 
> way might seem attractive.
> 
> Michael
> 
> Michael D Novack
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Duplicated Scheduled Transactions

[Adrien Monteleone]

Do a series of Finds from the CoA based on the info in your SX editor?

> On Jul 19, 2018, at 6:17 PM, David Carlson  
> wrote:
> 
> Somehow I have managed to duplicate a whole bunch of scheduled transactions
> in various account registers.  Is there some way to find them easier than
> discovering them accidentally when updating accounts?  They are not all on
> the same day or limited to one or two accounts.
> 
> This must have happened when GnuCash crashed a couple of days ago, but how
> it remembered the entries but forgot the entered flag in the SX list, I am
> not sure.
> 
> David C
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports indentation

[Adrien Monteleone]

Nigel, as long as your parent accounts are all placeholders that will work 
fine, but if any of them can or do contain transactions, by not showing their 
balances, the sum of the accounts on the report won’t match the totals shown. 
(making all parent accounts placeholders is probably the safest practice though)

Regards,
Adrien

> On Jul 20, 2018, at 10:14 AM, Nigel  wrote:
> 
> Adrien. You made me experiment a bit and I came up with:
> Parent account balances: Do not show
> Parent account sub-totals: Show sub-totals
> Show accounting style rules
> 
> Apart fro column indentation being dependant on longest account name (you can 
> possibly fudge that with account names :-(), this seems perfect to be. So 
> what if Total Expenses is at the bottom not the top.
> 
> No longer any need to export to Excel.
> Thanks.
> 
> Christopher. Downloaded the file and will be happy to test. A bit busy 
> setting up the books for the shop the wife is buying (doing a crash course on 
> bookkeeping), but when I am settled I might learn Scheme. I have lots of 
> experience with numerous languages, so what is one more.
> 
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports indentation

[Adrien Monteleone]

Even with your example, the Income and Sales amounts should be further to the 
right. I agree, child account amounts should be on the left and 
parents/subtotals/totals should be on the right.

Try this in your report options:

Set Parent Account Balances to ’Subtotal’
Set Parent Account Subtotals to ‘Do Not Show’

This will produce the following:

RevenuesR0,00
Income  R0,00
Interest Income R0,00
Other IncomeR0,00
Sales   R0,00
Consignment R0,00
Consignment R0,00
Core Business   R0,00
Biltong R0,00
Miscellaneous   R0,00
Total Revenue   R0,00

This will give you all parent totals to the right of their children, however, 
you do get a duplication with the grand totals for each section (revenues, 
expenses)

If you chose to show subtotals, you’d get duplication there as well.

Personally, I prefer these settings:

Parent Account Balances to ‘Account Balance’
Parent Account Subtotals to ’Show Subtotals’

I also set Omit Zero Balance figures and Show Accounting Style Rules.

This produces the following:

Revenues
Income
Interest Income R0,00
Other IncomeR0,00
Sales   R0,00
Consignment
Consignment R0,00
Total Consignment   -   R0,00
Core Business
Biltong R0,00
Miscellaneous   R0,00
Total Core Business -   R0,00
Total Sales -   R0,00
Total Income-   R0,00
Total Revenue   -   R0,00

The totals are always to the right of the children and are made more obvious 
with the lines. While there is duplication with the account names and 
subtotals, the subtotals stand out more and are easy to spot and read.

Note, I also dropped the total for revenue and expenses simply to reduce 
another instance of duplication as the revenue and expense accounts show their 
own subtotals already.

Regards,
Adrien

> On Jul 19, 2018, at 12:10 PM, Nigel  wrote:
> 
> I have looked for references to the problem via Google, but with no luck.
> 
> My problem is with indentation in reports with accounts that have children. I 
> feel that the parent should be indented further than the children, to give 
> the correct hierarchy. That way, the entries in a column are the total of the 
> entries in the column to the left (children.) This makes it a lot easier to 
> read. In a way, it also causes display redundancy, where some values are 
> displayed more than once.
> 
> Of course, there may be significant problems in implementing this.
> 
> I created a report with accounts that have children and children that have 
> children. Formatted with borders in Excel to help visualise the situation. 
> Sub-totals are switched off because they seem to cause even more 
> "redundancy." Any account with children is a placeholder.
> 
> Levels of Subaccounts is 4. This is what we get:
> Revenues  
> IncomeR0,00   
>   Interest Income R0,00   
>   Other IncomeR0,00   
>   Sales   R0,00   
> Consignment   R0,00   
>   Consignment R0,00   
> Core Business R0,00   
>   Biltong R0,00   
>   Miscellaneous   R0,00   
> Total Revenue R0,00
> 
> This is not right. The sub-total Core-business should not be in the same 
> column as the children Biltong and Miscellaneous.
> 
> This is how it should look:
> Revenues  
> IncomeR0,00   
>   Interest Income R0,00   
>   Other IncomeR0,00   
>   Sales   R0,00   
> Consignment   R0,00   
>   Consignment R0,00   
> Core Business R0,00   
>   Biltong R0,00   
>   Miscellaneous   R0,00   
> Total Revenue R0,00
> 
> 

Re: [GNC] How to change the order of the account list in pull-down menu during transaction register

[Adrien Monteleone]

They should be sorted by alpha. I’m not sure you can change that. (easily) I 
have a book using account numbers, but those don’t seem to affect the sort 
order. I also don’t see any preference for using another method.

Regards,
Adrien

> On Jul 17, 2018, at 12:47 AM, Alex Mak  wrote:
> 
> Hi Gnucash team
> 
> I would like to know how to change the order of the account list in the
> pull-down menu during transaction register ? Seem some of the account is
> not well ordered.
> 
> Regards
> Alex Mak
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Lost Files

[Adrien Monteleone]

Perhaps the files just aren’t where you are expecting them to be? (It can be 
too easy to click quickly when saving a file resulting in data winding up in 
odd locations) The ‘helpful’ feature of Gnucash that opens your last used file 
when opening the application can lead to the ‘forgetfulness’ of where the data 
is stored. If when last saving, you didn’t notice the location wasn’t where you 
normally save to, that ‘helpful’ feature makes finding the file in such a 
situation a tad difficult. (not that I’d change the feature, it’s just a ‘cost’ 
associated with it)

I’d do a search in Explorer to find any file with a .gnucash extension. 
(“*.gnucash”) Search all folders and drives, including hidden folders and 
system folders. Also be sure to not restrict the file type. (you may need to do 
an ‘Advanced’ search to enable all of those options) If you find the desired 
file, check that same location in the backup. My guess will be you’ll see a 
copy in that same odd place.

Finally, for the future, my advice would be to pay head to the rule, “If your 
data doesn’t exist in three places, it doesn’t exist at all.” That means, you 
need a backup, for your backup. Ideally, not just three physical copies, but in 
three physically separate locations. (not always easy to accomplish, but you’ll 
be reducing the probability of permanently lost data to nil)

Regards,
Adrien

> On Jul 17, 2018, at 3:19 PM, Michael Berkson via gnucash-user 
>  wrote:
> 
> I have lost all ledger and log files between 13 Oct 2017 and 15 July 2018.  
> Unbelievably, they are also missing from my off-line back up.
> 
> On 14 July 2018, I tried to open GnuCash.  The sequence appeared normal until 
> completion of user data download, when the file opened as a minimized icon on 
> the task bar, which I could not expand or read.   Since then every attempt to 
> open GnuCash brings up  the 13 Oct 2017 version updated only by scheduled 
> credits.
> 
> I am using GnuCash 3.1.  My operating System is Windows 10 Professional and 
> my preferred browser is Firefox 61.0.1 (32-bit).
> 
> I have run a System Restore and two lost file programs, EaseUS Data Recovery 
> and DiskDigger, without success.
> 
> Can you please help me to retrieve my missing accounts.
> 
> -- 
> Thanks
> 
> Michael Berkson
> 
> Southernwood
> 5 Woollards Lane
> Great Shelford
> CAMBRIDGE
> CB22 5LZ
> 
> Tel (Home) 01223 844503
> Office  01223 840510
> Mobile 07505 948170
> e-mail  michael.berk...@tiscali.co.uk
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] survey: unifying the appearance in different options dialogs

[Adrien Monteleone]

I didn’t realize there were so many such dialogs!

Looking them over now, I’d think setting the value to “8” would leave some room 
for future flexibility and this appears to be doable based on the size of most 
tabs. (this would vary with very long strings, perhaps considering German, it 
might be better to leave the max at “6”)

It looks like the Import/Export and Online Banking setup dialogs are different 
in that they force the user to step through each tab in order. Normally, tabs 
should not depend on or affect settings in other tabs. (or the dialog should be 
re-arranged) Since this is the case with those dialogs, it seems either they’ve 
been specially designed, or they are using a different gtk element to force the 
progression through tabs rather than let the user jump around.

I see some room for improvement here as well. Adding numerals before the label 
of each tab in these ‘ordered-tab-dialogs’ would make the fact that you have to 
go in order a bit more obvious. (I tried to jump around, and only when I 
couldn’t did I notice the ’Next’ button which clued me in)

Additionally, it seems the Import Bills/Invoice and the Customers/Vendors 
dialogs are intended to operate the same way, but simply haven’t been 
transitioned to the other format. (which I personally think is the better 
design as it forces the user to enter required information in order.)

If those last two changes aren’t something you’ll be dealing with, I’ll just 
file bug reports/RFE’s on them.

Thanks for your work!

Regards,
Adrien

> On Jul 17, 2018, at 2:42 PM, Di Mang  wrote:
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Edit Report options> Fancy Invoice > Default stylesheet

[Adrien Monteleone]

Does “GnuCash > Preferences > Business > Report for Printing:” not allow you to 
select your custom invoice?

This should control what is the default as far as I can tell.

Regards,
Adrien

> On Jul 19, 2018, at 9:46 AM, Andres Muniz Piniella  
> wrote:
> 
> Hopefully an easy one:
> I am running GnuCash 2.6.12 on ubuntu 16.04
> 
> I have edited /usr/share/gnucash/scm/gnucash/report/fancy-invoice.scm
> such that I don't have to manually change almost any value when I click
> "edit Report options". 
> 
> The last thing I can't manage is for it to default to my stylesheet and
> not to default. 
> 
> At first I thought it only picked the first one in alphabetical order
> but I created A-technicolor but still "default" was selected. 
> 
> Is it one of these two lines?
> 
>   (define gnc:*report-options* (gnc:new-options))
> 
>   (define (gnc:register-inv-option new-option)
> (gnc:register-option gnc:*report-options* new-option))
> 
> Thanks for your time!
> 
> 
> 
> -- 
> Andres (he/him/his)
> 
> HUG Director
> 
> RML Founding Member 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Posting private payments

[Adrien Monteleone]

The basic approach look fine here, but I’d consider posting payments you make 
for the actual construction and for the materials under an Asset account called 
something like “Work in Progress” rather than the generic Asset account. (it is 
probably safer to consider the parent asset account, or any parent account 
really, as a placeholder only) You may desire to have separate child accounts 
for materials and labor if you need that level of detail until the project is 
finished.

Then when construction is complete, make an entry moving the value of Work In 
Progress to the “Installation A” account.

Note, if you pony up a set amount of cash into some account (or petty cash) 
that you then draw out of for this installation, then you should treat those 
separately as capital investments by each partner directly to that asset 
account. (cash/bank, etc.) Then make transfers to the Work In Progress 
account(s) as materials are purchase or work completed.

Also, consider, is this ‘installation’ part of your ‘inventory’? That is, will 
you be selling or leasing this completed installation? If so, both the ‘Work In 
Progress’ and the completed ‘Installation A’ accounts should be children of 
Assets:Current Assets:Inventory.

If you regularly will be buying materials to be used in several installations, 
then consider a Inventory:Raw Materials account. For example, you might buy 
bolts by the pound, but not use all of them in any one installation. You would 
move to Work In Progress only the value of the actual bolts used. (you probably 
should employ other specialized software, or a spreadsheet to manage these 
calculations for each project as GnuCash is designed only for the end-result 
accounting entries)

It would be a good idea to read up on accounting for manufacturing businesses 
to get ideas on how to handle accounting for the production of goods that you 
are going to sell or lease.

I maintain books for a small operation where we have partners who usually buy 
raw materials and equipment personally on their own. I’ve set up an 
Equity:partner-name:Investments account for each partner, and under these, I 
created Capital Investments, and Reimbursable accounts. (we intend to be paid 
back for those personal purchases, but you could call this simply In-Kind 
Purchases or something similar if you intend the equity to remain on the books) 
When we pony up cash for a larger purchase, or simply give cash to another 
partner for them to use when physically buying materials or equipment, I book 
this against Capital Investments and Petty Cash. Otherwise, all personal 
purchases go under the Reimbursable account. (“In-Kind Purchases” or similar 
otherwise)

But please speak to a CPA about any of this so you have guidance specific to 
your legal jurisdiction.

Regards,
Adrien

> On Jul 18, 2018, at 1:24 PM, arjanl via gnucash-user 
>  wrote:
> 
> Hi, I'm new to GNUC, but I'm aware of most of the regular bookkeeping
> methods. My business partner and I just started a new business and we are
> paying for stuff out of our own pockets at the moment. These payments are
> booked on two equity accounts, called "Private payments A" and "Private
> payments B". The stuff we bought so far (materials) is all being used for an
> installation, to be found in our books under "Assets/Installation A". 
> 
> Now comes my question: how should I post all the payments that are done for
> building the installation? I now make transfers from "Private Payment"
> directly to "Assets", to be transferred to "Assets/Installation A", when the
> installation is completely built and paid for. So no transfers to
> "Assets/Cash" or any Expense account.
> 
> Is this OK bookkeeping wise?
> 
> Many thanks in advance for your responses!
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Future Payments

[Adrien Monteleone]

You can do it that way, and date the transaction appropriately (as 31st July). 
It will show in the register with a line between it and the current/historical 
transactions. (I think it will be a blue line if I recall)

Any report you run through or as of 30th July, (in this particular case) that 
transaction will not be included in the total for that account.

But if you really just want to schedule it, then use the Scheduled Transaction 
Editor as noted.

Regards,
Adrien

> On Jul 14, 2018, at 9:42 AM, adb34 via gnucash-user 
>  wrote:
> 
> Ah, that might be the problem. I was putting it straight in the account under
> expenses
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] survey: unifying the appearance in different options dialogs

[Adrien Monteleone]

Di Mang,

I have no preference for either top or left-side tabs, as long as they are 
consistent across the application. However, I can see that changing the main 
app preferences to top tabs might be cumbersome as there are so many. 
Therefore, if a delineation were made that ‘preference panes’ use left-side 
tabs, and ‘report-options’ used top-tabs, I think that would help to maintain 
functional consistency. App and file (book) preferences are something changed 
less often. Report Options might be adjusted frequently to generate different 
views of the same data.

The only other change visually I would think in order would be to style the 
report-options similar to the application preferences, by reversing the colors. 
(the main content area should be lighter colored, the tabs, darker) The styling 
change would make all preference/option dialogs consistent and easier to focus. 
With the present scheme, the tabs grab the user’s attention more than the 
options themselves. (I understand this wouldn’t hold up with any particular 
alternative gtk theme, but the default should look proper)

Regards,
Adrien

> On Jul 14, 2018, at 5:12 PM, Di Mang  wrote:
> 
> Hello gnucash user,
> 
> ​​
> during a comparison of the english and german versions of GnuCash, I
> ​have ​
> noticed that the dialog "Book Options" looks different
> ​ly​
> in both languages:
> * in english version this dialog has four tabs, which are arranged at the
> top (horizontally)
> * in the
> ​german version there are five tabs (one tab more for tax data), which are
> arranged on the left side (verticaly).
> 
> To fix this different appearance in both language, I have increased the
> global value MAX_TAB_COUNT from 4 to 5 (see my PR:
> https://github.com/Gnucash/gnucash/pull/382). This should make the
> appearance of the "Book Options" dialog the same in both languages.
> 
> As noted by the jralls, it is a global setting and this change also affects
> the appearance of the other reports' option dialogs with 5 tabs.
> 
> ​​
> It affect
> ​s​
> only
> ​the following reports - the appearance of the tabs will change from left
> side to the top:
> * reports/Transaction Report (5 tabs)
> * reports/Reconciliation Report (5 tabs)
> * reports/Assets & Liabilities/Balance sheet using eguile-gnc (5 tabs)
> * reports/Assets & Liabilities/General Ledger (5 tabs)
> * reports/Business/Receipt (5 tabs)
> * reports/Income & Expense/Equity Statement (5 tabs)
> * reports/Income & Expense/Income Statement (5 tabs)
> * reports/Income & Expense/Income and GST Statement (5 tabs)
> * reports/Income & Expense/Profit & Loss (5 tabs)
> 
> ​​
> The following reports have 6 tabs and will be
> ​​
> not affected from this change - tabs appears
> ​ furthermore​
> on the left side:
> * reports/Business/Australian Tax Invoice (6 tabs)
> * reports/Business/Tax Invoice (6 tabs)
> * reports/Income & Expense/Trial Balance (6 tabs)
> 
> In my opinion, this change leads to a consistent look of option dialogs in
> reports and other preference dialogs. If we increase MAX_TAB_COUNT to 6,
> the remaining three reports (see above) will get the same look too.
> 
> What do you think about it? Does this change have any disadvantages?
> 
> --
> ​​
> best regards,
> dimang
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Rod,

Do a list search for payroll questions via Google like this:

“site:lists.gnucash.org payroll”

That will limit the search to only the mailing list server. (I don’t think 
other search engines have that feature)

You’ll find many list topics dealing with the subject but the short answer is, 
no, there is no (and probably won’t ever be) any payroll module or features. 
Unfortunately, the jurisdictional requirement nightmare to comply with every 
nuance across the entire planet is beyond the time and resources of the small 
development team.

However, GnuCash can handle the payroll accounting entries and even print the 
checks. (with vouchers if you’re up for some finagling)

You’ll have to calculate the deductions from gross separately in some other 
software first though. The most common suggestion I’ve seen is to setup a 
spreadsheet with the proper deduction rates and you just fill in the gross.

If you spend some time on the formatting and setup, you could possibly even 
import the resulting transactions to GnuCash so as to avoid data duplication 
entry errors. (and save time)

Also, if the payroll transactions are generally the same, that is, salary based 
and regularly issued, you could either simply use the ‘duplicate transaction’ 
function each pay period, or otherwise set up a template scheduled transaction 
accordingly. (you get to approve the actual transaction) The latter option has 
the benefit of tying into a future scheduled transaction report so you can use 
that data to track future profitability.

Regards,
Adrien

> On Jul 25, 2018, at 11:22 AM, Roderick Anderson  wrote:
> 
> Looking for a way to handle payroll (US) that works/blends with  GNUCash.
> 
> The company I'm helping (actually a friend) is running some software that 
> isn't even available any more.
> 
> I've exposed her to GNUCash but the biggest hold up is payroll.  She does 
> accounting for some (very) small Water Districts and Homeowner Associations.
> 
> The database and associated files are hosted on a Linux server.  After this 
> last crash I really need to get her to move to software I can support.
> 
> Any suggestions or pointers to methods to handle payroll with GNUCash as the 
> accounting/bookkeeping.
> 
> 
> Side trip.  I use GNUCash for a small not-for-profit but have almost no 
> accounting experience so have kind-of blundered my way along -- 
> accounting-wise. (They keep reelecting me as Treasurer so I must be doing 
> something right.  Or, more probably, nobody else wants the job.)  :-)
> 
> 
> TIA,
> Rod
> -- 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Firefox is a browser, not a search engine, but I believe the current version 
defaults to using Google for it’s combo address bar-search field. (you can 
customize the toolbar to show the old separate search field where you can 
install many search engines and choose between them when searching) If you’re 
on an older version then it uses Yahoo! You can also manually change the 
default to any engine you have installed in the browser.

I just tried the site: option on both Bing and Yahoo and they both work. 
StartPage has severely truncated results with this specifier. (some terms 
return nothing) I’ve yet to see DuckDuckGo return anything at all using this. 
(both DuckDuckGo and StartPage use the Google engine via proxy)

Regards,
Adrien

> On Jul 25, 2018, at 1:45 PM, Rich Shepard  wrote:
> 
> On Wed, 25 Jul 2018, Adrien Monteleone wrote:
> 
>> That will limit the search to only the mailing list server. (I don’t think
>> other search engines have that feature)
> 
> Adrien,
> 
>  Firefox does.
> 
> Rich
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Payroll add-on, module, software?

[Adrien Monteleone]

Interesting. I’ll look’em over. Thanks!

Regards,
Adrien

> On Jul 25, 2018, at 3:07 PM, Rich Shepard  wrote:
> 
> On Wed, 25 Jul 2018, Adrien Monteleone wrote:
> 
>> Firefox is a browser, not a search engine, but I believe the current
>> version defaults to using Google for it’s combo address bar-search field.
>> (you can customize the toolbar to show the old separate search field where
>> you can install many search engines and choose between them when
>> searching) If you’re on an older version then it uses Yahoo! You can also
>> manually change the default to any engine you have installed in the
>> browser.
> 
> Adrien,
> 
>  True. I should have written that duckduckgo allows for both mail list
> searching as well as > 1,000 bang (!) codes. See, for example,
> <https://duckduckgo.com/bang>.
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Adrien Monteleone]

I don’t use the importer but this sounds like a good candidate for the FAQ or 
somewhere else appropriate on the wiki, if those of you who are more familiar 
with the process have the time.

If it’s simply a case of ‘import directly, don’t open it in Excel first’ I can 
certainly add that in myself.

Regards,
Adrien

> On Aug 29, 2018, at 7:36 AM, D via gnucash-user  
> wrote:
> 
> I should mention that this thread alerted me to the problems that Excel csv 
> files can cause with the importer. My own attempts to import price data also 
> failed, as I was using Excel as a source. I attempted to use different 
> encoding, as this person did, but none of the many format choices solved it 
> for me. My solution was to remove Excel from the process altogether.
> 
> It seems to me that there is need to determine precisely what needs to change 
> for the importer to work with Excel.
> 
> [For the record, I could never get the importer to process the EOL characters 
> in the Excel csv file. I'm on a Mac, and I know that EOL characters can vary 
> by OS. I tried replacing the newline character with CRLF, but that didn't 
> work. Nor did any other changes, and so I gave up. Regardless, suffice to say 
> that importing from an Excel-generated csv file didn't work on my Mac.]I
> 
> David
> 
> 
> On August 29, 2018, at 7:14 AM, Geert Janssens  
> wrote:
> 
> Oh, I missed that solution post apparently. Thanks for informing me.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 29 augustus 2018 13:11:36 CEST schreef Deva -:
>> Thanks Geert.
>> 
>> But please note this was not an issue for me; I was just trying to help
>> another poster with his problems (cc’d on this mail).
> 
>> Bob can rest easy because the OP said he finally solved it. Something to do
>> with the way he exported his price data from a spreadsheet to CSV was the
>> problem. Once he fixed that, everything worked ok. He posted his solution
>> on this list as well.
> 
>> Thanks for the follow up.
>> 
>> Cheers.
>> 
>> On 29-Aug-2018, at 4:06 PM, Geert Janssens
>> mailto:geert.gnuc...@kobaltwit.be>> wrote:
> 
>> megagru...@hotmail.com
>> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Balance Sheet Report Broken

[Adrien Monteleone]

Paul,

I’m not certain about your specific issue with the balance sheet. I do know 
there has been some recent discussion on the general topic of equity figures 
with relation to stocks. (mostly concerning unrealized gains/losses) There is 
an entirely new version of the balance sheet report being worked on hopefully 
for 3.3 or 3.4. I’m not sure if it addresses your issue. I’ll let others chime 
in, and you may need to file a bug report so it can be addressed in time for 
those releases.
--

As for the new version question:

There is a flatpak version of 3.2 out there, but some people have noticed some 
issues. (notably, storing files on external/network drives which has a 
workaround, and MySQL access which is broken)

Otherwise, it is fairly easy to build GnuCash yourself on Ubuntu. The 
instructions on the Wiki have been updated recently and should be pretty 
straightforward. (I successfully built 3.2 on Xenial about a month ago) The 
process is to install the build tools, install certain dependencies, download 
the source, make, build.

The places where people get tripped up the most (based on threads here on the 
list) is “where to install GnuCash to”, (/usr/local, /opt, or $HOME/.local are 
easiest) and making sure to follow the very strong suggestion to use a build 
directory that is *not* the source directory. (a child or sibling directory is 
fine)

Here’s the wiki page for building: https://wiki.gnucash.org/wiki/Building#Ubuntu

Read the General Instructions section there. Then, do not follow the *old* 
specific instructions for Ubuntu there, but instead on this new page: 
https://wiki.gnucash.org/wiki/BuildUbuntu16.04

*note, one of the steps on the second page is to setup GoogleTest as part of 
your build environment. That GoogleTest page is a tad confusing. The ’nutshell’ 
is you probably want to follow the first code block only.

Feel free to ask for assistance or clarification on the list here if you hit a 
stumbling block.

Regards,
Adrien

> On Aug 29, 2018, at 11:12 AM, Paul Schwartz  wrote:
> 
> I have been using gnucash for many years. I keep my books with the assets
> valued at their purchase price. The cost basis is important when selling
> assets.This is easy for most stocks but some require periodic adjustments
> because of return-of-capital [or similar] events. I have been working with
> version 2.6.12 most recently, and the balance sheets reported correct cost
> basis values for all of my stocks. When I upgraded my Ubuntu systems
> recently, version 2.6.19 was installed.  I now find that neither Balance
> Sheet report is working. The standard reports zero value for the stock if a
> return of capital adjustment was made while the eguile version just ignores
> the adjustment and reports the original purchase value.
> 
> I would greatly appreciate some help in figuring out how to migrate to
> later versions of gnucash.
> 
> Paul Schwartz
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is a 'pre-paymnet' and how do I remove it?

[Adrien Monteleone]

Right-click the transaction in your checking register and choose “Edit Payment” 
or “Assign as Payment” (depending on if it was already assigned at one time or 
not)

Then select both the payment and the invoice it should apply to and save the 
result.

Pre-payments happen when you process a payment and don’t assign it to an 
invoice. They can also happen when you unpost an invoice that is already paid 
and GnuCash doesn’t manage to reapply the payment when you repost the invoice. 
(not usual, but it does happen)


Regards,
Adrien

> On Sep 1, 2018, at 8:32 AM, Rich Shepard  wrote:
> 
>  GC-3.2 installed here.
> 
>  Last Moday I sent an invoice to a client and entered it, posted to A/R.
> Yesterday I recieved payment and entered the check, posting it to checking
> account.
> 
>  Today I open GC and find a messag that that client had two 'pre-payments'
> (now down to one for some reason). When I select that client and tell GC to
> process the payment it wants to issue a refund.
> 
>  How does a 'pre-payment' appear and how do I clear it?
> 
> Curious mind wants to know,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 save over network taking very long time

[Adrien Monteleone]

Not sure if Vinagre is available for Windows, but I noticed a significant 
improvement in response and lag accessing a remote session over VNC via an SSH 
tunnel with it vs. the built-in Mac screen sharing I was using. There is still 
a bit of latency, but that is to be expected since there are about 10 hops 
between me and the target machine. If you were accessing a local VM, I’d 
suspect you probably wouldn’t even notice any lag at all. It may not be 
available for Windows, but the point is that the viewing software can have a 
large impact in this area, perhaps another solution will work better than the 
PuTTY/Xming combo.

(this won’t address the file save issue of course, just the GUI responsiveness)

Regards,
Adrien

> On Aug 31, 2018, at 4:58 PM, David Carlson  
> wrote:
> 
> I have refrained from commenting on this because I do not run release 3.x,
> but now I will, in case it helps the developers to think of other issues
> that may be in play.
> 
> I am running release 2.6.17 in Ubuntu 16.04 installed on a VirtualBox guest
> and either viewing it directly or using PuTTY with Xming to SSH into that
> machine from the Windows 7 (64 bit) host.  This is on a core i7 laptop with
> 24 GIG of RAM.  My XML file resides on a NAS in a different room in my
> house.  My computer display is set to 1920x1080, and I recently reduced the
> the text size from 125% to 100 % in an attempt to see more text in the
> descriptions, but it did not seem to change anything (speed or text size)
> in SSH sessions.   Both methods are very slow, taking minutes to save my
> XML data file and even several seconds to process a keystroke such as
> changing the focus to a different transaction.  I can also run release
> 2.6.19(?) directly in Windows 7 but that is even slower.  I have plans to
> convert another computer to either Ubuntu or Debian and SSH into it instead
> of using VrtualBox, but I have not gotten there yet.  If release 3.2 is
> even slower, I do not want to go there.
> 
> On Fri, Aug 31, 2018 at 2:55 PM Geert Janssens 
> wrote:
> 
>> Op vrijdag 31 augustus 2018 21:46:31 CEST schreef Morris Walton:
>>> I've got many years worth of data saved in an xml file. I'm running 2.7.4
>>> on gentoo. With the amount of data i have, I'm not surprised it's getting
>>> slower, but saves that are initiated when i shell/x into the box from
>>> outside the home network are taking hours.  This long lag seemed to start
>>> happening sometime last year (my lastest build from gentoo was
>> 2018-02-03,
>>> and I think it started happening around that time).  my upstream b/w is
>>> somewhere around 40mbps, which is better than what it was when it was
>>> saving at a decent speed.
>>> 
>>> If I had to guess, i'd say it was taking that long because gnome/graphics
>>> wants to draw that progress circle? I can't say for sure but it seemed
>> like
>>> before it was drawing the circle, and saving at "at home rate."
>>> 
>>> Anybody got any ideas on what is going on, and how to remedy?
>>> 
>> 
>> Other users have reported slow saves as well. There's even a bug report:
>> https://bugs.gnucash.org/show_bug.cgi?id=795804
>> 
>> It does seem to be related to gui refreshes indeed. Suggested workarounds
>> are
>> to minimize the application while saving (but then it's hard to tell when
>> it's
>> done), reducing screen resolution or making the main window as small as
>> possible.
>> 
>> Regards,
>> 
>> Geert
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is a 'pre-paymnet' and how do I remove it? [RESOLVED]

[Adrien Monteleone]

Hmm... Not sure I’m following there. You assigned the payment to another 
payment? Is that even possible?

I suspect you’ve got an errant extra payment somewhere.

Perhaps Geert will need to chime in here. He has been very helpful with 
resolving these issues.

Regards,
Adrien

> On Sep 1, 2018, at 9:46 AM, Rich Shepard  wrote:
> 
> On Sat, 1 Sep 2018, Adrien Monteleone wrote:
> 
>> Right-click the transaction in your checking register and choose “Edit
>> Payment” or “Assign as Payment” (depending on if it was already assigned
>> at one time or not)
>> 
>> Then select both the payment and the invoice it should apply to and save
>> the result.
> 
> Adrien,
> 
>  That worked. For the most recent instance, when I clicked on the
> transaction and selected 'edit payment' both the mythical pre-payment and
> the actual payment appeared. Clicking 'OK' cleared both.
> 
>  Thanks for providing the solution.
> 
> Best regards,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting duplicate client invoice [RESOLVED]

[Adrien Monteleone]

What I meant by changing the invoice number was to make the invoice a 
placeholder. It doesn’t have to remain forever tied to that client or project 
since you don’t need it anymore and then it is easily findable to reuse for 
someone or something else.

Certainly, it’s a personal preference.

Regards,
Adrien

> On Sep 7, 2018, at 11:51 AM, Rich Shepard  wrote:
> 
> On Fri, 7 Sep 2018, Adrien Monteleone wrote:
> 
>> You can’t delete invoices. (or Bills)
> 
> Adrien,
> 
>  So I discovered.
> 
>> In addition to unposting, I’d suggest editing the invoice to remove as
>> much info as allowed and probably change the invoice number to ‘use next’.
> 
>  Won't work here as invoice numbers are client and project specific.
> 
>> Then instead of duplicating or creating a new invoice, even for a
>> different customer, use that one so it doesn’t remain floating around.
> 
>  It can float harmlessly forever as far as I'm concerned. :-)
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting duplicate client invoice [RESOLVED]

[Adrien Monteleone]

Rich,

You can’t delete invoices. (or Bills)

In addition to unposting, I’d suggest editing the invoice to remove as much 
info as allowed and probably change the invoice number to ‘use next’.

Then instead of duplicating or creating a new invoice, even for a different 
customer, use that one so it doesn’t remain floating around.

Some also have a special customer (probably from creating one they couldn’t 
delete) say , ‘Customer ABC’ or other generic label and then assign these ‘use 
next’ invoices to them. (so they don’t stay assigned to a particular real 
customer)

Regards,
Adrien

> On Sep 7, 2018, at 11:28 AM, Rich Shepard  wrote:
> 
> On Fri, 7 Sep 2018, Rich Shepard wrote:
> 
>> I have a duplicate invoice for one client and have not yet learned how to
>> delete it. The invoice was paid early last year.
>> 
>> Both copies of the invoice in A/R are marked 'read only.'
> 
>  I unposted the invoice (but did not delete it) and there is now only a
> single copy of that invoice in the A/R register. Checking account is correct
> and when I invoke gnucash for the business account I no longer see the nag
> screen about a payment without an invoice.
> 
>  Everything looks good so I'll consider this thread closed.
> 
> Regards,
> 
> Rich
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Deleting duplicate client invoice [RESOLVED]

[Adrien Monteleone]

My suggestion was based on manual numbering. As far as I can tell, it won’t 
work with automatic numbering since the invoice already exists and the code to 
generate that number won’t get fired twice. (an interesting RFE by the way) 
’Use next’ could just as easily be ‘duplicate’, ‘unused’, ‘use me next time’, 
‘abcdef’, etc. ‘Use next’ isn’t some special code or hook that GC would 
interpret. Changing the invoice number to such a label (and or placeholder 
customer) is simply to make it easy for you to find next time you need an 
invoice as Geert noted.

Regards,
Adrien

> On Sep 7, 2018, at 12:05 PM, Rich Shepard  wrote:
> 
> On Fri, 7 Sep 2018, Geert Janssens wrote:
> 
>> Huh, I don't understand this.
> 
> Geert,
> 
>  Adrien's suggestion likely was based on using an automatic sequential
> numbering system.
> 
>> I don't see why you can't reuse the invoice for the future. An unposted
>> invoice is like a blank sheet of paper. You can put anything on it or change
>> every aspect.
> 
>  Okay. I can do this.
> 
>  Now I need to find it again.
> 
> Regards,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Negative assets!

[Adrien Monteleone]

Credit Cards are usually liabilities, not Assets.

To not see a balance as a ‘Current Asset’ for an account that isn’t really a 
current asset makes sense. Though I’m not sure the code involved is paying 
attention to account type more than the sub-account’s location in the tree.

Click that credit card account in the CoA and then click the Edit Account 
button. What fundamental type is it? Asset? Liability?

Also, out of curiosity, does a Balance Sheet also show negative Current Assets?

Regards,
Adrien

> On Sep 6, 2018, at 4:05 AM, Muhammad Bashir Al-Noimi  
> wrote:
> 
>   On 09/06/2018 11:55 AM, Geert Janssens wrote:
> 
> Most transactions not showing a balance is odd.
> 
>   See this transaction as example:
>   When I open it from "Assets:Current Assets:TRY:Kocamustafapasa -
>   CreditCard" it appears correctly as shown below:
>   But when I open same transaction from "Current Assets and select
>   Edit>Open Subaccounts" it appears without a balance as shown below:
> --
> Best Regards,
> Muhammad Bashir Al-Noimi
> Skype+Telegram+GMail: mbnoimi
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.