[GNC] Accounts page error

[Graham]

Pardon my ignorance if this is something ultra basic, but at the bottom 
of the accounts tab, i get a line in the grey area like this:


£, Grand Total:              Net Assets £27,014,432 Profits -£86043

Now the profits side may be accurate, although I hope not; I can only 
dream of the net assets being even a tenth of the above figure! Most of 
the crazy numbers seem to be in the investment accounts for shares, but 
I can't see why it should be so inflated. Can it be just totalling up 
every transaction made in the account? [I do record purchases and sales 
in subaccounts of each nominee account]


Any suggestions most welcome.

Graham

--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Nothing Wrong

[Graham Balin]

Exactly what he said!

On Wed, 24 Apr 2024, 18:20 R Losey,  wrote:

> On Tue, Apr 23, 2024 at 4:00 PM Jim Muchow  wrote:
>
> > I want you maintainers and developers to know that I run GnuCash just
> > fine and don't have problems. I very much appreciate such a great free
> > product. Thanks.
> >
> > I kinda wanted to make this an annual thing but I have not been
> > consistent about this and for that I apologize. Also this is not
> > response to any one or more of the problem reports. Just a note of
> > thanks.
> >
>
> I'll add my voice to the growing chorus. I switched from Quicken in 2016
> and am very, very happy with GnuCash itself, and for the additional things
> I've learned following this newsgroup.
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Error message on opening GnuCash

[Graham & Irene Taggart via gnucash-user]

I have recently upgraded GnuCash to Version: 5.5 Build ID: 5.5+(2023-12-16).
However, every time I open the program I now get the following error
message.

 



 

The program appears to work OK after pressing OK.  I have tried reinstalling
version 5.5 and also copying the libxmlsec1.dll file from an old backup I
have but that hasn't worked.  What can I do to correct the error message?

 

Regards

Graham

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Customising colors on Cash Flow Barchart

[Graham Ward]

ideally, I would like to edit the colors in GnuCash. I can export the data
and recreate the chart, but that's not very interactive and has to be
repeated each time.

Thanks.


--

Message: 9
Date: Mon, 5 Jun 2023 08:48:54 +1000
From: ed...@billiau.net
To: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] Customising colors on Cash Flow Barchart
Message-ID: <20230605084854.220b8...@zenbook2.billiau.net>
Content-Type: text/plain; charset=US-ASCII

On Sun, 4 Jun 2023 21:34:11 +0100
Graham Ward  wrote:

> I need to change the colors on the standard Cash Flow Barchart.
> Currently, 'Money In' is Blue, 'Out' is Red and the 'Net Flow' Green.
> Can I change these three colors and is it possible to change the Net
> Flow so that it is grey above the line and red below i.e. negative?
>
> Thanks.

Do you need to change these colours in Gnucash or in a report to
present to other people?
I am asking for more context as there are different ways of trying to
achieve this according to actual requirements?

Liz


--
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Customising colors on Cash Flow Barchart

[Graham Ward]

I need to change the colors on the standard Cash Flow Barchart. Currently,
'Money In' is Blue, 'Out' is Red and the 'Net Flow' Green. Can I change
these three colors and is it possible to change the Net Flow so that it is
grey above the line and red below i.e. negative?

Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance:Quote again [sorry]

[Graham]

On 12/05/2023 17:23, Kalpesh Patel wrote:
Thanks Kalpesh - my replies in-line

That is all tell-tale sign of barfed up path for the env...

Additional steps to debug:

1 - Launch normal Command Prompt

2 - Type in following to know which perl binary you are actually executing:

where perl

--> this should display 'C:\Strawberry\perl\bin\perl.exe'

It did.


3 - type following at the command prompt (let's validate if the env is setup
correctly or not):

perl --version

--> this step should display perl 5, version 28 (your might very in the
version but should be around '28')

version 32

4 - type following at the command prompt (let's validate if the F::Q is
setup and working correctly):

perl -MFinance::Quote -e "print $Finance::Quote::VERSION .\"\n\";"

--> this step should display 1.54 (your might be different version)


After turning off antivirus and re-running the installer, it did display 
1.54.


However,on re-starting GNC, and clicking 'get quotes' when i had 
selected AAL.L, it did return yesterday's closing price for AAL, but not 
for anything else. I tried selecting 'LSE' and running 'get quotes' but 
that did nothing. I then tried selecting another single stock and 
running it, but that did nothing either.


Any thoughts?

[Many thanks to everyone who has replied]

--
--
Cheerio,

Graham

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance:Quote again [sorry]

[Graham]

On 11/05/2023 22:02, Murugan Muruganandam wrote:

Graham

The new command line query looks like this below, try to run it from a 
command prompt and see if it is working


Go to the following folder
C:\Program Files (x86)\gnucash\bin

execute the following query
gnucash-cli.exe --verbose -Q dump yahoo_json acn



Thanks Murugan

When I attempt that, I get :C:\Program Files 
(x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump yahoo_json acn
Price retrieval failed: Failed to initialize Finance::Quote: 
missing_modules Finance::Quote



so once again I tried the online price retrieval installer and this gave 
me the attached message.


Does this give any clues before I [an amateur] start delving into and 
editing files as others have suggested?



--
--
Cheerio,

Graham


gnu.odt
Description: application/vnd.oasis.opendocument.text
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Calculating IRR of an investment account

[Graham]

I have tried the manual without much success, and tried two different 
AIs [ChatGPT and Nova] but both give me instructions that don't seem to 
exist, such as :


1. Click on the "Reports" menu and select "New Report".
2. In the "Report Type" dropdown, select "Transaction".
3. Click on the "Add Column" button to add the columns you want to
   include in your report. For example, you could add "Date",
   "Description", "Amount", and "Memo" columns.
4. Click on the "Grouping" dropdown and select "Date".
5. In the "Filter" section, set the date range for the period you want
   to calculate the IRR for.
6. Click on the "Customize Report" button to open the report
   customization panel.
7. In the "Computation" section, click on the "Add" button to add a new
   computation to your report.
8. In the "Computation" dropdown, select "Internal Rate of Return (IRR)".

New report I take to be a new transaction report, but I can't see any 
add column button, customize report or computation options.


Am I missing something, or is AI as stupid as me? (Win 10, Gnucash 5.0)


--
--
Cheerio,

Graham
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Editing a Budget - "from this period onwards"

[Graham Ward]

You can edit a budget by changing the individual values by period, but is
there a way to edit all future periods from say period 3 - 12 rather than
having to edit each one individually? So ideally I would like to change a
line from "this period forward".

Thanks.
___
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] GnuCash help: How to set the default invoice layout

[Graham Ward]

Hi,

firstly I hope you are able to help, and secondly thank you very much 
for doing so!


I am relatively new too GnuCash and have been watching videos and going 
through a fair bit of the documentation on invoicing. So far I have 
setup a new style sheet for the invoice that I have created, as well as 
edited the options when viewing my invoice. I have saved a new config 
too. However what is still annoying now is that even though I have 
everything setup GnuCash still insists on giving me the plain vanilla 
default invoice whenever I click the option to "Print Invoice" when I am 
viewing the invoice. The only way it appears to me to be able to print 
using the saved configuration/style is that even though I already have 
my invoice open and a button available to print, I can't use it. Instead 
I have to go back to "Accounts", click Reports -> Saved Report 
Configurations -> select report configuration, go to Options select 
Invoice Number and search for it, double click the invoice found and 
click OK.


there surely has to be a way to setup the default config and style used 
so the "*Print Invoice*" button seen below works as required, when 
viewing the invoice.





Thanks everyone.
Graham
___
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] Hiding accounts of zero

[Graham]

On 06/08/2021 16:16, Derek Atkins wrote:


Brilliant. So easy when you know!!
Thanks muchly,
Graham

On Fri, August 6, 2021 11:05 am, Graham wrote:

Sorry if this is a basic question, but I've tried searching to no avail.

I'm thinking of stock accounts, where many have been bought and sold. Is
there a way of showing the account tree to 'hide' accounts of zero
value, or zero stock?

I could delete the account, but I want to keep the record, and I may
want to buy back in the future, so it keeps all the details for me.

However, it is a pain scrolling through long lists of stock I no longer
own. Similarly for old bank accounts such as term deposits; I'd like to
keep the details, just not have them showing up all the time in the
account list.

Two ways to do this:

1) View -> Filter By -> Other
uncheck "show zero total accounts"

2) Select the account in question
click Edit Account
select Hidden (to hide from the Chart of Accounts) and Placeholder (to
hide from autocomplete).

You may even want to perform a mix-and-match of these two options.


Thanks in advance,
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



--
--
Cheerio,

Graham


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

[GNC] Hiding accounts of zero

[Graham]

Sorry if this is a basic question, but I've tried searching to no avail.

I'm thinking of stock accounts, where many have been bought and sold. Is 
there a way of showing the account tree to 'hide' accounts of zero 
value, or zero stock?


I could delete the account, but I want to keep the record, and I may 
want to buy back in the future, so it keeps all the details for me.


However, it is a pain scrolling through long lists of stock I no longer 
own. Similarly for old bank accounts such as term deposits; I'd like to 
keep the details, just not have them showing up all the time in the 
account list.


Thanks in advance,

--
Cheerio,

Graham


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

Re: [GNC] I didn't like the dark theme. How to force using the default theme ?

[Parker Graham]

If you add (if not there) or change the gtk-3.0.css file to your
/home//name//.var/app/org.gnucash.GnuCash/config/gnucash, or wherever
the GnuCash config folder is on your computer to file attached you will
have a good screen rendering. You can tweak the file to personalize it
more if you want.

On 6/5/21 7:15 AM, marozsas wrote:


Hi there !
I'm using KDE with Breeze-Dark.
However, GnuCash in this dark theme displays a black foreground text on
black background . Impossible to read.
If I change KDE's default theme to something like Breeze, GnuCash displays
selected text as white foreground text on blue background, which is the
default and it is nice.
I would keep Breeze-Dark as the desktop's default theme but I need to fix
this weird choice of black text on black background in selections.
Alternatively, appliyng a light theme to whole gnucash is acceptable.
I've tried to add to .config/gtk-3.0/settings.ini the following, without any
change:
gtk-application-prefer-dark-theme=false
gtk-theme-name=breeze-twilight




--
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.
treeview {
  background-color: white;
  color: black;}

treeview:hover {
  background-color: lightgrey;
  color: black;
}

treeview:selected {
background-color: skyblue; 
 color: white;
}

/* Application wide font setting font-weight: bold;*/
* {
  font: 19px Aerial Regular;
  
}

scrollbar {
/* Just in case another file disabled them */
-GtkScrollbar-has-backward-stepper: 1;
-GtkScrollbar-has-forward-stepper: 1;
}

scrollbar slider {
/* Size of the slider */
min-width: 18px;
min-height: 12px;
border-radius: 12px;

/* Padding around the slider */
border: 3px solid transparent;
}


/* Register sheet font setting */
gnc-id-sheet {
  font: 22px Aerial Regular;
}


/* Register header font setting */
gnc-id-header {
  background-color: white;
  color:white;
}


/* Register cursor font setting */
gnc-id-cursor {
  background-color: #BDB76B;
  color: white;
}

gnc-id-cursor button {
  border-width: 1px;
  border-color: green;
}


/* Register sheet calendar */
gnc-id-sheet calendar {
  font: 13px arial;
  background-color:lightgreen;
  border-color: green;
  border-width: 1px;
}


/* Register User Colors, remove 'user' for builtin register values */
.gnc-class-user-register-header {
  background-color: lightgrey;
  color: black;
}

.gnc-class-user-register-primary {
  background-color: white;
}

.gnc-class-user-register-primary:disabled {
  background-color: plum;
}

.gnc-class-user-register-secondary {
  background-color: #FAF0E6;
}

.gnc-class-user-register-secondary:disabled {
  background-color: plum;
}

.gnc-class-user-register-split {
  background-color: tan;
}

.gnc-class-user-register-split:disabled {
  background-color: plum;
}

.gnc-class-user-register-cursor {
  background-color: #00BFFF;
  color: white;
  border-radius: 0px;
}


/* Toolbar Button size and spacing */
toolbar {
  background-color: lightsteelblue; 
 
}

/* Toolbar font size, 0 to remove text */
toolbar toolbutton label {
  font-size: 22px;
}

toolbar toolbutton button {
  padding-left: 8px;
  padding-right: 8px;
}

toolbar toolbutton label {
  padding-left: 8px;
  padding-right: 8px;
}


/* Negative number color */
.gnc-class-negative-numbers {
  color: red;
}


/* Gnucash Main Window, reduce size */
#gnc-id-main-window notebook tab {
  min-height: 6px;
  min-width: 0px;
  padding-top: 3px;
  padding-bottom: 3px;
  margin-top: 0px;
  margin-bottom: 0px;
  border-top: 0px;
  border-bottom: 0px;
}

#gnc-id-main-window notebook label {
  font: 20px arial, sans-serif;
}

#gnc-id-main-window notebook tab button {
  min-height: 0;
  min-width: 0;
  padding: 0px;
  margin-top: 0px;
  margin-bottom: 0px;
}


/* Dense Calendar Settings, use widget name gnc-id-dense-calendar
 * or gtk css name calendar which would also apply to other calendar
 * widgets */
#gnc-id-dense-calendar .frame {
  border-color: blue;
  border-width: 1px;
}

calendar .frame {
  border-color: blue;
  border-width: 1px;
}

#gnc-id-dense-calendar .header {
 background-color: lightgreen;
}

calendar .header {
 background-color: lightgreen;
}

#gnc-id-dense-calendar .primary {
  background-color: darksalmon;
}

#gnc-id-dense-calendar .secondary {
  background-color: darkseagreen;
}

#gnc-id-dense-calendar .markers {
  background-color: indianred;
}

#gnc-id-dense-calendar-popup {
  background-color: darksalmon;
  color: black;
}

Re: [GNC] mortgage refinance

[Parker Graham]

not following, please give me example such as original loan is
100,000.00 refi loan is 105,000.00

thanks

On 3/21/21 9:36 AM, py...@cox.net wrote:

Several ways to do this.   Here is the easiest way I know:

Mortgage Loan (start loan B)   Increase - Loan Amount
Mortgage Loan (start loan B)Decrease -Principal Amount remaining
from Loan A

Net result - New loan amount before first payment.  Now the two entries are
actually the net result of a split transaction entry that comes right from
the closing statement received from the mortgage company.  If you follow
that statement - you should be good to go.

Hope that helps.


-Original Message-
From: gnucash-user  On
Behalf Of Parker Graham
Sent: Sunday, March 21, 2021 6:25 AM
To: gnucash-user@gnucash.org
Subject: [GNC] mortgage refinance

Have mortgage set up in system but refinanced it and need help on how to
payoff existing loan and set up new loan

___
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] mortgage refinance

[Parker Graham]

Have mortgage set up in system but refinanced it and need help on how to
payoff existing loan and set up new loan

___
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 do I get the 3D Interface look - Take 2?

[Parker Graham]

you have to go into GnuCash preferences > Register and uncheck "Use
GnuCash built-in color themes" close program and restart it.

On 3/15/21 5:23 AM, viking wrote:

Parker Graham-2 wrote

I wondered the same thing about the 3D look and came to the conclusion
that I would have to set my whole Linux theme to achieve this but I don’t
want my whole system to look like windows so here is what I did in GTK to
make things look good and function well
Not sure where Windows keeps the .css files
Hope this helps

Parker

@Parker,
Thanks for the file. However, I am also not sure where to put it in Windows
(WIN7)?
There is a file here:
\gnucash\share\themes\Emacs\gtk-3.0\gtk-keys.css
I tried to replace it with your file but it didn't change anything, so this
is obviously not the correct location...

Could someone please help with the windows location for the CSS file?




--
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] CSS selectors for alternating rows and individual columns on the Account page?

[Parker Graham]

This is what I did in css to make it look good and function well

On 2/25/21 8:38 PM, Peter S. Shenkin wrote:

This sounds like a good reason to use Qt. 

(A cross-platform GUI building tool.)

-P.

On Thu, Feb 25, 2021 at 11:45 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


I poked around with the inspector quite a bit when GnuCash moved to
GTK3, and as far as I can tell, the content of the Account Page (save
the header bar) is not exposed to styling, sorry. (that is, the entire
account table 'tree' is one CSS node and the individual items, rows, and
columns are not accessible to CSS)

You could employ a very ugly workaround though:

Set every other account to have the background color you want, then turn
on: Preferences > Accounts > Account Color > Show the Account Color as
background.

