Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Adrien Monteleone
It’s been many years, but if I’m not mistaken, that is what GnuCash does when you enter an opening balance when creating an asset or liability account for the first time. (rather than entering it later) If you are planning to have other Equity entries, it is probably a good idea to split the op

Re: [GNC] Still can't update price quotes

2019-03-07 Thread Elias K Gardner
Thanks John I just double checked all of my securities. They all either have online quotes disabled or are set to alphavantage, no Yahoo left. Is there a log or something to get more details about the error? On Thu, Mar 7, 2019 at 10:59 AM John Ralls wrote: > Make sure that you have no securitie

Re: [GNC] gnucash 3.4 help needed

2019-03-07 Thread David Cousens
Try it without the -DCMAKE_PREFIX_PATH=$HOME/.local switch. This is only required if you have built the dependencies from source yourself and installed them in this location rather than in the usual system directories. $cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local ../gnucash-3.4 should do the trick

Re: [GNC] Uninstall GC

2019-03-07 Thread David Cousens
Dennis Take a look at https://wiki.gnucash.org/wiki/Uninstall_Gnucash_Ubuntu if you are on Linux. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnu

Re: [GNC] Checking for dependencies

2019-03-07 Thread David Cousens
Dennis As far as i know no dependencies have changed between 3.1 and 3.4. The dependencies listed on the wiki should work as I complied them from a build of 3.2 and I didn't have to chnge anything to build 3.4 that I remember. If there are any major incompatibilities when you run cmake it will st

Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Bucky Carr
I did it directly in the child account with the corresponding, double-entry accounting entry into Equity child account. For example I have my Asset:Banking:Checking1 hierarchy and my Equity:Opening_Balances hierarchy. In the Checking1 child account I entered the opening balance with a corre

Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Stephen M. Butler
On 3/7/19 9:56 AM, Teresa wrote: > I have 25 years experience in Accounting, however never set up a chart > of accounts. > > I just started working for my daughter, who has done everything in excel. > > I have put all the gl accounts in GnuCash, but they all went in as > parent accounts, I new term

Re: [GNC] Order of transactions

2019-03-07 Thread Stephen M. Butler
On 3/7/19 8:57 AM, Derek Atkins wrote: > Adrien Monteleone writes: > >> Lisa, >> >> I will add to David’s advice that you can use the NUM field other than >> a simple 1,2,3,4... >> >> You might, for example, need or want to keep an actual transaction >> number with the transaction. >> >> For that

Re: [GNC] Uninstall GC

2019-03-07 Thread Stephen M. Butler
On 3/7/19 8:55 AM, Dennis Powless wrote: > -do I NEED to uninstall Gnucash? > If so I've been told that you need to do so.  > > I installed 3.1 from source, I now am trying to upgrade to 3.4. On 18.04 > LTS. Where did you do the build?  Do the "make uninstall" from that directory/folder.

Re: [GNC] Order of transactions

2019-03-07 Thread Adrien Monteleone
Yes, that is why I was explaining the abuse of the NUM field as a time field for sorting and how to do it in a way that works. If you are doing this, (or instead using 1,2,3,4 ) *and* you want to keep track of a transaction number, then you’ll have to put it somewhere else so you can still sort

Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Michael or Penny Novack
On 3/7/2019 12:56 PM, Teresa wrote: I have 25 years experience in Accounting, however never set up a chart of accounts. I just started working for my daughter, who has done everything in excel. I have put all the gl accounts in GnuCash, but they all went in as parent accounts, I new term to me.

Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Derek Atkins
Hi, On Thu, March 7, 2019 12:56 pm, Teresa wrote: > I have 25 years experience in Accounting, however never set up a chart > of accounts. > > I just started working for my daughter, who has done everything in excel. > > I have put all the gl accounts in GnuCash, but they all went in as > parent ac

Re: [GNC] Setting up chart of accounts

2019-03-07 Thread Bucky Carr
The way I did it was to set up a CoA with 5 parent accounts: Asset, Equity, Liability, Income and Expenses. I set those as top level accounts so no transactions can be entered directly into them. Then I set up all my child accounts under the proper parent accounts. Then I set up the opening

[GNC] Setting up chart of accounts

2019-03-07 Thread Teresa
I have 25 years experience in Accounting, however never set up a chart of accounts. I just started working for my daughter, who has done everything in excel. I have put all the gl accounts in GnuCash, but they all went in as parent accounts, I new term to me. My question is, shouldn't these

Re: [GNC] Default invoice/statement

2019-03-07 Thread Derek Atkins
Hi, Roger Oliver writes: > Is there a way to move the Fancy invoice/statement layout up to replace the > default? Edit -> Preferences -> Business Report for Printing: ... > The default layout does not allow putting a logo on the masthead. I'm using > the last update of version 2 of GnuCash

Re: [GNC] Checking for dependencies

