Re: [GNC] Gnucash terminal commands not working & e-mail reply to all

2021-05-12 Thread David H
Oh and the FQ stuff is in .../Contents/Resources/bin and don't forget the
forward slash "/" :-)

Cheers David H.

On Thu, 13 May 2021 at 12:03, David H  wrote:

> Assuming you installed gnucash in your usual applications folder, in a
> terminal window (zsh) try 
>
> /Applications/Gnucash.app/Contents/MacOS/gnucash-cli
>
> /Applications/Gnucash.app/Contents/MacOS/gnucash --version
>
>
> You can see & expand these paths by right clicking on gnucash.app in
> Finder and clicking "Show Package Contents" and then expanding the various
> folders to find these...
>
>
> Can't help with your email issue as I don't use it :-)
>
> Cheers David H.
>
>
>
> On Thu, 13 May 2021 at 11:35,  wrote:
>
>> Using Mac OS 10.15.7, Gnucash 4.4-2, F:Q 1.47 Aqbanking ? (whatever came
>> with GC 4.4)
>>
>> First, I am not a computer person and know just enough to get myself in
>> trouble.  I have used the commands in the wiki to test finding GC version,
>> Aq banking version, to get quote for XAU, and to open GnuCash from the
>> terminal.  For the versions I would get “command not found”; and to open
>> GnuCash I got “unable to find application GnuCash.   The commands and
>> results are as follows:
>>
>> dwa1:~ dwa1$ gnucash --version
>> -bash: gnucash: command not found
>> dwa1:~ dwa1$ aqbanking-cli versions
>> -bash: aqbanking-cli: command not found
>> dwa1:~ dwa1$ flatpak run --command=sh org.gnucash.GnuCash
>> -bash: flatpak: command not found
>> dwa1:~ dwa1$ cd gnucash
>> -bash: cd: gnucash: No such file or directory
>> dwa1:~ dwa1$ cd \applications\gnucash
>> -bash: cd: applicationsgnucash: No such file or directory
>> dwa1:~ dwa1$ cd \applications
>> dwa1:applications dwa1$ gnucash --version
>> -bash: gnucash: command not found
>>
>> dwa1@dwa1 ~ % gnc-fq-dump -v alphavantage XAU
>> zsh: command not found: gnc-fq-dump
>> dwa1@dwa1 ~ % cd applications
>> dwa1@dwa1 applications % gnc-fq-dump -v alphavantage XAU
>> zsh: command not found: gnc-fq-dump
>> dwa1@dwa1 applications %
>>
>> dwa1@dwa1 ~ % cd applications
>> dwa1@dwa1 applications % open -a Gnucash --args Our GnuCash Data.gnucash
>> Unable to find application named ‘Gnucash'
>>
>> I tried changing directories to the application directory where GC is to
>> see if that helped.  Also between the first series and the second I changed
>> the shell that terminal said I should be using (from bash to zsh whatever
>> that means)
>>
>> I looked through the wiki and help manual and didn’t find anything that
>> helped.  Also tried going through mail list archives.  What am i missing?
>>
>> Second point is “reply to all” in an e-mail series on the mail list.  I’m
>> using the MAC mail program V13.4.  In normal e-mails I can hit reply to
>> all, but with the mail list when I double click to bring up an e-mail to
>> respond to, the reply to is greyed out.  In order to send to all in the
>> string I would have to copy and paste each e-mail address in my e-mail.
>> Again, what am  I doing wrong?
>>
>> These are probably some basic computer things that I don’t know and may
>> be wasting your time and if so I apologize.  Thanks for any help.
>> ___
>> 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] Gnucash terminal commands not working & e-mail reply to all

2021-05-12 Thread David H
Assuming you installed gnucash in your usual applications folder, in a
terminal window (zsh) try 

/Applications/Gnucash.app/Contents/MacOS/gnucash-cli

/Applications/Gnucash.app/Contents/MacOS/gnucash --version


You can see & expand these paths by right clicking on gnucash.app in Finder
and clicking "Show Package Contents" and then expanding the various folders
to find these...


Can't help with your email issue as I don't use it :-)

