Re: [GNC] Plot Size on Piechart reports

2019-08-15 Thread Geert Janssens
Op donderdag 15 augustus 2019 06:52:45 CEST schreef David T.: > Geert, > > I was beginning to understand this point as well. Not that it makes > sense in any way. Why would a user choose to define an image along with > its accompanying text box by pixel? I appreciate your user perspective on this

[GNC] I can no longer connect to mysql after upgrading to Debian Buster

2019-08-15 Thread sepp
Hi Sorry, I do not even know if this belongs here but I am a little lost I am a happy GnuCash user for years and have used Mysql as a backend for quite some time. Now I upraded Debian from Stretch to Buster and can no longer connect to the Mysql Database. Yes I can connect in the shel using the s

Re: [GNC] journal entries

2019-08-15 Thread Liz
On Wed, 14 Aug 2019 08:56:49 -0500 Dale Alspach wrote: > The start of this thread was a question from a new user about journal > entries as he understood them from being a Quicken user. (I believe > Quicken is a personal accounting version of Quickbooks. Quickbooks is > targeted at small to mediu

Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster

2019-08-15 Thread Colin Law
Have a look in the gnucash trace file and see if there is anything helpful there. Colin On Thu, 15 Aug 2019 at 09:48, sepp wrote: > > Hi > > Sorry, I do not even know if this belongs here but I am a little lost > > I am a happy GnuCash user for years and have used Mysql as a backend for > quite

Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster

2019-08-15 Thread Adrien Monteleone
The lock message means GnuCash crashed or was not properly shut down. While you can bypass this for XML and Sqlite with "Open Anyway", MySQL might not play nice. You might have to login to the MySQL console to fix things there. In addition to checking the tracefile, I’d also check the MySQL log

[GNC] Deleting a transaction which includes a reconciled split doesn't bring up a warning

2019-08-15 Thread Michael Hendry
Income from various members of my Rotary Club at weekly meetings destined for a particular charity (say Income:CharityX) now needs to be attributed to individual members for Gift Aid tax reclamation purposes. I have set up individual accounts (Income:CharityX:Member01, Income:CharityX:Member02

[GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
I purchased a coffee in Switzerland using my GBP-based Transferwise card.  That card could hold a CHF balance, but on that day it held only GBP.  My local currency is EUR.  So I can think of my coffee purchase as two FX transactions: funding (GBP -> CHF) and an expense (CHF -> EUR). What Transferw

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
Apparently the mailing list strips images, even very tiny ones. The first image simply showed Transferwise associating 5.70 CFH = 4.67 GBP. The second showed that gnucash is creating a correcting split in the transaction I'd entered: 512452_Transferwise CHF    5.70 6212_cafe 

Re: [GNC] journal entries

2019-08-15 Thread Dale Alspach
Thanks Liz. As I said in an earlier post I have no experience with Quicken. Some searching produced that some users are using capabilities of Quicken to make it act like a double entry system, but Quicken does not enforce this. Second, Intuit has apparently sold Quicken. Dale On 8/15/19 5:09 AM

Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster

2019-08-15 Thread David G Hamblen
"Open Anyway" works fine on mysql in GC 3.4 on Ubuntu 19.04. Once you open GC with the mysql backend, and do a "Save As" to an xml backend, it doesn't clear the lock on the mysql database; so you'll get the lock message.  But definitely look at the trace file. On 8/15/19 9:51 AM, Adrien Montel

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread John Ralls
> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson wrote: > > Somewhat related, I thought to import historical currencies, as I'm back > filling some data for analysis purposes. I grabbed 10 years of daily > quotes and imported them (3600 or so rows of data per currency). All ok > for GBP - EUR.

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread Jeff Abrahamson
On 15/08/2019 18:55, John Ralls wrote: >> On Aug 15, 2019, at 7:38 AM, Jeff Abrahamson wrote: >> >> Somewhat related, I thought to import historical currencies, as I'm back >> filling some data for analysis purposes. I grabbed 10 years of daily >> quotes and imported them (3600 or so rows of data

Re: [GNC] multiple currencies in one transaction

2019-08-15 Thread John Ralls
The list server doesn't like inline images. It mostly works with images stuck at the end of the message. Mostly. In what account is the 2.80 debit? In which account (and so which currency) did you create the transaction? A side note, have you considered/tried enabling trading accounts? Some use

Re: [GNC] Deleting a transaction which includes a reconciled split doesn't bring up a warning

2019-08-15 Thread Adrien Monteleone
You should get a confirmation on deleting the transaction, but I don’t think there is a separate one for the fact that it is reconciled. I could be mistaken. Actions > Reset Warnings will show you what you have suppressed and allow you to clear that preference so you’ll see the warnings again.

Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster

2019-08-15 Thread Adrien Monteleone
Interesting. Thanks for the info. Regards, Adrien > On Aug 15, 2019, at 11:31 AM, David G Hamblen wrote: > > "Open Anyway" works fine on mysql in GC 3.4 on Ubuntu 19.04. Once you open GC > with the mysql backend, and do a "Save As" to an xml backend, it doesn't > clear the lock on the mysql d

Re: [GNC] Unrealized gain/loss on Forex

2019-08-15 Thread Jayakumar Chakravarthy
David, Normally I can account the unrealized loss by debiting 'Unrealized Gain/Loss' Account and crediting the Customer Account in my local currency. But since here I have kept the Customer's account in foreign currency, the Customer's account is already showing nil balance. Now where would the

Re: [GNC] Unrealized gain/loss on Forex

2019-08-15 Thread David T. via gnucash-user
Jayakumar, I am no expert on this subject. This has been discussed on the lists before, however, so I hope that one of the previous participants can explain the situation and its solution better than I will.  David On Fri, Aug 16, 2019 at 11:14, Jayakumar Chakravarthy wrote: David, No