Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
And by-the-way, don’t try to run GnuCash from inside the dmg. Drag it to your regular file system somewhere; the “canonical” location is /Applications, but it doesn’t really matter. Regards, John Ralls > On May 28, 2018, at 8:10 PM, John Ralls wrote: > > OK, but that’s not what you’re running

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread John Ralls
Does the database have a table named something like “foo_save”? If so, try dropping it before starting GnuCash. Regards, John Ralls > On May 27, 2018, at 9:56 AM, maniek wrote: > > OK, I turned on query logs. > > when my 2018 DB (a problematic one): > > > Tcp port: 0 Unix socket: /var/lib/

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
OK, but that’s not what you’re running from the command line. Regards, John Ralls > On May 28, 2018, at 6:51 PM, Nicholas Shust wrote: > > Here is more info from the Gnucash file itself: > > Kind: Application > Size: 356,791,772 bytes (394.7 MB on disk) > Where: /Volumes/Gnucash-3.1 3 > Di

[GNC] HSA Deposit from Employer

2018-05-28 Thread aegross
Each month, I deduct from my Gross Salary to fund my Health Savings Account. However, my employer also funds the account each month. The employer part is not attributed to Gross Salary on my paycheck. The section of the paycheck is labeled as "Employer Paid" which isn't very helpful. Trying to

Re: [GNC] A/P: invoice not displayed and payment is displayed

2018-05-28 Thread Adrien Monteleone
You may have to clean up your lots for the A/P account. (you later mention A/R, but I presume you meant A/P) That can get tricky but is sometimes needed after several un-posting and reposting of invoices especially with payments hanging around for future dates. Check the Tutorial & Concepts Gui

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Adrien Monteleone
Was this paid by check or card? If the payment already is there but unassigned, then simply select both it and the bill in the process payment window and it will get applied. Otherwise, that will hang around as a ‘pre-payment’ in limbo. If the unassigned payment is not supposed to be there, the

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Adrien Monteleone
Just edit the transaction and type the amounts in the proper columns. Get into the transaction, tab to the debit, delete it. Enter the same amount in the credit column. Do the same for the other half of the transaction in reverse, but this time, after you enter the debit amount, be sure to dele

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread Nicholas Shust via gnucash-user
Here is more info from the Gnucash file itself: Kind: Application Size: 356,791,772 bytes (394.7 MB on disk) Where: /Volumes/Gnucash-3.1 3 Disk Image: /Users/nicholas/Downloads/Gnucash-Intel-3.1-3.dm Created: May 10, 2018 at 3:18 PM Modified: May 10, 2018 at 3:18 PM Version: 3.1 Copyright:

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread Nicholas Shust via gnucash-user
Gnucash-Intel-3.1-3.dmg. Kind: Disk Image Size: 184,553,092 bytes (184.6 MB on disk) Where from: https://phoenixnap.dl.sourceforge.net/project/gnucash/gnucash%20%28stable%29/3.1/Gnucash-Intel-3.1-3.dmg, https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.1/Gnucash-Inte

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
OK, I turned on query logs. when my 2018 DB (a problematic one): Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 180527 18:51:29 8 Connect root@localhost as anonymous on gnucash_2018 8 Query SET NAMES 'utf8'

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
Nope, just opening a GnuCash after recovering my DB from backup. -- 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 unsubscr

Re: [GNC] Gnucash 3.1 and fedora 28