Cheers David H.



On Thu, 13 May 2021 at 11:35,  wrote:

> Using Mac OS 10.15.7, Gnucash 4.4-2, F:Q 1.47 Aqbanking ? (whatever came
> with GC 4.4)
>
> First, I am not a computer person and know just enough to get myself in
> trouble.  I have used the commands in the wiki to test finding GC version,
> Aq banking version, to get quote for XAU, and to open GnuCash from the
> terminal.  For the versions I would get “command not found”; and to open
> GnuCash I got “unable to find application GnuCash.   The commands and
> results are as follows:
>
> dwa1:~ dwa1$ gnucash --version
> -bash: gnucash: command not found
> dwa1:~ dwa1$ aqbanking-cli versions
> -bash: aqbanking-cli: command not found
> dwa1:~ dwa1$ flatpak run --command=sh org.gnucash.GnuCash
> -bash: flatpak: command not found
> dwa1:~ dwa1$ cd gnucash
> -bash: cd: gnucash: No such file or directory
> dwa1:~ dwa1$ cd \applications\gnucash
> -bash: cd: applicationsgnucash: No such file or directory
> dwa1:~ dwa1$ cd \applications
> dwa1:applications dwa1$ gnucash --version
> -bash: gnucash: command not found
>
> dwa1@dwa1 ~ % gnc-fq-dump -v alphavantage XAU
> zsh: command not found: gnc-fq-dump
> dwa1@dwa1 ~ % cd applications
> dwa1@dwa1 applications % gnc-fq-dump -v alphavantage XAU
> zsh: command not found: gnc-fq-dump
> dwa1@dwa1 applications %
>
> dwa1@dwa1 ~ % cd applications
> dwa1@dwa1 applications % open -a Gnucash --args Our GnuCash Data.gnucash
> Unable to find application named ‘Gnucash'
>
> I tried changing directories to the application directory where GC is to
> see if that helped.  Also between the first series and the second I changed
> the shell that terminal said I should be using (from bash to zsh whatever
> that means)
>
> I looked through the wiki and help manual and didn’t find anything that
> helped.  Also tried going through mail list archives.  What am i missing?
>
> Second point is “reply to all” in an e-mail series on the mail list.  I’m
> using the MAC mail program V13.4.  In normal e-mails I can hit reply to
> all, but with the mail list when I double click to bring up an e-mail to
> respond to, the reply to is greyed out.  In order to send to all in the
> string I would have to copy and paste each e-mail address in my e-mail.
> Again, what am  I doing wrong?
>
> These are probably some basic computer things that I don’t know and may be
> wasting your time and if so I apologize.  Thanks for any help.
> ___
> 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] Url and file links in scheduled transactions.

2021-05-12 Thread David Carlson
I have not figured out how to attach a url or a file link to a scheduled
transaction.   Is that possible?
___
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] Gnucash terminal commands not working & e-mail reply to all

2021-05-12 Thread smada46
Using Mac OS 10.15.7, Gnucash 4.4-2, F:Q 1.47 Aqbanking ? (whatever came with 
GC 4.4)

First, I am not a computer person and know just enough to get myself in 
trouble.  I have used the commands in the wiki to test finding GC version, Aq 
banking version, to get quote for XAU, and to open GnuCash from the terminal.  
For the versions I would get “command not found”; and to open GnuCash I got 
“unable to find application GnuCash.   The commands and results are as follows:

dwa1:~ dwa1$ gnucash --version
-bash: gnucash: command not found
dwa1:~ dwa1$ aqbanking-cli versions
-bash: aqbanking-cli: command not found
dwa1:~ dwa1$ flatpak run --command=sh org.gnucash.GnuCash
-bash: flatpak: command not found
dwa1:~ dwa1$ cd gnucash
-bash: cd: gnucash: No such file or directory
dwa1:~ dwa1$ cd \applications\gnucash
-bash: cd: applicationsgnucash: No such file or directory
dwa1:~ dwa1$ cd \applications
dwa1:applications dwa1$ gnucash --version
-bash: gnucash: command not found