The downside is you'd need to do this for every other account manually,
and then when you collapse parts of the tree, your striping will break.
(and then you can't use other custom colors) You could maybe just set
the parent accounts to have a background color, so that when everything
is expanded, there is some visual separation.

*note, I've found the page easier to read and see the hierarchy when I
turned *off*: Preferences > General > General > Enable vertical grid
lines on table displays.

Regards,
Adrien

On 2/23/21 9:18 PM, Evelyn Yamanaka wrote:

Hi all,

I'm using GNUCash 4.4 on Windows 10, and I'm trying to customize the
appearance of the Account page using the CSS file:

%APPDATA%\GnuCash\gtk-3.0.css

I can't figure out how to modify alternating rows (background color)
or individual columns (e.g. the "Account Name" column) on the Account
page because I don't know the CSS selector for those items.

I've used the GTK Inspector to identify other elements. But I can't
figure out the CSS path for these two items. I've tried the following,
in case the tree in the Account page behaved like an HTML table, but
neither worked:

#gnc-id-account-tree tr:nth-child(even) {
  background-color: #888;
}
#gnc-id-account-tree td:nth-child(1) {
  background-color: #888;
}

More info, including a screenshot for reference, can be found here:


https://superuser.com/questions/1627977/what-are-the-css-selectors-for-alternating-rows-and-specific-columns-in-gnucash

Would appreciate any help figuring out which CSS selectors to use, or
just letting me know if it's impossible to do. Thanks.

___
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.
treeview {
  background-color: white;
  color: black;}

treeview:hover {
  background-color: lightgrey;
  color: black;
}

treeview:selected {
background-color: skyblue; 
 color: white;
}

/* Application wide font setting font-weight: bold;*/
* {
  font: 19px Aerial Regular;
  
}

scrollbar {
/* Just in case another file disabled them */
-GtkScrollbar-has-backward-stepper: 1;
-GtkScrollbar-has-forward-stepper: 1;
}

scrollbar slider {
/* Size of the slider */
min-width: 18px;
min-height: 12px;
border-radius: 12px;

/* Padding around the slider */
border: 3px solid transparent;
}


/* Register sheet font setting */
gnc-id-sheet {
  font: 22px Aerial Regular;
}


/* Register header font setting */
gnc-id-header {
  background-color: white;
  color:white;
}


/* Register cursor font setting */
gnc-id-cursor {
  background-color: #BDB76B;
  color: white;
}

gnc-id-cursor button {
  border-width: 1px;
  border-color: green;
}


/* Register sheet calendar */
gnc-id-sheet calendar {
  font: 13px arial;
  background-color:lightgreen;
  border-color: green;
  border-width: 1px;
}


/* Register User Colors, remove 'user' for builtin register values */
.gnc-class-user-register-header {
  background-color: lightgrey;
  color: black;
}

.gnc-class-user-register-primary {
  background-color: white;
}

.gnc-class-user-register-primary:disabled {
  background-color: plum;
}

.gnc-class-user-register-secondary {
  background-color: #FAF0E6;
}

.gnc-class-user-register-secondary:disabled {
  background-color: plum;
}

.gnc-class-user-register-split {
  background-color: tan;
}

.gnc-class-user-register-split:disabled {
  background-color: plum;
}

Re: [GNC] Security price retrieval [again]

[Graham]

On 08/01/2021 10:16, Liz Dodd wrote:

On Thu, 7 Jan 2021 17:01:42 +
Graham  wrote:


Sorry - didn't realise that the images hadn't gone through.
When I try to update prices, more than half do not update, and it
prompts me to continue with the ones that have updated. I tried
converting the source from Morningstar GB to Yahoo-JSON but that
froze Gnucash.


I have run gnc-fq-update and I get:  Date::Manip is up to date
(6.83). Finance::Quote is up to date (1.49).


Not sure where I go next

Sell the shares and buy something different you can price

Stay well Dr Balin from Dr Dodd


Good advice! Maybe not the most financially astute, but an answer to the 
problem, certainly.


Stay well yourself, Dr Dodd, and keep posting -lurking enthusiastically 
-enjoying your spot diagnosis at present.


no2 could well be HSV as posited, but perhaps HZV?

--
--
Cheerio,

Graham


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

Re: [GNC] Security price retrieval [again]

[Graham]

On 07/01/2021 20:06, David H wrote:
Not uncommon, perhaps you should list the ones that aren't working, 
other users might be able to point you in the right direction...


Cheers David H.


Thanks David,

All LSE:

DNE, SCF, EUDV, LGEN, GFRD, JCH, KETL, EPIC, PNN,AIRE,CTY , 
currency:eur, currency:aud plus some funds. Ive tried altering the 
source between Alphavantage US, Morningstar GB, Yahoo-JSON and Yahoo-JQL 
but the same tickers keep coming up.


Thanks for anyone who can help

--
--
Cheerio,

Graham


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

Re: [GNC] Security price retrieval [again]

[Graham]

Sorry - didn't realise that the images hadn't gone through.
When I try to update prices, more than half do not update, and it 
prompts me to continue with the ones that have updated. I tried 
converting the source from Morningstar GB to Yahoo-JSON but that froze 
Gnucash.



I have run gnc-fq-update and I get:  Date::Manip is up to date (6.83). 
Finance::Quote is up to date (1.49).



Not sure where I go next

--
--
Cheerio,

Graham



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

Re: [GNC] Security price retrieval [again]

[Graham]

On 04/01/2021 22:22, David H wrote:

Sorry - just read your reply to Michelle. Ran it and got: C:\Program 
Files (x86)\gnucash\bin>perl "C:\Program Files 
(x86)\gnucash\bin\gnc-fq-check"
("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" 
"aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse" 
"bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" 
"dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" 
"fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" 
"finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" 
"fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" 
"hustock" "iexcloud" "indiamutual" "known_currencies" "lerevenu" 
"maninv" "morningstar" "morningstarau" "morningstarch" "morningstarjp" 
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" 
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" 
"tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" 
"tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" 
"vanguard" "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")


C:\Program Files (x86)\gnucash\bin>

The dump command gave:
C:\Program Files (x86)\gnucash\bin>perl "C:\Program Files 
(x86)\gnucash\bin\gnc-fq-dump


Usage: C:\Program Files (x86)\gnucash\bin\gnc-fq-dump [-v] 
  [ ...]


-v: verbose
Available sources are:
 aex za_unittrusts cse bourso citywire morningstar fidelity_direct 
za mstaruk hustock deka amfiindia ftportfolios nyse bse troweprice 
greece finland aufunds hex vanguard nz hu yahoo_json uk_unit_trusts vwd 
usfedbonds fidelity canadamutual romania fool goldmoney tnetuk 
tdwaterhouse dwsfunds iexcloud financecanada unionfunds morningstarau 
bsero tsx platinum usa morningstarjp ftfunds tdefunds seb_funds hufund 
tiaacref indiamutual tsp france bamosz bmonesbittburns nzx maninv 
fidelityfixed finanzpartner adig hungary europe dutch asegr 
ftportfolios_direct aiahk sixfunds australia stockhousecanada_fund 
troweprice_direct morningstarch alphavantage nasdaq known_currencies 
lerevenu yahoo_yql asx fundlibrary ukfunds bet sixshares trustnet canada 
cominvest fetch_live_currencies


What do I do next?

Cheerio,

Graham



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

Re: [GNC] Security price retrieval [again]

[Graham]

On 04/01/2021 22:22, David H wrote:

Graham,

My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files 
(x86)\gnucash\bin.


If they're not present have you run the "Install Online Price 
Retrieval for GnuCash" which installs/sets up everything for Online 
Price Retrieval to work?


Cheers David H.


Thanks David.  There are gnc-fq-xxx files in C:\Program Files 
(x86)\gnucash\bin. [ I have run Install Online Price Retrieval for 
GnuCash .]


I apologise for ignorance but trying to run check from cmd prompt i get:

C:\Program Files (x86)\gnucash\bin>$ gnc-fq-check

'$' is not recognized as an internal or external command,
operable program or batch file.



--
Cheerio,

Graham


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

Re: [GNC] Security price retrieval [again]

[Graham]

Thanks Frank, but I get ' Can't open perl script "gnc-fq-check": No such 
file or directory '.

This

is all i have in the start menu. I have used the install program to get 
the latest version, and I've d/l'd GNC4.4


Graham






On 03/01/2021 20:06, Frank H. Ellenberger wrote:

Hi Graham,

Am 03.01.21 um 18:45 schrieb Graham:

I have uninstalled and installed 4.4, but it is still not there. When I
run the update prices, some stocks are updated, but after a good 4
minutes, this appears :


Looking at the list, some were set to Morningstar GB whereas the
Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo
JSON ran update prices again and it just froze completely.

Any ideas, o wise ones?

lookong at https://github.com/finance-quote/finance-quote/commits/master
several services like Morningstar have problems in F::Q

Can you test with gnc-fq-* scripts?
https://wiki.gnucash.org/wiki/Online_Quotes

Regards
Frank



--
--
Cheerio,

Graham



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

Re: [GNC] Security price retrieval [again]

[Graham]

Hi team,

After unsuccessful aatempts to get price retrieval to work on Windows, 
Gnucash 3.8, i went back to the manual, only to find that I was missing 
gnc-fq-dump in the start menu.


I have uninstalled and installed 4.4, but it is still not there. When I 
run the update prices, some stocks are updated, but after a good 4 
minutes, this appears :



Looking at the list, some were set to Morningstar GB whereas the 
Yahoo-JSON ones had updated correctly. I changed the MSGB ones to Yahoo 
JSON ran update prices again and it just froze completely.


Any ideas, o wise ones?

--

--
Cheerio,

Graham



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

Re: [GNC] GTK3 question

[Parker Graham]

Appreciate it 



Sent from myMail for iOS


Tuesday, December 15, 2020, 1:52 PM -0500 from Adrien Monteleone  
:
>The highlighting issue does seem like a bug in that case. Perhaps check 
>Bugzilla and if one is not there, file one.
>
>If in my CSS review early next year, I find a way to style the columns, 
>I'll report back here.
>
>
>Regards,
>Adrien
>
>On 12/15/20 12:41 PM, Parker Graham wrote:
>> 
>> I guessed that you cannot address the main page columns but wanted to be 
>> sure because I saw image of main screen online and first column was light 
>> gray while other columns were white but figured it was screenshot from 
>> windows instead of Linux, won’t be going back to that OS anytime soon
>> 
>> I have 3 accounts
>> Checking,savings and CC
>> When I have the account name background on and click the checking it 
>> highlights blue
>> When I click the savings it doesn’t highlight at all
>> When I click CC it will highlight but the checking account also highlights 
>> and it should not do this
>> It doesn’t seem to work when I click any other account meaning they won’t 
>> highlight at 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] Processing refunds

[Parker Graham]

You sent this to wrong email 



Sent from myMail for iOS


Tuesday, December 15, 2020, 1:47 PM -0500 from Adrien Monteleone  
:
>Unless you posted invoices for the rest of the year, you should not have 
>issued a credit note.
>
>I just did a test book with the following transactions:
>
>1. Annual pre-payment for 1 year @ $1200 (assuming $100/month)
>2. Invoice for Dues on 1/31/20 posted.
>3. Applied a portion of pre-payment to invoice of 1/31/20 ($1100 
>pre-payment remaining)
>4. Invoice for Dues on 2/28/20 posted.
>5. Applied a portion of pre-payment to invoice of 2/28/20 ($1000 
>pre-payment remaining)
>6. Invoice for Dues on 3/31/20 posted.
>7. Applied a portion of pre-payment to invoice of 3/31/20 ($900 
>pre-payment remaining)
>
>At this point the Customer has a credit of $900. There is no need to 
>issue a credit note. (they have not been 'invoiced' for dues not yet 
>paid, but the opposite)
>
>So an 8th transaction would be in order:
>
>8. Refund of $900.
>
>Do this using 'Business > Customer > Process Payment' for the date you 
>issued the refund; select the Pre-payment line (there should be no 
>invoices still visible to select) and make sure the 'Payment' box shows 
>"0.00" and the 'Refund' box shows the remaining amount of their 
>pre-payment that you are refunding. (that should happen by default when 
>you select the pre-payment line) Be sure to select the proper asset 
>account from which you are issuing the refund. (Checking, Cash, etc.)
>
>Re-load or re-run the applicable Customer Report to verify the Totals. 
>Also note you can now show 'links' to relevant documents under Options > 
>Display. I prefer 'detailed' but use whatever you find best. Showing 
>links will make it clear what payments applied to which invoices.
>
>Regards,
>Adrien
>
>On 12/12/20 2:56 PM, Don Earnhardt wrote:
>> I am really struggling with this.  Creating and paying a Credit Note does
>> indeed reduce the income appropriately.  However, the Customer Report shows
>> a Totals increase instead of a reduction.  Here is my situation.  I use
>> GnuCash to manage income and expenses for a non-profit organization
>> (actually a community band). Our members pay monthly dues, and frequently
>> people pay quarterly, semi-annually, and even annually.  Therefore several
>> people paid in advance at the beginning of the year. Now that COVID has
>> prevented us from meeting since the end of March, I would like to refund the
>> dues over payments to those members who have paid in advance (beyond the
>> first quarter).
>> 
>> At the end of each quarter, I print Customer Reports for each member to show
>> how much they have paid. I create and Pay Invoices to show their payments on
>> the Customer Report.  The statements accumulate so that the last one of the
>> year shows everything that was paid for the year. I would like for the
>> refunded payments to reduce the Totals at the bottom of the Customer Report,
>> but instead the refunds look like additional payments, increasing the Total,
>> instead of Reducing them.  What can I do to show the refunds correctly?
>
>___
>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] GTK3 question

[Parker Graham]

I guessed that you cannot address the main page columns but wanted to be sure 
because I saw image of main screen online and first column was light gray while 
other columns were white but figured it was screenshot from windows instead of 
Linux, won’t be going back to that OS anytime soon 

I have 3 accounts 
Checking,savings and CC
When I have the account name background on and click the checking it highlights 
blue 
When I click the savings it doesn’t highlight at all 
When I click CC it will highlight but the checking account also highlights and 
it should not do this 
It doesn’t seem to work when I click any other account meaning they won’t 
highlight at all 



Sent from myMail for iOS


Tuesday, December 15, 2020, 1:25 PM -0500 from Adrien Monteleone  
:
>Apologies, I meant “Parker”, I was reading two different e-mails when 
>replying...
>
>Regards,
>Adrien
>
>> On Dec 15, 2020 w51d350, at 12:19 PM, Adrien Monteleone < 
>> adrien.montele...@lusfiber.net > wrote:
>> 
>> Peter,
>> 
>> Please remember to copy the list on all replies.
>> 
>> I’m not sure what you mean by ’three columns’ but if you are referring to 
>> the Accounts Tab, and the columns showing the account tree and other info, 
>> you can’t target those specifically. (they are not exposed for styling with 
>> CSS node names, IDs or classes) Note too, you can have more than 3 columns. 
>> At the far right of the header bar is a down arrow icon. Clicking it will 
>> reveal available columns to make visible or hide.
>> 
>> As for the Account Name Background, that works fine for me, but do note that 
>> if you select that account, your OS selection color will override the 
>> Account Name Background. (otherwise you couldn’t be sure you had it 
>> selected) If an account with an assigned color is *not* selected, does that 
>> color show up as the background for that row in the Accounts chart? When you 
>> select that account, does the background color change to that of any other 
>> selected element? If so, it is working as intended.
>> 
>> When 4.3 comes out in 2 weeks, there are additional elements which will be 
>> exposed for CSS styling. I don’t have a list on hand, but hopefully the dev 
>> who made the change will update the wiki. If not, I’ll see about getting 
>> them added.
>> 
>> Regards,
>> Adrien
>> 
>>> On Dec 15, 2020 w51d350, at 12:00 PM, Parker Graham < plgii...@gmail.com > 
>>> wrote:
>>> 
>>> Wiki doesn’t show how to address the main screen elements like the three 
>>> columns 
>>> Would like to have them different background color individual and if I turn 
>>> on the account color as background setting it will not highlight the 
>>> account lines as I select them seems buggy on this
>> 
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>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] GTK3 question

[Parker Graham]

How do I set the main window attributes in my gtk-3.0 file? Have set the 
register stuff but would like to be able to set the main screen too.


Thanks

___
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] Tweaks

[Parker Graham]

gnucash 4.2 on linuxmint 19.3

How can I change the scrollbar width? Have looked at and tried the gtk 
tweaks, but nothing seems to work



Thanks

___
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] invisible checkboxes [Solved]

[Graham Menhennitt]

On /Apr 6 04:58:58 EDT 2020, Richard Ullger wrote:
/

On 05/04/2020 06:14, Graham Menhennitt wrote:
>>/Something very strange has happened to my GnuCash installation - I no />>/longer have any checkboxes. In dialogs 
where I'd expect to see them, />>/there is just blank space. In the reconcile window, when I hover my />>/mouse over a 
line, I can see a blank white square where the checkbox />>/would be. If I click the checkbox, the square changes to blue. 
But />>/when I move the mouse away, it's invisible again. Other applications />>/seem unaffected. />//>/Sorry, I 
forgot to say... I'm running GnuCash 3.8 on FreeBSD 12 with />/KDE5 as my desktop. /
There was a problem with the gtk theme in plasma causing checkboxes not
to be correctly rendered but this is fixed in more recent versions of
plasma.

