Re: [GNC] help lost data file

2019-04-02 Thread John Ralls
Yes, I deliberately wrote them generically. Since you've now specified the OS I can further explain that you'll find the book folder in ~/Library/Application Support/gnucash and that TextEdit is perfectly fine for examining the contents of the directories. In order to get Finder to look in ~/Lib

[GNC] Error While Saving in GnuCash 3.5 on Win7-64

2019-04-02 Thread Greg Feneis
Hi, I just upgraded to 3.5 from 2.6.21. I've been using 2.6.x for a few years, and never had trouble saving to this directory, but after upgrading to 3.5, I tried to save and it gives me an error message. "You attempted to save in "can't be displayed" or a subdirectory thereof. This is not allow

Re: [GNC] help lost data file

2019-04-02 Thread Eric Rathhaus office
Thanks, John. I’m using a Mac. Will your directions still apply? Kind regards, Eric W. Rathhaus Law Office of Eric W. Rathhaus 484 Lake Park Avenue, Suite 50 Oakland, CA 94610 415.577.0920 tel 415.737.0603 fax www.ewrlaw.com Confidentiality : The information contained in this message is leg

Re: [GNC] [GNC-dev] Account Balance does not match transaction history

2019-04-02 Thread John Ralls
Please copy the list on all replies. Since you didn't I've re-directed this to gnucash-user where it belongs. If Income:Sales has sub accounts with transactions then the total shown on the Accounts Page will sum the balances of Income:Sales and all of its sub accounts. In most cases when you

Re: [GNC] help lost data file

