Re: [GNC] Hand-over on Succession or Short Term Absence
Hi Michael, That should work. There is one pitfall with the way saved report configurations are handled in gnucash, but that is in general and not specific to your situation: saved rerport configurations are shared by all your books even though their configuration details may only make sense for one book. To detail if you have multiple books those books may have different accounts (and hence also different account id-numbers internally). If you now save a report configuration in book A, with a selection of accounts from book A, the report will not work properly when opened on book B, as not all accounts from book A would match the accounts from book B. Regards, Geert Op vrijdag 9 april 2021 08:40:45 CEST schreef Michael Hendry: > > On 8 Apr 2021, at 21:28, David Cousens wrote: > > > > Michael, > > > > The location of the saved reports files is OS dependent. Full infor on the > > location sis given at > > https://wiki.gnucash.org/wiki/Configuration_Locations > > although it takes a bit of sorting through but I think the saved reports > > are in USER_DATA_HOME.They are on LInux Mint 20. See also > > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.ht > > ml#:~:text=Migrating%20financial%20data,desired%20path%20from%20within%20G > > nuCash%20. > > > > David Cousens > > That’s very helpful, David, thanks. > > On my Mac, I found the saved reports here: > > ~/Library/Application Support/Gnucash/saved-reports-2.8 > > and I’ve produced an alphabetic list of all the reports using gnucash-cli, > as recommended by Chris Lam. > > Next, I'll clean up duplicate and redundant reports and tidy up inconsistent > naming. > > Am I right in thinking that I could copy and paste a report's definition > from my saved-reports-2.8 file to my successor’s? START COPY FROM HERE: > ;;; > ;; Options for saved report "ESJE Transaction Report to 31/10/2019", based > on template “2fe3b9833af044abb929a88d5a59620f” … > > ) > FINISH COPY HERE > ;;; > ;; Options for saved report "RChBalance Sheet", based on template > “c4173ac99b2b448289bf4d11c731af13" > > If this is a workable method, I could copy all the report definitions for > BookA, BookB and BookC into individual files, ready for copying into > SuccessorA, SuccessorB and SuccessorC’s respective saved-reports-2.8 files. > > Of course, there could be a fatal flaw in my plan which I am too ignorant to > spot… > > 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. ___ 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] Hand-over on Succession or Short Term Absence
> On 9 Apr 2021, at 08:15, Geert Janssens wrote: > > Hi Michael, > > That should work. > > There is one pitfall with the way saved report configurations are handled in > gnucash, but that is in general and not specific to your situation: saved > rerport configurations are shared by all your books even though their > configuration details may only make sense for one book. > To detail if you have multiple books those books may have different accounts > (and hence also different account id-numbers internally). If you now save a > report configuration in book A, with a selection of accounts from book A, the > report will not work properly when opened on book B, as not all accounts > from book A would match the accounts from book B. > > Regards, > > Geert Thanks for your prompt response, Geert. One concern I have is whether the references such as 'based on template “c4173ac99b2b448289bf4d11c731af13”’ would always have the base template to refer to in later versions of GNC, or if this is necessary. I guess I’ll have to suck it and see! 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] Autofill Oddity
This has been happening to me as well since 4.4. It seems input is still being read by GnuCash, but any response to the input (e.g. updating the transfer account list or even echoing the characters typed) is being blocked. I've found that pressing tab to move to the next field, then pressing shift-tab to move back to the transfer account list "fixes" the problem and allows me to type and get autofill working as expected. For me, this is more convenient than reaching for the mouse. Note that GnuCash does not visually respond to tab and shift-tab (e.g. cell highlighting does not update) when it gets into this frozen state. But I'm fairly certain the active fields are changing behind the scenes because the tab + shift-tab sequence seems to reset the transfer account input to a working state. On Thu, Apr 8, 2021 at 2:42 PM Robin Chattopadhyay wrote: > > This happens to me under Ubuntu 20.04 LTS as well (Under several Gnucash > versions up to 4.4, it started around the time the feature to filter > accounts was introduced instead of the previous way of starting at the top > of the tree). > > I have worked around this by clicking the drop-down arrow in the Transfer > column. Then the auto-fill can proceed as 'normal'. > > Robin > > On Thu, Apr 8, 2021 at 11:42 AM David T. via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > Hi, > > > > GnuCash 4.4 under Windows 10. Long time user. > > > > Recent releases have included an update to the Autofill feature, which > > generally is a good thing. However, others have reported strange hitches > > using the new feature under Windows--situations where the register hangs > > and the application appears to stop working. I have also experienced > > these problems, but could not see any specific aspects that would help. > > However, I have now noticed one detail on my machine that may help in > > tracking this down. To wit, when I first start GnuCash, the first > > transaction entered in a register hangs after the user enters the first > > character in the Transfer column. The combo box indicator shows, but > > there is no further indication that anything has happened; the machine > > just stops. The application doesn't respond to keyboard input, but > > clicking elsewhere in the register window causes the Create account > > dialog to display. Cancelling this dialog then brings focus back to the > > Transfer column, the Accounts combo box shows, and all behaves as > > expected. From this point forward, Autofill seems to work as expected. > > > > Best, > > > > David T. > > > > ___ > > 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: [GNC] Hand-over on Succession or Short Term Absence
Michael I have to confess I don't know if you can edit the saved-reports-2.8 file. As it is a text file, it should be OK. I would keep a copy of the original just in case. It may be worth taking a good look at the first and last entries so you can establish the formatting. That looks like it would work from a look at my copy of it David - David Cousens -- 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] Hand-over on Succession or Short Term Absence
> On 9 Apr 2021, at 09:57, David Cousens wrote: > > Michael > I have to confess I don't know if you can edit the saved-reports-2.8 file. > As it is a text file, it should be OK. I would keep a copy of the original > just in case. It may be worth taking a good look at the first and last > entries so you can establish the formatting. That looks like it would work > from a look at my copy of it > David Thanks, David. My plan is to make a virgin installation of Gnucash on my wife’s Windows 10 laptop (which will never actually be used for GNC work) copy BookA.gnucash across, and then edit saved-reports-2.8 to include one of the BookA-specific custom reports. If I get away with that, I’ll copy all my BookA-specific custom reports, and check them out. Thinking about my 11-year learning-curve for GNC, I also have to think about the possibility of exporting GNC books in a form that could be imported by one of the commercial bookkeeping programs so that my successor would hit the ground running with familiar software. (Shocking disloyalty, I realise, but we have to be pragmatic about such things!). 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] Hand-over on Succession or Short Term Absence
Op vrijdag 9 april 2021 09:32:40 CEST schreef Michael Hendry: > > On 9 Apr 2021, at 08:15, Geert Janssens > > wrote: > > > > Hi Michael, > > > > That should work. > > > > There is one pitfall with the way saved report configurations are handled > > in gnucash, but that is in general and not specific to your situation: > > saved rerport configurations are shared by all your books even though > > their configuration details may only make sense for one book. To detail > > if you have multiple books those books may have different accounts (and > > hence also different account id-numbers internally). If you now save a > > report configuration in book A, with a selection of accounts from book A, > > the report will not work properly when opened on book B, as not all > > accounts from book A would match the accounts from book B. > > > > Regards, > > > > Geert > > Thanks for your prompt response, Geert. > > One concern I have is whether the references such as 'based on template > “c4173ac99b2b448289bf4d11c731af13”’ would always have the base template to > refer to in later versions of GNC, or if this is necessary. Hi Michael, Yes, the base template id's shouldn't change in future gnucash versions. Once a report template gets an id (assigned by the developer that creates this report template) it will be fixed. This is not dependent on your installation or your accounting data. The only thing that could possibly happen is when a report template is removed from gnucash. That's equivalent to the report no longer being accessible via the reports menu. For completeness, if you have written your own reports in guile code, they will have their own unique ID. It would be up to you to ensure these handwritten reports get copied to the respective gnucash installations that need them in order for these report template id's to be available. Regards, 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: [GNC] Hand-over on Succession or Short Term Absence
I'll jump in just to say that it is perfectly fine to copy and paste saved report configurations into and out of saved-reports-2.8. For a while, I had a strange problem where my reports file kept being truncated, and I had to copy in my reports numerous times. I've also heard of a user who scripted the startup process to include copying a book-specific set of report configurations into the proper location, so that the reports listed in a given file only applied to that file. The only warning is to be sure of what you cut and paste; the contents of the file are pretty opaque, and it's easy for my eyes to glaze over and copy too little or too much... David T. Original Message From: Michael Hendry Sent: Fri Apr 09 05:48:54 EDT 2021 To: David Cousens Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Hand-over on Succession or Short Term Absence > On 9 Apr 2021, at 09:57, David Cousens wrote: > > Michael > I have to confess I don't know if you can edit the saved-reports-2.8 file. > As it is a text file, it should be OK. I would keep a copy of the original > just in case. It may be worth taking a good look at the first and last > entries so you can establish the formatting. That looks like it would work > from a look at my copy of it > David Thanks, David. My plan is to make a virgin installation of Gnucash on my wife’s Windows 10 laptop (which will never actually be used for GNC work) copy BookA.gnucash across, and then edit saved-reports-2.8 to include one of the BookA-specific custom reports. If I get away with that, I’ll copy all my BookA-specific custom reports, and check them out. Thinking about my 11-year learning-curve for GNC, I also have to think about the possibility of exporting GNC books in a form that could be imported by one of the commercial bookkeeping programs so that my successor would hit the ground running with familiar software. (Shocking disloyalty, I realise, but we have to be pragmatic about such things!). 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. ___ 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] Hand-over on Succession or Short Term Absence
On 4/9/2021 8:34 AM, D. via gnucash-user wrote: I'll jump in just to say Computers do not know who owns them. That means that what you need to do to transfer to another person's computer is in no way different from transferring to another computer that you yourself own. So this is NOT a different question than "how do I transfer my gnucash to my new computer?" which comes up here frequently. How do I transfer gnucash temporarily to somebody else's computer? (so they can do the work while you are out of commission) and then back again afterwards is just "transfer to a new/different computer" twice in succession. Michael D Novack ___ 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] Hand-over on Succession or Short Term Absence
> > Hi Michael, > > Yes, the base template id's shouldn't change in future gnucash versions. Once > a report template gets an id (assigned by the developer that creates this > report template) it will be fixed. This is not dependent on your installation > or your accounting data. The only thing that could possibly happen is when a > report template is removed from gnucash. That's equivalent to the report no > longer being accessible via the reports menu. That’s good news... > > For completeness, if you have written your own reports in guile code, they > will have their own unique ID. It would be up to you to ensure these > handwritten reports get copied to the respective gnucash installations that > need them in order for these report template id's to be available. > > Regards, > > Geert ... and I haven’t dipped my toes into guile, so that constraint won’t affect me. Thanks, 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] Hand-over on Succession or Short Term Absence
> On 9 Apr 2021, at 13:34, D. wrote: > > I'll jump in just to say that it is perfectly fine to copy and paste saved > report configurations into and out of saved-reports-2.8. For a while, I had a > strange problem where my reports file kept being truncated, and I had to copy > in my reports numerous times. I've also heard of a user who scripted the > startup process to include copying a book-specific set of report > configurations into the proper location, so that the reports listed in a > given file only applied to that file. > > The only warning is to be sure of what you cut and paste; the contents of the > file are pretty opaque, and it's easy for my eyes to glaze over and copy too > little or too much... > > David T. A clear example of the carpenter’s motto "Measure twice, cut once”. 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] Hand-over on Succession or Short Term Absence
> On 9 Apr 2021, at 14:27, Michael or Penny Novack > wrote: > > On 4/9/2021 8:34 AM, D. via gnucash-user wrote: >> I'll jump in just to say > > Computers do not know who owns them. > > That means that what you need to do to transfer to another person's computer > is in no way different from transferring to another computer that you > yourself own. So this is NOT a different question than "how do I transfer my > gnucash to my new computer?" which comes up here frequently. Not entirely true, because 1. a new computer will have the default set of reports and my stand-in might (indeed preferably should) be an experience GNC user, with GNC installed and in use already. 2. I’d prefer to transfer only BookA-specific reports to the temporary keeper of BookA.gnucash, and so on. > > How do I transfer gnucash temporarily to somebody else's computer? (so they > can do the work while you are out of commission) and then back again > afterwards is just "transfer to a new/different computer" twice in > succession. Again, not entirely true, because BookA’s temporary book-keeper might write his own new reports during his spell of duty, as might BookB’s and BookC’s, and these would need to be amalgamated into a single file on my recovery, perhaps all at the same time, or perhaps separately (eg if BookA’s year-end was coming up, and its bookkeeper was going to finish off the year before returning control to me). 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] Ghost Equity Accounts
Frank, Thank you for an explanation. I have tested your advice and found it wanting. Here are my observations after a morning of tests: * The new code creates a new equity account whenever the new account has a different currency/commodity than the base currency of the book regardless of the underlying type of the account. Because Stocks and Mutual Funds have a different currency/commodity from the base currency, these are the first times I have seen this. * The Opening Balance setting on the Equity:Opening Balances account has **no effect** on the behavior of this code. New Opening Balances accounts are created under exactly the same circumstances as when this setting is left unchecked. * The new code automatically creates the Opening Balances - XXX account every time an account with a different currency is touched. This includes deleting an account--so, for example, when I created a dummy account that triggered the new equity account creation, deleted the Equity account, and then the dummy account, the new code re-created the equity account before deleting the account for which the equity account was required in the first place. This is truly an ugly corner of this code. I believe the patch needs to be reconsidered more fundamentally to only be invoked on a new file. I don't want the program deciding that I need an equity account for every new asset I add to the account structure. I can't understand why an opening balance equity account is needed for an asset in which I identify the source of the opening balance. There is another problem with the logic in this change, though. In my case, the program created a new equity account-- and then didn't assign any splits to it. That suggests strongly that it shouldn't have created the account in the first place. Finally, to do all this without even a dialog alerting the user of this action is extremely disturbing. I personally don't look at the Equity portion of my account tree very often; I only happened to notice it in a combo box. I repeat my recommendation that this change be limited to new or empty files only. Either that, or the change should be reverted until a better solution is found. As it stands, there is no way I can prevent this stupidity from happening EVERY TIME I ADD A NEW STOCK ACCOUNT. Yikes. David Original Message From: "Frank H. Ellenberger" Sent: Thu Apr 08 23:16:27 EDT 2021 To: "D." , ralf.habac...@freenet.de Cc: Gnucash Users Subject: Re: [GNC] Ghost Equity Accounts Hi David, let me try to explain, but Ralf may correct me: An new account property "Opening Balance" was introduced to avoid some other problems. And each book needs (at least) one account with the property set. While you created the account, the program could not find such an account and created one. You should be able to avoid this behaviour by marking your existing [Equity:]"Opening Balance" – whatever it is named – with the flag in Edit Account. Probably the current checks should be improved in a few ways: Run only on file load or delete of the last as Opening balance marked account. Instead of automaticly creation display a dialog with the list of current equity accounts ands ask to select or create one, which gets the flag set. Finally it should be documented in https://github.com/Gnucash/gnucash-docs/blob/maint/help/C/Help_ch_Account-Actions.xml and probably other places. Regards Frank Am 08.04.21 um 14:30 schrieb D.: > Frank, > > We should keep this on the list. > > I've read through this bug, and a related bug mentioned in the comments > there, and I admit I do not understand the various points of the discussions > there. > > If my experience can be explained by these changes, though, I'd like to point > out that in my use case, I am neither attempting to use the New Account > Hierarchy nor creating a new file. I am simply creating a new account in my > existing CoA. I am adding a comment to that bug to have my problem considered > in relation to it. > > David T. > > > Original Message > From: "Frank H. Ellenberger" > Sent: Thu Apr 08 02:05:32 EDT 2021 > To: "David T." > Subject: Re: [GNC] Ghost Equity Accounts > > Hi David, > > I suspect, it could be related to > https://bugs.gnucash.org/show_bug.cgi?id=798070 and its ancestor. > > Regards > Frank > > Am 08.04.21 um 03:28 schrieb David T. via gnucash-user: >> Hello, >> >> I thought I saw something about this not too long ago, but cannot put my >> finger on the thread. >> >> I am using GC4.4 on Windows 10, and have been using GnuCash since 2005. >> >> Basically, I recently purchased shares of a new stock, and I followed my >> usual procedure in GnuCash: I created a new asset account of type Stock >> for the new equity under my brokerage account (Assets:Brokerage:XXX >> Stock). While creating the account, I used the new commodity option to >> create the entry in the security database. Having done this, I the
Re: [GNC] Autofill Oddity
Thanks everyone. So it would appear that the new Type ahead (I am using the appropriate terminology here) code has an initialization problem that numerous users have observed. I have submitted bug 798162 to document this. David T. Original Message From: Evelyn Yamanaka Sent: Fri Apr 09 04:20:56 EDT 2021 To: Robin Chattopadhyay Cc: "David T." , Gnucash Users Subject: Re: [GNC] Autofill Oddity This has been happening to me as well since 4.4. It seems input is still being read by GnuCash, but any response to the input (e.g. updating the transfer account list or even echoing the characters typed) is being blocked. I've found that pressing tab to move to the next field, then pressing shift-tab to move back to the transfer account list "fixes" the problem and allows me to type and get autofill working as expected. For me, this is more convenient than reaching for the mouse. Note that GnuCash does not visually respond to tab and shift-tab (e.g. cell highlighting does not update) when it gets into this frozen state. But I'm fairly certain the active fields are changing behind the scenes because the tab + shift-tab sequence seems to reset the transfer account input to a working state. On Thu, Apr 8, 2021 at 2:42 PM Robin Chattopadhyay wrote: > > This happens to me under Ubuntu 20.04 LTS as well (Under several Gnucash > versions up to 4.4, it started around the time the feature to filter > accounts was introduced instead of the previous way of starting at the top > of the tree). > > I have worked around this by clicking the drop-down arrow in the Transfer > column. Then the auto-fill can proceed as 'normal'. > > Robin > > On Thu, Apr 8, 2021 at 11:42 AM David T. via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > Hi, > > > > GnuCash 4.4 under Windows 10. Long time user. > > > > Recent releases have included an update to the Autofill feature, which > > generally is a good thing. However, others have reported strange hitches > > using the new feature under Windows--situations where the register hangs > > and the application appears to stop working. I have also experienced > > these problems, but could not see any specific aspects that would help. > > However, I have now noticed one detail on my machine that may help in > > tracking this down. To wit, when I first start GnuCash, the first > > transaction entered in a register hangs after the user enters the first > > character in the Transfer column. The combo box indicator shows, but > > there is no further indication that anything has happened; the machine > > just stops. The application doesn't respond to keyboard input, but > > clicking elsewhere in the register window causes the Create account > > dialog to display. Cancelling this dialog then brings focus back to the > > Transfer column, the Accounts combo box shows, and all behaves as > > expected. From this point forward, Autofill seems to work as expected. > > > > Best, > > > > David T. > > > > ___ > > 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: [GNC] asset discrepancy in change of year
Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam < christopher@gmail.com> ha scritto: > > There is some discussion in an unusually detailed bug report > https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in > GnuCash's transaction currency being permitted to be any currency. e.g. if > your home currency is USD, but transfer GBP to EUR, the UI will record only > GBP/EUR fx. The new method would enforce the transaction currency to be USD > therefore your GBP->EUR would require GBP/USD and EUR/USD fx rates. Thus, > w.r.t. USD, all fx gains/losses are recorded accurately. > > To fix this would be an enormous amount of work and invalidate a lot of > code, but would definitely simplify and fix a lot of code too IMHO. > Does it apply also to mutual funds purchased in a foreign currency? For example,I operate in EUR, I change a given amount to USD and use it to purchase a USD-denominated fund. Will gnucash with the "trading account" option enabled record everything correctly or is it just the scenario mentioned in the bugreport? Also, by enabling trading account in the 2020 file, I managed to precisely account for the discrepancy in capital at end of year / beginning of year. Should I close this amount to my Capital:EUR account or can I just carry it forward in the trading account for 2021? I've tried entering a transaction in the trading account but it was left unbalanced, so I gave up. Thanks, Andrea. ___ 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] Proper way to record receiving a commission check
What is the "GnuCash" way of properly recording what will be a monthly commission check that I will be receiving. Rick ___ 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] asset discrepancy in change of year
> On Apr 9, 2021, at 9:37 AM, Andrea Borgia wrote: > > Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam < > christopher@gmail.com> ha scritto: > > >> >> There is some discussion in an unusually detailed bug report >> https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in >> GnuCash's transaction currency being permitted to be any currency. e.g. if >> your home currency is USD, but transfer GBP to EUR, the UI will record only >> GBP/EUR fx. The new method would enforce the transaction currency to be USD >> therefore your GBP->EUR would require GBP/USD and EUR/USD fx rates. Thus, >> w.r.t. USD, all fx gains/losses are recorded accurately. >> >> To fix this would be an enormous amount of work and invalidate a lot of >> code, but would definitely simplify and fix a lot of code too IMHO. >> > > Does it apply also to mutual funds purchased in a foreign currency? > For example,I operate in EUR, I change a given amount to USD and use it to > purchase a USD-denominated fund. > Will gnucash with the "trading account" option enabled record everything > correctly or is it just the scenario mentioned in the bugreport? > > > Also, by enabling trading account in the 2020 file, I managed to precisely > account for the discrepancy in capital at end of year / beginning of year. > Should I close this amount to my Capital:EUR account or can I just carry it > forward in the trading account for 2021? I've tried entering a transaction > in the trading account but it was left unbalanced, so I gave up. > That's exactly the scenario discussed in bug 797796 except that the primary interlocutor's home currency is CAD rather than EUR. You need to create a capital gains transaction as explained in https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html. 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] Proper way to record receiving a commission check
Hi Rick, What about setting it up as a scheduled transaction and then it's automatic? On Fri, Apr 9, 2021 at 1:02 PM Rick Mobley wrote: > What is the "GnuCash" way of properly recording what will be a monthly > commission check that I will be receiving. > > > > Rick > > > > ___ > 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.
[GNC] Tracking Precious Metals
What's the best way of tracking the value of your silver and gold holdings in GNUCash? I guess I would have a Asset account but what do you when the process of an oz. varies like a stock does? -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ 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] Tracking Precious Metals
> On Apr 9, 2021, at 1:36 PM, Jack Frillman via gnucash-user > wrote: > > > What's the best way of tracking the value of your silver and gold holdings in > GNUCash? > > I guess I would have a Asset account but what do you when the process of an > oz. varies like a stock does? You treat it just like a stock. https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html 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.
[GNC] Help with Gnucash 4.5 installation problem
Hello to Whom this concerns: I just installed Gnucash 4.5 (latest) on my Windows 10 computer. However, it does not show up in the start menu and list of Windows installed programmes. I have restarted the computer and reinstalled several times but still cannot see Gnucash in the list of software programmes. What can I do to start the programme? (I have IOBit Uninstaller installed and this programme gave me a message onscreen that Gnucash 4.5 was installed after I performed the installation.) Is this a bug or can anyone offer some help? David. davidjag...@gmail.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] Help with Gnucash 4.5 installation problem
Did you accept all the defaults presented by the installer? On Fri, Apr 9, 2021, 3:58 PM David Jaggar wrote: > Hello to Whom this concerns: > I just installed Gnucash 4.5 (latest) on my Windows 10 computer. However, > it does not show up in the start menu and list of Windows installed > programmes. I have restarted the computer and reinstalled several times but > still cannot see Gnucash in the list of software programmes. What can I do > to start the programme? (I have IOBit Uninstaller installed and this > programme gave me a message onscreen that Gnucash 4.5 was installed after I > performed the installation.) > Is this a bug or can anyone offer some help? > David. > davidjag...@gmail.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 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] Help with Gnucash 4.5 installation problem
> On Apr 8, 2021, at 3:22 AM, David Jaggar wrote: > > Hello to Whom this concerns: > I just installed Gnucash 4.5 (latest) on my Windows 10 computer. However, > it does not show up in the start menu and list of Windows installed > programmes. I have restarted the computer and reinstalled several times but > still cannot see Gnucash in the list of software programmes. What can I do > to start the programme? (I have IOBit Uninstaller installed and this > programme gave me a message onscreen that Gnucash 4.5 was installed after I > performed the installation.) > Is this a bug or can anyone offer some help? The installer has two checkboxes in the last frame to create shortcuts on the desktop and the start menu. Having unchecked both of them would explain why the shortcuts are there but not why GnuCash 4.5 doesn't appear in Settings>Apps & Features. Is the program installed where you told the installer to put it (the default is C:\Program Files (x86)\gnucash)? If it is you can launch it by navigating there in Windows File Explorer and double-clicking on bin\gnucash.exe. As long as that works you can create your own shortcut and put it wherever you like. 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] Tracking Precious Metals
Then how do you set it up since silver or gold doesn't have ticker symbol? On 4/9/21 4:47 PM, John Ralls wrote: On Apr 9, 2021, at 1:36 PM, Jack Frillman via gnucash-user wrote: What's the best way of tracking the value of your silver and gold holdings in GNUCash? I guess I would have a Asset account but what do you when the process of an oz. varies like a stock does? You treat it just like a stock. https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html Regards, John Ralls -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ 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] Tracking Precious Metals
On Fri, Apr 9, 2021 at 4:33 PM Jack Frillman via gnucash-user < gnucash-user@gnucash.org> wrote: > Then how do you set it up since silver or gold doesn't have ticker symbol? > In GnuCash, choose “Currency” as the “Type” (in account setup) or "Namespace" (in the price editor), and “XAG" (silver) or "XAU" (gold) as the "currency" — all the precious metals are given codes starting with "X". ___ 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] CPAs: Your opinion about Equity account in other currencies than the domestic
Hi all, IIRC having equity account in something else than the domestic (book) currency is discouraged. Can some experts (CPA etc.) explain the details? I see currently only a pragmatical use case: While I create my inventory I record only the number of shares as a reminder and later, after finding the recipe or another reliable prize source, replace the record by one containing the real prize. For the records: David opended https://bugs.gnucash.org/show_bug.cgi?id=798163 - Equity Accounts Creation for different commodities about this issue. The motivation for the original change can be read in https://bugs.gnucash.org/show_bug.cgi?id=797836 - Add support for specifying an opening balance account Regards Frank Am 09.04.21 um 17:23 schrieb D.: > Frank, > > Thank you for an explanation. I have tested your advice and found it wanting. > > Here are my observations after a morning of tests: > > * The new code creates a new equity account whenever the new account has a > different currency/commodity than the base currency of the book regardless of > the underlying type of the account. Because Stocks and Mutual Funds have a > different currency/commodity from the base currency, these are the first > times I have seen this. > > * The Opening Balance setting on the Equity:Opening Balances account has **no > effect** on the behavior of this code. New Opening Balances accounts are > created under exactly the same circumstances as when this setting is left > unchecked. > > * The new code automatically creates the Opening Balances - XXX account every > time an account with a different currency is touched. This includes deleting > an account--so, for example, when I created a dummy account that triggered > the new equity account creation, deleted the Equity account, and then the > dummy account, the new code re-created the equity account before deleting the > account for which the equity account was required in the first place. This is > truly an ugly corner of this code. > > I believe the patch needs to be reconsidered more fundamentally to only be > invoked on a new file. I don't want the program deciding that I need an > equity account for every new asset I add to the account structure. I can't > understand why an opening balance equity account is needed for an asset in > which I identify the source of the opening balance. > > There is another problem with the logic in this change, though. In my case, > the program created a new equity account-- and then didn't assign any splits > to it. That suggests strongly that it shouldn't have created the account in > the first place. > > Finally, to do all this without even a dialog alerting the user of this > action is extremely disturbing. I personally don't look at the Equity portion > of my account tree very often; I only happened to notice it in a combo box. > > I repeat my recommendation that this change be limited to new or empty files > only. Either that, or the change should be reverted until a better solution > is found. As it stands, there is no way I can prevent this stupidity from > happening EVERY TIME I ADD A NEW STOCK ACCOUNT. > > Yikes. > > David ___ 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] Upgrade to V4.5
I have a very basic question; it reflects my computing level. I am currently using Gnucash V4.4 on a Windows 10 computer and want to upgrade to the latest version on the same computer. I have read the upgrade information on Nabble but was unable to decide whether the best method is to just install V4.5 over V4.4 or to uninstall V4.4 and then install V4.5. I just use Gnucash for bookkeeping and investment stock records. At this stage I just manually update commodity prices and banking data so i am not worried about setting up my preferences and few reports again. Peter ___ 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] Upgrade to V4.5
My upgrade strategy on Windows is always the same and has never caused any problems... 1. Backup your Gnucash data file. 2. Download new Gnucash file and double click on it to start the process. 3. Let Gnucash uninstall the current version and then install the new version - no need to do the uninstall beforehand. 4. Start using it :-) Cheers David H. On Sat, 10 Apr 2021 at 15:52, Peter Williamson wrote: > I have a very basic question; it reflects my computing level. > > I am currently using Gnucash V4.4 on a Windows 10 computer and want to > upgrade to the latest version on the same computer. > > I have read the upgrade information on Nabble but was unable to decide > whether the best method is to just install V4.5 over V4.4 or to uninstall > V4.4 and then install V4.5. > > I just use Gnucash for bookkeeping and investment stock records. > > At this stage I just manually update commodity prices and banking data so > i am not worried about setting up my preferences and few reports again. > > Peter > ___ > 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] Upgrade to V4.5
Hi David Thanks for your very clear answer. It is very much appreciated. Peter > On 10 April 2021 at 18:02 David H wrote: > > My upgrade strategy on Windows is always the same and has never caused > any problems... > > 1. Backup your Gnucash data file. > 2. Download new Gnucash file and double click on it to start the process. > 3. Let Gnucash uninstall the current version and then install the new > version - no need to do the uninstall beforehand. > 4. Start using it :-) > > Cheers David H. > > > On Sat, 10 Apr 2021 at 15:52, Peter Williamson < pwan...@xtra.co.nz > mailto:pwan...@xtra.co.nz > wrote: > > > > I have a very basic question; it reflects my computing level. > > > > I am currently using Gnucash V4.4 on a Windows 10 computer and want > > to upgrade to the latest version on the same computer. > > > > I have read the upgrade information on Nabble but was unable to > > decide whether the best method is to just install V4.5 over V4.4 or to > > uninstall V4.4 and then install V4.5. > > > > I just use Gnucash for bookkeeping and investment stock records. > > > > At this stage I just manually update commodity prices and banking > > data so i am not worried about setting up my preferences and few reports > > again. > > > > Peter > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org mailto: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] Upgrade to V4.5
Hi Peter, I've never actually needed the backup file but you never know :-) Cheers David H. On Sat, 10 Apr 2021 at 16:39, Peter Williamson wrote: > Hi David > > Thanks for your very clear answer. It is very much appreciated. > > Peter > > On 10 April 2021 at 18:02 David H wrote: > > My upgrade strategy on Windows is always the same and has never caused any > problems... > > 1. Backup your Gnucash data file. > 2. Download new Gnucash file and double click on it to start the process. > 3. Let Gnucash uninstall the current version and then install the new > version - no need to do the uninstall beforehand. > 4. Start using it :-) > > Cheers David H. > > > On Sat, 10 Apr 2021 at 15:52, Peter Williamson < pwan...@xtra.co.nz> > wrote: > > I have a very basic question; it reflects my computing level. > > I am currently using Gnucash V4.4 on a Windows 10 computer and want to > upgrade to the latest version on the same computer. > > I have read the upgrade information on Nabble but was unable to decide > whether the best method is to just install V4.5 over V4.4 or to uninstall > V4.4 and then install V4.5. > > I just use Gnucash for bookkeeping and investment stock records. > > At this stage I just manually update commodity prices and banking data so > i am not worried about setting up my preferences and few reports again. > > Peter > ___ > 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.