I can't remember in which version it was fixed but it was working in
plasma 5.18.3. Current version is 5.18.4 and is working there too.

Richard


Thanks very much for replying, Richard.

I did have 5.18.3 and it wasn't working. But I upgraded to 5.18.4 and 
it's now all ok.


Thanks for your help.

Regards,

    Graham

___
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] invisible checkboxes

[Graham Menhennitt]

On 5/4/20 3:07 pm, Graham Menhennitt wrote:
Something very strange has happened to my GnuCash installation - I no 
longer have any checkboxes. In dialogs where I'd expect to see them, 
there is just blank space. In the reconcile window, when I hover my 
mouse over a line, I can see a blank white square where the checkbox 
would be. If I click the checkbox, the square changes to blue. But 
when I move the mouse away, it's invisible again. Other applications 
seem unaffected. 


Sorry, I forgot to say... I'm running GnuCash 3.8 on FreeBSD 12 with 
KDE5 as my desktop.


Graham

___
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] invisible checkboxes

[Graham Menhennitt]

Something very strange has happened to my GnuCash installation - I no 
longer have any checkboxes. In dialogs where I'd expect to see them, 
there is just blank space. In the reconcile window, when I hover my 
mouse over a line, I can see a blank white square where the checkbox 
would be. If I click the checkbox, the square changes to blue. But when 
I move the mouse away, it's invisible again. Other applications seem 
unaffected.


Does anybody have any suggestions, please.

Thanks,

    Graham

___
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 to match Quicken

[Graham]

On 17/08/2019 19:50, Adrien Monteleone wrote:

That looks like what you can get out of a Transaction Report.

Regards,
Adrien



Thanks, but the export of a transaction report seems to be pdf or html 
only, and if I cut and paste into a spreadsheet, the values seem to come 
out as a string, like


$26.75

and using the Sum function gives a zero total

--
Cheerio,

Graham



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

[GNC] Reports to match Quicken

[Graham]

Hi folks,

I'm sorry to bother the list with what I suspect is a trivially easy 
problem, but I've been trying and trying to get a report to match the 
sort I used to get from Quicken. [and failing spectacularly badly!]


I'm after an income and expense list, subtotalled by what used to be 
Category in Quicken, to give a format such as:



DateAccount Description 
Amount  















Interest Inc





29/03/2018  ANZ Online SaverCredit Interest $23.21  

28/02/2018  ANZ Online SaverCredit Interest $22.41  

31/01/2018  ANZ Online SaverCredit Interest $26.39  

29/12/2017  ANZ Online SaverCredit Interest $29.42  

30/11/2017  ANZ Online SaverCredit Interest $38.67  

06/11/2017  ANZ Joint (Acc Adv Chq) Account Credit Interest 
$0.20   

06/11/2017  ANZ Online SaverBonus Interest  $16.77  

31/10/2017  ANZ Online SaverCredit Interest $51.02  

Any advice would be most welcome!

 --
Cheerio,

Graham



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

Re: [GNC] v3.5

[Graham]

On 07/04/2019 10:16, Colin Law wrote:

On Sun, 7 Apr 2019 at 10:11, Graham  wrote:

Thanks, Gnus, for a successfully completed first year of use, after
migrating from Quicken.

The prospect of upgrading to 3.5 scares me witless! Is there an idiot's
guide, or is it the same as installing in the first place? Presumably I
just need to ensure safe copies of data files somewhere.

You should make sure you *always* have safe backup copies of your
accounts file, not only when doing an upgrade.  Your disk or computer
may (literally or metaphorically) go up in smoke at any time taking
all your data with it you have not got backups.

The detailed technique for upgrading depends on which OS you are using
and how you installed it in the first place.

Colin

Thanks, Colin, and indeed I have many safe copies, I'm pleased to say. 
I'm on W10, desktop PC. I did try looking for a pointer in the help 
files but failed.


--
--
Cheerio,

Graham


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

[GNC] v3.5

[Graham]

Thanks, Gnus, for a successfully completed first year of use, after 
migrating from Quicken.


The prospect of upgrading to 3.5 scares me witless! Is there an idiot's 
guide, or is it the same as installing in the first place? Presumably I 
just need to ensure safe copies of data files somewhere.


Cheers

Graham

--
--
Cheerio,

Graham


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

Re: [GNC] Receivables Ageing report has a type "Balance", which is in error

[Graham Stoddart-Stones via gnucash-user]

Ah, the point that I was trying to make is that the Receivables Ageing
Report shows a 2018-01-01 balance of ₤25 for a customer that did not exist
in the system on 01Jan18 - ie there are no entries for that customer before
09Apr18.  There are many entries for ₤25, both before and after either
date. I am at a bit of a loss to account for that!

Thank you

Graham

On Thu, 18 Oct 2018 at 05:47, prl  wrote:

> On 17/10/2018 02:09, Graham Stoddart-Stones via gnucash-user wrote:
> > Is there a way of narrowing down the search
> > that you are suggesting, please?
> > This is actually a new customer, who had not been in the system before
> > April 2018.not sure if that is at all relevant?
> Doesn't that fact itself suggest a way of narrowing down the search:
> perhaps you have the customer name or other id information in a
> searchable field like Description or Memo?
>
> Peter
> >> Hi,
> >>
> >> gcstones52  writes:
> >>
> >>> Date Range: 2018-01-01 - 2018-10-16
> >>> Date Due Date Reference Type Description Credits Debits Amount
> >>> 2018-01-01Balance £25.00
> >>> 2018-04-05 2018-04-05 LSVH-2018-85 Invoice Quiz Night deposit, 9Nov18
> >>> £25.00
> >>> £25.00
> >>> 2018-04-102018-85 Payment Bank transfer   -£25.00
> >> -£25.00
> >>> Period Totals £25.00  -£25.00 £0.00
> >>> Total Due £25.00
> >>> Current   0-30 days   31-60 days  61-90 days  91+ days
> >>> £0.00 £0.00   £0.00   £0.00   £25.00
> >>>
> >>> The customer has paid all invoices, and should have a balance of zero
> >> (and
> >>> shows as zero in Accounts Receivable).  However, the report shows a
> >>> "balance" of £25 due from 2018-01-01, but I can find no entries
> anywhere
> >> in
> >>> the system (searching on client name, on transaction date, on amount)
> >> that
> >>> would generate this balance.  Note that the first entry for the
> customer
> >> was
> >>> 2018-04-01.  Could anyone please suggest how a balance may have been
> >> created
> >>> for this customer on 2018-01-01?
> >> This report is looking at Transaction Metadata which might not be
> >> searchable.  If there is a transaction tied to a Lot that is tied to the
> >> customer, that would be sufficient to get it listed.
> >>
> >> Is there a ₤25.00 transaction in A/R at all?
> >>
> >>> Thank you
> >>> Graham
> >>> 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 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] Receivables Ageing report has a type "Balance", which is in error

[Graham Stoddart-Stones via gnucash-user]

Derek:

Thank you for your prompt response.

There are many transactions valued at £25, as that is the standard deposit
for renting the Village Hall.  Is there a way of narrowing down the search
that you are suggesting, please?
This is actually a new customer, who had not been in the system before
April 2018.not sure if that is at all relevant?

Thank you.

Graham

On Tue, 16 Oct 2018 at 16:03, Derek Atkins  wrote:

> Hi,
>
> gcstones52  writes:
>
> > Date Range: 2018-01-01 - 2018-10-16
> > Date Due Date Reference Type Description Credits Debits Amount
> > 2018-01-01Balance £25.00
> > 2018-04-05 2018-04-05 LSVH-2018-85 Invoice Quiz Night deposit, 9Nov18
> > £25.00
> > £25.00
> > 2018-04-102018-85 Payment Bank transfer   -£25.00
> -£25.00
> > Period Totals £25.00  -£25.00 £0.00
> > Total Due £25.00
> > Current   0-30 days   31-60 days  61-90 days  91+ days
> > £0.00 £0.00   £0.00   £0.00   £25.00
> >
> > The customer has paid all invoices, and should have a balance of zero
> (and
> > shows as zero in Accounts Receivable).  However, the report shows a
> > "balance" of £25 due from 2018-01-01, but I can find no entries anywhere
> in
> > the system (searching on client name, on transaction date, on amount)
> that
> > would generate this balance.  Note that the first entry for the customer
> was
> > 2018-04-01.  Could anyone please suggest how a balance may have been
> created
> > for this customer on 2018-01-01?
>
> This report is looking at Transaction Metadata which might not be
> searchable.  If there is a transaction tied to a Lot that is tied to the
> customer, that would be sufficient to get it listed.
>
> Is there a ₤25.00 transaction in A/R at all?
>
> > Thank you
> > Graham
>
> > 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] Auto Save Ledger

[Graham]

On 19/09/2018 16:58, Lesley Douglass wrote:

Every time GnuCash auto saves, it automatically saves two new icons on my 
desktop. A GnuCash icon and a text document. Is there anyway to change the 
settings so this stops?
You can edit the number of saves that are stored to less than 1 day, but 
wouldn't it be better to save to a folder on your desktop instead? That 
way your workspace is uncluttered but you still have plenty of backup in 
case of stuff-ups.


Graham

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

Re: [GNC] UK Shares and Yahoo as JSON

[Graham Balin]

Have you tried single-Morningstar GB as your source?

Cheerio

Graham

On Tue, 4 Sep 2018, 8:15 pm Eric Coates,  wrote:

> Hi
>
> Context: I’m running GnuCash 2.16.7 on Ubuntu 1604 with Finance-Quote 1.47.
>
> Like many others I have been using AlphaVantage as the source for my
> online share price retrievals and been experiencing difficulties.
> Following up on hints in the mailing list I have tried using
> Single/Yahoo as JSON as an alternative source.
>
> Having set the source as Single/Yahoo as JSON for all my shares and
> clicking Get Quotes I got very rich! Unfortunately, a quick
> investigation revealed that, although my European shares had received
> (what looked like) good quotes, the prices received for my UK shares
> come back 100 times too big.
>
> As I have relatively few shares and usually only update the prices at
> the end of the month it is not totally ridiculous to input UK share
> prices by hand. But it would be so much nicer to be able to do it
> automatically.
>
> Assuming that others are having the same problem with UK shares and
> Yahoo as JSON (are they?), is there a known (and hopefully simple) way
> to correct the Yahoo prices?
>
> I wonder if there is a possible alternative: It has been hinted here
> that GnuCash 3 has a much improved CSV importer and (if I understand
> properly) it is possible to input share prices using it. It would be
> possible to get the list of shares and their prices from my broker
> account. Is the GnuCash 3 importer documented (I can't find anything) so
> as to make the import easy? (But that means upgrading and, again, my
> ignorance means I need simple instructions.)
>
> As always, my thanks to the developers and the documentation team and
> other users of this list for their time and efforts
>
> Best wishes
>
> Eric
>
> PS: Please forgive this aside:
>
> On the Securities Editor page, for me, it is not possible to un-tick the
> box in the Get Quote column. Should it be?
>
> ___
> 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- SOLVED!!!!

[Graham Balin]

On 19/08/2018 11:04, Colin Law wrote:
What resolution is your screen?  You said it works ok on a larger 
monitor, what display resolutions are you getting on each?  Go to 
Settings > Devices > Screen Displays and it will show you.



Aha! By George he's got it!
Went into screen displays; changed 'scale for menu and title bars' to 
.75% and the font got smaller but still easily readable, and there is 
acres more space on the screen. Balance shows up nicely, no scrolling 
needed. Slider bars work fine.


Many thanks one and all,  for the advice and help

--

Cheerio,

Graham


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

Re: [GNC] Column widths again

[Graham Balin]

On 19/08/2018 11:04, Colin Law wrote:
What resolution is your screen?  You said it works ok on a larger 
monitor, what display resolutions are you getting on each?  Go to 
Settings > Devices > Screen Displays and it will show you.


Colin


1366*768 on the laptop; 1920x1080 on the [windows] PC

--

Cheerio,

Graham


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

Re: [GNC] Column widths again

[Graham Balin]

What happens is that it springs back to its original width, obscuring the
balance column.
I'll try the ubuntu forums as Adrien advised.
Thanks for all the suggestions. I'll keep you updated.
--

Cheerio,

Graham


On Sat, 18 Aug 2018 at 19:00, David T.  wrote:

> Graham,
>
> Once your balance column has disappeared, what happens if you then grab
> the *right* hand edge of the Description column, and drag it all the way to
> the *left*, and let go? When I take these steps, I am left with a register
> that shows the complete balance column, and the Description changes to fill
> the remaining space, as it is programmed to do.
>
> David
>
> On Aug 17, 2018, at 11:08 AM, 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.
>
> 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.

Re: [GNC] Column widths again

[Graham Balin]

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.

Re: [GNC] Column widths again

[Graham Balin]

--

Cheerio,

Graham


On Fri, 17 Aug 2018 at 22:00, 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
>
>
>>
>> Thanks Colin. Sorry I forgot - Ubuntu  2.16.4 LTS is the version. I can
>> pull the vertical sizing bar down to decrease the height of the tile, but
>> the horizontal bar won't move at all.
>>
> Graham
___
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

[Graham Balin]

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.

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.

Re: [GNC] Column widths again

[Graham Balin]

Yes. 2.6.12 on Ubuntu with HP Laptop. No matter what I do, only the letters
'Ba' show in the Balance column on the far right of the screen.
Clicking tile window allows me to resize the height of the window but not
the width.
Very frustrating. No problem when I am on my big monitor running 3.1 but
then i don't need to resize as the screen is wide enough. However i have
tried to resize and the same 'snapping  back' occurs.
Thanks for the suggestions anyway

Cheerio

Graham

On Thu, 16 Aug 2018, 1:30 pm Colin Law,  wrote:

>
>
> On Thu, 16 Aug 2018 at 09:44, Graham Balin  wrote:
>
>> No, that doesn't work. Sadly my previous 'fix' doesn't work either because
>> as soon as I open a new account window, the widths of all open windows are
>> spoilt. It seems to think my screen is an inch or so wider than it really
>> is, as the balance column is always off-screen.
>>
>
> For most people, once they understand how to sort it there is no problem.
> Something about your situation must be unusual.
> Do you see the same issue if the window is not maximised?
> Have you told us which version of GC you are using and on what OS?
>
> Colin
>
>
>> Dragging the right divider doesn't work - as soon as I let go, it springs
>> back to the previous width.
>>
>> What I can't understand is why this problem still happens. Someone once
>> must have coded the auto-size feature for the description column - given
>> that people have been complaining about it for at least 8 years, can it
>> not
>> just be deleted so all columns behave the same way?
>> --
>>
>> Cheerio,
>>
>> Graham
>>
>>
>> On Wed, 15 Aug 2018 at 21:46, GT-I9070 H  wrote:
>>
>> > I have large and small monitors and the sizing of the columns started to
>> > work very well for me after I got enough knowledge to deal with them.
>> >
>> > After you scale all columns to your liking, drag in the header the end
>> > divider of the Description column farthest to the left and then drop it
>> and
>> > it will auto size as much as possible in the window without a horizontal
>> > scrollbar.
>> >
>> > Double-clicking on the column header resizes it to the minimum required
>> > and sets this width, dragging its right divider in the header defines a
>> > fixed width.
>> >
>> >
>> > Regards
>> > GTI
>> >
>> > Em seg, 13 de ago de 2018 às 14:34, Graham Balin <
>> graham.ba...@gmail.com>
>> > escreveu:
>> >
>> >> Hi all,
>> >> Recent convert from Quicken and pleased overall...BUT...
>> >> version 2.6.12 on a windows machine and 24" monitor-fine; on a HP
>> >> laptop...almost unusable due to description column auto-widening to
>> screen
>> >> width.
>> >> I have tried trawling through the many posts, dating back 8 years!, and
>> >> cannot believe that it still happens! Why on earth is there such a
>> feature
>> >> that is the antithesis of user-friendliness?
>> >> Is there some programming reason it needs to be there?
>> >> I have tried all workarounds except going into programming in which I
>> am
>> >> sadly ignorant.
>> >> Once I have made the error of re-sizing one of the columns -bang, I
>> have
>> >> to
>> >> keep horizontal scrolling to see what is going on. Does 3.2 offer any
>> >> improvement on this?
>> >>
>> >> Has anyone got any suggestions?
>> >> --
>> >>
>> >> Cheerio,
>> >>
>> >> Graham
>> >> ___
>> >> 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] Column widths again

[Graham Balin]

No, that doesn't work. Sadly my previous 'fix' doesn't work either because
as soon as I open a new account window, the widths of all open windows are
spoilt. It seems to think my screen is an inch or so wider than it really
is, as the balance column is always off-screen.
Dragging the right divider doesn't work - as soon as I let go, it springs
back to the previous width.

What I can't understand is why this problem still happens. Someone once
must have coded the auto-size feature for the description column - given
that people have been complaining about it for at least 8 years, can it not
just be deleted so all columns behave the same way?
--

