Question on mysql "account" table

2017-10-11 Thread Joseph Hesse
Here is an example of what I am trying to do.  My expenses in gnucash have items that look like: Expenses   Auto     Gas     Service When I look in the mysql accounts table I can find the record containing Service but no easy way to find Expenses:Auto:Service. The record containing Service in

Re: Question on mysql "account" table

2017-10-11 Thread Colin Law
If you use joins on the guid values to the parents then you should be able to get them directly using the appropriate queries. Colin On 11 October 2017 at 14:31, Joseph Hesse wrote: > Here is an example of what I am trying to do. My expenses in gnucash have > items that look like: > > Expenses

Re: Question on mysql "account" table

2017-10-11 Thread John Ralls
> On Oct 11, 2017, at 6:31 AM, Joseph Hesse wrote: > > Here is an example of what I am trying to do. My expenses in gnucash have > items that look like: > > Expenses > Auto > Gas > Service > > When I look in the mysql accounts table I can find the record containing > Service but

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-11 Thread Maf. King
On Wednesday, 11 October 2017 14:35:51 BST Frankie Raney wrote: > The cloud could be your own (hard drive or home cloud). I think you can > install to a shareable drive(cloud) then create a short cut on each machine > to it. I think I have seen a way to share one of your desktops. I don't > know f

Scheduled Transactions, Variables and Formulas

2017-10-11 Thread Cheryl Wheeler
I am playing with variables and formulas in scheduled transactions. I created a test SX using the example shown here (https://wiki.gnucash.org/wiki/Scheduled_Transactions#Bank_Account_Interest). When I tried to save the SX, GnuCash gave me an error message saying that it couldn't parse the form

Re: Report - Items sold, quantity and value

2017-10-11 Thread Eduardo Estefano Neto
Thank you Christopher. What I'm looking for is the aggregrated items report. Hope this is in the roadmap. Eduardo On Wed, Oct 11, 2017 at 3:21 AM Christopher Lam wrote: > You can print a report of itemized sales in one invoice by running the > Reports/Business/Tax Invoice report. > > I don't t

Github projects related to gnucash

2017-10-11 Thread Sébastien de Menten
Hello, Just to let you know, I have updated the list of github projects with gnucash in their description: http://piecash.readthedocs.io/en/latest/doc/github_links.html Python is the front runner language in terms of # projects followed at some distance by perl and Java. Kind regards, Sébastien

Re: importing

2017-10-11 Thread frank raney
OK So I redid the import and saved my self periodicallyeverything was going well.Untill I deleted an accoiut that was called TradingI did not have that accoiunt in quicken by that name.  It is my IRA...when I deleted that file, the program crashed again.  I had just saved

Re: importing

2017-10-11 Thread frank raney
I just answered my own question..The lck file is a temporary file when the main file is opened.  I opened my file read only, resaved it. closed it and the lck file went away.  I opened the file in a smaller window so I coiuld see my directory and the lck file appeared again..it went

Re: importing

2017-10-11 Thread Aaron Laws
On Wed, Oct 11, 2017 at 3:31 PM, frank raney wrote: > I just answered my own question..The lck file is a temporary file > when the main file is opened. I opened my file read only, resaved it. > closed it and the lck file went away. I opened the file in a smaller > window so I coiuld see

How to rename a budget?

2017-10-11 Thread gbguy
Is there any way to rename a budget so that when you "Actions->Budget->Open Budget" you see a new name for the budget? I've tried "Actions->Rename Page" but that does not change the name of the budget. Google nor my searching of this forum yielded any help. TIA -- Sent from: http://gnucash.14

Re: importing

2017-10-11 Thread David Carlson
Frank, There is still a problem with Gnucash on your computer because it should not be crashing. It may be somehow related to the account named Trading that GnuCash created. Normally, GnuCash will only create that account for users that know that they want to use a special feature that is there

Re: importing

2017-10-11 Thread David Carlson
I forgot to mention that there is a setting somewhere called "Use Trading Accounts" that turns that feature on or off. I think it is mentioned somewhere in the documentation. David C On Wed, Oct 11, 2017 at 4:07 PM, David Carlson wrote: > Frank, > > There is still a problem with Gnucash on you

Re: importing

2017-10-11 Thread frank raney
I can't find the documentation to tell me where to put the help files.  I put them in the same dir as the program but when I click on help, I am told it can not be found. Frankie Raney 12454 Auberry Rd. Clovis, Ca. 559.297.8577 H 559.304.1751 C On 10/11/2017 2:14:08 PM, David Carlson wrote: I

Re: importing

2017-10-11 Thread David Carlson
What O S are you installing into and what version are you installing? The help files come along automatically in Windows and most Linux packages. David C On Oct 11, 2017 11:18 PM, "frank raney" wrote: > I can't find the documentation to tell me where to put the help files. I > put them in the