Re: Save to MySQL
Hello, I'm using two machines (both are Ubuntu 16.04) and trying to use MySQL to save GnuCash data. In one machine the GnuCash application in the second one MySQL. While trying to save the data (with Save As, MySQL option) I provide the MySQL information (Host, DB, User and Pass). In MySQL I see that the database was created as well as the tables. However, I get an error in GnuCash - The Server at URL:// experienced an error or encountered bad or corrupt data. If I try to save agian with the same MySQL information I get: The file already exits. Are you sure you want to overwrite it ? Answering Yes creates another set of tables with _back suffix to all tables. How to resolve the issue ? Kind regards, Daniel Orkan -- 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: Preferences - Online Banking
On Wed, 21 Mar 2018 07:58:01 -0400 R Winstead wrote: > I guess I'm just sending this to the moderator for this group. I > never saw this come across in email so I'm wondering if this was not > released to the group by the moderator, or was there some other > reason? I have checked archives and I didn't see anything that would > answer my question. I don't believe I've done anything outside of > the rules of etiquette for this group, but please let me know if I > have. > > Thank you. Simple. Gmail does not send you a copy of your messages to (any) list. 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.
Re: Save to MySQL
On 22 March 2018 at 07:39, daniel wrote: > Hello, > > I'm using two machines (both are Ubuntu 16.04) and trying to use MySQL to > save GnuCash data. > In one machine the GnuCash application in the second one MySQL. > > While trying to save the data (with Save As, MySQL option) I provide the > MySQL information (Host, DB, User and Pass). > > In MySQL I see that the database was created as well as the tables. > > However, I get an error in GnuCash - The Server at URL:// experienced an > error or encountered bad or corrupt data. > > If I try to save agian with the same MySQL information I get: > The file already exits. Are you sure you want to overwrite it ? > Answering Yes creates another set of tables with _back suffix to all tables. The _back tables are (I think) backups of the ones before the save. The normally named tables should contain the correct data. Did the save succeed this time? If it still did not succeed check that the user has full access to the database. Also which version of gnucash and which version of SQL sever are you using? Colin ___ 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.
incorrect starting balance in reconcile
I am trying to reconcile a Bank account. Everything has been working fine since I opened the account, but recently I tried to reconcile a statement, and the starting balance of the reconcile is incorrect. At the end of every statement, I put in a trxn with 0 value and the correct ending balance in the description so that I can quickly check the ledger. The starting balance had always matched the correct balance for the account on the next reconcile. This time it did not. After reading through a lot of posts concerning incorrect starting balances, I decided to unreconcile all the trxns in the account and re-reconcile. After un-reconciling back the account open, when I try to reconcile the first trxn (amount = 0), the starting balance in the reconcile is not zero. There are no trxns before this one trxn I am trying to reconcile. HOW CAN THIS BE? It appears that GNU Cash is keeping a reconciled balance in the file that is no longer correct. I can fix this with an entry to balance the starting balance and make a note that it is because of a bug in GNUCash, but this is very bad, as if anyone ever looks at the books, they will ask the legitimate question: Can I trust a program that requires adjusting entries because of bugs? Once all txns in an account are unreconciled, it should be possible to reset the starting balance for the account to the correct starting balance. Based on all the related posts I've seen, this appears to be an ongoing problem. Help would be appreciated. Thanks, -- 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: "Unrealized Losses" in Trial Balance Report
Thanks for your thoughts, Adrien. Yes, I do have losses from changes in exchange rates between when I booked a currency and the date of the report. However, these changes were tiny compared to the "Unrealized Losses" figure that appeared in the Trial Balance report. So, while I agree that this report shouldn't show virtual accounts, the bigger question in my mind is, "Where did this number come from?" That's still a mystery to me, but the use of multiple currencies is definitely a trigger. As soon as I remove all transactions in a foreign currency, this line disappears from the report. About this rounding bug you described: are you sure this affects only the Trial Balance report? I'm worried that this could cause a lot of other problems. It sounds like I have to give up on putting foreign currency transactions in my GnuCash books until these problems are fixed. I see your point that Trial Balances should not be necessary, but I don't think I'm likely to get my accountant to change her ways because GnuCash won't generate the reports she wants, and I'm not quite ready to go looking for a new accountant! Thanks, Richard On 22/3/18, 2:22 PM, "gnucash-user on behalf of Adrien Monteleone" wrote: You might see unrealized losses with multiple currencies to account for the change in value between the time you booked a currency and the date of the report. So if you converted some SGD to USD at some particular exchange rate, and that rate has since changed (very likely) then you will either have a gain or loss (depending on the direction of the change) that is yet unrealized because you haven’t converted the USD back to SGD. If you did convert them back, the loss or gain would be realized in the conversion transaction. But I’m not sure why the report shows the unrealized figures at all. It really doesn’t belong in there unless I don’t understand ’trial balance’ properly. It should be showing you the balance of ACTUAL accounts, not virtual ones. What’s worse, even without that figure, I also discovered that you can get an imbalanced result here even if the value hasn’t changed. There is a rounding bug that kicks in because the report takes the newer value based on a rounded total of the foreign currency. But the asset account register for that currency only rounds the display, not the actual figures. The cumulative effect can be a gain/loss of several currency units over a 2 year period.(noted in that thread you linked) So if you have multiple currencies, this report is most likely going to be wrong. Really, the report is not necessary any longer using computers instead of paper books. The purpose of the trial balance is to check your books before you close them. But you don’t need to close your books with Gnucash. If you are closing, you want to make sure everything is correct because the process of closing wipes out some accounts back to zero, effectively ‘erasing’ their history. (or rather, fixing their history as a single end-of-period figure, rather than individual transactions) In the days of paper, this was necessary as part of the process of creating the basic financial statements. But with Gnucash, you don’t need to close the books in order to generate those financial statements. (Income Statement, Balance Sheet, etc.) You can generate those reports at any time. Regards, Adrien > On Mar 22, 2018, at 1:02 AM, Richard wrote: > > Hi there, > > > > I’ve been using GnuCash for about a year to run a small business in Singapore. I’m thrilled that it has worked so well, since I have no accounting experience, but I’m trying to create a Trial Balance report for my accountant, and I can’t get it to work right. At the bottom of the report there is a line showing “Unrealized Losses” of S$230.42, which seems to have come out of nowhere. Note that this line does not correspond to any account, but is something that the report has automatically added, and it is causing a mismatch between Debits and Credits. Does anyone know why a Trial Balance report would show a line like this? Is this a bug? I saw the following conversation on gnucash-dev that seems to be discussing something similar, but I’m not sure. > > > > http://gnucash.1415818.n4.nabble.com/Re-trial-balance-how-to-find-mismatch-question-td4697393i20.html > > > > There are a few other things to note about my situation. First, I should say that I’m running GnuCash 2.6.19 on Mac OS 10.13.3. Second, I have no investment accounts or stocks in this set of accounts, so I don’t have any unrealized losses due to that. Finally, I am using two currencies (USD and SGD), and I do have a small loss (of S$3.58 I think) that I have not yet accounted for. I saw mention of multiple currencies in the thread I linked to above. Could this be causing the problem? >
Re: incorrect starting balance in reconcile
Sounds like you entered a transaction with a date prior to your last reconciled date or perhaps even before the opening balance of the particular account you're looking at. Check the View >> Filter By... options to ensure you're seeing all the transactions in the account you're trying to unreconcile. Cheers Dave H. On 22 March 2018 at 05:22, darrylctx wrote: > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile > is > incorrect. > At the end of every statement, I put in a trxn with 0 value and the correct > ending balance in the description so that I can quickly check the ledger. > The starting balance had always matched the correct balance for the account > on the next reconcile. This time it did not. > After reading through a lot of posts concerning incorrect starting > balances, > I decided to unreconcile all the trxns in the account and re-reconcile. > After un-reconciling back the account open, when I try to reconcile the > first trxn (amount = 0), the starting balance in the reconcile is not zero. > There are no trxns before this one trxn I am trying to reconcile. > > HOW CAN THIS BE? > > It appears that GNU Cash is keeping a reconciled balance in the file that > is > no longer correct. > > I can fix this with an entry to balance the starting balance and make a > note > that it is because of a bug in GNUCash, but this is very bad, as if anyone > ever looks at the books, they will ask the legitimate question: > > Can I trust a program that requires adjusting entries because of bugs? > > Once all txns in an account are unreconciled, it should be possible to > reset > the starting balance for the account to the correct starting balance. > > Based on all the related posts I've seen, this appears to be an ongoing > problem. > > Help would be appreciated. > > Thanks, > > > > > -- > 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: incorrect starting balance in reconcile
On Wednesday, 21 March 2018 19:22:10 GMT darrylctx wrote: > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At the end of every statement, I put in a trxn with 0 value and the correct > ending balance in the description so that I can quickly check the ledger. > The starting balance had always matched the correct balance for the account > on the next reconcile. This time it did not. > After reading through a lot of posts concerning incorrect starting balances, > I decided to unreconcile all the trxns in the account and re-reconcile. > After un-reconciling back the account open, when I try to reconcile the > first trxn (amount = 0), the starting balance in the reconcile is not zero. > There are no trxns before this one trxn I am trying to reconcile. > > HOW CAN THIS BE? > > It appears that GNU Cash is keeping a reconciled balance in the file that is > no longer correct. > > I can fix this with an entry to balance the starting balance and make a note > that it is because of a bug in GNUCash, but this is very bad, as if anyone > ever looks at the books, they will ask the legitimate question: > > Can I trust a program that requires adjusting entries because of bugs? > > Once all txns in an account are unreconciled, it should be possible to reset > the starting balance for the account to the correct starting balance. > > Based on all the related posts I've seen, this appears to be an ongoing > problem. > > Help would be appreciated. > > Thanks, > Hi, the usual advice if the start balance is off is to just ignore it and try to complete the reconcile anyway. I believe that the most typical reasons for the start balance to be wrong is because a reconciled transaction has been modified in some way, or a transaction has been entered in the wrong year. by going through the reconcile (which if it doesn't work out can be cancelled) there is a good chance that you'll see the mistaken transaction if it is out of register order. AFAIK, the reconciled balance isn't stored anywhere, but is calculated on the fly when needed. HTH, Maf. ___ 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: Save to MySQL
Hello Colin, More information: - The save didn't succeed, all the tables are empty (Error is: The Server at URL:// experienced an > error or encountered bad or corrupt data) - I'm using root user for MySQL (at least for now), DB and tables were created - GnuCash version 2.6.19 (built from sources using cmake) - MySQL version 5.7.21 Daniel Orkan -- 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: Save to MySQL
Daniel, Have you tried using your file manager on your local computer to see if you can access the folder containing the data db on the other computer just before trying the GnuCash action? I have sometimes had problems with network discovery working rather slowly. David C On Thu, Mar 22, 2018 at 6:33 AM, daniel wrote: > Hello Colin, > > More information: > > - The save didn't succeed, all the tables are empty (Error is: The Server > at > URL:// experienced an > > error or encountered bad or corrupt data) > - I'm using root user for MySQL (at least for now), DB and tables were > created > - GnuCash version 2.6.19 (built from sources using cmake) > - MySQL version 5.7.21 > > Daniel Orkan > > > > -- > 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.
Recent posts and replies missing issues in several GnuCash user threads
I have noticed an issue on my computer recently that Gmail is not always correctly displaying threads from the GnuCash user maillists. I have usually been able to find the missing items by scrolling through the threads, but then I see all the duplicated text in the replies and I get even more confused. This could be affecting other users as well. David C ___ 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: incorrect starting balance in reconcile
On 21 March 2018 at 19:22, darrylctx wrote: > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At the end of every statement, I put in a trxn with 0 value and the correct > ending balance in the description so that I can quickly check the ledger. > The starting balance had always matched the correct balance for the account > on the next reconcile. This time it did not. Almost certainly you have (presumably accidentally) modified or deleted a reconciled transaction or manually marked a transaction as reonciled. > After reading through a lot of posts concerning incorrect starting balances, > I decided to unreconcile all the trxns in the account and re-reconcile. > After un-reconciling back the account open, when I try to reconcile the > first trxn (amount = 0), the starting balance in the reconcile is not zero. > There are no trxns before this one trxn I am trying to reconcile. As Dave suggested view the filter options to make sure you can see all the transactions. > > HOW CAN THIS BE? > > It appears that GNU Cash is keeping a reconciled balance in the file that is > no longer correct. > > I can fix this with an entry to balance the starting balance and make a note > that it is because of a bug in GNUCash, but this is very bad, as if anyone > ever looks at the books, they will ask the legitimate question: > > Can I trust a program that requires adjusting entries because of bugs? It is almost always a mistake to start by assuming that a problem is caused by a bug, particularly something as dramatic as this that would be most unlikely to have gone unnoticed by the many thousands of people who use Gnucash and have not seen the problem. Very occasionally it will be a bug but more often the error lies between the chair and the hands. > > Once all txns in an account are unreconciled, it should be possible to reset > the starting balance for the account to the correct starting balance. > > Based on all the related posts I've seen, this appears to be an ongoing > problem. I cannot remember a single instance where an error of this sort was not caused by mistakes such as those I mention above. Possibly the best solution is go back through your routine backups till you find one the last one that does show the correct reconciled balance and start again from there, or work forwards from there to find what caused the error. Colin ___ 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: Finally ready to move from Windoze to Unix, suggestions of flavor of Unix to use **[solved]**
On 3/21/2018 6:05 PM, David Carlson wrote: Linux is not Unix. Nor is BSD. Very few users are interested either of the other two, but they both are very important in the grand scheme of things. David C True about linux and the unixes not being the SAME operating system, but users do not ordinarily interact with their computers at the level of the operating system itself. They interact with a "windows manager" and perhaps if a bit more advanced, at the command line with a "shell language". Since linux and the various unix variants share* choices of windows manager and shell languages and the standard unix library of utilities, share the same notion of "permissions", etc. it makes little practical difference at the user level. If I sat down at a terminal, in front of me say a KDE screen or at the command line of bash I would not immediately know was that linux, an old unix, BSD, etc. and with very little of what I might do would it make any difference. Michael D Novack * A particular linux disto (or unix distro) might not come with the full range of what is available in place, but could always get them. ___ 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: Save to MySQL
On 22 March 2018 at 11:33, daniel wrote: > Hello Colin, > > More information: > > - The save didn't succeed, all the tables are empty (Error is: The Server at > URL:// experienced an >> error or encountered bad or corrupt data) > - I'm using root user for MySQL (at least for now), DB and tables were > created > - GnuCash version 2.6.19 (built from sources using cmake) > - MySQL version 5.7.21 Have a look in the gnucash trace file to get more information about the failure. https://wiki.gnucash.org/wiki/Tracefile Colin ___ 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: "Unrealized Losses" in Trial Balance Report
Hi Richard If I understand 'unrealised gains', this is a known issue. I think any double-entry accounting system will have this issue when currencies or stocks are converted without accounting for capital gains. With stocks we expect to receive capital gains and are usually taxed on these gains; and these gains must be documented in Gnucash. With currency conversions (to and from), we don't usually expect to account for capital gains. The issue has been documented by http://www.mscs.dal.ca/~selinger/accounting/tutorial.html and http://www.mscs.dal.ca/~selinger/accounting/gnucash.html I think if the gains are documented correctly the TB should balance. The Balance sheet has been fixed when Trading Accounts are enabled, but the Trial Balance was missed out. ^ All above IANAA, just have some inkling that numbers should balance, except when the exchange rates / share prices are not fixed. Simplest answer for the accountant is to *not* document currency gains/losses using Gnucash; if I have accounts in GBP and USD I'd keep separate books and whenever I do an international transfer I'd make the money disappear from Asset:GBPBank -> Equity:Foreign, and Equity:Foreign -> Asset:USDBank in the two books separately. I'll present both chart of transactions separately and let the accountant handle the headache. HTH, C On Thu, 22 Mar 2018, 17:44 Richard wrote: > Thanks for your thoughts, Adrien. > > Yes, I do have losses from changes in exchange rates between when I booked > a currency and the date of the report. However, these changes were tiny > compared to the "Unrealized Losses" figure that appeared in the Trial > Balance report. So, while I agree that this report shouldn't show virtual > accounts, the bigger question in my mind is, "Where did this number come > from?" That's still a mystery to me, but the use of multiple currencies is > definitely a trigger. As soon as I remove all transactions in a foreign > currency, this line disappears from the report. > > About this rounding bug you described: are you sure this affects only the > Trial Balance report? I'm worried that this could cause a lot of other > problems. > > It sounds like I have to give up on putting foreign currency transactions > in my GnuCash books until these problems are fixed. I see your point that > Trial Balances should not be necessary, but I don't think I'm likely to get > my accountant to change her ways because GnuCash won't generate the reports > she wants, and I'm not quite ready to go looking for a new accountant! > > Thanks, > Richard > > > > On 22/3/18, 2:22 PM, "gnucash-user on behalf of Adrien Monteleone" > adrien.montele...@gmail.com> wrote: > > You might see unrealized losses with multiple currencies to account > for the change in value between the time you booked a currency and the date > of the report. > > So if you converted some SGD to USD at some particular exchange rate, > and that rate has since changed (very likely) then you will either have a > gain or loss (depending on the direction of the change) that is yet > unrealized because you haven’t converted the USD back to SGD. If you did > convert them back, the loss or gain would be realized in the conversion > transaction. > > But I’m not sure why the report shows the unrealized figures at all. > It really doesn’t belong in there unless I don’t understand ’trial balance’ > properly. It should be showing you the balance of ACTUAL accounts, not > virtual ones. > > What’s worse, even without that figure, I also discovered that you can > get an imbalanced result here even if the value hasn’t changed. There is a > rounding bug that kicks in because the report takes the newer value based > on a rounded total of the foreign currency. But the asset account register > for that currency only rounds the display, not the actual figures. The > cumulative effect can be a gain/loss of several currency units over a 2 > year period.(noted in that thread you linked) So if you have multiple > currencies, this report is most likely going to be wrong. > > Really, the report is not necessary any longer using computers instead > of paper books. The purpose of the trial balance is to check your books > before you close them. But you don’t need to close your books with Gnucash. > If you are closing, you want to make sure everything is correct because the > process of closing wipes out some accounts back to zero, effectively > ‘erasing’ their history. (or rather, fixing their history as a single > end-of-period figure, rather than individual transactions) In the days of > paper, this was necessary as part of the process of creating the basic > financial statements. But with Gnucash, you don’t need to close the books > in order to generate those financial statements. (Income Statement, Balance > Sheet, etc.) You can generate those reports at any time. > > Regards, > Adrien > > > On Mar 22, 2018, at 1:02 AM, Richard wrote:
Compiling -DWITH_GNUCASH=NO
Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with -DWITH_GNUCASH=NO I pick errors since it seems that libgnucash needs scm/price-quotes.scm which in turn needs scm-gnome-utils which seem to be defined under gnucash/gnome-utils/ but that directory won't be included without WITH_GNUCASH. The error I get is simply: make[2]: *** No rule to make target '/var/tmp/portage/app-office/gnucash-2.7.5-r1/work/ gnucash-2.7.5/libgnucash/scm/scm-gnome-utils', needed by 'lib64/gnucash/scm/ccache/2.2/ gnucash/price-quotes.go'. Stop. How should I build libgnucash without gtk? Thanks, P. signature.asc Description: PGP signature ___ 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: incorrect starting balance in reconcile
You can use the Edit->Find menu item to search for entries by their reconcile status. It might help you find an accidentally-inserted transaction. On 3/22/2018 8:43 AM, Colin Law wrote: On 21 March 2018 at 19:22, darrylctx wrote: I am trying to reconcile a Bank account. Everything has been working fine since I opened the account, but recently I tried to reconcile a statement, and the starting balance of the reconcile is incorrect. At the end of every statement, I put in a trxn with 0 value and the correct ending balance in the description so that I can quickly check the ledger. The starting balance had always matched the correct balance for the account on the next reconcile. This time it did not. Almost certainly you have (presumably accidentally) modified or deleted a reconciled transaction or manually marked a transaction as reonciled. After reading through a lot of posts concerning incorrect starting balances, I decided to unreconcile all the trxns in the account and re-reconcile. After un-reconciling back the account open, when I try to reconcile the first trxn (amount = 0), the starting balance in the reconcile is not zero. There are no trxns before this one trxn I am trying to reconcile. As Dave suggested view the filter options to make sure you can see all the transactions. HOW CAN THIS BE? It appears that GNU Cash is keeping a reconciled balance in the file that is no longer correct. I can fix this with an entry to balance the starting balance and make a note that it is because of a bug in GNUCash, but this is very bad, as if anyone ever looks at the books, they will ask the legitimate question: Can I trust a program that requires adjusting entries because of bugs? It is almost always a mistake to start by assuming that a problem is caused by a bug, particularly something as dramatic as this that would be most unlikely to have gone unnoticed by the many thousands of people who use Gnucash and have not seen the problem. Very occasionally it will be a bug but more often the error lies between the chair and the hands. Once all txns in an account are unreconciled, it should be possible to reset the starting balance for the account to the correct starting balance. Based on all the related posts I've seen, this appears to be an ongoing problem. I cannot remember a single instance where an error of this sort was not caused by mistakes such as those I mention above. Possibly the best solution is go back through your routine backups till you find one the last one that does show the correct reconciled balance and start again from there, or work forwards from there to find what caused the error. Colin ___ 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.
GST / HST / VAT on Employee Vouchers
Is it possible to add a section for value added tax in employee vouchers? Right now I'm just adding it as a separate line item, but it makes things look awful in my books. -- 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: Recent posts and replies missing issues in several GnuCash user threads
I too noticed a change about a month or two ago. Perhaps it was happening before, but it seems more frequent lately. My subscribed address is Gmail, but I use macOS mail client on my desktop so it’s not a web vs. client issue. So far that I can tell, it appears though that the issue may not be Gmail, but rather people hitting the reply button instead of new/compose. It seems they are taking the advice to change the subject line appropriately, but that still breaks the thread. (threading is by message id, not subject text) I investigated a few such threads by viewing By Thread on the archive page. Sure enough, subject lines changed in several threads, and it was the same few users in each case causing the issue. What I have noticed as odd is that posts appear to be re-sending. (at least OPs from newbies) One of these I determined was a real re-post, I didn’t investigate the others to see if they were in fact re-posted or if the mailman server was re-sending them. Sometimes this happens for replies too. So I’ll see a thread, maybe even participate in it, and then 3 days later, the OP appears again fresh and new. At least in the one case that was an actual repost, I suspect the OP did not check to see if they received a reply from the list, or else, it’s possible to post to the list without subscribing. (I didn’t think this was possible) If the latter is the case, then if they don’t subscribe, they won’t get any replies sent back *only* to the list. The usual tell-tale for this is a newbie posts a question, several people chime in with answers, and the OP never responds again. Then they repost the original question. Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to the list AND each sender (depending on the message you are replying to) which then means those people get multiple copies. I personally don’t care to deal with duplicates of the same message, so I try to avoid it for others. But if people can post without subscribing, that means they’ll never see my reply. (or the reply of anyone else only replying to the list) Does Nabble allow people to post and not subscribe? Perhaps they are using Nabble and then loosing track of the thread to see replies? Maybe they don’t know how to find their own threads? (I’m not a Nabble user) Regards, Adrien > On Mar 22, 2018, at 8:01 AM, David Carlson > wrote: > > I have noticed an issue on my computer recently that Gmail is not always > correctly displaying threads from the GnuCash user maillists. I have > usually been able to find the missing items by scrolling through the > threads, but then I see all the duplicated text in the replies and I get > even more confused. > > This could be affecting other users as well. > > David C > ___ > 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: incorrect starting balance in reconcile
> On Mar 21, 2018, at 12:22 PM, darrylctx wrote: > > I am trying to reconcile a Bank account. > Everything has been working fine since I opened the account, but recently I > tried to reconcile a statement, and the starting balance of the reconcile is > incorrect. > At the end of every statement, I put in a trxn with 0 value and the correct > ending balance in the description so that I can quickly check the ledger. > The starting balance had always matched the correct balance for the account > on the next reconcile. This time it did not. > After reading through a lot of posts concerning incorrect starting balances, > I decided to unreconcile all the trxns in the account and re-reconcile. > After un-reconciling back the account open, when I try to reconcile the > first trxn (amount = 0), the starting balance in the reconcile is not zero. > There are no trxns before this one trxn I am trying to reconcile. > > HOW CAN THIS BE? > > It appears that GNU Cash is keeping a reconciled balance in the file that is > no longer correct. > > I can fix this with an entry to balance the starting balance and make a note > that it is because of a bug in GNUCash, but this is very bad, as if anyone > ever looks at the books, they will ask the legitimate question: > > Can I trust a program that requires adjusting entries because of bugs? > > Once all txns in an account are unreconciled, it should be possible to reset > the starting balance for the account to the correct starting balance. > > Based on all the related posts I've seen, this appears to be an ongoing > problem. Nope. GnuCash calculates balances on the fly, starting from the first transaction in the account, at file open and every time you change something. Balances aren't written out. If you have a reconciled balance it's because there are reconciled splits in the account. 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: "Unrealized Losses" in Trial Balance Report
The rounding error I found can be very large depending on the variance between the exchange rate for each transaction and the date of the report. But, I don’t think it affects anything else, because it’s a function of the report, not any math Gnucash otherwise performs. And I’ve never seen this discrepancy anywhere else. Others are using multiple currencies without major issue, so I don’t think overall that there’s any danger. Perhaps someone who routinely uses multiple currencies AND performs Trial Balance reports could weigh in. As for the Unrealized line, do you have Trading Accounts enabled by chance? I’d have to play with it, but perhaps that is why you are seeing that line at all. (I have it on in my book) I don’t know the implications of turning that off once it’s on. One of the more seasoned users or developers would have to chime in. However, you can ‘adjust it out’ if need be. (that’s the purpose of a trial-balance, to determine what if any adjusting entries need to be made) In this case, you won’t be making any actual transaction entries in Gnucash - just on the Trial Balance. Check this out: Trial Balance Total Debits - Trial Balance Total Credits + Unrealized(+Gain, -Loss) = rounding error (or zero if no error) If this equation holds true for your Trial Balance Report, then you are otherwise in balance. If not, then you really do have an error somewhere that you need to correct/adjust for. To determine the actual rounding error, open the foreign currency asset account. Add up all of the entries in the native currency. (If you have Trading Accounts on, you’ll see two debits and credits for each transaction, one in the native currency of the book, and one in the foreign currency of the account) Then subtract balance of this account found on the trial balance. The result is the rounding error. So for example if the sum of your SGD entries is debit S$1100 and the Trial Balance report says the account is really debit S$1000, then the rounding error is S$100. So if the result of Total Debits - Total Credits - Unrealized Loss = S$100, then you are otherwise in balance. I’ve tried several reports to do this math for me to no avail. Probably the closest is the Account report, but that doesn’t give totals in the native currency, only the foreign currency set for that account. I suppose though it would be trivial enough to copy/export to a spreadsheet to generate that figure. My XAG account only has about 10 entries, so I don’t mind doing the calculator math. Regards, Adrien > On Mar 22, 2018, at 4:42 AM, Richard wrote: > > Thanks for your thoughts, Adrien. > > Yes, I do have losses from changes in exchange rates between when I booked a > currency and the date of the report. However, these changes were tiny > compared to the "Unrealized Losses" figure that appeared in the Trial Balance > report. So, while I agree that this report shouldn't show virtual accounts, > the bigger question in my mind is, "Where did this number come from?" That's > still a mystery to me, but the use of multiple currencies is definitely a > trigger. As soon as I remove all transactions in a foreign currency, this > line disappears from the report. > > About this rounding bug you described: are you sure this affects only the > Trial Balance report? I'm worried that this could cause a lot of other > problems. > > It sounds like I have to give up on putting foreign currency transactions in > my GnuCash books until these problems are fixed. I see your point that Trial > Balances should not be necessary, but I don't think I'm likely to get my > accountant to change her ways because GnuCash won't generate the reports she > wants, and I'm not quite ready to go looking for a new accountant! > > Thanks, > Richard > > > > On 22/3/18, 2:22 PM, "gnucash-user on behalf of Adrien Monteleone" > adrien.montele...@gmail.com> wrote: > >You might see unrealized losses with multiple currencies to account for > the change in value between the time you booked a currency and the date of > the report. > >So if you converted some SGD to USD at some particular exchange rate, and > that rate has since changed (very likely) then you will either have a gain or > loss (depending on the direction of the change) that is yet unrealized > because you haven’t converted the USD back to SGD. If you did convert them > back, the loss or gain would be realized in the conversion transaction. > >But I’m not sure why the report shows the unrealized figures at all. It > really doesn’t belong in there unless I don’t understand ’trial balance’ > properly. It should be showing you the balance of ACTUAL accounts, not > virtual ones. > >What’s worse, even without that figure, I also discovered that you can get > an imbalanced result here even if the value hasn’t changed. There is a > rounding bug that kicks in because the report takes the newer value b
Re: Recent posts and replies missing issues in several GnuCash user threads
In Gmail I do not see an option to reply-To-List. That does seem to be logical if I could figure out how to do it. David C On Thu, Mar 22, 2018 at 12:01 PM, Adrien Monteleone < adrien.montele...@gmail.com> wrote: > I too noticed a change about a month or two ago. Perhaps it was happening > before, but it seems more frequent lately. > > My subscribed address is Gmail, but I use macOS mail client on my desktop > so it’s not a web vs. client issue. > > So far that I can tell, it appears though that the issue may not be Gmail, > but rather people hitting the reply button instead of new/compose. It seems > they are taking the advice to change the subject line appropriately, but > that still breaks the thread. (threading is by message id, not subject > text) I investigated a few such threads by viewing By Thread on the archive > page. Sure enough, subject lines changed in several threads, and it was the > same few users in each case causing the issue. > > What I have noticed as odd is that posts appear to be re-sending. (at > least OPs from newbies) One of these I determined was a real re-post, I > didn’t investigate the others to see if they were in fact re-posted or if > the mailman server was re-sending them. Sometimes this happens for replies > too. So I’ll see a thread, maybe even participate in it, and then 3 days > later, the OP appears again fresh and new. At least in the one case that > was an actual repost, I suspect the OP did not check to see if they > received a reply from the list, or else, it’s possible to post to the list > without subscribing. (I didn’t think this was possible) If the latter is > the case, then if they don’t subscribe, they won’t get any replies sent > back *only* to the list. The usual tell-tale for this is a newbie posts a > question, several people chime in with answers, and the OP never responds > again. Then they repost the original question. > > Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to > the list AND each sender (depending on the message you are replying to) > which then means those people get multiple copies. I personally don’t care > to deal with duplicates of the same message, so I try to avoid it for > others. But if people can post without subscribing, that means they’ll > never see my reply. (or the reply of anyone else only replying to the list) > Does Nabble allow people to post and not subscribe? Perhaps they are using > Nabble and then loosing track of the thread to see replies? Maybe they > don’t know how to find their own threads? (I’m not a Nabble user) > > Regards, > Adrien > > > On Mar 22, 2018, at 8:01 AM, David Carlson > wrote: > > > > I have noticed an issue on my computer recently that Gmail is not always > > correctly displaying threads from the GnuCash user maillists. I have > > usually been able to find the missing items by scrolling through the > > threads, but then I see all the duplicated text in the replies and I get > > even more confused. > > > > This could be affecting other users as well. > > > > David C > > ___ > > 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. ___ 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: Recent posts and replies missing issues in several GnuCash user threads
> I have noticed an issue on my computer recently that Gmail is not always > correctly displaying threads from the GnuCash user maillists. I have I'm not a Gmail user but I saw a similar thing happening in other situations, not now. a) In case your webmail or email client has the message you want to reply to, use "Reply to list/group" (or similar feature), not "Reply", nor "Compose new", even if you want to change the "Subject" header field. By "changing the subject" I mean this scenario: suppose someone mentions a thing inside topic A, however the thing is not directly related to topic A or is related but in part, so in both cases it might deserve to be in topic B instead, so it goes like this: --8<---cut here---start->8--- A Re: A B (was: A) Re: B Re: A Re: A --8<---cut here---end--->8--- All these items are examples of literal "Subject" lines, including "B (was: A)". b) If you don't have original message file in your webmail client or in your email client, but you know a place where it's archived: see if the archiver tells you about the "Message-ID" of the original message, or if it gives you a link or a button to reply to the message, this link/button must give you a "mailto" URL that should have an "In-Reply-To" header field. In both cases, the strange or often long thing that is in these fields is what tells both mailing list software, email clients, and webmail clients about the "identity" of *current* the message (Message-ID) and of the innermost parent (In-Reply-To). Without "In-Reply-To" a message that has the same "Subject" --- of a supposed parent email --- is actually unthreaded. So in all cases, see if the problematic messages that were already sent have the "In-Reply-To" header field, a "References" field together with the other I just mentioned also helps. For those replying to future messages, be sure to see (a) and (b). -- - https://libreplanet.org/wiki/User:Adfeno - Palestrante e consultor sobre /software/ livre (não confundir com gratis). - "WhatsApp"? Ele não é livre. Por favor, veja formas de se comunicar instantaneamente comigo no endereço abaixo. - Contato: https://libreplanet.org/wiki/User:Adfeno#vCard - Arquivos comuns aceitos (apenas sem DRM): Corel Draw, Microsoft Office, MP3, MP4, WMA, WMV. - Arquivos comuns aceitos e enviados: CSV, GNU Dia, GNU Emacs Org, GNU GIMP, Inkscape SVG, JPG, LibreOffice (padrão ODF), OGG, OPUS, PDF (apenas sem DRM), PNG, TXT, WEBM. ___ 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: Recent posts and replies missing issues in several GnuCash user threads
As noted, I don’t use the Gmail web interface. But macOS Mail doesn’t have it either. (I do miss Thunderbird for that reason) I simply hit reply-all and then delete the individuals’ emails, leaving only the list e-mail. It is annoying as I’d certainly prefer if Mail offered a reply-list option. Otherwise, I might set up a separate mailbox and switch mail clients just for this list, but I’d rather have everything in one place. Regards, Adrien > On Mar 22, 2018, at 1:50 PM, David Carlson > wrote: > > In Gmail I do not see an option to reply-To-List. > > That does seem to be logical if I could figure out how to do it. > > David C > > > On Thu, Mar 22, 2018 at 12:01 PM, Adrien Monteleone > wrote: > I too noticed a change about a month or two ago. Perhaps it was happening > before, but it seems more frequent lately. > > My subscribed address is Gmail, but I use macOS mail client on my desktop so > it’s not a web vs. client issue. > > So far that I can tell, it appears though that the issue may not be Gmail, > but rather people hitting the reply button instead of new/compose. It seems > they are taking the advice to change the subject line appropriately, but that > still breaks the thread. (threading is by message id, not subject text) I > investigated a few such threads by viewing By Thread on the archive page. > Sure enough, subject lines changed in several threads, and it was the same > few users in each case causing the issue. > > What I have noticed as odd is that posts appear to be re-sending. (at least > OPs from newbies) One of these I determined was a real re-post, I didn’t > investigate the others to see if they were in fact re-posted or if the > mailman server was re-sending them. Sometimes this happens for replies too. > So I’ll see a thread, maybe even participate in it, and then 3 days later, > the OP appears again fresh and new. At least in the one case that was an > actual repost, I suspect the OP did not check to see if they received a reply > from the list, or else, it’s possible to post to the list without > subscribing. (I didn’t think this was possible) If the latter is the case, > then if they don’t subscribe, they won’t get any replies sent back *only* to > the list. The usual tell-tale for this is a newbie posts a question, several > people chime in with answers, and the OP never responds again. Then they > repost the original question. > > Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to the > list AND each sender (depending on the message you are replying to) which > then means those people get multiple copies. I personally don’t care to deal > with duplicates of the same message, so I try to avoid it for others. But if > people can post without subscribing, that means they’ll never see my reply. > (or the reply of anyone else only replying to the list) Does Nabble allow > people to post and not subscribe? Perhaps they are using Nabble and then > loosing track of the thread to see replies? Maybe they don’t know how to find > their own threads? (I’m not a Nabble user) > > Regards, > Adrien > > > On Mar 22, 2018, at 8:01 AM, David Carlson > > wrote: > > > > I have noticed an issue on my computer recently that Gmail is not always > > correctly displaying threads from the GnuCash user maillists. I have > > usually been able to find the missing items by scrolling through the > > threads, but then I see all the duplicated text in the replies and I get > > even more confused. > > > > This could be affecting other users as well. > > > > David C > > ___ > > 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. > ___ 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: Recent posts and replies missing issues in several GnuCash user threads
What would really be sweet is for a mail client to offer to allow you to add a message to a thread, or split messages off of a thread. I understand that can be a mess with IDs, but it would just be for your own viewing/use/organization. So far, I’ve not seen any that can do it. (I think some allow you to add individual messages to a thread, but none allow you to remove a mis-threaded message to its own thread) My guess would be that the function to accomplish this would have to alter the message-id/in-reply-to headers and possibly for sanity, set special ‘original message-id/in-reply-to’ headers. It could insert special headers for its own use, but then new sent mail might not thread for others into the proper places. Regards, Adrien > On Mar 22, 2018, at 2:18 PM, Adonay Felipe Nogueira > wrote: > >> I have noticed an issue on my computer recently that Gmail is not always >> correctly displaying threads from the GnuCash user maillists. I have > > I'm not a Gmail user but I saw a similar thing happening in other > situations, not now. > > a) In case your webmail or email client has the message you want to > reply to, use "Reply to list/group" (or similar feature), not > "Reply", nor "Compose new", even if you want to change the "Subject" > header field. > > By "changing the subject" I mean this scenario: suppose someone > mentions a thing inside topic A, however the thing is not directly > related to topic A or is related but in part, so in both cases it > might deserve to be in topic B instead, so it goes like this: > > --8<---cut here---start->8--- > A > Re: A >B (was: A) > Re: B >Re: A > Re: A > --8<---cut here---end--->8--- > > All these items are examples of literal "Subject" lines, including "B > (was: A)". > > b) If you don't have original message file in your webmail client or in > your email client, but you know a place where it's archived: see if > the archiver tells you about the "Message-ID" of the original > message, or if it gives you a link or a button to reply to the > message, this link/button must give you a "mailto" URL that should > have an "In-Reply-To" header field. In both cases, the strange or > often long thing that is in these fields is what tells both mailing > list software, email clients, and webmail clients about the > "identity" of *current* the message (Message-ID) and of the innermost > parent (In-Reply-To). Without "In-Reply-To" a message that has the > same "Subject" --- of a supposed parent email --- is actually > unthreaded. > > So in all cases, see if the problematic messages that were already sent > have the "In-Reply-To" header field, a "References" field together with > the other I just mentioned also helps. For those replying to future > messages, be sure to see (a) and (b). > > -- > - https://libreplanet.org/wiki/User:Adfeno > - Palestrante e consultor sobre /software/ livre (não confundir com > gratis). > - "WhatsApp"? Ele não é livre. Por favor, veja formas de se comunicar > instantaneamente comigo no endereço abaixo. > - Contato: https://libreplanet.org/wiki/User:Adfeno#vCard > - Arquivos comuns aceitos (apenas sem DRM): Corel Draw, Microsoft > Office, MP3, MP4, WMA, WMV. > - Arquivos comuns aceitos e enviados: CSV, GNU Dia, GNU Emacs Org, GNU > GIMP, Inkscape SVG, JPG, LibreOffice (padrão ODF), OGG, OPUS, PDF > (apenas sem DRM), PNG, TXT, WEBM. > ___ > 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: Recent posts and replies missing issues in several GnuCash user threads
Note, you can change the default behavior to ‘reply-all’ instead of 'reply' in your settings if you find it a pain to have to switch. Regards, Adrien > On Mar 22, 2018, at 1:50 PM, David Carlson > wrote: > > In Gmail I do not see an option to reply-To-List. > > That does seem to be logical if I could figure out how to do it. > > David C > > > On Thu, Mar 22, 2018 at 12:01 PM, Adrien Monteleone > wrote: > I too noticed a change about a month or two ago. Perhaps it was happening > before, but it seems more frequent lately. > > My subscribed address is Gmail, but I use macOS mail client on my desktop so > it’s not a web vs. client issue. > > So far that I can tell, it appears though that the issue may not be Gmail, > but rather people hitting the reply button instead of new/compose. It seems > they are taking the advice to change the subject line appropriately, but that > still breaks the thread. (threading is by message id, not subject text) I > investigated a few such threads by viewing By Thread on the archive page. > Sure enough, subject lines changed in several threads, and it was the same > few users in each case causing the issue. > > What I have noticed as odd is that posts appear to be re-sending. (at least > OPs from newbies) One of these I determined was a real re-post, I didn’t > investigate the others to see if they were in fact re-posted or if the > mailman server was re-sending them. Sometimes this happens for replies too. > So I’ll see a thread, maybe even participate in it, and then 3 days later, > the OP appears again fresh and new. At least in the one case that was an > actual repost, I suspect the OP did not check to see if they received a reply > from the list, or else, it’s possible to post to the list without > subscribing. (I didn’t think this was possible) If the latter is the case, > then if they don’t subscribe, they won’t get any replies sent back *only* to > the list. The usual tell-tale for this is a newbie posts a question, several > people chime in with answers, and the OP never responds again. Then they > repost the original question. > > Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to the > list AND each sender (depending on the message you are replying to) which > then means those people get multiple copies. I personally don’t care to deal > with duplicates of the same message, so I try to avoid it for others. But if > people can post without subscribing, that means they’ll never see my reply. > (or the reply of anyone else only replying to the list) Does Nabble allow > people to post and not subscribe? Perhaps they are using Nabble and then > loosing track of the thread to see replies? Maybe they don’t know how to find > their own threads? (I’m not a Nabble user) > > Regards, > Adrien > > > On Mar 22, 2018, at 8:01 AM, David Carlson > > wrote: > > > > I have noticed an issue on my computer recently that Gmail is not always > > correctly displaying threads from the GnuCash user maillists. I have > > usually been able to find the missing items by scrolling through the > > threads, but then I see all the duplicated text in the replies and I get > > even more confused. > > > > This could be affecting other users as well. > > > > David C > > ___ > > 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. > ___ 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: Recent posts and replies missing issues in several GnuCash user threads
On 22 March 2018 at 19:18, Adonay Felipe Nogueira wrote: > ... > b) If you don't have original message file in your webmail client or in >your email client, but you know a place where it's archived: see if >the archiver tells you about the "Message-ID" of the original >message, or if it gives you a link or a button to reply to the >message, this link/button must give you a "mailto" URL that should >have an "In-Reply-To" header field. In both cases, the strange or >often long thing that is in these fields is what tells both mailing >list software, email clients, and webmail clients about the >"identity" of *current* the message (Message-ID) and of the innermost >parent (In-Reply-To). Without "In-Reply-To" a message that has the >same "Subject" --- of a supposed parent email --- is actually >unthreaded. Just for reference I do not believe gmail uses the ID for threading. I believe that it uses just the subject line. Thus adding something like [Solved] to a subject line breaks the thread. Colin ___ 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: Compiling -DWITH_GNUCASH=NO
On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with -DWITH_GNUCASH=NO I pick errors since it seems that libgnucash needs scm/price-quotes.scm which in turn needs scm-gnome-utils which seem to be defined under gnucash/gnome-utils/ but that directory won't be included without WITH_GNUCASH. The error I get is simply: make[2]: *** No rule to make target '/var/tmp/portage/app-office/gnucash-2.7.5-r1/work/ gnucash-2.7.5/libgnucash/scm/scm-gnome-utils', needed by 'lib64/gnucash/scm/ccache/2.2/ gnucash/price-quotes.go'. Stop. How should I build libgnucash without gtk? Thanks, P. For what it's worth, I solved my issue simply removing the target in libgnucash/scm/CMakeLists.txt ___ 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. signature.asc Description: PGP signature ___ 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: Recent posts and replies missing issues in several GnuCash user threads
Unfortunately, this *is* true for the Gmail web interface. (this has no bearing if you use a different client to view your gmail account) This does not affect the actual thread on the Gnucash Mailman server, or any client that uses the message-id, in-reply-to, or references headers. It only affects the Gmail web interface user. Regards, Adrien > On Mar 22, 2018, at 3:40 PM, Colin Law wrote: > > On 22 March 2018 at 19:18, Adonay Felipe Nogueira > wrote: >> ... >> b) If you don't have original message file in your webmail client or in >> your email client, but you know a place where it's archived: see if >> the archiver tells you about the "Message-ID" of the original >> message, or if it gives you a link or a button to reply to the >> message, this link/button must give you a "mailto" URL that should >> have an "In-Reply-To" header field. In both cases, the strange or >> often long thing that is in these fields is what tells both mailing >> list software, email clients, and webmail clients about the >> "identity" of *current* the message (Message-ID) and of the innermost >> parent (In-Reply-To). Without "In-Reply-To" a message that has the >> same "Subject" --- of a supposed parent email --- is actually >> unthreaded. > > Just for reference I do not believe gmail uses the ID for threading. I > believe that it uses just the subject line. Thus adding something > like [Solved] to a subject line breaks the thread. > > Colin > ___ > 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.
Default style sheets default setting
Hello all, I am new to the mailing list and have tried GNUC many years ago. Now I am looking to replace QB with GNUC and running into some issues. To preference this, I am not an accountant or anything near. In fact, My accounting skills are somewhat basic. I have a question on setting the default style sheet. I have created a new one and have it basically customized for my needs but now I would like it to be the default style sheet for my reports and invoices. Whats the best way of doing this? I have been searching around the web for an answer but havent really found one. Thanks for such a great program and I am working hard to improve my book keeping skills. :) Thanks, jdegraw ___ 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: Compiling -DWITH_GNUCASH=NO
Hi Potuz This is clever- would you mind documenting the process to run reports from command line? C On 23/03/18 04:57, Potuz wrote: On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with -DWITH_GNUCASH=NO I pick errors since it seems that libgnucash needs scm/price-quotes.scm which in turn needs scm-gnome-utils which seem to be defined under gnucash/gnome-utils/ but that directory won't be included without WITH_GNUCASH. The error I get is simply: make[2]: *** No rule to make target '/var/tmp/portage/app-office/gnucash-2.7.5-r1/work/ gnucash-2.7.5/libgnucash/scm/scm-gnome-utils', needed by 'lib64/gnucash/scm/ccache/2.2/ gnucash/price-quotes.go'. Stop. How should I build libgnucash without gtk? Thanks, P. For what it's worth, I solved my issue simply removing the target in libgnucash/scm/CMakeLists.txt ___ 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: Compiling -DWITH_GNUCASH=NO
On Mar 23, Christopher Lam wrote: Hi Potuz This is clever- would you mind documenting the process to run reports from command line? I am not running gnucash reports, I wrote my own set of C programs to write tax returns and portfolio performance related reports specialized for Brazilian tax laws. I got a new laptop and I moved to Qt + qtwebengine and since I am on Gentoo I am not keen on compiling gtk+ and certainly not gtk-webkit. This way I now can compile libgnucash (which my programs link) without gnucash Cheers, R. C On 23/03/18 04:57, Potuz wrote: On Mar 22, Potuz wrote: Hello, I have a number of scripts that parse my .gnucash sqlite dbase and produce reports. I'd like to be able to compile and run those programs in a linux system without gtk+ (in particular no gnome and no webkit-gtk). However when I try to compile with -DWITH_GNUCASH=NO I pick errors since it seems that libgnucash needs scm/price-quotes.scm which in turn needs scm-gnome-utils which seem to be defined under gnucash/gnome-utils/ but that directory won't be included without WITH_GNUCASH. The error I get is simply: make[2]: *** No rule to make target '/var/tmp/portage/app-office/gnucash-2.7.5-r1/work/ gnucash-2.7.5/libgnucash/scm/scm-gnome-utils', needed by 'lib64/gnucash/scm/ccache/2.2/ gnucash/price-quotes.go'. Stop. How should I build libgnucash without gtk? Thanks, P. For what it's worth, I solved my issue simply removing the target in libgnucash/scm/CMakeLists.txt signature.asc Description: PGP signature ___ 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.
Check Printing
Hi. I'm looking for a good example of how to specify the font and size of
a line to be printed in a custom .chk file. I know it is specified with
"font_n" ("n" being the line number) but the format of what follows is
what I cannot find any reference to or an example of. Thanks
--
*<< Robert Lewis >>*
___
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: Check Printing
> On Mar 22, 2018, at 9:54 PM, Robert Lewis wrote:
>
> Hi. I'm looking for a good example of how to specify the font and size of
> a line to be printed in a custom .chk file. I know it is specified with
> "font_n" ("n" being the line number) but the format of what follows is
> what I cannot find any reference to or an example of. Thanks
>
> --
> *<< Robert Lewis >>*
https://lists.gnucash.org/docs/C/gnucash-guide/check_format_info.html
says "any string that is acceptable by gtk as a font specifier”
Earlier on that page, it gives the example of “sans 12” as a gtk font
description for the overall font choice. I’ve forgotten what fonts are included
by default in any particular style of gtk installation.
The _n is an object number rather than a line number, as you can have more than
one object per line (and even items that can span more than one line).
Dave
--
Dave Reiser
dbrei...@icloud.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: Recent posts and replies missing issues in several GnuCash user threads
Op vrijdag 23 maart 2018 00:01:05 WIB schreef Adrien Monteleone: > Personally, I reply-to-list. I do not ‘reply-all’. Reply-all will send to > the list AND each sender (depending on the message you are replying to) > which then means those people get multiple copies. I doubt this. I believe mailman is smart enough to send the message only once if the direct mails are also list subscribers. I've been using reply-all for a long time (and I deliberately did so for this message). Do you get it twice ? 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.
Re: Compiling -DWITH_GNUCASH=NO
Op donderdag 22 maart 2018 21:20:19 WIB schreef Potuz: > Hello, I have a number of scripts that parse my .gnucash sqlite dbase and > produce reports. I'd like to be able to compile and run those programs in a > linux system without gtk+ (in particular no gnome and no webkit-gtk). > However when I try to compile with -DWITH_GNUCASH=NO I pick errors since it > seems that libgnucash needs scm/price-quotes.scm which in turn needs > scm-gnome-utils which seem to be defined under gnucash/gnome-utils/ but > that directory won't be included without WITH_GNUCASH. The error I get is > simply: > > make[2]: *** No rule to make target > '/var/tmp/portage/app-office/gnucash-2.7.5-r1/work/ > gnucash-2.7.5/libgnucash/scm/scm-gnome-utils', needed by > 'lib64/gnucash/scm/ccache/2.2/ gnucash/price-quotes.go'. Stop. > > How should I build libgnucash without gtk? Our goal is to make libgnucash independent of gtk. But your experiment shows we're not fully there yet... Can you file this as a bug report ? 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.
Re: Compiling -DWITH_GNUCASH=NO
Op vrijdag 23 maart 2018 06:27:07 WIB schreef Christopher Lam: > Hi Potuz > > This is clever- would you mind documenting the process to run reports > from command line? > > C It's one of my long term goals to separate report generation from report display. That would allow to generate reports from the command line. Ideally this would become part of libgnucash in order to make the report generation platform independent as well (and hence opening the way to make it accessible one day on android or osx platforms). This will only be possible at the cost of moving away from scheme as reporting engine unfortunately as that would not be portable... A huge work and hence long term... 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.
Re: "Unrealized Losses" in Trial Balance Report
HI all, Thanks everyone for your thoughts. Once I see what my accountant does with these foreign currency transactions, I will try entering them back into GnuCash and see what happens. A message from Christopher mentioned stocks and capital gains. I don't have any stocks in my books, but as I mentioned I do have a small gain or loss due to currency conversion. I'm working with my accountant on this. What's so strange about this "Unrealized losses" line that appeared in the trial balance is that it's so much larger than any gain or loss that I have from currency conversion. However, the "Unrealized losses" line could disappear when I account for these currency exchange gains or losses correctly. Adrien asked if I have Trading Accounts enabled. I didn't know about this feature, and I see that I have it turned off. I turned it on and re-generated my Trial Balance, but I didn't see any difference. Cheers, Richard On 23/3/18, 2:25 AM, "gnucash-user on behalf of Adrien Monteleone" wrote: The rounding error I found can be very large depending on the variance between the exchange rate for each transaction and the date of the report. But, I don’t think it affects anything else, because it’s a function of the report, not any math Gnucash otherwise performs. And I’ve never seen this discrepancy anywhere else. Others are using multiple currencies without major issue, so I don’t think overall that there’s any danger. Perhaps someone who routinely uses multiple currencies AND performs Trial Balance reports could weigh in. As for the Unrealized line, do you have Trading Accounts enabled by chance? I’d have to play with it, but perhaps that is why you are seeing that line at all. (I have it on in my book) I don’t know the implications of turning that off once it’s on. One of the more seasoned users or developers would have to chime in. However, you can ‘adjust it out’ if need be. (that’s the purpose of a trial-balance, to determine what if any adjusting entries need to be made) In this case, you won’t be making any actual transaction entries in Gnucash - just on the Trial Balance. Check this out: Trial Balance Total Debits - Trial Balance Total Credits + Unrealized(+Gain, -Loss) = rounding error (or zero if no error) If this equation holds true for your Trial Balance Report, then you are otherwise in balance. If not, then you really do have an error somewhere that you need to correct/adjust for. To determine the actual rounding error, open the foreign currency asset account. Add up all of the entries in the native currency. (If you have Trading Accounts on, you’ll see two debits and credits for each transaction, one in the native currency of the book, and one in the foreign currency of the account) Then subtract balance of this account found on the trial balance. The result is the rounding error. So for example if the sum of your SGD entries is debit S$1100 and the Trial Balance report says the account is really debit S$1000, then the rounding error is S$100. So if the result of Total Debits - Total Credits - Unrealized Loss = S$100, then you are otherwise in balance. I’ve tried several reports to do this math for me to no avail. Probably the closest is the Account report, but that doesn’t give totals in the native currency, only the foreign currency set for that account. I suppose though it would be trivial enough to copy/export to a spreadsheet to generate that figure. My XAG account only has about 10 entries, so I don’t mind doing the calculator math. Regards, Adrien > On Mar 22, 2018, at 4:42 AM, Richard wrote: > > Thanks for your thoughts, Adrien. > > Yes, I do have losses from changes in exchange rates between when I booked a currency and the date of the report. However, these changes were tiny compared to the "Unrealized Losses" figure that appeared in the Trial Balance report. So, while I agree that this report shouldn't show virtual accounts, the bigger question in my mind is, "Where did this number come from?" That's still a mystery to me, but the use of multiple currencies is definitely a trigger. As soon as I remove all transactions in a foreign currency, this line disappears from the report. > > About this rounding bug you described: are you sure this affects only the Trial Balance report? I'm worried that this could cause a lot of other problems. > > It sounds like I have to give up on putting foreign currency transactions in my GnuCash books until these problems are fixed. I see your point that Trial Balances should not be necessary, but I don't think I'm likely to get my accountant to change her ways because GnuCash won't generate the reports she wants, and I'm not quite ready to go looking for a new accountant! > > Thanks, > Richard > > ---