dwa1@dwa1 ~ % gnc-fq-dump -v alphavantage XAU
zsh: command not found: gnc-fq-dump
dwa1@dwa1 ~ % cd applications
dwa1@dwa1 applications % gnc-fq-dump -v alphavantage XAU
zsh: command not found: gnc-fq-dump
dwa1@dwa1 applications % 

dwa1@dwa1 ~ % cd applications
dwa1@dwa1 applications % open -a Gnucash --args Our GnuCash Data.gnucash
Unable to find application named ‘Gnucash'

I tried changing directories to the application directory where GC is to see if 
that helped.  Also between the first series and the second I changed the shell 
that terminal said I should be using (from bash to zsh whatever that means)

I looked through the wiki and help manual and didn’t find anything that helped. 
 Also tried going through mail list archives.  What am i missing?

Second point is “reply to all” in an e-mail series on the mail list.  I’m using 
the MAC mail program V13.4.  In normal e-mails I can hit reply to all, but with 
the mail list when I double click to bring up an e-mail to respond to, the 
reply to is greyed out.  In order to send to all in the string I would have to 
copy and paste each e-mail address in my e-mail.  Again, what am  I doing wrong?

These are probably some basic computer things that I don’t know and may be 
wasting your time and if so I apologize.  Thanks for any help.
___
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] What is the current GnuCash version and...

2021-05-12 Thread David Carlson
Fran,

Since you are using Windows, the Windows installer will automatically
remove the current version and install the new version.

If you had done a non-standard installation that might not work smoothly,
but it will leave your saved report settings, window sizes, etc. intact.  I
believe there may be an issue with selecting accounts if you are building
new transactions in that particular release - see "[Bug 798061] Quickfill
for account splits on Windows: input freeze if more than 2 characters are
typed" for info.  If that will affect you, you may want to wait for the
next release before updating.

On Wed, May 12, 2021 at 7:51 PM Glenn Fowler  wrote:

> Hi,
>
> The current version is 4.5 which you can d/l here:
> https://www.gnucash.org/download.phtml
>
> You shouldn't have any issues upgrading from 4.1 to 4.5 since it's not a
> major release change as detailed here:
>
> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
>
> On Wed, May 12, 2021 at 8:04 PM Fran_3 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > Running Version: 4.1
> > Build ID: 4.1+(2020-07-25)here on  Windows 10 system
> > What is the latest version and can I just download it and install it or
> > should I remove the old version first... or what proceedure?
> > Thanks for any help.
> > ___
> > 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] What is the current GnuCash version and...

2021-05-12 Thread Glenn Fowler
Hi,

The current version is 4.5 which you can d/l here:
https://www.gnucash.org/download.phtml

You shouldn't have any issues upgrading from 4.1 to 4.5 since it's not a
major release change as detailed here:
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade

On Wed, May 12, 2021 at 8:04 PM Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Running Version: 4.1
> Build ID: 4.1+(2020-07-25)here on  Windows 10 system
> What is the latest version and can I just download it and install it or
> should I remove the old version first... or what proceedure?
> Thanks for any help.
> ___
> 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] What is the current GnuCash version and...

2021-05-12 Thread Fran_3 via gnucash-user
Running Version: 4.1
Build ID: 4.1+(2020-07-25)here on  Windows 10 system
What is the latest version and can I just download it and install it or should 
I remove the old version first... or what proceedure?
Thanks for any help.
___
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] Need Transaction Report on Checking to show only Debits

2021-05-12 Thread Fran_3 via gnucash-user
 Matt, thanks for the reply.
Note that all withdrawals from Checking are not charged to Expense Accounts so 
that wouldn't pick up all withdrawals.
I can export the checking range I want to work on and do all this in a 
spreadsheet however so no worries.
Thanks


On Wednesday, May 12, 2021, 4:43:51 AM EDT, Maf. King  
wrote:  
 
 On Tuesday, 11 May 2021 13:41:04 BST Fran_3 via gnucash-user wrote:
> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.
> ___

Hi,

use the Filter... settings on the "accounts" tab of the report options.

so run the report on the Checking account, and then in the lower half of the 
accounts tab  Filter by say only Expense accounts.