2018-05-28 Thread maniek
Unfortunately anything in MariaDB log: 2018-05-27 18:22:34 140224845301504 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255). 2018-05-27 18:22:34 140224845301504 [ERROR] Incorrect definition of t

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread David Carlson
Nicholas, Can you report the exact name, size and date stamp on the .dmg file which you installed? Somehow it seems that you are not actually getting the correct file. David C On Mon, May 28, 2018 at 4:56 PM, Nicholas Shust wrote: > Ok, used that link. Here are the results. > > (process:1067)

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Adrien Monteleone
Rich, Does right-clicking the payment and using “Assign as payment” work? It should give you a “process payment window” where you pull up the vendor and will then see the unpaid $45 charge that you can apply it to. Be sure to mind you don’t change dates, amount, and source account for the origi

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread Adrien Monteleone
Sorry. I didn’t realize 3.1-3 was up there. That’s the one you want. Regards, Adrien > On May 28, 2018, at 10:50 AM, annapolishome via gnucash-user > wrote: > > version 3.1-2 is a .exe extension which is a windows file and will not run on > the Mac? > > > > -- > Sent from: http://gnucash.14

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread David Carlson
Use this link from the GnuCash home page:< https://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-3.1-3.dmg > David C On Mon, May 28, 2018 at 3:38 PM, John Ralls wrote: > Please remember to copy the list on all replies. > > The warning about negative dimensions is a (harmless) bug

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread Nicholas Shust via gnucash-user
Ok, used that link. Here are the results. (process:1067): gnc.gui-WARNING **: [mac_set_languages()] Language list: en:en_US:C This is a development version. It may or may not work. Report bugs and other problems to gnucash-de...@gnucash.org You can also lookup and file bug reports at http://bug

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Rich Shepard
On Mon, 28 May 2018, Rich Shepard wrote: Yes, the process payment window appears (when I right-click on the transaction in the credit card register). However, when I select the telco as the Vendor, a different invoice (different date and amount; shows the invoice number and an off-setting pre-p

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Rich Shepard
On Mon, 28 May 2018, Adrien Monteleone wrote: Does right-clicking the payment and using “Assign as payment” work? Adrien, Unfortuately, it does not. It should give you a “process payment window” where you pull up the vendor and will then see the unpaid $45 charge that you can apply it to.

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
Sorry, no you didn’t. I just downloaded that and checked it: No development version message. Regards, John Ralls > On May 28, 2018, at 2:06 PM, Nick Shust wrote: > > SourceForge/gnucash.org site > > Sent from my iPhone > > On May 28, 2018, at 4:38 PM, John Ralls

[GNC] A/P: invoice not displayed and payment is displayed

2018-05-28 Thread Rich Shepard
Looking at the A/P register there is a transaction from 06/19/2017 showing payment from the checking account, including the check number. There is no off-setting invoice displayed for that transaction. When I look under Business -> Vendor -> Find Vendor -> Find Vendor's Bills, there is a post

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Rich Shepard
On Mon, 28 May 2018, Rich Shepard wrote: More detail. The A/P transaction shown when I try to assign the credit card as the payment of the telco invoice was paid by check on the invoice posting date. And the checking account shows that account as reconciled. Think I found the problem: the cr

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread Nick Shust via gnucash-user
SourceForge/gnucash.org site Sent from my iPhone > On May 28, 2018, at 4:38 PM, John Ralls wrote: > > Please remember to copy the list on all replies. > > The warning about negative dimensions is a (harmless) bug in GtkNotebook. > > But the note about “This is a development version” means tha

Re: [GNC] location for environment.local on macOS

2018-05-28 Thread John Ralls
> On May 28, 2018, at 1:43 PM, David Reiser wrote: > > Where should the environment.local file be put on macOS? I tried > $HOME/Library/Application Support/Gnucash where I have some other things like > a Checks folder for custom formats, but the program didn’t pick up the > variable (AQOFX_L

[GNC] location for environment.local on macOS

2018-05-28 Thread David Reiser
Where should the environment.local file be put on macOS? I tried $HOME/Library/Application Support/Gnucash where I have some other things like a Checks folder for custom formats, but the program didn’t pick up the variable (AQOFX_LOG_COMM=1) I’m trying to set. If I add the variable to the enviro

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
Please remember to copy the list on all replies. The warning about negative dimensions is a (harmless) bug in GtkNotebook. But the note about “This is a development version” means that it’s not GnuCash 3.1, it’s a git build. Where did you get it? Regards, John Ralls > On May 28, 2018, at 12:01

Re: [GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Rich Shepard
On Mon, 28 May 2018, Paul Konnersman wrote: For a balance error that is evenly divisible by 9 the likely error is an entry that is a multiple of 10. In this case you may have entered $50 rather than $5 or $5 rather than $50. Paul, That's not the issue. The A/P register has a transaction of

Re: [GNC] Reconciling credit card and A/P accounts [UPDATE]

2018-05-28 Thread Rich Shepard
On Mon, 28 May 2018, Rich Shepard wrote: 1.) On a credit card account the displayed reconciled balance is $45 greater than the true balance as shown on the company's web site as of today. I'm not seeing where this discrepancy arises. I think I found the error but haven't figured out how to

[GNC] Reconciling credit card and A/P accounts

2018-05-28 Thread Rich Shepard
I've read the reconciliation sections in the gnucash-guide and do not see how to fix my situations here. 1.) On a credit card account the displayed reconciled balance is $45 greater than the true balance as shown on the company's web site as of today. I'm not seeing where this discrepancy ari

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
> On May 28, 2018, at 8:50 AM, annapolishome via gnucash-user > wrote: > > version 3.1-2 is a .exe extension which is a windows file and will not run on > the Mac? That's correct. You want Gnucash-Intel-3.1-3.dmg. Regards, John Ralls ___ gnucash-u

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread John Ralls
> On May 28, 2018, at 8:45 AM, annapolishome via gnucash-user > wrote: > > actually, I just downloaded 3.1-3 for the Mac Intel and tried to install and > am still having the same problem. looks like everything is going fine until > it gets to the open and then it immediately exits. If it's c

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread annapolishome via gnucash-user
version 3.1-2 is a .exe extension which is a windows file and will not run on the Mac? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription pref

Re: [GNC] Can't install 3.1-1 on my Mac

2018-05-28 Thread annapolishome via gnucash-user
actually, I just downloaded 3.1-3 for the Mac Intel and tried to install and am still having the same problem. looks like everything is going fine until it gets to the open and then it immediately exits. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html