[GNC] Find by Value No Longer Seems to Work

2021-04-08 Thread Patrick Skelton
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

2021-04-08 Thread Christopher Lam
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

2021-04-08 Thread Liz
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

2021-04-08 Thread Deva -
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

2021-04-08 Thread D. via gnucash-user
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

2021-04-08 Thread mike823
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

2021-04-08 Thread Michael Hendry
> 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

2021-04-08 Thread David T. via gnucash-user

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

2021-04-08 Thread Robin Chattopadhyay
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

2021-04-08 Thread David Carlson
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

2021-04-08 Thread Robin Chattopadhyay
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

2021-04-08 Thread David Cousens
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

2021-04-08 Thread Geoff

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

2021-04-08 Thread Frank H. Ellenberger
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

2021-04-08 Thread 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.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.