HTH,
Maf.



  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Need Transaction Report on Checking to show only Debits

2021-05-12 Thread Fran_3 via gnucash-user
 This almost worked for what I wanted but it gave me a double line for each 
transaction... 
line 1: the goes in account line 2: and the goes out account
As opposed to when I simply run a Transaction Report on Checking... I can get 
one line per transaction.
I can, of course, export the checking account and do this in a spreadshet... 
but I thought I could previously do it via a Transaction Report.
That said, I've been away from gnuCash for months... maybe a year... and just 
got called back to do some work... so I'm learning all over again.
I do appreciate the help folks. Thanks!



On Tuesday, May 11, 2021, 10:44:24 PM EDT, Geoff  
wrote:  
 
 Hi Fran

Since it is only for a single account, here is a slightly long winded 
way to do it:

1. Open the Account
2. Do a Find specifying Debit (or Credit) values only
3. Run the Account Report on the search results.

See attached screenshot.

Hope this helps.

Regards

Geoff
=

On 12/05/2021 9:22 am, Fran_3 via gnucash-user wrote:
>  What are txns? Transactions?
> I sorted the Transaction Report by "amount" but I don't know how to limit the 
> output to values greater than zero... or to values less than zero.
> Do I do that on the Filter tab? And if so how?
> If its Regular Expressions my eyes just rolled back in my head :-)
> Thanks for  the help.
> 
> 
>      On Tuesday, May 11, 2021, 12:17:52 PM EDT, Fred Bone 
> wrote:
>  
>  On 11 May 2021 at 12:41, Fran_3 said:
> 
>> How can I create a Transaction Report on the Checking AccountAnd show only
>> Debits?Or show only Credits? Thanks for any help.
> 
> Start by selecting only the relevant txns, perhaps?
> e.g. Value has debits greater than 0.00
> 
> 
> 
> ___
> 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] Equity Accounts - Opening Balance or no?

2021-05-12 Thread David Cousens
Troy
Please use Reply List or Reply All when replying to the User forum mail
messages. This allows other users to benefit from the dialogues

Assuming your file/book has been started before or concurrently with your
business then yes. You would then record the contributions and draws as normal
transactions as they occur (or backdated appropriately where necessary - for
example I paid a lot of the setup costs for my business out of personal funds as
I had no business accountsor accounting initially, then included them as owner
contributions once I had the accounting setup backdated to when they were made).
 Owner contributions would be recorded as a debit to the bank account  (or the
appropriate asset account if you have used personal funds to purchase a business
asset for example) and a credit to Equity:Owner Contributions. Owner draws will
be the reversal of the debits and credits to the appropriate accounts.
David 





On Wed, 2021-05-12 at 10:24 -0400, Troy Spindler wrote:
> I see. Thank you. So since my business and Gnu Cash file are both new, it
> sounds like I should just use an Equity Account without "Opening balance"
> checked for all owner contributions and owner draws.
> On Tue, May 11, 2021 at 6:52 PM David Cousens 
> wrote:
> > Troy,
> > 
> > 
> > 
> > The Opening Balances in Equity record the net worth of your Assets and
> > 
> > Liabilities at the time you open a new set of books/file. The option to
> > 
> > create them when creating a new file is to accommodate the situation where
> > 
> > you are transferring existing balances from a previous set of books/file.
> > 
> > 
> > 
> > If there are no existing Assets and Liabilities at the time the book is
> > 
> > opened then you would not create them, i.e  a new business the option should
> > 
> > be checked off.
> > 
> > 
> > 
> > You can always manually create the transactions at a later stage if you need
> > 
> > to.
> > 
> > 
> > 
> > To record the value of an existing asset you would debit the corresponding
> > 
> > asset account for the value and credit the value to the Equity:Opening
> > 
> > Balances account. 
> > 
> > 
> > 
> > To record a liability you would credit the corresponding liability account
> > 
> > for the value of the liability and debit  the value to Equity:Opening
> > 
> > Balances account. 
> > 
> > 
> > 
> > The Opening Balances option on file creation just creates these entries when
> > 
> > opening a new file using the balances entered for the Asset and Liability
> > 
> > accounts. It will not allow you to enter balances for other types of
> > 
> > accounts.
> > 
> > 
> > 
> > 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.
> > 
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
___
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] Error on Advanced Portfolio Report