2019-03-07 Thread Colin Law
As far as I know gnucash 3.4 iis not available from the Ubuntu repository for 18.04 (it is for 18.10). However packages have been built for 18.04 by Stephen Butler, an extract from is post is: Here are the three debian files for 3.4 (as released): https://drive.google.com/open?id=1fV_fURy6c77e7gf

Re: [GNC] Uninstall GC

2019-03-07 Thread ref...@gmx.net
If you installed from source, you need to uninstall, yes. Otherwise you have a potential mess. Where did you install into? I keep all programmes I compile myself under /usr/local/ which keeps it clean and easy to separate out if necessary. Peter Sent from my mobile. Please forg

Re: [GNC] Order of transactions

2019-03-07 Thread Derek Atkins
Adrien Monteleone writes: > Lisa, > > I will add to David’s advice that you can use the NUM field other than > a simple 1,2,3,4... > > You might, for example, need or want to keep an actual transaction > number with the transaction. > > For that case, you can put the real transaction number in th

[GNC] Uninstall GC

2019-03-07 Thread Dennis Powless
-do I NEED to uninstall Gnucash? If so I installed 3.1 from source, I now am trying to upgrade to 3.4. On 18.04 LTS. I have on my home directory dennis@dennis-XPS-8500:~/Applications$ ls build-gnucash-3.1 gnucash-3.1 Output from whereis gnucash /home/dennis/.local/bin/gnucash I use

Re: [GNC] Optimising migration via qif

2019-03-07 Thread Derek Atkins
Hi, Jonathan Williams writes: > I am trying to migrate from MS Money to GNC using qif files for each account, > and am meeting problems with the importer. It asks me to check many > hundreds of transactions, and if I skip this it results in hundreds of > missing transactions (not duplicates, wh

Re: [GNC] MySQL

2019-03-07 Thread John Ralls
> On Mar 7, 2019, at 7:39 AM, Jean-David Beyer via gnucash-user > wrote: > > On 3/7/19 7:22 AM, David G Hamblen wrote: >> In the past, I've had problems with a mysql file, just getting >> seqfaults. Turned out that I was entering a transaction with a 1962 >> date. I forget the details, but

Re: [GNC] Still can't update price quotes

2019-03-07 Thread John Ralls
Make sure that you have no securities using any yahoo source except yahoo_json (which BTW still works well and unlike alphavantage doesn't throttle). Any attempt to use the other yahoo sources will cause the entire retrieval to fail. Regards, John Ralls > On Mar 7, 2019, at 7:34 AM, Elias K Ga

[GNC] Checking for dependencies

2019-03-07 Thread Dennis Powless
I have GC 3.1 installed on 18.04 LTS, want to upgrade to 3.4. I was trying to see if any dependencies have changed so I went to the page here and typed this in terminal. You can check whether the required libraries and/or headers are already installed by listing the installed packages.

Re: [GNC] MySQL

2019-03-07 Thread Jean-David Beyer via gnucash-user
On 3/7/19 7:22 AM, David G Hamblen wrote: > In the past, I've had problems with a mysql file, just getting > seqfaults.  Turned out that I was entering a transaction with a 1962 > date.  I forget the details, but mysql stored it as a zero, which I > couldn't reopen.  I changed the date (to post-197

Re: [GNC] Still can't update price quotes

2019-03-07 Thread Elias K Gardner
My apologies I left out the error, its: "There was an unknown error while retrieving the price quotes" On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner wrote: > I'm still getting the"" error when trying to update my price database. I > got an alpha advantage key, put it in gnucash, and updated m

[GNC] Still can't update price quotes

2019-03-07 Thread Elias K Gardner
I'm still getting the"" error when trying to update my price database. I got an alpha advantage key, put it in gnucash, and updated my Finance::Quote perl module to 1.47. At one point that seemed to sort of work but now I just get the "" error. Most of my quotes are approaching a year old. The abso

Re: [GNC] MySQL

2019-03-07 Thread David G Hamblen
In the past, I've had problems with a mysql file, just getting seqfaults.  Turned out that I was entering a transaction with a 1962 date.  I forget the details, but mysql stored it as a zero, which I couldn't reopen.  I changed the date (to post-1970?)  with the mysql command line tool.  Perhap

Re: [GNC] gnucash 3.4 help needed

2019-03-07 Thread cicko
Hi, Devlin, Considering you posted in GnuCash Users group, I gotta ask a question - do you really want to build GnuCash or you just want to run it? Cause there is now a binary (Flatpak) version available (even though still in testing stages) but that might be an easier option in case GnuCash is no

Re: [GNC] Splitting a multi-year file

2019-03-07 Thread David Cousens
Andrea To export the account tree use File->Export->Export Accounts to export the account structure into a new book file directly. It works fine with GnuCash V3.4. What version of GnuCash are you using and on what operating system? Using the export of the account Tree to CSV will also work but th