[GNC] Find by Value No Longer Seems to Work
Hi, I've been using GnuCash for years and generally found it to be excellent. In the past, I have never had any problem with using the Find feature. Now, however, when I try a find-by-value, nothing is ever shown in the results. I enter *Value -> has credits of debits -> equal to -> AMOUNT* and enter an amount that I can see quite clearly in different accounts and nothing is ever shown in the results box. Can anyone suggest what I may be doing wrong? Kind wishes - Patrick ___ 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 First, good luck and hope all goes well. Second, you can 'describe' a custom report by the following process. This uses the gnucash-cli tool. $gnucash-cli -R list This will list all built-in and saved reports, the latter denoted by a 'C'. e.g. * Account Summary * Advanced Portfolio * C Annual Report for Accountant Chris AU * Assets * Assets Over Time * Australian Tax Invoice $gnucash-cli -R show --name "Annual Report for Account Chris AU" This describes the report and the options used. e.g. * name: Annual Report for Accountant Chris AU guid: 49b7979123564c5e944586db82a123e8 parent-template: Transaction Report Display / Num: Disabled Display / Memo: Disabled Sorting / Show Full Account Name: Enabled Sorting / Secondary Subtotal for Date Key: none Sorting / Show Account Description: Enabled Sorting / Secondary Key: date Sorting / Primary Key: account-code Accounts / Accounts: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null Filter / Account Name Filter: ^1 The reason the accounts are null is because the datafile isn't loaded. HTH On Thu, 8 Apr 2021 at 06:32, Michael Hendry wrote: > I’m shortly to undergo surgery, and although I expect to be home in three > or four days, it’ll be several weeks before I’m fully up and running again. > As a retired doctor, I’m well aware that bad stuff can happen during or > after surgery. > > As well as managing my personal accounts, I’m treasurer of a club and two > small charities, and I’d like to be able to prepare a hand-over bundle for > a temporary (or permanent) successor. > > This process should ideally be reversible, so that I can take over again > after my recovery. > > Sharing the .gnucash files is an obvious first step, but I’d need to share > the reports I’ve refined over the years which apply only to one set of > books, along with any other necessary settings. > > There’s some overlap with a 2013 topic “sequential use of Gnucash on > multiple computers”, but I haven’t found any recent references to this. > > Before I reinvent the wheel, does anyone have a ready-to-use solution? > > 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.
[GNC] One bit of spam
Sorry Gals and Guys I've let through one bit of spam. It has got caught in my spam filtering here, so you may or may not see it. I do apologise. 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: [GNC] When Do Account Totals Update When Updating Prices
Jack, I don't exactly have an answer to your question, but I find that such mysterious behaviour goes away sometimes when I do View->Refresh. For instance, when I am switching datafiles, sometimes the accounts page shows all totals as zero (I am on Ubuntu GNC 3.10). All totals reappear when I do the View->Refresh action. Hopefully, this will solve your problem as well. If this doesn't work, I'm afraid I don't have much else to offer you. Cheers, Deva - From: Jack Frillman To: Gnucash Users Subject: [GNC] When Do Account Totals Update When Updating Prices Message-ID: <8b17fa76-f11f-8408-f985-5093b129f...@me.com> Content-Type: text/plain; charset=utf-8; format=flowed I have an IRA account set up where the parent account is a Bank Account and under that are a number of Stock and Mutual Funds accounts. When I update the prices by importing a CSV file the total $ amount for the parent (IRA Account) account does not always update right away. Sometimes it take a while and I'm a bit confused on what's going on. What triggers the account totals to update? -- 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] Ghost Equity Accounts
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 then > opened the register and entered the buy transaction in the usual way. > > All good to this point. > > However, now I find a new account in the Equity hierarchy for the new > commodity: Equity: Opening Balances - XXX > > This account is empty, so I can just delete it, BUT... > > Why is this account getting created? I didn't set up an existing > holding, which might ostensibly have required an opening balances > transaction (but which I would not have done in this way anyhow). And I > didn't explicitly ask for a new equity account to be created. > > Will I get Equity accounts created when I add other kinds of accounts? > I'll note that I also have a new Equity account for a mutual fund > account I added at the same time. But, what about Bank accounts? > Liabilities? And if not, why not? > > And why am I only seeing this NOW? As I've said, I've used GnuCash for a > long long time, and none of the OTHER equities I've created over the > years (and there have been a LOT!) have generated these spurious Equity > accounts. So, why now? > > Finally, Is there some way to NOT have GnuCash create these accounts > every time I create a new Stock or Mutual Fund Account? > > Cheers, > > 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.
[GNC] Advanced portfolio report - same stock in multiple investment accounts
Hi everyone, I am using the advanced portfolio report for tracking multiple investment accounts for family members, less than 20. One major issue I am having is that reporting can be done only by "account" which is the security and no information about account hierarchy is available in the report. As an example, if "user 1" holds MSFT stock in "IRA account" and "IBKR margin account" as well, there is no way to see this info in the AP report. Wondering if there is a way to get parent account information in the AP report. TIA. -- 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 8 Apr 2021, at 10:36, Christopher Lam wrote: > > Michael > First, good luck and hope all goes well. > Second, you can 'describe' a custom report by the following process. This > uses the gnucash-cli tool. > > $gnucash-cli -R list > > This will list all built-in and saved reports, the latter denoted by a 'C'. > e.g. > > * Account Summary > * Advanced Portfolio > * C Annual Report for Accountant Chris AU > * Assets > * Assets Over Time > * Australian Tax Invoice > > $gnucash-cli -R show --name "Annual Report for Account Chris AU" > > This describes the report and the options used. e.g. > > * name: Annual Report for Accountant Chris AU > guid: 49b7979123564c5e944586db82a123e8 > parent-template: Transaction Report > Display / Num: Disabled > Display / Memo: Disabled > Sorting / Show Full Account Name: Enabled > Sorting / Secondary Subtotal for Date Key: none > Sorting / Show Account Description: Enabled > Sorting / Secondary Key: date > Sorting / Primary Key: account-code > Accounts / Accounts: null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null, null, null, null, null, null, null, null, null, null, null, null, > null, null > Filter / Account Name Filter: ^1 > > The reason the accounts are null is because the datafile isn't loaded. > > HTH Thanks, Christopher, That’s an excellent starting point - I’ve been accumulating a lot of custom reports, several of which are duplicates or near duplicates, and this will help me to cull the redundant ones. I think if I rename the reports so that they start with" Book-A”, "Book-B” etc it’ll be clear to whoever is filling in for me which reports relate to his/her organisation, so the one file could be shared by all. Is it possible to merge a set of custom reports into an existing Gnucash installation? What I’m thinking is that I would copy BookX.gnucash along with my .gnucash directory and its contents into ~/Dropbox/BookX and send a Dropbox link to the nominated BookX bookkeeper. This bookkeeper would have to have the appropriate version of Gnucash installed for his/her operating system, and be given appropriate instructions on how to deal with the Dropbox files. Does this sound feasible? Incidentally, gnucash-cli isn’t in my PATH, so I had to run it from: /Applications/Gnucash.app/Contents/MacOS 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.
[GNC] Autofill Oddity
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.
Re: [GNC] Autofill Oddity
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.
Re: [GNC] Autofill Oddity
Apparently the feature to filter accounts described by Robin is something that I do not see in release 3.8. Is that described somewhere in the Help manual? On Thu, Apr 8, 2021 at 1: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. > -- David Carlson ___ 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
It was introduced in 4.0 and described in the release notes like this: • New type-ahead search added to sequential search when selecting an account in the register: Instead of typing the first few characters of a top level account, the separator, the first few characters of the next level account and so on you may instead type a few characters of any part of a full account name and the drop-list will be filtered to contain only matching accounts. Once you have a small enough list you can use the arrow keys to select the account that you want. On Thu, Apr 8, 2021 at 2:56 PM David Carlson wrote: > Apparently the feature to filter accounts described by Robin is something > that I do not see in release 3.8. Is that described somewhere in the Help > manual? > > On Thu, Apr 8, 2021 at 1: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. >> > > > -- > David Carlson > ___ 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, 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.html#:~:text=Migrating%20financial%20data,desired%20path%20from%20within%20GnuCash%20. David Cousens - 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] Advanced portfolio report - same stock in multiple investment accounts
Hi Mike As a workaround, if you structure your accounts like this: Person01 --SecurityA --SecurityB --SecurityC Person02 --SecurityA --SecurityC --SecurityD Person03 --SecurityA --SecurityD --SecurityE etc You can save a separate Advanced Portfolio report for each person by using the Options to select their individual sub-accounts. Then, if you want to see all people's reports on the same page (without grand totals) you can use the Custom Multicolumn Report. Hope this helps. Regards Geoff = On 9/04/2021 12:58 am, mike823 wrote: Hi everyone, I am using the advanced portfolio report for tracking multiple investment accounts for family members, less than 20. One major issue I am having is that reporting can be done only by "account" which is the security and no information about account hierarchy is available in the report. As an example, if "user 1" holds MSFT stock in "IRA account" and "IBKR margin account" as well, there is no way to see this info in the AP report. Wondering if there is a way to get parent account information in the AP report. TIA. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] 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 then >> opened the register and entered the buy transaction in the usual way. >> >> All good to this point. >> >> However, now I find a new account in the Equity hierarchy for the new >> commodity: Equity: Opening Balances - XXX >> >> This account is empty, so I can just delete it, BUT... >> >> Why is this account getting created? I didn't set up an existing >> holding, which might ostensibly have required an opening balances >> transaction (but which I would not have done in this way anyhow). And I >> didn't explicitly ask for a new equity account to be created. >> >> Will I get Equity accounts created when I add other kinds of accounts? >> I'll note that I also have a new Equity account for a mutual fund >> account I added at the same time. But, what about Bank accounts? >> Liabilities? And if not, why not? >> >> And why am I only seeing this NOW? As I've said, I've used GnuCash for a >> long long time, and none of the OTHER equities I've created over the >> years (and there have been a LOT!) have generated these spurious Equity >> accounts. So, why now? >> >> Finally, Is there some way to NOT have GnuCash create these accounts >> every time I create a new Stock or Mutual Fund Account? >> >> Cheers, >> >> 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.
Re: [GNC] Hand-over on Succession or Short Term Absence
> 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.html#:~:text=Migrating%20financial%20data,desired%20path%20from%20within%20GnuCash%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.