Cheerio,

Graham


On Wed, 15 Aug 2018 at 21:46, GT-I9070 H  wrote:

> I have large and small monitors and the sizing of the columns started to
> work very well for me after I got enough knowledge to deal with them.
>
> After you scale all columns to your liking, drag in the header the end
> divider of the Description column farthest to the left and then drop it and
> it will auto size as much as possible in the window without a horizontal
> scrollbar.
>
> Double-clicking on the column header resizes it to the minimum required
> and sets this width, dragging its right divider in the header defines a
> fixed width.
>
>
> Regards
> GTI
>
> Em seg, 13 de ago de 2018 às 14:34, Graham Balin 
> escreveu:
>
>> Hi all,
>> Recent convert from Quicken and pleased overall...BUT...
>> version 2.6.12 on a windows machine and 24" monitor-fine; on a HP
>> laptop...almost unusable due to description column auto-widening to screen
>> width.
>> I have tried trawling through the many posts, dating back 8 years!, and
>> cannot believe that it still happens! Why on earth is there such a feature
>> that is the antithesis of user-friendliness?
>> Is there some programming reason it needs to be there?
>> I have tried all workarounds except going into programming in which I am
>> sadly ignorant.
>> Once I have made the error of re-sizing one of the columns -bang, I have
>> to
>> keep horizontal scrolling to see what is going on. Does 3.2 offer any
>> improvement on this?
>>
>> Has anyone got any suggestions?
>> --
>>
>> Cheerio,
>>
>> Graham
>> ___
>> 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

[Graham Balin]

Thanks. doesn't work for me.
However, I have discovered that closing Gnucash and re-opening re-sets
things, so as long as I leave the column widths alone, all is well. The
moment I try to re-size, bang.
Masterly inactivity is called for, I think!
--

Cheerio,

Graham


On Mon, 13 Aug 2018 at 21:45, Colin Law  wrote:

> On Mon, 13 Aug 2018 at 19:37, Graham Balin  wrote:
>
>> ...
>> Once I have made the error of re-sizing one of the columns -bang, I have
>> to
>> keep horizontal scrolling to see what is going on.
>>
>
> All you have to do is to set the column sizes (apart from description) as
> you want then double click the description column and it should resize to
> fit the window.  At least that works for me.
>
> 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.

[GNC] Column widths again

[Graham Balin]

Hi all,
Recent convert from Quicken and pleased overall...BUT...
version 2.6.12 on a windows machine and 24" monitor-fine; on a HP
laptop...almost unusable due to description column auto-widening to screen
width.
I have tried trawling through the many posts, dating back 8 years!, and
cannot believe that it still happens! Why on earth is there such a feature
that is the antithesis of user-friendliness?
Is there some programming reason it needs to be there?
I have tried all workarounds except going into programming in which I am
sadly ignorant.
Once I have made the error of re-sizing one of the columns -bang, I have to
keep horizontal scrolling to see what is going on. Does 3.2 offer any
improvement on this?

Has anyone got any suggestions?
--

Cheerio,

Graham
___
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] Fwd: liability or expense

[Graham Balin]

Forwarded as I forgot to 'reply  all'. Sorry. Newbie brain!

Cheerio

Graham

-- Forwarded message -
From: Graham Balin 
Date: Mon, 6 Aug 2018, 10:12 pm
Subject: Re: [GNC] liability or expense
To: Baldero Mendoza 


I have found Gnucash to be a very powerful hammer to crack a very small nut
using it for domestic accounts only. Does the job well but there are
features of double entry bookkeeping that are superfluous. For example you
will have an expenses;groceries account that will be a mass of entries and
will never be reconciled because it is irrelevant.just ignore it. It is
there to help you categorise your spending. Well, you can reconcile it if
you want to spend half your life on your accounts!
I'm into my 3rd month and haven't done any reports yet. Just pleased that
all bank accounts and liabilities (credit cards)are balanced and
reconciled. Investments are taking a bit longer to get my head around.
Good luck!

Cheerio

Graham

On Mon, 6 Aug 2018, 10:02 pm Baldero Mendoza,  wrote:

> Please be patient with me - brand new to this.
>
> Household financial stuff. I want to post a "google play" purchase.
> Should I post as an expense or a liability?
>
> I have accounts open for things like "electricity" and that seems to
> work just fine, but "google play" looks like it works sort of like a
> credit card, so I listed it under  "liabilities", and that seems to
> work too. I made the connected account "checking" and it all seems to
> balance and work.
>
> However, what bothers me is that the "google play" entry under
> "liabilities" is listed as a red negative number. So I have two red
> negative numbers listed now, one under "liabilities" and one under
> "google play". Everything balances, so is it okay or should I place
> "google play" purchases as "expenses"? (I just started gnucash so
> there aren't any credit card or debit card purchases yet.) The
> "expenses" stuff gets listed as black positive numbers even though
> they're an outflow of money just like the "google play" stuff under
> "liabilities". Maybe it's optional and can be done either way?
> Confusing.
>
> Thank you everybody!
> ___
> 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] Strange Problem

[Graham Balin]

On 22/06/2018 17:34, Les wrote:

John:

I never received your reply because for some reason, it ended up in my 
spam folder.


I am not sure what you mean, but I cannot find the stock in question 
in Price Editor so I cannot check its prices.  I have selected to get 
quotes via AlphaVantage in Security Editor.


At any rate, I cannot get prices or input a price manually.

Thanks,

Les 


Have you tried using the ISIN number as an identifier?

--

Cheerio,

Graham


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

Re: [GNC] Search facility

[Graham Balin]

On 16/06/2018 13:00, Geert Janssens wrote:

D'oh.:-[
Of course.
Memo to self: Try harder next time



Edit->Find

This behaves slightly differently when started  from the account hierarchy or
from an account register.

When started from the account hierarchy it will search all transactions and
splits in all accounts. When started from an account register it will only
search for splits (and their associated transaction info) in that account.

Regards,

Geert




--
--

Cheerio,

Graham


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

[GNC] Search facility

[Graham Balin]

Apologies if this is brain-numbingly obvious, but I have tried looking 
for the answer, honest!


How do I search for a particular item eg search all accounts for $4.35, 
or transactions with 'Harrison' in it?  Quicken had a very simple search 
bar which worked very well. Is there a similar function in GNC?


--
--

Cheerio,

Graham


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

[GNC] exchange rate calculations

[Graham Balin]

Another problem has cropped up now.. in the investment portfolio report, 
i see this:


IG GROUP    IGG.L    LSE    400.00    £8.67    £3,468.00
LOVISA    LOV.AX    ASX    3,500.00    $12.17    £7,268.89

Note the IG quote is worked out properly, but LOV.AX has updated the 
correct price in AUD, but the value of £7268.89 is the original purchase 
price, not the current value which should be [3500*12.17]*0.57 ish


I tried entering the AUD /GBP price manually, but the report stayed the 
same as above.


As usual, any tips would be gratefully received,

--
--

Cheerio,

Graham


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

Re: [GNC] Online quotes for funds

[Graham Balin]

On 10/06/2018 22:07, Richard Ullger wrote:

Assuming you're in the UK going by the .L you're using, Morningstar, GB
works for me using just the ISIN code.

Regards,

Richard.

Thanks Richard. Do you enter the account as a fund or a stock? I have 
tried both; I've tried online quotes -'single' morningstar gb and 
'multiple - Funds UK etc' but neither seem to do the trick. Keeps coming 
up as 'unable to retrieve quote'


--
--

Cheerio,

Graham


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

[GNC] Online quotes for funds

[Graham Balin]

Sorry to be a bore, but having cracked the stock quotes problem, I'm now 
having trouble with funds. I suspect the problem lies in the display 
box. Stocks are easy xyz.L or whatever, but how do I find out what funds 
should be?


I tried putting the ISIN number in but that doesn't work. Can someone 
point me to a source to find out the equivalent of a ticker for a fund?


--

Cheerio,

Graham


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

Re: [GNC] Online quotes problem -sorted

[Graham Balin]

Many thanks for the replies all
Going through the API route and altering the environment file has done 
the trick.

G

On 09/06/2018 11:48, Maf. King wrote:

On Saturday, 9 June 2018 10:22:19 BST Graham Balin wrote:

Many thanks for the reply, but sadly none of this works.
I tried adding an ".AX" stock as described below but that didn't work
either.
I'm afraid I don't understand the references to API for AlphaVantage -
is that something I need to find out about?
G


Hi Graham

OK, back in November Yahoo stopped providing price information.  There was a
lot of traffic on the list around then and some rapid patches provided by
various developers to keep the wheels turning.

There are a couple of alternatives you can use - there is a service called
Alphavantage which is nearly the same as the old Yahoo service.  But you need
to register with Alphavantage and get an " API key" (a sequence of
Alphanumeric characters to authorise you on their service) which the Finance
Quote PERL scripts need to be told, but then can handle getting price info
from Alphavantage.  The Gnucash FAQ contains details and instructions about
that.

Another option - it has been reported on the list that Yahoo still have a way
to get info - but you need to tell F::Q use "yahoo_json" in place of Yahoo.  I
haven't tried it.  The list archives will have more info if you can search and
find it!

HTH,
Maf.







--
--

Cheerio,

Graham


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

Re: [GNC] Online quotes problem

[Graham Balin]

Many thanks for the reply, but sadly none of this works.
I tried adding an ".AX" stock as described below but that didn't work 
either.
I'm afraid I don't understand the references to API for AlphaVantage - 
is that something I need to find out about?

G

On 09/06/2018 07:38, WasserLand wrote:

Graham,

What follows here is a cut & paste of the recent chain of emails that 
resulted in the resolution of the same problem.  Read from bottom up, 
in blue.  Tell me if I can further elaborate:


Thank you Maf,

The very first thread led me to the answer.  Simply a matter of
adding an ".AX" suffix to the  share code!

How I struggled to resolve the matter prior!  As always the
solution is simple.

Thank again for responding to my outcry.

Dave W



On 06/06/18 23:48, Maf. King wrote:
Hi,

have you tried the list archives?  Try this thread (yes it is Win,
but that
isn't relevant)

https://lists.gnucash.org/pipermail/gnucash-user/2018-May/076983.html

or maybe this

https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075839.html


HTH,
Maf.




On Wednesday, 6 June 2018 13:50:39 BST WasserLand wrote:

I have a problem with getting quotes for my ASX portfolio in GnuCash.
Finance::Quote no longer works.

I am running Ubuntu 16.04.

Any help, please.

Dave W

On 09/06/18 02:40, Graham Balin wrote:


Hey guys n gals,

I'm afraid I'm getting a bit out of my depth here. Keep having 
problems getting online updates of stocks. Been through the archives 
but none of it seems relevant to me on this topic.


Tried re-installing the perl installer [on Win 10]and it seemed to be 
fine. Only problem is I still get 'unknown error' message when I try 
to 'get quotes'.


As per the guide, I tried c:\Program Files 
(x86)\gnucash\bin>gnc-fq-dump -v yahoo USDEUR=X. .got:


'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.

Then I tried

c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl 
gnc-fq-helper


and I got:

Use of uninitialized value $year in numeric lt (<) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"\"-//W3C//"...} in substitution (s///) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <> 
line 1.
Use of uninitialized value within %info in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <> 
line 1.

(#f)
I have no idea what is going on, and would value any tips of where to 
go/what to do.


TIA

--

Cheerio,

Graham


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





--
--

Cheerio,

Graham

___
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] Mailing list filter no longer working

[Graham Balin]

Mine is fine. Reinstall TB? (Save profile first)

Cheerio

Graham

On Fri, 8 Jun 2018, 6:30 pm elvis,  wrote:

> Just wondering if something changed in the list-ID, Thunderbird no
> longer recognises gnucash emails
>
> --
>
> ___
> 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] Online quotes problem

[Graham Balin]

Hey guys n gals,

I'm afraid I'm getting a bit out of my depth here. Keep having problems 
getting online updates of stocks. Been through the archives but none of 
it seems relevant to me on this topic.


Tried re-installing the perl installer [on Win 10]and it seemed to be 
fine. Only problem is I still get 'unknown error' message when I try to 
'get quotes'.


As per the guide, I tried c:\Program Files (x86)\gnucash\bin>gnc-fq-dump 
-v yahoo USDEUR=X. .got:


'gnc-fq-dump' is not recognized as an internal or external command,
operable program or batch file.

Then I tried

c:\Program Files (x86)\gnucash\bin>echo (yahoo "CSCO") | perl gnc-fq-helper

and I got:

Use of uninitialized value $year in numeric lt (<) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 750, <> line 1.
Use of uninitialized value $month in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 768, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 773, <> line 1.
Use of uninitialized value $month in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $day in sprintf at 
C:/strawberry/perl/site/lib/Finance/Quote.pm line 774, <> line 1.
Use of uninitialized value $info{"in substitution (s///) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 233, <> line 1.
Use of uninitialized value within %info in pattern match (m//) at 
C:/strawberry/perl/site/lib/Finance/Quote/Yahoo/Base.pm line 238, <> line 1.

(#f)
I have no idea what is going on, and would value any tips of where to 
go/what to do.


TIA

--

Cheerio,

Graham


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

Re: [GNC] Entering preexisting shares

[Graham Balin]

On 06/06/2018 20:28, John C wrote:
Assuming you're transferring shares from one brokerage account to 
another, I found it best to enter the shares and their original 
purchase dates in the destination stock account and the cash used for 
the purchase comes from Equity: Opening Balances.  This way maintains 
the lot purchase dates and doesn't seem to conflict with the brokerage 
account opening date.


You could also enter a negative number of shares and the base price in 
one stock account and the same (but positive) number of shares and 
base price in the destination account.


You won't have much luck trying to credit the stock account directly 
from Equity:Opening Balances, because the currencies are different, 
"shares" vs. "dollars".



Wow! Didn't expect a reply that fast!
No, I wasn't transferring, just trying to enter a date in the past when 
i bought the shares. I take your point about the conflict with opening 
dates -will play around with that.


[Crediting the stock account seems to be what is described in 9.5.1 of 
the guide; it is the value of the shares that is credited ]


Thanks for the reply
--

Cheerio,

Graham


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

[GNC] Entering preexisting shares

[Graham Balin]

Hi. My first post as a gnu-bie, so please bear with me.

Trying to enter preexisting shares as split transaction, with commission 
and tax. [Have searched google /archives without success]


I enter the splits, [as per 9.5.1 of gnucash guide] add a balancing 
amount from 'equity:opening balances' and yet I get 'imbalance' and 
'orphan-gbp' generated.


Hope the image comes out ok. Any ideas or places to look, gratefully 
received


--

Cheerio,

Graham



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

Re: importing splits

[Matt Graham]

The easiest way would be saving  the spreadsheet to .csv format and importing 
that to Gnucash.

Id recommend:
- first removing any other text and stuff you have so that the spreadsheet is 
just the headings you want and the data you want in columns
- doing the import on a new test gnucash file first if you have a lot of data 
already in your gnucash book. Just in case.

Good luck!

Thanks and regards,
Matt


 Original message 
From: Jeff Abrahamson 
Date: 21/2/18 05:00 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: importing splits

I'm processing check deposits.  I have a spreadsheet with lovely columns
like name, check number, amount, and the account to debit.  It seems a
shame to retype it all.

I see some old discussion on the list that, essentially, says this is
not well supported if supported at all.


https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2F2014-October%2F056617.html=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=uG5aM8vQ0%2FJ6JvudouGDUL%2F%2BJaLVQvq%2FOQcX93gD%2BaA%3D=0

Is there anything since that might help?  I'm not sure converting
spreadsheets to QIF to then import into gnucash is better than retyping.

--

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fp27.eu%2Fjeff%2F=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=Y%2FRcHTU8yWdltXDL4zBTAMPN8grAsKCwY7mf%2FQfmhyw%3D=0

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=LnIFOxRytZiVO6O4On68c7%2B%2FT6DbEEEOclsFRTwyxyo%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C78035f813c42409f0bb008d5788bde6b%7C84df9e7fe9f640afb435%7C1%7C0%7C636547464489079590=gnCglOKNDVqlWOaz1Wc4ilJcgVFWM9OkBtXcCFXJdWE%3D=0
 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: Users replying to digest rather than starting a new thread

[Matt Graham]

Actually – better idea:
Can the digest produce a hyperlink at the end of each topic that is titled 
“Reply to this thread”. The hyperlink would be a standard “mailto:” hyper link 
that sets up an email to this user thread with the subject line of the thread. 
Would make it extremely easy to reply to a digest (and harder to do it wrong!).

Should be possible making the link address 
‘mailto:gnucash-user@gnucash.org?subject=Previous subject string’. Just don’t 
know if it is possible with mailman.

Thanks and regards,

Matt

From: Matt Graham<mailto:matt_graham2...@hotmail.com>
Sent: Wednesday, 14 February 2018 8:44 AM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: RE: Users replying to digest rather than starting a new thread

No worries Liz,

I was thinking how off-putting it must be for a new user receiving messages 
from other users saying “Don’t post like that!!!”

My next idea would be for the server to automatically change the subject line 
to ‘ “Question from “ + User Name’ whenever someone replies straight to a 
digest.

Happy for no change though – just means we’ll probably still keep getting 
people replying to the digests like this. Ultimately, it isn’t a big issue, and 
if there is no easy way to fix it, we can just work with it.

Thanks and regards,

Matt

From: Liz<mailto:ed...@billiau.net>
Sent: Tuesday, 13 February 2018 5:49 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Users replying to digest rather than starting a new thread

On Sun, 11 Feb 2018 05:29:13 +
Matt Graham <matt_graham2...@hotmail.com> wrote:

> Probably stupid question – is there a way to set rules on the
> gnucash-user account?
>
> Ie anytime someone sends an email that starts with “Re gnucash-user
> Digest”, the system rejects their email with a response along the
> lines of “Please do not reply to the digest without changing the
> subject line. Start a new email with the subject line the same as the
> topic you wish to respond to.”
>
> Thanks and regards,
>
> Matt

I'm not aware of a place to put such an option.
I wouldn't like to get such an email if I was a new user with a
question related to a topic on the digest, and I'm not in favour of
making such a change.

Liz
Moderator
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=LlRjzoHtVNrz9j%2F7VNrpqsDV462KPt1IwcpHzsGiqIA%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=%2FTKZ8ySMJ%2Fh%2FCWMgXKfOhu6hSdJekV8lqVUxs5C5sHU%3D=0
 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://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Ccff2ecdae28a40e0f9e608d5732afc43%7C84df9e7fe9f640afb435%7C1%7C0%7C636541550805828852=zcx0b%2B6m23MlsWOO69EeJpws6RAK5Mu5uudSF60Kq1c%3D=0
If you are using Nabble or Gmane, please see 
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Ccff2ecdae28a40e0f9e608d5732afc43%7C84df9e7fe9f640afb435%7C1%7C0%7C636541550805828852=I2tONWBr9smRjtkhn%2F4KjAsMs6%2FRYXCYquFRzvV9HpE%3D=0
 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: Users replying to digest rather than starting a new thread

[Matt Graham]

No worries Liz,

I was thinking how off-putting it must be for a new user receiving messages 
from other users saying “Don’t post like that!!!”

My next idea would be for the server to automatically change the subject line 
to ‘ “Question from “ + User Name’ whenever someone replies straight to a 
digest.

Happy for no change though – just means we’ll probably still keep getting 
people replying to the digests like this. Ultimately, it isn’t a big issue, and 
if there is no easy way to fix it, we can just work with it.

Thanks and regards,

Matt

From: Liz<mailto:ed...@billiau.net>
Sent: Tuesday, 13 February 2018 5:49 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Users replying to digest rather than starting a new thread

On Sun, 11 Feb 2018 05:29:13 +
Matt Graham <matt_graham2...@hotmail.com> wrote:

> Probably stupid question – is there a way to set rules on the
> gnucash-user account?
>
> Ie anytime someone sends an email that starts with “Re gnucash-user
> Digest”, the system rejects their email with a response along the
> lines of “Please do not reply to the digest without changing the
> subject line. Start a new email with the subject line the same as the
> topic you wish to respond to.”
>
> Thanks and regards,
>
> Matt

I'm not aware of a place to put such an option.
I wouldn't like to get such an email if I was a new user with a
question related to a topic on the digest, and I'm not in favour of
making such a change.

Liz
Moderator
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=LlRjzoHtVNrz9j%2F7VNrpqsDV462KPt1IwcpHzsGiqIA%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C3bc50f9d260146db808108d572adf749%7C84df9e7fe9f640afb435%7C1%7C0%7C636541013856348160=%2FTKZ8ySMJ%2Fh%2FCWMgXKfOhu6hSdJekV8lqVUxs5C5sHU%3D=0
 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: inventory management examples or links

[Matt Graham]

https://wiki.gnucash.org/wiki/Inventory_Handling

This issue must have come up before. The wiki could ideally use some discussion 
about separation of inventory and accounting systems. I imagine for a small 
business that just wants to keep track of a few things they would want them 
both integrated (but then later realise that they really need them separate – 
unless GNUcash wants to branch into both worlds).

I didn’t find anything in the tutorials and concepts guide under the business 
features – but unless Gnucash is going to get an “inventory” capability, that’s 
probably okay.

Adrien – do you have time to put your example on the wiki of how to integrate 
inventory systems with GNUcash’s accounting?

Thanks and regards,

Matt

From: Adrien Monteleone
Sent: Tuesday, 13 February 2018 10:11 PM
To: Bert Heijne
Cc: gnucash-user@gnucash.org
Subject: Re: inventory management examples or links

Bert,

I posted some more replies in the original thread containing various inventory 
related transaction examples and suggested accounts.

Let me know if you need anything specific that isn’t covered and I’ll see what 
I can do.

Really, these are just basic accounting entries for a retail business that you 
can find in any standard accounting text book, or online.

There’s nothing special about them with regards to Gnucash.

Regards,
Adrien

> On Feb 12, 2018, at 6:25 AM, Bert Heijne  wrote:
>
> Hello All.
>
> This is a nice treat about Inventory but are there some “real examples”  or “ 
> putting it all together”  of gnucash for Inventory or stock of goods 
> management?
> And how this is covered with the invoice.
> I now that gnu cash is not build for that but small stock would be nice
> Woocommerce webshop is in construction so this will be covered mostly by WC.
>
> Would be nice to see some real samples in gnucash to study.
> Any links or G search links  would be nice
>
> Gr. Bert
>
> Verzonden met Windows Mail
>
> Van: Robert Heller
> Verzonden: ‎zondag‎ ‎11‎ ‎februari‎ ‎2018 ‎17‎:‎15
> Aan: stepbystepf...@dialup4less.com
> CC: gnucash-user@gnucash.org
>
> At Sun, 11 Feb 2018 10:55:58 -0500 stepbystepf...@dialup4less.com wrote:
>
>>
>> On 2/11/2018 9:03 AM, Robert Heller wrote:
>>> At Sun, 11 Feb 2018 08:15:56 +0100 Jeff Abrahamson  wrote:
>>> ... transfer
>>> "money" from the vegetable account to a bank account (income when you sell
>>> vegetables) and when you transfer money from a bank account to the vegetable
>>> account (an expense when you buy vegetables). *I* do this which my inventory
>>> of thumb drives. GnuCash does not have "inventory" accounts or any way of
>>> dealing with inventory as such
>> Inventory MANAGEMENT is something else (gnucash lacks this but that
>> belongs in an inventory system*, not "general ledger".
>
> Yes, I understand.
>
>>
>> But you are saying that gnucash does not support inventory value and
>> cost accounting and that is simply not so.
>
> Only in the sense of not specificly labeling things as "inventory value and
> cost accounting". You are right, one can use gnucash to "manage" inventory
> value and cost accounting. From the point of a newbie, there isn't a specific
> menu of things relating to inventory value and cost accounting, so there is
> the *appearence* of a of lack of support for inventory. My intent was to point
> the OP in "right direction", one that is not obvious. Inventory value and cost
> accounting is handled in GnuCash under "other names" -- it is a matter of
> understanding that inventory is really a kind of asset (that is bought and
> sold) and can (should) be treated as such, at which point all of pieces fall
> into place. The OP wanted to treat his inventory as income or expense and that
> what was confusing (to him).
>
>>
>> Let's say incidental to its main activity an organization sells various
>> things (tee shirts, coffee mugs, etc.) as a fund raiser. You create
>> under Assets (after "current assets" and "fixed assets") a parent
>> "Inventory of goods". Under that might be accounts (more likely also
>> parents as batches of goods might have different basis) for "tee
>> shirts", "coffee mugs", etc. When the organization buys a new batch of
>> tee shirts that is a debit to "tee shirts" (or as I mentioned, perhaps
>> "tee shirts batch 4" --- the account description can include what the
>> unit price was for this batch) and a credit to checking << note: we get
>> confused using the supposedly more user friendly terms worrying about
>> what sort of "transfer" this is). Each sale of a tee shirt not only
>> debits cash and credits "sale of tee shirts" for the sale price but also
>> debits "cost of goods sold" and credits the inventory account "tee
>> shirts batch N" for the unit cost of batch N << going to be a 

Users replying to digest rather than starting a new thread

[Matt Graham]

Probably stupid question – is there a way to set rules on the gnucash-user 
account?

Ie anytime someone sends an email that starts with “Re gnucash-user Digest”, 
the system rejects their email with a response along the lines of “Please do 
not reply to the digest without changing the subject line. Start a new email 
with the subject line the same as the topic you wish to respond to.”

Thanks and regards,

Matt

From: Geert Janssens
Sent: Saturday, 10 February 2018 11:59 PM
To: gnucash-user@gnucash.org
Subject: Re: gnucash-user Digest, Vol 179, Issue 34

Op zaterdag 10 februari 2018 13:30:36 CET schreef Adonay Felipe Nogueira:
> I once *heard* that GNU Mailman version 3 has forum-like interface but
> with proper mailing list integration. We are using GNU Mailman, but not
> the last version, and I don't know why. I know little about the
> internals of GnuCash project's infrastructure because I'm just a user.

Mailman 3 in combination with Hyperkitty would indeed provide the combined
functionality.

The problem is both are missing from Fedora repositories. I have asked about
this and the answer was they are not stable enough. Not a good base to build a
user facing platform on yet.

I'm still hoping it will materialize one day, though I'm no longer holding my
breath on that...

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C6ab25e7c347f4520bb8708d570862c24%7C84df9e7fe9f640afb435%7C1%7C0%7C636538643924219800=H2Y0jC9lxKIJAZkC8Lmse2yg2vvcotQAf8xtbMlHdU4%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C6ab25e7c347f4520bb8708d570862c24%7C84df9e7fe9f640afb435%7C1%7C0%7C636538643924219800=wMU2%2FR4ibO59od7k3xeOyY%2B6xwh%2BJ0oyoQGh%2BB%2Bcm7c%3D=0
 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.

The Wiki, and documentation

[Matt Graham]

Thanks Dave (And sorry – I knew I forget at least one of the regular mailing 
list people... Should have just said that you all rock ☹ )

Anyway – your comments make a good point regarding the never ending push to try 
to keep it all up to date. I know that the Tut and concepts guide and manual 
are done within xml DocBook. Does anyone know of any way to have one source of 
all information that the system can then produce the wiki pages, manual and 
tut/concepts guide? They are all different forms of information, but just 
wondering whether, for example, “GNUCash Windows Installation” could have one 
file that has tags or something for the different information in the different 
areas (so the “how to” section gets automatically pulled to the manual, the 
detailed tutorial and cool stuff to do gets pulsed into the concepts, and the 
detailed discussions and troubleshooting gets shunted to the wiki). Hopefully 
you could also define some “FAQ” questions for any of the topics that are 
automatically pulled to that page.

Maybe I’m just overthinking it... I have a habit of doing that.

Thanks and regards,

Matt

From: David T.<mailto:sunfis...@yahoo.com>
Sent: Friday, 9 February 2018 4:27 PM
To: Matt Graham<mailto:matt_graham2...@hotmail.com>
Cc: Adrien Monteleone<mailto:adrien.montele...@gmail.com>; 
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Cash Flow View

Matt,

The wiki can always use help, so thank you! I think your approach makes sense. 
I will note that there already is a set of installation pages, and it may be 
most useful simply to move the relevant questions and answers to them. I 
suspect that there are similar overlaps in other areas of the FAQ. In each 
case, I would hope that you would keep a general question in the FAQ along with 
a reference to the appropriate dedicated wiki page. But by all means, move 
content to more specific pages wherever possible!

One major challenge in all the GnuCash documentation (the wiki, the website, 
and the Help and Guide) is making sure that the information is up to date, 
accurate, and still relevant. While it may be interesting to refer to technical 
accounting discussions from the lists in 2005, are the discussions still 
useful, and should readers need to know about them? I would hope that as you 
move things around, some of the more dated entries could be removed or placed 
in a different context to reflect their time-dated nature.

Generally, I think that information that addresses problems for versions that 
are no longer officially supported should either be deleted or archived in a 
special GnuCash salt mine, so that current users of the software aren’t 
worrying whether they need to manage their dbus daemons or not.

David

> On Feb 9, 2018, at 9:03 AM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> G’day All,
>
> I was thinking about what Adrien said in a past email: “Many questions lately 
> seem to be asked a bit too quickly.”. I agree – I sometimes wonder whether 
> people do a simple google before asking.
>
> Still, when I tried to go onto the GNUCash FAQ wiki to find the answer and 
> send it to someone, I found it really hard to find it (but it was there when 
> I searched the page). Due to the huge amount of ‘questions’ on there, It is 
> very difficult to quickly scan down to find stuff you are interested in.
>
> I have edited the page to take the actual questions out of the table of 
> contents – so hopefully people can more easily find their answer through 
> browsing their area (eg the “Using the Business Features” area if they are 
> wondering about how to do invoice stuff). Devs/experts, feel free to revert 
> it back if you don’t like it.
> I fiddled with “mw-collapsable” to get an expandable table of contents, but 
> couldn’t get it working well.
>
> To further improve it all, I’m considering trying to establish more wiki 
> pages to take a lot of the questions off the FAQ. Eg all the installation 
> questions would probably be better placed on wiki pages, with the FAQ just 
> having entries “Installing on Windows”, “Installing on Mac” and “Installing 
> on Linux” to link users to the right wiki page
>
> Anyone got any other ideas to make it easier for people to find the answers 
> without taking up Adrien/John/Geert/Mike’s time? (you all rock, by the way)
>
> Thanks and regards,
>
> Matt
>
> From: Adrien Monteleone<mailto:adrien.montele...@gmail.com>
> Sent: Thursday, 8 February 2018 6:29 AM
> To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
> Subject: Re: Cash Flow View
>
> I second Mike’s comments generally.
>
> What would probably address most concerns in this regard is a default 
> multi-column report that included the basics—Income Statement, Balance Sheet, 
> and perhaps Income/Expense graphs. This would b

mailing list

[Graham Jacks]

A few days ago I asked you a question about GnuCash, as I was wondering whether 
to start using it.   Since then I seem to have been put on your mailing list, 
and have been seeing a lot of  email messages about issues related to GnuCash 
which mean nothing to me.   

After studying GnuCash, I don’t think it would be the program/app/system that I 
need, so could I ask you to take me off the mailing list?  

I will delete the messages that have already arrived.

Best wishes, Graham Jacks  
___
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: can't change preferences [SOLVED]

[Graham Menhennitt]

On 05/02/2018 22:54, Geert Janssens wrote:

Op zondag 4 februari 2018 09:48:49 CET schreef Graham Menhennitt:

Hi GnuCashers,

I'm running GnuCash 2.6.19 on FreeBSD 11-stable. Everything seems to
work correctly except that I can't change any preferences. I try to
click on the tick boxes/radio buttons etc. in the Edit Preferences
dialog, but nothing happens. It's as if everything is read-only.

I presume that the reason for this also causes that it doesn't remember
my most recent open files, and it always shows tips on startup even
though I unticked the "show tips" box.

Does anybody have any clues, please?


The gnucash preferences are stored in gsettings. This is a generic preferences
store that requires a platform dependent backend. On linux this backend is
dconf. I presume this is also what would be used on FreeBSD. Can you check if
dconf is installed (and used) ?


Thanks for replying, Geert.

I can run the dconf command. But I can't seem to get anything out of it:

    dconf list /
    dconf list /org.gnucash/
    dconf list /org/gnucash/

all print nothing.

I can see /usr/local/share/glib-2.0/schemas/ contains lots of files 
including 16 org.gnucash.* ones. I can also see the file 
gschemas.compiled in that directory and it has the same date/time as the 
gnucash files.


I built GnuCash from the FreeBSD port system using the guile2 option 
(after having used older versions of GnuCash and guile for many years). 
Maybe that's when I started having this problem. I can try switching 
back to guile1, or even going back to an older version of GnuCash.


Hang on, I'm going to try something...

... ok, back again and solved it!

It appears that my dconf settings were corrupt. I installed dconf-editor 
and, when I ran it and tried to edit something, it said:


    (dconf-editor:25665): dconf-WARNING **: failed to commit changes to 
dconf: 
GDBus.Error:org.gtk.GDBus.UnmappedGError.Quark._g_2dfile_2derror_2dquark.Code17: 
Cannot open dconf database: invalid gvdb header


So I renamed ~/.config/dconf to ~/.config/dconf_save and tried it again, 
and it worked. And now I can change the GnuCash preferences too! So, 
it's all working now.


Thanks again for your help,
    Graham
___
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: New Entities

[Matt Graham]

The only other thing to add - this all presumes that you need separation. 
Probably do for your businesses (tax and legal reasons - I have no idea), but 
don't forget that GNUCash reports are very flexible - you choose the accounts 
you want included.

I don't use the business features though - I'm not sure whether they would be 
as flexible.

You could have two different root accounts for each business (each with their 
own assets, expenses, liabilities, and income sub accounts) and go from there.

I'm sure I just gave a few accountants on this list a heart attack...

Ultimately, as others have said, opening different files for each business is 
probably a better way to go.

David/Adrian/John - is opening multiple windows a feature we should be putting 
into bugzilla for eventual incorporation? I'm getting the impression that V3.0 
onwards will be much easier to fix up stuff like this.

Thanks and regards,
Matt


 Original message 
From: Roger Hatton 
Date: 7/2/18 08:58 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: New Entities

Does GNU Cash support more than one entity?
In other words separate ledgers for separate business names?
Using the one single downloaded GNU Cash system?
Process advice appreciated.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C84e11b321bfc4040f86708d56dacb622%7C84df9e7fe9f640afb435%7C1%7C0%7C636535510911511456=0yjSI3HEmIcgJ0O6YlWxXsER5VqgDAKSM36SHFtWpvw%3D=0
If you are using Nabble or Gmane, please see 
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C84e11b321bfc4040f86708d56dacb622%7C84df9e7fe9f640afb435%7C1%7C0%7C636535510911511456=7DOvQGlFHI88FacJjXqZSqSRe0GwZAcmFHHAEwBZxBY%3D=0
 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.

can't change preferences

[Graham Menhennitt]

Hi GnuCashers,

I'm running GnuCash 2.6.19 on FreeBSD 11-stable. Everything seems to 
work correctly except that I can't change any preferences. I try to 
click on the tick boxes/radio buttons etc. in the Edit Preferences 
dialog, but nothing happens. It's as if everything is read-only.


I presume that the reason for this also causes that it doesn't remember 
my most recent open files, and it always shows tips on startup even 
though I unticked the "show tips" box.


Does anybody have any clues, please?

Thanks,

    Graham

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

Getting started

[Graham Jacks]

I have been using Quicken for my finances for some years, but I want to change, 
and I like what I have read about Gnu Cash.  I’ve had enough experience with 
double-entry book-keeping systems to know what it means. 

Would it be feasible to use my closing balances from Quicken, at, say,  Dec 31 
2017 as the opening balances to start my Gnu Cash financials at Jan 1, 2018? 

I plan to keep and be able to access my Quicken files for historical purposes 
(tax returns come to mind), but I was not planning to import them into my new 
Gnu Cash record.  

Is this what new users usually do?
___
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: Future allocated money vs Budgets

[Matt Graham]

So there really is more than one way to skin a cat... or make a budget. 
Whatever.

Since we are talking about something very personal to the needs of individuals, 
perhaps Gnucash needs a ‘add module’ system, where we can write modules that 
perform data access and manipulation? So we could write an “envelope budgeting” 
module that can overlay in the Gnucash environment.

Seems a waste to have to export to another tool to do a small part of budgeting.

Thanks and regards,

Matt

From: Mike or Penny Novack
Sent: Monday, 5 February 2018 3:12 AM
To: gnucash-user@gnucash.org
Subject: Re: Future allocated money vs Budgets

On 2/4/2018 1:21 AM, Christopher Lam wrote:
> Looks nice. My main concern with these "shadow accounts" is that they will,
> by default, be counted in the Net worth reports, income reports, etc, and
> must be manually deselected every time.
>
> In my view budget allocations are technically "outside the books" and must
> therefore ideally be recorded in ways that don't affect the everyday data
> and reports.
>
The problems people have been discussing are really "work flow" and "how
done" issues.

a) As noted in the second paragraph, technically "outside the books". So
ONE solution is to do just that, a separate set of "books" (gnucash can
handle many). That obviously would mean no effect on reports run against
the regular books. And of course that could be using the built in budget
facility.

b) But it seems most would prefer not having to switch books to record
the effect on budget items resulting from the real transactions. I can
think of MANY ways to put the "budget" accounts so that they would have
no net effect on reports, total of the parent standing accounts (asset,
liability, equity). What I can't see is any easy way to "automate"
because IN GENERAL users, especially non-organizational users, will be
ADJUSTING budget allocations on the fly as needed << don't need a vote
of some board to authorize that >>

c) Some people seem to be confused about "liabilities" thinking that
they NECESSARILY represent an actual debt (the most common use) instead
of possibly representing a CONDITIONAL debt. I will note that some of
the things I have mentioned in this context (especially for non-profit
orgs) may be changing << I have heard that new accounting practice will
allow some restricted funds not to be considered liabilities
until/unless something prevents their use for the intended purpose
instead of as now from the get go as a conditional debt* >>