2021-05-12 Thread Danilo Freitas da Costa
Hi everyone!

I'm facing an issue with in Advanced Portfolio Report:

*There is an error processing the transaction 'buying 100. share
units'. This may to be caused by a sell transaction causing a negative
stock balance, and a subsequent buy transaction causing a zero balance.
This leads to a division-by-zero error. It can be fixed by preventing
negative stock balances.*

I looked for the cause and I found it. But I don't know how to solve it.

This problem is caused by a sequence of stock register (just this specific
stokc):

* Jan 12 - Sell 200 Stock XXX
* Jan 12 - Buy 100 Stock XXX

Until now, no problem. The report works well. Then I finish this operation:

* Feb 17 - Buy 100 Stock XXX

When I register this last operation the problem happens.

I don't understand that, because I have other operations like this one and
the report always works well.

To avoid any data entry error, I removed all transactions and inserted them
again.

Do you have any idea how to solve that?

Thanks!

Att,
Danilo
___
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] Equity Accounts - Opening Balance or no?

2021-05-12 Thread Michael or Penny Novack

On 5/11/2021 3:39 PM, Troy Spindler wrote:

Hey all.

Does anyone know what's the difference between an Equity account with vs.
without having "Opening balance" checked off? From what I can tell, they do
the same thing.

I have a new business with its own Gnu Cash file, and I'm trying to record
my transfers from my personal accounts as equity rather than income. It
seems right to use an "Opening balance" account to record my initial
investments I made in the company, but should I treat all future transfers
from personal the same way? If so, what would a Equity account that isn't
an Opening balance account be used for?

Thank you,
Troy


Sad but true, using an application like gnucash to partially automate 
the processes of bookkeeping do not mean you don't have to take the time 
to learn the fundamentals of double entry bookkeeping.


a) "Opening balance" is a shortcut you ca use when beginning a set of 
books instead of using an explicit opening transaction or transactions 
(using two means not having to enter a transaction split on BOTH the 
debit and credit side)


b) Yes, in the future, putting money into your business or taking money 
out would be transactions where the other side is an equity account. 
Keep in  mind, in the general case the business might not have a sole 
owner  (so partner shares need to be tracked, further investments and 
drawings).


c) With gnucash, you don't have to explicitly "close the books" (close 
the temporary equity accounts of type "income" and "expense" to equity). 
Gnucash can produce the P&L report without that. But in this report, you 
do get to see a virtual (equity) account for  net gain or loss. This is 
the amount that would have been transferred to equity (an equity 
account) had you done a "close the books". That amount will also show up 
when you run a Balance Sheet report as a (virtual) equity account 
"retained gains" (or losses).


d) If you do use "opening balance" when opening the books, that account 
is usually never changed. Especially if, as is likely, you will both be 
putting money in and taking money out, and you want to see "owner's 
equity" in one place, that is an argument for not using the "opening 
balance tool". Thus, personally, I would create the (new) set of books 
with all accounts 0 (in other words, no opening balance) and under 
equity I would put an account with a name like "owner's equity". I would 
then, using your balance sheet from before gnucash to enter two 
transactions, spits, one for all the asset accounts (credit side 
"owner's equity) and one for all the liability accounts (debit side 
"owner's equity) with description "opening the books" dated as of the 
date the books are being opened for. Then, when in the future, you are 
making additional investments in the business or taking money out, your 
net equity will always be available at a glance.


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] Need Transaction Report on Checking to show only Debits

2021-05-12 Thread Maf. King
On Tuesday, 11 May 2021 13:41:04 BST Fran_3 via gnucash-user wrote:
> How can I create a Transaction Report on the Checking AccountAnd show only
> Debits?Or show only Credits? Thanks for any help.
> ___

Hi,

use the Filter... settings on the "accounts" tab of the report options.

so run the report on the Checking account, and then in the lower half of the 
accounts tab  Filter by say only Expense accounts.

HTH,
Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.