2019-04-02 Thread John Ralls
The books directory in GNC_DATA_DIR (see http://wiki.gnucash.org/wiki/Configuration_Locations to see where that is on your OS) will have a file named after each one that you've had open with a .gcm extension instead of .gnucash. If you left registers open when you closed the .gnucash file the .

Re: [GNC] Keeping two sets of books

2019-04-02 Thread Stuart McGraw
It opens without the popup. Which I suppose implies that the keyring checking is occurring in gnucash code conditionally for database access, or in whatever api gnucash uses for database access (libdbi?), or possibly in database-specific api libdbi uses (eg libpq(?) for Postgresql). I don't t

Re: [GNC] help lost data file

2019-04-02 Thread Eric Rathhaus office
Thanks, John. My only problem is that I tried opening various files to see if I could find the correct one so that the the “good” file won’t be on the list of four. Any other ways to find it? Kind regards, Eric W. Rathhaus Law Office of Eric W. Rathhaus 484 Lake Park Avenue, Suite 50 Oakland,

Re: [GNC] Keeping two sets of books

2019-04-02 Thread Colin Law
If, as an experiment, you start a new accounts file and save it as xml, then shutdown and restart gnucash, which should then open the xml file, do you get the popup? Colin On Tue, 2 Apr 2019 at 18:21, Stuart McGraw wrote: > > No auto-login here and I think the app that needs an option to ignore

Re: [GNC] How To Process a Payment Without Invoicing?

2019-04-02 Thread Adrien Monteleone
Greg, Needing to generate the invoice to get the customer to pay you and generating the invoice to create the income-A/R transaction are two different things. You still need to record the revenue/income earned. You can continue to generate the invoice to do so even if you don’t send it to the c

Re: [GNC] Process Payment for Customer with Credit Balance

2019-04-02 Thread Adrien Monteleone
Simply zero out the calculated refund amount. GnuCash will retain the remainder as a pre-payment. Alternatively, if even for one invoice, you can change the preference to “pay on posting” and GnuCash will auto-enter the payment using the pre-payment balance that it needs, then you can change th

Re: [GNC] Cancel Sub. Thanks mguszak

2019-04-02 Thread David Carlson
Michael, If you want to cancel your subscription you need to read and follow the instructions in the link at the bottom of your post. David Carlson On Tue, Apr 2, 2019 at 2:52 PM MICHAEL GUSZAK wrote: > > ___ > gnucash-user mailing list > gnucash-use

Re: [GNC] Cancel Sub. Thanks mguszak

2019-04-02 Thread Michael Hendry
> On 2 Apr 2019, at 20:49, MICHAEL GUSZAK wrote: > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using

[GNC] Cancel Sub. Thanks mguszak

2019-04-02 Thread MICHAEL GUSZAK
___ 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

[GNC] How To Process a Payment Without Invoicing?

2019-04-02 Thread Greg Feneis
(Win 7-64, GnuCash 3.5) Hi Folks, Usually, when I work for a client, I use GnuCash to generate an invoice that details what I've done and what I expect to get paid and send that invoice to the client. Then, the clent pays me the amount on the invoice, and when I receive the payment, in GnuCash I

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Adrien Monteleone-2 wrote >> On Apr 2, 2019, at 11:59 AM, no_more_quicken < > nospam@ > > wrote: >> >> >> 5. I still haven't quite figured out the reporting framework; my goal is >> to >> generate an "expenses over the last X months grouped by month" report >> (i.e., >> just like the "Expense O

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Cricket Onebit wrote > Can you explain more about not being able to undo things with the SQL > backend vs XML (or point to more details)? I'm undecided about which > backend. Fully-functional and easy to install and maintain is more > important to me than a few seconds while using, unless those sec

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Cricket Onebit
Thanks for this. I have a similar project in the near future, and was wondering the best order for some things. It looks like the major re-categorization should be done before leaving Quicken. Good to know there's a workaround for the HiDPI bug. Is there a bug report / feature request for bulk a

[GNC] Process Payment for Customer with Credit Balance

2019-04-02 Thread David Burleigh
How do you process a payment when the customer has a credit balance sufficient to cover the invoice? In the "process payment" dialog box (as suggested on the #gnucash irc), I selected both the current invoice and the earlier pre-payment, and clicked OK. This resulted in recording the payment for th

Re: [GNC] Keeping two sets of books

2019-04-02 Thread Adrien Monteleone
While GnuCash is the app you are trying to run, it is calling MySQL (which is its own app) with the user:password as an argument. I suspect (though I could be wrong) that it is MySQL trying to check that password in the keychain that is the trigger. Something to consider. Good luck figuring it o

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Adrien Monteleone
> On Apr 2, 2019, at 11:59 AM, no_more_quicken wrote: > > > 5. I still haven't quite figured out the reporting framework; my goal is to > generate an "expenses over the last X months grouped by month" report (i.e., > just like the "Expense Over Time" built-in chart, but in a table format with >

Re: [GNC] Keeping two sets of books

2019-04-02 Thread Stuart McGraw
No auto-login here and I think the app that needs an option to ignore the keyring check entirely is Gnucash (not the database which isn't an app). As for creating a different default keyring, I'll look into that sometime (so thanks for the direction to look!) but right now, clicking the Cancel

[GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
I've been diligently tracking my personal finances since early 2000. I started with MS Money, then reluctantly switched to Quicken when Money was discontinued. I LOVED MS Money, but I've never really been happy with Quicken. It's hard to pinpoint exaclty why, but some combination of the clunky UI,

Re: [GNC] Transaction won't reconcile

2019-04-02 Thread Colin Law
If you go into reconcile again does the starting balance match the ending balance from the just-completed reconcile. Are you certain that there are not two similar transactions, one of which you have reconciled and one not? Check very carefully the date on the one that is not reconciled and re-che

[GNC] Transaction won't reconcile

2019-04-02 Thread dlbonline
I have checked the other sources for this info and don't see it. I have a single transaction that I found missing (my bad) during reconciliation. I entered the transaction, completed the reconciliation process and balanced the account to the bank statement. The problem is: the new tra

Re: [GNC] How to change the currency in the summary bar

2019-04-02 Thread Christopher Lam
We prefer https://wiki.gnucash.org/wiki/Mailing_Lists#Netiquette here To change root currency: 1. backup datafile 2. rename datafile.gnucash to datafile.gnucash.gz then gunzip using a reputable tool such as 7-zip 3. open using a reputable text editor such as Notepad++. find the root currency label

Re: [GNC] Bills in Gnucash

2019-04-02 Thread Geert Janssens
The preference was added by Christian back in the 2.6 days. I'm not sure of the end goal of this feature but I believe it was indeed mostly meant to persistently add a few convenience buttons on the tool bar. I'm sure it doesn't manage the availability of the AR/AP accounts and it equally won't

Re: [GNC] Bills in Gnucash

2019-04-02 Thread Derek Atkins
If this preference is added, it should also remove the A/R and A/P Account type choices! -derek On Mon, April 1, 2019 11:21 pm, David Carlson wrote: > Back in 2014 I used to think that going to Edit > Preferences > Business > and checking Enable Extra Buttons was about enabling business features,