d) IF I wanted to put the "envelopes" in my main books, I could put them
under assets, liabilities, or equity WITHOUT affecting the totals of any
of those. Thus:
Budget (the parent)
  Total allocated funds(debit side?)
Allocations   (credit side?)
Each individual envelope
<< all that matters is that Total Allocated Funds and
Allocations be on opposite sides --- which means the total for the
parent "Budget" will be ZERO >>

Michael D Novack

* In my practical experience, donors of conditional gifts or grants
often will agree to a change of use, extension of time to use, etc. But
I have never had to deal with governmental grants, etc. which I suspect
would be less forgiving. But I also have practical experience where ALL
there is is budget accounting << the organization or committee has no
funds in hand --- the budget represents what will be reimbursed if the
committee votes to authorize an expenditure and some committee member
goes out and spends the money --- and then submits the receipts to the
town treasurer for reimbursement. The committee must track "how much do
we have left to spend" or somebody will be out of pocket >>


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C83bd3ce9f801415c935008d56bea0556%7C84df9e7fe9f640afb435%7C1%7C0%7C636533575212166479=3MNjRS39Z12eOjBWLUx6JajL0rRyHYThwC7E%2F7Sln%2FM%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C83bd3ce9f801415c935008d56bea0556%7C84df9e7fe9f640afb435%7C1%7C0%7C636533575212166479=zTHJC9ALUjbF1jbL56Aixwk2i4PMBiYUYxLlsG6JMvI%3D=0
 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 

RE: Entering Budget Values

[Matt Graham]

Ah, okay. Weird.

