Re: [GNC] Unrealized gain/loss on Forex
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 credit go? Thanks. Jayakumar Chakravarthy Founder - Consultant +91-9840 356 506 www.Fulcrum-ACE.com On 14-08-2019 at 14:09, David T. wrote: I believe that the "Unrealized Losses" entry on the Trial Balance report is calculated. You will need to create an account for it, as well as the transaction to account for the loss. HTH, David On Wed, Aug 14, 2019 at 11:40, Jayakumar Chakravarthy wrote: Hi, When I make an Invoice and receive money in a foreign currency and account them in my home currency, where does the unrealized gain/loss go? I observe an entry in Trial Balance having 'Unrealized Losses' with this amount. But where is that account? How can I view it? Thanks. Jayakumar Chakravarthy ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster
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 database; so you'll get the lock message. But > definitely look at the trace file. > ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting a transaction which includes a reconciled split doesn't bring up a warning
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. Regards, Adrien > On Aug 15, 2019, at 9:22 AM, Michael Hendry wrote: > > 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 etc) to enable this to be recorded and reported on > in due course, and am working on the necessary editing of existing > transactions. > > The method I have adopted is to create a dummy transaction between > Assets:Petty Cash and each of these Member accounts, but with no amounts > recorded, and then duplicate this to every date on which a CharityX > transaction has already been recorded. > > The next step is to fill in the necessary contributions in the dummy > transaction and then delete the original (two-split) transaction. > > I expected to be warned that the Petty Cash split had been already been > reconciled, and that bad things would happen to my next reconciliation, as > happens when an attempt is made to edit a reconciled transaction, but no such > warning came up. > > I can’t find any option in Preferences to suggest that I’ve switched off the > reminder I’d expected to see - shouldn’t a deletion be regarded as an edit of > sorts, and bring up a suitable warning? > > Regards, > > Michael ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] multiple currencies in one transaction
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 users who operate in multiple currencies find them useful. Regards, John Ralls > On Aug 15, 2019, at 7:54 AM, Jeff Abrahamson wrote: > > 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 CHF5.70 >6212_cafe 5.70 >512452_Transferwise CHF5.70 >51245_Transferwise 5.70 > 2.80 > > And that 2.80 is rather odd. > > Jeff Abrahamson > > > On 15/08/2019 16:38, Jeff Abrahamson wrote: >> 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 Transferwise tells me is the amount of the purchase and the amount >> of the transaction. (I can also poke further and find the exchange rate >> they used and the minuscule fee, but the important point to me is the >> the two endpoints.) >> >> Now what makes sense to me based on reading about accounting principles >> for multiple currencies is that I should make one transaction thus: >> >>Coffee (CHF) <-- Bank (GBP)# This is the funding part of >>the transaction. >>Expense acct <-- Coffee (CHF) # Here I'm tracking the actual >>expense. >> >> I put those in a single transaction for easier understanding later. >> Here I've created a bank account for Transferwise (GBP) as well as >> subaccounts of that called Transferwise_CHF and some others, denominated >> in the indicated currencies. Those three accounts are transfer >> accounts: I usually expect them to have zero balance. >> >>Transferwise_CHF <-- Transferwise (GBP) # This is the >>funding part of the transaction. >>Expense/cafe <-- Transferwise_CHF # Here I'm tracking >>the actual expense. >> >> Gnucash asks me for some exchange rates, and I answer for the CHF - GBP >> part with the specific numbers provided by Transferwise and for the GBP >> - EUR part with the exchange rate I've downloaded for that date. >> >> I expect to see this in the account Transferwise_CHF >> >>5.70 <-- 5.70 # This is the funding part of the transaction. >>5.70 <-- 5.70 # Here I'm tracking the actual expense. >> >> and this in the Transferwise (GBP) account >> >>4.67 <-- 4.67 # This is the funding part of the transaction. >>4.67 <-- 4.67 # Here I'm tracking the actual expense. >> >> and something similar looking at the splits in the (euro-denominated >> expense account). >> >> But what I see (from the perspective of the CHF account) is this, which >> makes no sense to me: >> >> Gnucash has entered the 2.80, and deleting that split just makes it pop >> up again. Something is terribly wrong if any account's view of the >> transaction doesn't balance. (This is gnucash 3.4, ubuntu, build id >> 3.4+ (2018-12-30). >> >> Is this my error or a bug in gnucash? Any pointers? >> >> >> 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. When I do the same for CHF - EUR, gnucash says it's done >> it, but the price database doesn't show more than a handful. When I do >> it for JPY - EUR, gnucash says it's done but the price editor shows none >> of them. The proposed exchange rates when entering transactions are >> consistent with what the price editor thinks it knows. >> >> Is there a limit on FX rates? (This is about 4000, which doesn't strike >> me as terribly large.) >> > -- > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > http://p27.eu/jeff/ > http://transport-nantes.com/ > > ___ > 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_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your
Re: [GNC] multiple currencies in one transaction
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 per currency). All ok >> for GBP - EUR. When I do the same for CHF - EUR, gnucash says it's done >> it, but the price database doesn't show more than a handful. When I do >> it for JPY - EUR, gnucash says it's done but the price editor shows none >> of them. The proposed exchange rates when entering transactions are >> consistent with what the price editor thinks it knows. >> >> Is there a limit on FX rates? (This is about 4000, which doesn't strike >> me as terribly large.) > Did you look at both both directions in the price db? > > Between versions 2.6.8 and 3.5 GnuCash inverted quotes < 1.0 because of a > mis-begotten rounding scheme in 2.6 that truncated at 6 decimal places. The > rounding was fixed in 3.0 but the reversal wasn't removed until Mike > Alexander noticed it when working on a bug last spring. > > Aside from a few days in January 2015 the CHF has traded at less than 1 EUR > and the JPY of course always trade that way, so most of the CHF rates and all > of the JPY rates should show up under EUR. I did look in both directions. Under euro there were no exchange rates listed in the price database. I'll play with it a bit more and see what I can find. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] multiple currencies in one transaction
> 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. When I do the same for CHF - EUR, gnucash says it's done > it, but the price database doesn't show more than a handful. When I do > it for JPY - EUR, gnucash says it's done but the price editor shows none > of them. The proposed exchange rates when entering transactions are > consistent with what the price editor thinks it knows. > > Is there a limit on FX rates? (This is about 4000, which doesn't strike > me as terribly large.) Did you look at both both directions in the price db? Between versions 2.6.8 and 3.5 GnuCash inverted quotes < 1.0 because of a mis-begotten rounding scheme in 2.6 that truncated at 6 decimal places. The rounding was fixed in 3.0 but the reversal wasn't removed until Mike Alexander noticed it when working on a bug last spring. Aside from a few days in January 2015 the CHF has traded at less than 1 EUR and the JPY of course always trade that way, so most of the CHF rates and all of the JPY rates should show up under EUR. Regards, John Ralls ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster
"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 Monteleone wrote: 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 logs. (which might need to be turned on, or increase their verbosity) Before you get too far down a rabbit hole trying to fix this, be certain if you are running MySQL proper, or MariaDB (a near drop in replacement shipped by many distros) as there may be some differences. Regards, Adrien On Aug 14, 2019, at 12:58 PM, 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 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 same credentials ... 1st "Gnucash caould obtainm the lock for mysql://... When I select Open Anyway I get a message Unable to save to databse with the option cancel. Selecting cancel just reproduces the message so I have to kill it from the shell When I select Open RO -> Unable to save to database. Book is marked read-only. Close option just reproduces the message - again killing in the shell Gnucash Version 3.4 Build ID: 3.4+ (2018-12-30) any advice is very much apreciated Thank you kind regards Sepp ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- dhamb...@afrinc.com home phone (207) 633-4342 Cell Phone (207) 350-0440 ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] journal entries
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, Liz wrote: > 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 medium size businesses.) My post was an attempt >> to explain why a new user coming from Quicken might have a different >> notion of journal entry and not understand the responses he was >> getting from this list. > > > Quicken and Quickbooks are completely different. I have owned both > (which may have been last century). > > Quickbooks is double entry accounting with fancy forms which hide the > works. > > Quicken does not do double entry accounting. Hence my suggestion that > those who come from Quicken are advised to learn about double entry > accounting from some suitable sources. > > Liz > ___ > 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_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] multiple currencies in one transaction
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 5.70 512452_Transferwise CHF 5.70 51245_Transferwise 5.70 2.80 And that 2.80 is rather odd. Jeff Abrahamson On 15/08/2019 16:38, Jeff Abrahamson wrote: > 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 Transferwise tells me is the amount of the purchase and the amount > of the transaction. (I can also poke further and find the exchange rate > they used and the minuscule fee, but the important point to me is the > the two endpoints.) > > Now what makes sense to me based on reading about accounting principles > for multiple currencies is that I should make one transaction thus: > > Coffee (CHF) <-- Bank (GBP) # This is the funding part of > the transaction. > Expense acct <-- Coffee (CHF) # Here I'm tracking the actual > expense. > > I put those in a single transaction for easier understanding later. > Here I've created a bank account for Transferwise (GBP) as well as > subaccounts of that called Transferwise_CHF and some others, denominated > in the indicated currencies. Those three accounts are transfer > accounts: I usually expect them to have zero balance. > > Transferwise_CHF <-- Transferwise (GBP) # This is the > funding part of the transaction. > Expense/cafe <-- Transferwise_CHF # Here I'm tracking > the actual expense. > > Gnucash asks me for some exchange rates, and I answer for the CHF - GBP > part with the specific numbers provided by Transferwise and for the GBP > - EUR part with the exchange rate I've downloaded for that date. > > I expect to see this in the account Transferwise_CHF > > 5.70 <-- 5.70 # This is the funding part of the transaction. > 5.70 <-- 5.70 # Here I'm tracking the actual expense. > > and this in the Transferwise (GBP) account > > 4.67 <-- 4.67 # This is the funding part of the transaction. > 4.67 <-- 4.67 # Here I'm tracking the actual expense. > > and something similar looking at the splits in the (euro-denominated > expense account). > > But what I see (from the perspective of the CHF account) is this, which > makes no sense to me: > > Gnucash has entered the 2.80, and deleting that split just makes it pop > up again. Something is terribly wrong if any account's view of the > transaction doesn't balance. (This is gnucash 3.4, ubuntu, build id > 3.4+ (2018-12-30). > > Is this my error or a bug in gnucash? Any pointers? > > > 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. When I do the same for CHF - EUR, gnucash says it's done > it, but the price database doesn't show more than a handful. When I do > it for JPY - EUR, gnucash says it's done but the price editor shows none > of them. The proposed exchange rates when entering transactions are > consistent with what the price editor thinks it knows. > > Is there a limit on FX rates? (This is about 4000, which doesn't strike > me as terribly large.) > -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] multiple currencies in one transaction
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 Transferwise tells me is the amount of the purchase and the amount of the transaction. (I can also poke further and find the exchange rate they used and the minuscule fee, but the important point to me is the the two endpoints.) Now what makes sense to me based on reading about accounting principles for multiple currencies is that I should make one transaction thus: Coffee (CHF) <-- Bank (GBP) # This is the funding part of the transaction. Expense acct <-- Coffee (CHF) # Here I'm tracking the actual expense. I put those in a single transaction for easier understanding later. Here I've created a bank account for Transferwise (GBP) as well as subaccounts of that called Transferwise_CHF and some others, denominated in the indicated currencies. Those three accounts are transfer accounts: I usually expect them to have zero balance. Transferwise_CHF <-- Transferwise (GBP) # This is the funding part of the transaction. Expense/cafe <-- Transferwise_CHF # Here I'm tracking the actual expense. Gnucash asks me for some exchange rates, and I answer for the CHF - GBP part with the specific numbers provided by Transferwise and for the GBP - EUR part with the exchange rate I've downloaded for that date. I expect to see this in the account Transferwise_CHF 5.70 <-- 5.70 # This is the funding part of the transaction. 5.70 <-- 5.70 # Here I'm tracking the actual expense. and this in the Transferwise (GBP) account 4.67 <-- 4.67 # This is the funding part of the transaction. 4.67 <-- 4.67 # Here I'm tracking the actual expense. and something similar looking at the splits in the (euro-denominated expense account). But what I see (from the perspective of the CHF account) is this, which makes no sense to me: Gnucash has entered the 2.80, and deleting that split just makes it pop up again. Something is terribly wrong if any account's view of the transaction doesn't balance. (This is gnucash 3.4, ubuntu, build id 3.4+ (2018-12-30). Is this my error or a bug in gnucash? Any pointers? 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. When I do the same for CHF - EUR, gnucash says it's done it, but the price database doesn't show more than a handful. When I do it for JPY - EUR, gnucash says it's done but the price editor shows none of them. The proposed exchange rates when entering transactions are consistent with what the price editor thinks it knows. Is there a limit on FX rates? (This is about 4000, which doesn't strike me as terribly large.) -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Deleting a transaction which includes a reconciled split doesn't bring up a warning
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 etc) to enable this to be recorded and reported on in due course, and am working on the necessary editing of existing transactions. The method I have adopted is to create a dummy transaction between Assets:Petty Cash and each of these Member accounts, but with no amounts recorded, and then duplicate this to every date on which a CharityX transaction has already been recorded. The next step is to fill in the necessary contributions in the dummy transaction and then delete the original (two-split) transaction. I expected to be warned that the Petty Cash split had been already been reconciled, and that bad things would happen to my next reconciliation, as happens when an attempt is made to edit a reconciled transaction, but no such warning came up. I can’t find any option in Preferences to suggest that I’ve switched off the reminder I’d expected to see - shouldn’t a deletion be regarded as an edit of sorts, and bring up a suitable warning? Regards, Michael ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster
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 logs. (which might need to be turned on, or increase their verbosity) Before you get too far down a rabbit hole trying to fix this, be certain if you are running MySQL proper, or MariaDB (a near drop in replacement shipped by many distros) as there may be some differences. Regards, Adrien > On Aug 14, 2019, at 12:58 PM, 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 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 same credentials ... > > 1st "Gnucash caould obtainm the lock for mysql://... > When I select Open Anyway I get a message Unable to save to databse with the > option cancel. Selecting cancel just reproduces the message so I have to > kill it from the shell > When I select Open RO -> Unable to save to database. Book is marked > read-only. Close option just reproduces the message - again killing in the > shell > Gnucash Version 3.4 Build ID: 3.4+ (2018-12-30) > > any advice is very much apreciated > > Thank you kind regards > Sepp ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] I can no longer connect to mysql after upgrading to Debian Buster
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 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 same credentials ... > > 1st "Gnucash caould obtainm the lock for mysql://... > When I select Open Anyway I get a message Unable to save to databse with the > option cancel. Selecting cancel just reproduces the message so I have to > kill it from the shell > When I select Open RO -> Unable to save to database. Book is marked > read-only. Close option just reproduces the message - again killing in the > shell > Gnucash Version 3.4 Build ID: 3.4+ (2018-12-30) > > any advice is very much apreciated > > Thank you kind regards > Sepp > > > > > > -- > 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 unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] journal entries
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 medium size businesses.) My post was an attempt > to explain why a new user coming from Quicken might have a different > notion of journal entry and not understand the responses he was > getting from this list. Quicken and Quickbooks are completely different. I have owned both (which may have been last century). Quickbooks is double entry accounting with fancy forms which hide the works. Quicken does not do double entry accounting. Hence my suggestion that those who come from Quicken are advised to learn about double entry accounting from some suitable sources. Liz ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] I can no longer connect to mysql after upgrading to Debian Buster
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 same credentials ... 1st "Gnucash caould obtainm the lock for mysql://... When I select Open Anyway I get a message Unable to save to databse with the option cancel. Selecting cancel just reproduces the message so I have to kill it from the shell When I select Open RO -> Unable to save to database. Book is marked read-only. Close option just reproduces the message - again killing in the shell Gnucash Version 3.4 Build ID: 3.4+ (2018-12-30) any advice is very much apreciated Thank you kind regards Sepp -- 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 unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Plot Size on Piechart reports
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 and I can see the usefulness of strictly defining only the plot size in some way. While obvious from the outside it's unfortunately much less so when trying to implement this. Assuming we define the plot size only, then where should the legend be rendered ? On-screen you could argue the canvas size is infinite so it can go next to the plot even beyond the borders of the window. But what should happen with it when printed ? Note the choice for pixels is historical. Nowadays people are more interested in millimeters or inches. That adds the challenge of getting proper screen resolutions from the system to convert this back to pixels on-screen. And there are plenty more technical challenges. I believe most likely all can be solved, but it requires some thorough analysis of the report use cases, wishes and constraints. > Further: the setting is "Plot width" > --and not "Width of pie and accompanying text box" or something equally > dense but accurate. "Plot" to me means "the image portion of this report." > I presume "Plot width" was the most dense the original author of that code could come up with a long time ago. Or originally there were no legends for the charts. Or we have changed chart rendering engines three times by now (and four times soon). Perhaps the original rendering engine did it differently. > I won't even go into the odd ways that these reports get jammed into a > multi column report, since I can't begin to understand what the various > factor are there. Suffice to say the result is not predictable or expected. > > Now that I understand the idiosyncrasy, I will let the matter drop. > Maybe someday someone will investigate an improved method for rendering > these reports It will first require someone to clearly describe the exact requirements of such an improved method of rendering. Feel free to focus your thoughts in an enhancement request! Geert ___ 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_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.