I’ve also realised that when you start a new budget you should see all ‘zeros’ 
in each ‘cell’ too. So I was on the wrong lines talking about that (thought the 
cells might be there with no values entered, but by default you would see 0.00 
in each cell until you enter something. Light grey for ones that it has 
calculated from sub-accounts, black for ones that are lowest level or you have 
entered.

Can you see the four “Totals” rows at the bottom – Income, Expenses, Transfers, 
and Total? Do they have Zeros next to each period?

The only other thing I can think of is if you have accidently created a budget 
report, rather than a budget. You created it through “Actions” => “Budget” => 
“New Budget”, right? You could try creating another budget for the same time 
period and seeing if it displays the same behaviour.

Thanks and regards,

Matt

From: BCnon-admin<mailto:bmclar...@comcast.net>
Sent: Monday, 5 February 2018 4:59 AM
To: Matt Graham<mailto:matt_graham2...@hotmail.com>
Subject: Re: Entering Budget Values


Matt,

Hierarchy is good. "no cells" means that I would expect to see cells like on an 
excel spreadsheet but there aren't any - the space under the time period is 
just a blank page.

BC

On 2/3/2018 10:05 PM, Matt Graham wrote:
Hi Bruce!

Have you established your account hierarchy? The budget view should mirror your 
normal account hierarchy and allow you to enter values against each time 
period. So when you say ‘no cells’, do you mean you can see the accounts on the 
left and the periods along the top?

Additionally, do you have any hidden accounts? The default is no, so this 
shouldn’t be the problem, but accounts can be hidden so you don’t see them 
which could theoretically be why you aren’t seeing the cells.

Finally, are you Windows? There is a bug in windows whereby the display can be 
incredibly slow to respond. I have to click on a cell and wait almost a minute 
(no joke) before I can enter the value

Thanks and regards,

Matt

From: Bruce Clark<mailto:bmclar...@comcast.net>
Sent: Sunday, 4 February 2018 2:24 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Entering Budget Values

Today is my first day with GnuCash and everything was going well until I tried 
to enter budgets for my accounts. I have selected 2018 as my time frame (12 
periods). ‘Help’ says all I have to do is select a cell (month) and enter the 
value but I don’t have any cells. Where have I gone wrong?

Bruce Clark
bmclar...@comcast.net<mailto:bmclar...@comcast.net>
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C50fbbbf45fea4f9feb0f08d56b7ece62%7C84df9e7fe9f640afb435%7C1%7C0%7C636533114743493905=xeK5b3xFKrSayAKK9sAFZltmfghqj0kCfrW33XSQa9o%3D=0
If you are using Nabble or Gmane, please see 
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C50fbbbf45fea4f9feb0f08d56b7ece62%7C84df9e7fe9f640afb435%7C1%7C0%7C636533114743493905=NdLDvDU04Yi%2B43%2FYMSs%2BIlhl%2FEhPH41gv4npQPu6nJE%3D=0
 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: Future allocated money vs Budgets

[Matt Graham]

Welcome to the discussion!

So if I understand correctly, you have written scripts to automate the use of 
extra accounts to track allocated money? That was the line I was going down too 
(except building them into GNUCash), but Chris Lam’s discussion on “Budget 
transactions” is starting to look to me like a simpler and more elegant way to 
do what we want, whilst fitting in with other uses of budgets and automating 
what we want... Have a look on the Dev list for more details – can’t remember 
how much he posted on the user list about it.

Thanks and regards,

Matt

From: ebridges
Sent: Sunday, 4 February 2018 11:39 AM
To: gnucash-user@gnucash.org
Subject: Re: Future allocated money vs Budgets

Sorry for the delayed response, just managing to catch up on this thread.

I've been looking at how to do envelope-style budgeting for my personal
finances using GnuCash for about 6-7 months.  Like you, this began with this
article from 2008 "[Better Budgeting with
GnuCash"](https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fallmybrain.com%2F2008%2F12%2F15%2Fbetter-budgeting-with-gnucash%2F=02%7C01%7C%7C9b6d2224a4b3476a8f9b08d56b67cddb%7C84df9e7fe9f640afb435%7C1%7C0%7C636533015939354212=frZ3TUMhMzf%2FA2zBxsSTJZLW5UYLhrctdjhiXmgtvwE%3D=0).

After toying around with that approach, I decided there were two drawbacks
to it:

1. It was tedious.  Manually creating a split for every expense to draw down
budget accounts ("envelopes") that were allocated previously, was super
boring and error prone.  In addition, because of the detailed nature of
doing this work, one would be discouraged from allocating all of your income
to different "envelopes".
2. It was fragile.  By treating "Budgeted Cash" as an asset made allocated
money difficult to reconcile to money that was drawn out of your budget
accounts.  A useful insight in that article is to consider a budget account
as a liability.  However, it categorizes budgeted cash as an Asset, when it
is more useful to consider it also as a liability.  Doing so allows you to
reconcile allocated money to monies spent out of the "envelopes".

For the past month, I've been able to apply an approach to my existing
reconciliation process that I believe will prove to be a very useful and
easy to manage approach to envelope budgeting for personal finance.

To simplify allocating income and expenses to envelopes I use two tools:

* 
[QifQif](https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FKraymer%2Fqifqif=02%7C01%7C%7C9b6d2224a4b3476a8f9b08d56b67cddb%7C84df9e7fe9f640afb435%7C1%7C0%7C636533015939354212=pGZVbq9N4uDjNAI2fJg0WroQ2t4MpcVUpqglYYVmmuw%3D=0)
 which makes it easy to quickly
insert categories into a QIF file;
* 
[qif-split](https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Febridges%2Fqif-split=02%7C01%7C%7C9b6d2224a4b3476a8f9b08d56b67cddb%7C84df9e7fe9f640afb435%7C1%7C0%7C636533015939354212=eSOJkz3h29fzh4kHHVH5xf6sYk4Do7LBns%2B3jBCtfzA%3D=0),
 a tool that I wrote,
which adds splits to QIF files according to some rules defined in a file.

After downloading transactions for my credit card & bank accounts in QIF
format, I first process the file with QifQif to match up every transaction
to one of my accounts from GnuCash.  QifQif supports using wild cards and
regexes for matching payees to accounts, and then adds the account as a
category to the QIF transaction.

After categorization of the transactions, the files can be processed by
`qif-split`, and split according to predefined rules.

I have been using `QifQif` for about a year, and have found it to be very
reliable and easy to work with.  In the past month, I began using
`qif-split` to allocate income and expenses to budget accounts.

The `qif-split` configuration rules splitting the incoming transactions are
twofold

1. Allocating income as credits to various envelopes, or
2. Allocating expenses as debits to those same envelopes.

These allocations are balanced with corresponding debits or credits to a
"Budgeted Cash" account.  Because of these balanced entries, the toplevel
"Budgets" account will always self-reconcile (i.e. its balance will always
be 0).  When the balance of a given budget subaccount ("envelopes") is
negative, then you've overspent that category.

By using `qif-split` to automatically generate split transactions, and by
altering my chart of accounts to roll up budgeted cash alongside the
budgeted expenses it makes envelope-style budgeting very straightforward in
GnuCash.




--
Sent from: 
https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html=02%7C01%7C%7C9b6d2224a4b3476a8f9b08d56b67cddb%7C84df9e7fe9f640afb435%7C1%7C0%7C636533015939354212=ljoRx485NZ8x5yfi573z7%2B1SZDkp0mI%2BM2tgbTHirk4%3D=0
___
gnucash-user mailing list

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

’s up to you.

As an alternative to making the Allocated account in Equity, you could create a 
new top level Asset account called ‘Allocated' (or ‘Budgeted’) and still use 
the special purpose accounts under Equity. This is more of a ‘correct’ 
situation since you’re using equity accounts to lay claim to assets. The only 
difference is you’d have to make sure NOT to include ANY of these accounts when 
you run a balance sheet or both your assets and equity will be overstated.  
(until you spend everything to zero) I wouldn’t put this under ‘Current Assets’ 
like I would the sub-account approach, because then Current will always be 
inflated by the amount allocated/budgeted. The downside is your top level 
Assets & Equity accounts will always be overstated as long as the balances of 
those special accounts are not zero.

The big advantage of this approach, other than being technically correct from 
an accounting standpoint is that each allocation would be a proper debit to an 
asset and credit to equity, (increasing both) and each expenditure would be a 
credit to the asset and debit to equity. (decreasing both) If you combined your 
splits in a single expense transaction, you’d be debiting expenses and equity 
while crediting assets. That route is even less mental gymnastics since it 
doesn’t require the use of any reverse-balanced account.

If on the other hand, you want to segregate funds within their physical 
location, and save the extra work of additional splits, and not have to worry 
about inflated top level accounts, or making sure not to include your special 
accounts in Balance Sheet reports, then I’d just opt to use asset sub-accounts 
as I already outlined.

Best of luck to you.

Regards,
Adrien

> On Jan 30, 2018, at 5:05 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Again, thank you Adrien for being patient with me. I’m probably getting 
> myself confused too, but I’m starting to get more and more clear on it all. I 
> know I’m definitely weird, and whilst I think the purpose I have is common, 
> the way I use it probably isn’t.
>
> We have some different assumptions going on.
>
> Lets start with sub-accounts. Sub-accounts are a great way to do it – if you 
> spend from that sub-account at least most of the time. We have discussed how 
> to handle the splits when you spend from a different account and want to 
> record it against that allocation, so it works, and probably works well 
> (although would be very confusing for beginners to get their head around 
> initially).
>
> But instead of using a sub-account to record the money that has been 
> segmented, what if I use a completely separate account? Why? Because I don’t 
> want to touch the balances of my core asset accounts – the ones that 
> correspond to bank accounts or physical cash. Maybe this is my silly desire 
> of mine. There is nothing wrong (or difficult) with adding virtual 
> sub-accounts, because gnucash is really good at handling sub-accounts (with 
> the reconciliation stuff we talked about). So now I need a new location in 
> the hierarchy to store my allocated money – best done as an asset, and since 
> it isn’t a sub-account, it needs to be balanced with another account (also 
> best done as an asset). We’ll get to your example in a minute.
>
> Assumption 2: That I only (or mainly) segment cash when I receive it. 
> Probably true for most people, and I’m glad you mentioned it because I should 
> use that for most of the examples when I write something up for the tutorials 
> and concepts guide. That isn’t how I work. I plan everything out in advance 
> to make sure I have the cash flow. I allocate to various purposes on the 
> first day of the month, rather than allocating by pay. I do this so that I 
> get a regular and measureable allocation to things I want to spend on 
> (restaurants & Cafes, spending money, etc). I can afford to do this because I 
> am very (very very very) good with sticking to a budget and savings in 
> general. So I just make sure I have more money in my account than I plan to 
> spend that month (transferring the rest away to investments or to reduce my 
> loans), and I have no cashflow problems. So for me, I want to do an 
> allocation on the start of every month, that doesn’t correspond to income. No 
> real problem. Still, lets carry on with your example of allocating out of pay:
>
> If, rather than a sub-account, I use a separate asset account then there is 
> no balancing Cr to an asset to increase the allocation. In your example, you 
> had a balancing Cr on the parent when you allocated the money. So, we receive 
> a $1000 pay check, and want to allocate $500 to the four accounts:
> Cr Income: Salary $1000
> Dr Asset:Current:Checking $1000
> Cr Asset:Current:AllocatedCash $500
> Dr. Assets:Allocated:Vacation$250
> Dr. Ass

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

Hi Dave!

Yep, that is pretty much the conclusion I’ve come to. Not sure what you are 
asking about in “where are you balancing the funds”. The Cr and Dr are balanced 
in the example. Maybe you are asking the location in the hierarchy for the 
accounts? It all goes up to the root account “Assets”. For this idea, I had 
Current Assets, Fixed assets, and Allocated Assets. All the little allocation 
accounts were stored in the Allocated Assets branch.
They were balanced by a single account under current assets called 
“AllocatedCash” (as per the example below). This is the weird one – a negative 
asset account that reflects how much I SHOULDN’T spend out of current assets 
unless I am spending on my allocated causes.

As per Adrian’s discussions, if you are spending out of the account that you 
have put your sub-account into, then there are less splits and it is far easier 
to understand. Using Adrien’s idea, at WORST you have a couple of transactions 
that are just as complex as every transaction the other way – but this is only 
in the rare event that you spend out of a different account from that which 
your sub-account is in.

I still haven’t fully wrapped my head around Adrien’s most recent email, so 
that could create some more “Aha!” moments too.

Thanks and regards,

Matt

From: David T.<mailto:sunfis...@yahoo.com>
Sent: Wednesday, 31 January 2018 2:31 PM
To: matt_graham2...@hotmail.com<mailto:matt_graham2...@hotmail.com>; Adrien 
Monteleone<mailto:adrien.montele...@gmail.com>; 
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

Matt,

I see one huge problem: where are you balancing the funds for the allocated 
accounts? They need balancing, and once you add something to balance them, you 
might as well male them Subaccounts of checking anyway.

Cheers,
David

On Wed, Jan 31, 2018 at 4:06, Matt Graham
<matt_graham2...@hotmail.com>

[Snip]
If, rather than a sub-account, I use a separate asset account then there is no 
balancing Cr to an asset to increase the allocation. In your example, you had a 
balancing Cr on the parent when you allocated the money. So, we receive a $1000 
pay check, and want to allocate $500 to the four accounts:
Cr Income: Salary $1000
Dr Asset:Current:Checking $1000
Cr Asset:Current:AllocatedCash $500
Dr. Assets:Allocated:Vacation$250
Dr. Assets:Allocated:Insurance  $150
Dr. Assets:Allocated:Dining  $ 50
Dr. Assets:Allocated:Coffee  $ 50

___
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: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

type if I was using a sub-account and didn’t spend from that sub 
account:
Dr Expenses:Dining $20
Cr Assets:MyCash $20
Cr Assets:Checking:Dining $20
Dr Assets:Checking $20

So if I (foolishly) chose a sub-account for allocation that I never spent from, 
doing it the separated way is no extra work – still similar four splits. But as 
you say, if you use a sub-account and spend from it most of the time, the messy 
four line transaction becomes a simple
Cr Checking:Dining $20
Dr Expenses:Dining $20

Does this make sense?

Thanks and regards,

Matt

From: Adrien Monteleone<mailto:adrien.montele...@gmail.com>
Sent: Tuesday, 30 January 2018 6:45 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

Matt,

You lost me again.

I don’t understand why you’d have a negative 'segmented spending money' asset.

You receive a paycheck, say $1000.

You earmark 50% of that into various sub-accounts.

You still have $1000.

There’s no negative balance on any asset account.

Perhaps your checking account holds $500 of that money, and each of four 
sub-accounts hold $250, $150, $50 & $50 respectively. That all adds up to $1000.

The act of earmarking funds moves you from one account with a single positive 
$1000 balance to 5 accounts totaling a positive $1000 balance NONE of which are 
negative.

Where’s the ‘negative segmented money account?’

Please describe with debits and credits. I don’t see it. What I see is this:

Receipt of money with segregation:

Dr. Assets:Checking $500
Dr. Assets:Checking:Vacation$250
Dr. Assets:Checking:Insurance   $150
Dr. Assets:Checking:Dining  $ 50
Dr. Assets:Checking:Coffee  $ 50
Cr. Income:Salary   $1000

When you go out for lunch I see this:

Dr. Expenses:Dining $20
Cr. Assets:Checking:Dining  $20

How does recording an expense INCREASE the allocated cash for Dining as you 
describe? (making it less negative) How was it negative in the first place? 
What transaction did you record to make it so? Note, for an asset to be 
‘negative’ it has to have a ‘credit’ balance, that is, credits have to be 
greater than debits. Making an asset account ‘less negative’ is a debit 
transaction. (since asset accounts are usually debit positive balanced) Debits 
don’t decrease an asset, they increase it. Spending money never gives you more 
to spend, it means you have less. Spending money is always (eventually) a 
credit to assets, never a debit.

I can’t see any scenario where that above example of going out for lunch looks 
like this:

Dr. Expenses:Dining $20
Dr. Assets:Checking:Dining  $20
Cr. $40

If that would even begin to make any sense why $40 is moving somewhere instead 
of just $20.

Note, doing this:

Dr. Assets:Checking:Dining  $20
Cr. Expenses:Dining $20

Is an incorrect transaction if you SPENT the money. (as opposed to receiving a 
refund, or correcting a prior error) Crediting an expense is a refund/reversing 
condition, not a normal expenditure.

When you record the receipt of money, that goes to an income/revenue account, 
split with the physical asset account for the form you received the payment in. 
Generally, this will be a credit to ‘income’ and a debit to ‘cash.’ Where and 
how do you record the receipt of money as a credit to an asset instead and how 
does that balance against your credit to your income account?

i.e.—

Dr. $1000
Cr. Income:Salary   $1000
Cr. Assets:??

Regards,
Adrien


> On Jan 29, 2018, at 11:25 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Ah, true. I guess this is why I favored "triggered transactions " rather than 
> "template transactions".
>
> I want a transaction involving expense account "spending money" to 
> automatically add two more splits to reduce the asset account "segmented 
> spending money" balanced by increasing the value of "allocated cash" asset 
> acct (increase = make it less negative).
>
> For saving up for something expensive, I would still set up the above, but I 
> would need to manually change the numbers if I wanted to return the 
> allocation to zero.
>
> So when I enter:
>
> Cr account I used to pay insurance 1150
> Dr expense account for insurance (with the trigger attached) 1150
>
> I would want gnucash to automatically add the splits
>
> Cr account I am using to segment insurance money 1150
> Dr account showing allocated cash 1150.
>
> I would the (during my reconciling/budget review) need to amend that 
> transaction (or create a new one to return the insurance allocation to zero.
>
> For many of my other money allocations (eg restaurants/cafe) I wouldnt change 
> it - underspendi

RE: Merging Files or Other Method getting Transactions into main File.

[Matt Graham]

Hi Mike,

So if I understand correctly from looking through the email chains:

  1.  You had everything entered into the mobile app
  2.  You exported from the mobile app and hit the bug where splits lose their 
values in the export
  3.  You imported all the transactions into GNUCash desktop in a new file (so 
get the splits, but no values) then painfully went through and entered all the 
transaction amounts for the splits
  4.  You tried exporting from Gnucash desktop in a variety of formats and 
importing back into your main file, and it didn’t work. So you are now 
re-entering all of those transactions manually into your main file That is 
incredibly painful.

Is all of this correct?

To try to save you a lot of painful hours of concentration, and assuming my 
above is correct, my questions are:

  1.  Is this the kind of data that you are willing/able to send to one of us 
so that we can see what the outputs are ourselves? (probably the qif export 
from the desktop gnucash). Obviously, don’t post it to gnucash-user because 
then the world will have it online. Usually this is not an option for people, 
but if it is then it could really help the troubleshooting. Export/import qif 
from gnucash has always been really good for me.
  2.  If that is not an option, when you exported from Gnucash desktop in qif 
format. What do you see when you open the file in Wordpad or Notepad (I’m 
assuming you use windows)? It will be a large file, with lots of text, but it 
would give us clues as to what is going wrong.

Thanks and regards,

Matt

From: Mike Stillingfleet
Sent: Tuesday, 30 January 2018 8:33 PM
To: Geert Janssens; 
gnucash-user@gnucash.org
Subject: Re: Merging Files or Other Method getting Transactions into main File.

Thanks Geert,  yes I have previously had a go at that other forum no response.

I have this morning created reports from the corrected XML file.

I am starting to input manually.  It may take a week or so to re-input the data 
but carrying on with the current effort is completely pointless.

I do think that the GNU cash Web site should take down any link to the App and 
further issue a massive health warning about the App.

Having said that.  Since upgrading I gave scheduled a daily QIF download from 
the App.

GNU Cash so far appears to be able to handle these tiny QIF files. But I would 
urge users not to enter a volume of data on the App. It is a disastrous waste 
of time.





On Tue, Jan 30, 2018, at 8:22 AM, Geert Janssens wrote:
> Op dinsdag 30 januari 2018 07:59:01 CET schreef john_mike:
> > Confused!
> >
> > Back ground : Trying to get damaged transactions from phone to main file.
> > Transactions entered whilst phone app had some sort of double minus problem.
> >
> >
> > What I have done:
> >
> > The only way to repair the transactions was to export as an XML file. Open
> > that XML in GNUCash. Go through line by line and enter amounts.
> >
> > Now I want these transactions to be imported into my main file.
> >
> >
> > I have attempted to export these corrected transactions to a QIF File. But
> > this option does not seem to exist. So have followed the export to CSV file.
> >
> > Now when attempting to import these CSV files to my main file. It fails.
> >
> I'm sorry you have such trouble trying to interchange data between these two
> applications.
>
> But you really should ask help on the Gnucash for Android forum, which is not
> here. The issue starts there in this particular case, and there nothing
> gnucash on desktop can do about this I'm afraid.
>
> CSV import in gnucash 2.6 and before has a very limited scope: it was written
> solely for importing bank statements and the options to tweak it show this.
> GnuCash data (like exported from gnucash to CSV) on the other hand has much
> more detail and the importer has no knowledge of how to interpret this. So in
> 2.6, a CSV export/import cycle won't work. The upcoming 3.0 will allow this,
> but for your specific problem it will come a few months too late probably.
>
> Good luck solving your issue!
>
> Geert
>
>


--
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7C51cdae5a0fd948a6251808d567c4913c%7C84df9e7fe9f640afb435%7C1%7C0%7C636529016297750524=W0zv1rhjxbBbxXl%2FHG4UO8wfyNkF9J1BCi9UjdZUqH8%3D=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7C51cdae5a0fd948a6251808d567c4913c%7C84df9e7fe9f640afb435%7C1%7C0%7C636529016297750524=rXuZ%2FU%2FL%2F9mVo%2B3ssU5RdPRmjm5x%2BMjpBijWFeh5gAU%3D=0

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

Ah, true. I guess this is why I favored "triggered transactions " rather than 
"template transactions".

I want a transaction involving expense account "spending money" to 
automatically add two more splits to reduce the asset account "segmented 
spending money" balanced by increasing the value of "allocated cash" asset acct 
(increase = make it less negative).

For saving up for something expensive, I would still set up the above, but I 
would need to manually change the numbers if I wanted to return the allocation 
to zero.

So when I enter:

Cr account I used to pay insurance 1150
Dr expense account for insurance (with the trigger attached) 1150

I would want gnucash to automatically add the splits

Cr account I am using to segment insurance money 1150
Dr account showing allocated cash 1150.

I would the (during my reconciling/budget review) need to amend that 
transaction (or create a new one to return the insurance allocation to zero.

For many of my other money allocations (eg restaurants/cafe) I wouldnt change 
it - underspending means the money is available for later.

Am I understanding you right?


Thanks and regards,
Matt


 Original message 
From: Mike or Penny Novack <stepbystepf...@dialup4less.com>
Date: 30/1/18 09:31 (GMT+10:00)
To: Matt Graham <matt_graham2...@hotmail.com>
Cc: gnucash-user@gnucash.org
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

On 1/28/2018 8:11 PM, Matt Graham wrote:
 When you look at what liabilities really are, Adrien and I concluded 
on this thread that this situation (segmenting money for future) is really 
using a separate asset account. After all - creating a liability INCREASES your 
cash available. ...
Yes, the problem precisely, we aren't assigning the same meaning to "available" 
and "liability"

But your example of what you would like to see:

Template transactions (I'd probably call them "Triggerred transactions", but it 
doesn'tmatter) sound awesome. As someone else highlighted, there are 
implementation difficulties to consider, but I dont think that it would be too 
onerous.

In terms of spending from another account but recording against a sub-account, 
its easy:
Dr Exp whatever account
Cr Cash I pay for something awesome
Dr Parent account the amount I paid
Cr sub-account the amount I paid

SPECIAL CASE of a GENERAL requirement. The special case might be easy to 
implement BUT in general the amounts are NOT going to be the same.

This is actually a fairly common situation for me, say one of the organizations 
SELLS a tee shirt (fundraising, but tee shirts might also be being given away 
to volunteers).
Db   Cash
Cr   Sales
Db   Cost of goods sold
Cr   Tee shirt inventory
<< the shirts might be being sold for $20 but cost the organization $7 >>

Or, and though this is common with our restricted funds (not exactly matching) 
I will give an example precisely for your situation. You socked away into this 
reserve $100/mo toward the annual renewal of your car insurance based on your 
ESTIMATE of what that annual bill will be. But when the bill arrives it is for 
$1150 or $1250. In both cases you pay the bill and release the restriction, 
yes? << in one case, you had more in the fund than needed but it still can be 
released to general purposes, in the other you used all of the fund AND had to 
add some general funds >>

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.

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

Agree with your other email! A program should entertain whatever users are 
requesting for better functionality. Of course, open source volunteer 
developers can't be expected to drop everything to implement "my awesome idea". 
Hence why I'm going to try to contibute (sigh, always need more time).

Template transactions (I'd probably call them "Triggerred transactions", but it 
doesn'tmatter) sound awesome. As someone else highlighted, there are 
implementation difficulties to consider, but I dont think that it would be too 
onerous.

In terms of spending from another account but recording against a sub-account, 
its easy:
Dr Exp whatever account
Cr Cash I pay for something awesome
Dr Parent account the amount I paid
Cr sub-account the amount I paid

This is (like all of our segregating money transactions) a virtual one, but it 
wont affect your reconciling (because as discussed previously we are 
reconciling by the parent and including sub-accounts).
Hmmm now that I re-read your email, I think you might have meant this 
already. Sorry!

Thanks and regards,
Matt


 Original message 
From: Adrien Monteleone <adrien.montele...@gmail.com>
Date: 28/1/18 15:33 (GMT+10:00)
To: GNU Cash User <gnucash-user@gnucash.org>
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

You can already use formulas in scheduled transactions, I just don’t think you 
can use a present GC register value as a variable. (such as x% of the balance 
of Assets:Checking) I could be wrong. It should be possible though to use the 
value of one split as a variable so some auto-allocation might be possible.

There’s also the issue with triggering the transaction based on an event other 
than a date stamp. (such as triggering after you post a credit to income or a 
debit to an checking account)

What we really need there isn’t so much a Scheduled Transaction but a Template 
Transaction. (that can retain formulas)

As for keeping accounts straight, if someone in the real world wants to spend 
money from a savings account by writing a check on their checking account - 
that’s physically impossible. (barring auto adjusting as overdraft protection) 
I don’t see why GnuCash should be any different. Trying to make that possible I 
think would lead to all sorts of confusion as to where money came from or where 
it should be. To help reduce the tendency to do so, I suggested splitting up 
the sub-accounts based on where you are most likely to draw funds from for 
those particular purposes. Otherwise, you’d have to do a transfer from say 
‘Savings’ to ‘Checking’ in GnuCash first just like you would in the real world. 
But if you’re in the habit of spending from any ole’ source for any ole’ 
purpose then by all means, keep the sub-accounts separate, you’ll just have to 
include the transfer split in the expense transaction or else do a separate 
transfer transaction.

Regards,
Adrien

> On Jan 27, 2018, at 9:25 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Nice! It seems like we are getting somewhere. I am convinced that the process 
> we think of budgeting where we are saving up for something is really a case 
> of segmenting money within a sub-account. And it looks like Gnucash is 
> already happy with this kind of situation - with the include sub-accounts in 
> the recociliation window.
>
> I'm going to try this out over the next week or so and then try to 
> contriubute to the Tutorial and concepts guide on it. It can get pretty 
> complicated (for beginners) when you segment the money in your savings 
> acount, and then want to spend out of cash/checking etc. Is a pretty common 
> thing that people want out of Gnucash.
>
> After trying it, I'll also be in a position to suggest any feature changes 
> that would make it easier. Hinted already by others is the feature of 
> "formula" based data entry - doing data entry a bit like a spreadsheet, where 
> simple equations can be used often based on the values present in other 
> accounts/transactions... I'll leave that for now and explore it in my next 
> big discussion with you all!
>
> Thanks again - greatly appreciate your time,
> Matt
>
>
>  Original message 
> From: Adrien Monteleone <adrien.montele...@gmail.com 
> <mailto:adrien.montele...@gmail.com>>
> Date: 27/1/18 18:15 (GMT+10:00)
> To: GNU Cash User <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>>
> Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]
>
> That’s an interesting use of future dated transactions. Thanks!
>
>
> Regards,
> Adrien
>
> > On Jan 26, 2018, at 5:21 PM, Tommy Trussell <tommy.truss...@gmail.com 
> > <mailto:tommy.truss...@gmail.com>> wrote:
> >
> > I was following the budget discussion, and I decided to split 

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

:-) you missed one of the previous posts. Using Liability accounts that way is 
adding anoter "layer" of accounting to your system. When you look at what 
liabilities really are, Adrien and I concluded on this thread that this 
situation (segmenting money for future) is really using a separate asset 
account. After all - creating a liability INCREASES your cash available. 
However, shifting it to another asset account (either sub-account or completely 
different area) reduces cash available AND allows you to record the increasing 
amount you have segmented. If I get a chance, I think I'll type all this up 
with some examples (it is easier to show with exampes).

Thanks and regards,
Matt
 Original message 
From: Mike or Penny Novack <stepbystepf...@dialup4less.com>
Date: 29/1/18 00:51 (GMT+10:00)
To: gnucash-user@gnucash.org
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

On 1/27/2018 10:25 PM, Matt Graham wrote:
> Nice! It seems like we are getting somewhere. I am convinced that the process 
> we think of budgeting where we are saving up for something is really a case 
> of segmenting money within a sub-account. And it looks like Gnucash is 
> already happy with this kind of situation - with the include sub-accounts in 
> the recociliation window.
Not exactly. This is a case where the term "budgeting" is being used in
different ways meaning different things. Budgets my be legal
(organizations, government entities) or advisory (personal, business)
though of course businesses might have requirements to set aside funds
<< might be in the terms of a loan, etc. >>

ONE way of doing this is with liability accounts (typical -- account for
amounts needed for taxes) but that method can also be used for "reserve
funds" <<  I deal mainly with non-profits where "restricted funds" are
common >>

Note that partitioning of a checking account in this way earlier
described is still just "advisory" as it would NOT prevent you from
writing a check for more than the balance remaining in the unrestricted
portion of the account. Just you can't do that without seeing that you
are doing it.

Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=2IRNnuUZ4u9Vu%2FEryYTBw6QSBfRJOx8OV0%2FBBYbZn%2BM%3D=0
If you are using Nabble or Gmane, please see 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Cd653d44ededf436304a408d566563154%7C84df9e7fe9f640afb435%7C1%7C0%7C636527442736383577=sveoJ58ma1r3tnK4q1zqT5IuppYFxRlvmnJQrOj7g8E%3D=0
 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: Does anyone successfully use GNU Android App. If not get it off the main web site.

[Matt Graham]

I find the android app useful, exporting transactions by qif file and then 
bringing them into my desktop app. It is very limited, as you say. Really needs 
to implement proper access to the ".gnucash" files so that we can keep the two 
in sync easily.

Pretty sure that app is also open source on github, so the best way to get it 
improved is to help out, or donate/set bounties.

Having said all that, it would be ideal to have an "official" mobile version of 
GNUcash with as close as possible to full functionality. Hopefully using a 
large part of the desktop code (translated to Java for android though)
Coding party, anyone?

Thanks and regards,
Matt


 Original message 
From: jeffrey black 
Date: 29/1/18 07:12 (GMT+10:00)
To: john_mike , gnucash-user@gnucash.org
Subject: Re: Does anyone successfully use GNU Android App. If not get it off 
the main web site.

On 1/28/2018 8:31 AM, john_mike wrote:
> Dear All,
>
> I gave up trying to import the QIF file generated by the Android App.
>
> I exported from Android as XML then opened that file in GNU Cash. This had
> the dates of the transactions the narrative (well some of it) and the
> relevant accounts and about 30% of the values.
>
> I have nearly gone blind going through each transaction on my phone and
> entering the amount in the GNU Cash file.
>
> Now I need to work out how to import these completed transactions into my
> main file.
>
> I think I am done with the Android App. Every time I try to use it in messes
> up. It is therefore a huge waste of time.
>
> One of the reasons I started with GNU was the option of having the Android
> companion.
>
> Clearly it doesn't work. Clearly it was never intended to be a 'clone' of
> the main GNU Cash Application.
>
> Might I suggest that it is removed from the GNU Cash web site. It is
> detrimental to GNU Cash which by and large works. The Android App is just a
> huge waste of time.
>
> I wondered if there is any intention to create an App that works.
>
> All I wish to do is record stuff on the phone and load it to the PC. Is this
> possible / achievable.
>
> What I don't want is to spend time recording stuff on my phone and then
> spend 3-4 days transferring it across as that is completely pointless and
> very frustrating. It would be much better to remove the current offering
> from the system as it is setting a false user expectation. Which it turn
> leads to mistrust of GNU Cash.
>
>
>
>
> --
> Sent from: 
> https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=KJJZ1IZM9TtHb4ZGAQvB7q7BoxVmbU9XwNp00kb%2BI%2FM%3D=0
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=qK9uN7vSV%2FTBz2fotCUC9kAI4X6KhjQFUIeIs2OUJoo%3D=0
> If you are using Nabble or Gmane, please see 
> https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=lWeKmb9NHUQcB33%2B7vafWZEw9UeqtT6cvb7LwZ4EovE%3D=0
>  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.
> .
>
I use the Android app on my LG phone.  For me it works wonderfully.  It
does lack a few features of  GnuCash on the desktop.  Most notably Check
number.  And it requires a little getting used to for doing split
transactions.

I do need to trim my account list on the phone, I have all of my
accounts in the app.  I don't really need accounts like depreciation
while pumping gas.  The really nice thing is I can log my transactions
as I do them rather than reading a bunch of crumpled up receipts at the
end of the week.

All I do is export the app data to a qif file and use the usb port to
transfer it to my desktop.  Never had a problem with it. I have never
tried exporting as xml.

Keep in mind the android app is an entirely separate product, developed
by a different group.


--JEffrey Black M.B.A.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7C%7Cbd466c05436a48f13b8008d5668b7b25%7C84df9e7fe9f640afb435%7C1%7C0%7C636527671605334518=qK9uN7vSV%2FTBz2fotCUC9kAI4X6KhjQFUIeIs2OUJoo%3D=0
If you are using 

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

[Matt Graham]

Nice! It seems like we are getting somewhere. I am convinced that the process 
we think of budgeting where we are saving up for something is really a case of 
segmenting money within a sub-account. And it looks like Gnucash is already 
happy with this kind of situation - with the include sub-accounts in the 
recociliation window.

I'm going to try this out over the next week or so and then try to contriubute 
to the Tutorial and concepts guide on it. It can get pretty complicated (for 
beginners) when you segment the money in your savings acount, and then want to 
spend out of cash/checking etc. Is a pretty common thing that people want out 
of Gnucash.

After trying it, I'll also be in a position to suggest any feature changes that 
would make it easier. Hinted already by others is the feature of "formula" 
based data entry - doing data entry a bit like a spreadsheet, where simple 
equations can be used often based on the values present in other 
accounts/transactions... I'll leave that for now and explore it in my next big 
discussion with you all!

Thanks again - greatly appreciate your time,
Matt


 Original message 
From: Adrien Monteleone 
Date: 27/1/18 18:15 (GMT+10:00)
To: GNU Cash User 
Subject: Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

That’s an interesting use of future dated transactions. Thanks!


Regards,
Adrien

> On Jan 26, 2018, at 5:21 PM, Tommy Trussell  wrote:
>
> I was following the budget discussion, and I decided to split my comment
> into a different thread. I'm not responding to any particular comment, and
> this isn't quite germane to budgeting.
>
> But I want to clear up a few misunderstandings I'm seeing folks express
> about reconciling with sub-accounts. Subaccounts work very well, but they
> do take a little maintenance.
>
> WHEN TO USE SUBACCOUNTS
>
> You can use subaccounts for several purposes, including budgeting, holding
> onto money that isn't "yours" (a bond you're holding from a contractor for
> successful completion of a project, for instance), identifying earmarked
> funds, OR (as in the example below) simply stopping yourself from spending
> down the account more than you'd like.
>
> (If folks have additional suggested uses for subaccounts, bring em on!)
>
> EXAMPLE: MINIMUM BALANCE VIEW
>
> Here's a real-world (well it's real in MY world) example -- avoiding
> "minimum balance" fees. The bank name has been changed to protect the
> bookkeeper. ;-)
>
> I have a checking account at BigBank.
>
> Assets:Current Assets:BigBank Checking
>
> The terms on that bank account say it doesn't cost me anything UNLESS the
> balance drops below $2500, at which point I have to pay $8.50/month. (There
> are some other miscellaneous fees, all higher when the balance goes low.)
>
> SO to help avoid the $8.50/month expense, I created a sub account:
>
> Assets:Current Assets:BigBank Checking:Minimum Balance
>
> Then I created a transaction dated 2/15/2015, transferring $2500 from the
> account to its subaccount:
>
> (This is a representation of the BigBank Checking two-line auto-split
> register. Items in the right column are "cr" and items in the left column
> are "dr".)
>
>  2/15/2015 min Minimum Balance   2500.00cr
>Assets:Current Assets:BigBank Checking:Minimum Balance   $2500.00dr
>Assets:Current Assets:BigBank Checking   $2500.00cr
>
> When I reconciled my account the first time after creating this
> transaction, I made sure to tick the "Include Subaccounts" checkbox on the
> Reconcile Information dialog. I (as always) verified the ENDING balance
> information exactly as it was shown on the bank's statement.
>
> Also that first time I reconciled, I noticed TWO items to clear that
> weren't actually on the bank statement -- $2500 in the funds in side and
> $2500 in the funds out side of the reconcile window. I marked them BOTH as
> "cleared."
>
> From now on, I notice a few things have changed from before --
>
> o - My default balance when I reconcile AND the running balance in the
> BigBank Checking register will always show $2500 lower than I actually
> have.
>
> o - When I reconcile I always have to remember to override the default and
> enter the ENDING balance as it is shown on BigBank's statement.
>
> o - When I reconcile the "Include Subaccounts" checkbox is ticked and it
> needs to stay ticked. (It seems to "remember" the setting from session to
> session, as you would hope.)
>
> o - I also notice when I'm reconciling that when I "jump" to a transaction
> by double-clicking on an item in the funds in / funds out lists, the
> transaction opens into a different kind of "general ledger" style register
> that includes ALL transactions in the account and subaccounts. It exactly
> resembles the kind of register that appears when you search for
> transactions. It has a "plus" (+) mark in its tab and looks different from
> the "ordinary" register.
>
>
> 

RE: Future allocated money vs Budgets

[Matt Graham]

nt to 
stick with GnuCash, you’d have to set up a spreadsheet to handle the envelope 
part, at least the calculations as to how much to segregate at each opportunity 
and keep track of any goals.

But I’d proffer that something along the lines of MoneyWell is more suited to 
the task, especially for those who live from a checking account. As far as I 
know it’s Mac only however. (there are mobile versions, but I don’t think they 
are stand-alone) For those who handle a fair amount of cash, or want to track 
investments and asset values, or need to track A/P and A/R, GnuCash is better 
suited. MoneyWell was designed specifically to implement the envelope method 
(using ‘buckets’) to automatically ‘flow’ money you receive to targeted 
purposes such as your utilities, rent, car, savings, etc. I’ve played with it 
quite a bit, and I’d like GnuCash to have something similar, but I find it too 
limited for all my other accounting purposes. If there were a way to get 
transactions in and out easily, I might use it for daily purposes and budgeting 
and keep GnuCash for the overall big picture stuff.

Regards,
Adrien

> On Jan 25, 2018, at 9:29 PM, Matt Graham <matt_graham2...@hotmail.com> wrote:
>
> Hi All!
> I’m going to discuss (and get people’s opinions) on a way in which many users 
> (myself included) struggle to get “what they want” from GNUCash budgeting. 
> GNUcash is very strict on proper double-entry bookkeeping practices (which I 
> love). In accounting, “budgeting” means that you are plotting out exactly 
> when you are going to change account values in what way. It is forecasting 
> the future states of the accounts.
>
> So if you have a monthly bill of $50 you need to pay – easy. You enter it 
> into the monthly periods - both expense account and asset account. You know 
> you will spend that amount, and you (usually) know what asset account you are 
> spending it out of. This is budgeting, and allows you to see that you are not 
> losing money overall and sending yourself broke by end of year.
>
> The next thing that people call “budgeting” is when they want to save up for 
> something, but don’t have a distinct plan of when it will be spent or how it 
> will be paid for. My example is “Spending Money” (but perhaps “holiday 
> savings” is a better example). I allocate $100 every month to myself and my 
> wife to spend as we want (hobbies, clothes, etc). If we don’t spend it, it 
> builds up allowing us to buy bigger stuff later. So I should put $100 in each 
> budget period against those two expense accounts, right? NO, NO, NO From 
> an accounting perspective, nothing is necessarily going to be spent out of my 
> “Spending money” expense account. It is an allocation of money, not a 
> spending of money. I can’t predict in advance any real changes to my asset or 
> expense accounts from this monthly “allocation of money”. What I am doing 
> from an accounting perspective is setting up a liability on myself – a 
> promise to give money later to someone (in this case a promise to give money 
> to myself). The reduction in my assets (cash) is as completely fake as the 
> increase in liability – none of my cash or credit accounts have changed in 
> value.
>
> For now I’m going to call this application “Future allocated money”, and 
> controversially say that it is NOT “budgeting”.
>
> So if you have some ‘budget’ purpose such as this, and lament that GNUCash 
> can’t give you the running total, the way to deal with it is the way this 
> person describes:
> https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fallmybrain.com%2F2008%2F12%2F15%2Fbetter-budgeting-with-gnucash%2F=02%7C01%7C%7C2d1add0a2c6a4643591d08d5647e306d%7C84df9e7fe9f640afb435%7C1%7C0%7C636525415498305568=s61s%2FSFcqv5L1C0v2xEma0%2BbaPC4eQl2EyPXGHLgTcc%3D=0
>
> The fake asset account is used to show the money that has been allocated for 
> certain purposes in the future (ie is unavailable). It needs to be a fake 
> account, because usually we don’t know in advanced which asset account we are 
> going to spend the allocated money out of. If you know which asset account 
> you are going to be spending the money out of, then sure you can just create 
> a sub-account to record the amount allocated to this. In this case, you don’t 
> really need to record the liability at all (the liability is effectively 
> shown in your sub-account), and the transactions become easier – just 
> transferring between that sub-account and the actual expense account when you 
> spend. But for most people, you need a fake asset account because you don’t 
> know in advance which account you will spend out of.
>
> The fake liability account is your running amount you can spend at any time.
>
> The problem in doing this?
> It creates extra transactions that look rea

Accounts using mySQL stuck in Read-only mode

[Graham Reeves]

I have been using Gnucash with mySQL for about as long as such things 
were possible on both Windows and Ubuntu clients to a mySQL server 
running on a Ubuntu server.
Occasionally the connection between the client and mySQL server would be 
lost. This was a nuisance but not a great problem. All that was needed 
was to close down the client. The connection would be re-established 
when Gnucash was relaunched.


Recently however the connection appeared to be re-established but no 
changes could be saved. An error message 'Unable to save to database' 
was given. That was on a Windows laptop. We then tried to access the 
same set of accounts on a Xubuntu machine. This worked for a couple of 
weeks but then suffered the same problem.


Throughout this time I could still access the accounts from other 
Windows and Xubuntu machines but I feared the malaise would spread.


I managed to recover the use of the Windows laptop by uninstalling 
Gnucash, deleting the .gnucash folder, and reinstalling.


I tried to completely remove Gnucash from the Xubuntu client machine 
using the --purge flag, deleting the .gnucash folder and cleaning gconf 
using ' gconftool-2 --recursive-unset /apps/gnucash ' but I must have 
missed something. When I reinstalled and ran Gnucash it went straight 
into loading the last used accounts and would still not save changes.


The question is, what have I missed?

In still have access to these accounts from another Windows machine and 
another Xubuntu machine so that suggests the database is OK. I run two 
other sets of accounts, one with mySQL and the other with SQLite. Both 
mySQL accounts are affected, the SQLite accounts are not.


Any help would be appreciated.

Graham Reeves

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.