Re: [GNC] Printing Chart of Accounts WITHOUT balances

[Stan Brown]

Re-sending to the list this time.

Somebody remind me why the list manager program doesn't set reply-to to
the list? :-)

Thank you, David.

Could you (or someone) enter a bug, please? (Accounts Summary report
displays account balances though that option is deselected in Report
Options.)

I tried to enter it, but GnuCash Bugzilla rejected my login credentials
for some reason. And in any case, I wouldn't be able to attest from my
own knowledge that the bug still exists in the current version.

Yes, I have exported the report to HTML, opened it in Excel, deleted the
unwanted columns, and so forth. But that's kind of a pain, and if the
option is in the GUI it really ought to be honored.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2022-06-30 14:30, David H wrote:
> Stan,
> 
> If it's available in 2.6.19 you could try File >> Export >> Export
> Account tree to CSV as a work around.  Then open in your spreadsheet
> program, remove columns (balances not included) you don't want and print
> from there ?
> 
> Cheers David H.
> 
> 
> On Fri, 1 Jul 2022 at 06:58, Stan Brown  > wrote:
> 
> I have GC 2.6.19 in Widows 10. I'm attempting to print a chart of
> accounts, showing account code and account title. I'm using the Account
> Summary report, because there does not seem to be a Cart of Accounts
> report. But I don't want account balances to show on this report.
> 
> In report options, there's a tick box for Account Balance, and I have
> unticked it. I click on Apply to rewrite the report, but the account
> balances still appear.
> 
> I'm attaching my selected report options. (I have not changed anything
> on the Commodities tab, because I don't have any commodity accounts.)
> 
> I know I'm using an old version, so maybe GC 2.6.19 just has a bug that
> causes it to display account balances even though they're un-requested.
> But also I wonder if some option I selected has the side effect of
> showing balances. (On the Display tab, I did try changing Parent Account
> Balances to "Do not show". That suppressed the parent account balances,
> but all the other accounts showed balances.)
> 
> Is there something I can do to get a chart of accounts without balances,
> apart from exporting HTML and hand editing? Thanks!
> 
> -- 
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Paste problem?

[Paul Kinzelman]

This happened in 4.9 so I upgraded to 4.11 (latest) and it's still 
happening.

Running on W10.

If I Transaction|Copy, say a credit card charge, then paste it into the
same or a different credit-card account, it doesn't display or paste 
correctly.


So if I have a transaction in a credit card account like
Date, SomeCompany, Expenses:someaccount, Payment blank, Charge $12.34, 
Balance $1123


Then I copy it and paste it into the same or different credit card account,
I expect to see that same line with the date changed to today so that I
can Enter and commit that transaction.

However, in Basic Ledger View after the paste, what I see is:
Date, SomeCompany, Liability:SameAccount, Payment $12.34, Charge blank, 
Balance $1123

The payment is in the wrong column, and the account in the transaction
is the same account that I'm already viewing.
And if I Enter, the transaction seems to vanish because it's a transfer from
and to the same account.

But if I do the same thing but before Enter, go to View Transaction Journal,
then the pasted transaction looks correct, just like the one I copied.
And then if I Enter, the transaction is committed correctly.
And then if I go back to Basic Ledger View, the transaction still looks OK.

So to make it work, I have to go to View Transaction Journal, do the 
paste and

enter, then go back to Basic Ledger View
-Paul Kinzelman

___
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] Transaction Paste problem?

[David Carlson]

For comparison I tried the Duplicate Transaction feature in release 3.8.  I
do not use the Basic Ledger View much but I did switch to that view first
before trying the function on a transaction that has lots of splits.
Because GnuCash had been open since yesterday, I first received a pop-up
asking me what date to use.  I let it use yesterday's date so I could
better see what happened.  The resulting duplicate was identical except for
the date.

Then I tried the Transaction Copy/Paste feature and found that when I tried
to Paste I got a warning that I would overwrite an existing transaction,
probably because I did not move to a different transaction before trying to
paste.  After moving to a different transaction I got the same overwrite
warning.  If I used the Move to Blank transaction then pasted I got the
duplicate as a new entry which I had to accept before switching to a
different transaction.  I think all those tests passed in release 3.8, so
perhaps there is a problem with the current release.

On Fri, Jul 1, 2022 at 11:54 AM Paul Kinzelman  wrote:

> This happened in 4.9 so I upgraded to 4.11 (latest) and it's still
> happening.
> Running on W10.
>
> If I Transaction|Copy, say a credit card charge, then paste it into the
> same or a different credit-card account, it doesn't display or paste
> correctly.
>
> So if I have a transaction in a credit card account like
> Date, SomeCompany, Expenses:someaccount, Payment blank, Charge $12.34,
> Balance $1123
>
> Then I copy it and paste it into the same or different credit card account,
> I expect to see that same line with the date changed to today so that I
> can Enter and commit that transaction.
>
> However, in Basic Ledger View after the paste, what I see is:
> Date, SomeCompany, Liability:SameAccount, Payment $12.34, Charge blank,
> Balance $1123
> The payment is in the wrong column, and the account in the transaction
> is the same account that I'm already viewing.
> And if I Enter, the transaction seems to vanish because it's a transfer
> from
> and to the same account.
>
> But if I do the same thing but before Enter, go to View Transaction
> Journal,
> then the pasted transaction looks correct, just like the one I copied.
> And then if I Enter, the transaction is committed correctly.
> And then if I go back to Basic Ledger View, the transaction still looks OK.
>
> So to make it work, I have to go to View Transaction Journal, do the
> paste and
> enter, then go back to Basic Ledger View
> -Paul Kinzelman
>
> ___
> 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] Printing Chart of Accounts WITHOUT balances

[Adrien Monteleone]

On 7/1/22 11:33 AM, Stan Brown wrote:

Re-sending to the list this time.

Somebody remind me why the list manager program doesn't set reply-to to
the list? :-)


That's a function of your e-mail/newslist reader. Some do not 
auto-detect lists, so don't present the option. (or hide it under a 
drop-down or menu) Others only offer a 'reply-all' option.


For some, like Thunderbird, they name that button 'Followup'.

So, it's on you to make sure you're addressing to the right party.


Thank you, David.

Could you (or someone) enter a bug, please? (Accounts Summary report
displays account balances though that option is deselected in Report
Options.)


I don't ever recall this being a thing. Thus that would be a Request for 
Enhancement. But unless it would be really easy to implement, I don't 
see it appearing any time soon. And you have options to get what you are 
looking for as you noted.

I tried to enter it, but GnuCash Bugzilla rejected my login credentials
for some reason. And in any case, I wouldn't be able to attest from my
own knowledge that the bug still exists in the current version.


I just logged in fine, so again, seems to be a user thing.

As for the bug report, it already exists from 11 years ago: 
https://bugs.gnucash.org/show_bug.cgi?id=657530


But determined 'Not A Bug'.

It works, but maybe not as you expected.

It is arguable that the wording of the option should be improved, or the 
option should be modified in behavior, or additional options added to 
decide what level of account balances to exclude. (it presently only 
operates on top-level accounts)


Regards,
Adrien


___
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] Multiple currencies in split tx

[HSC]

> --
> 

> Message: 4
> Date: Thu, 30 Jun 2022 15:03:37 -0700
> From: list+gnuc...@jdlh.com
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Multiple currencies in split tx
> Message-ID: 2b04aeb5-7f10-cfa9-3960-261bbee4b...@jdlh.com
> 

> Content-Type: text/plain; charset=UTF-8; format=flowed
> 

> Hello, HSC:
> 

> Welcome to GnuCash.
> 

> On 2022-06-30 13:30, HSC wrote:
> 

> > ...Is it possible to account in one GC split entry for a tx in which a 
> > payment processor simultaneously makes a payment to two different vendors 
> > in two different local currencies?...
> 

> 

> In my experience, yes. I have made some transactions like this.
> 

> > We see it on the statement as one payment in source currency and two in 
> > destination currencies, without any details regarding conversion rates.
> > 

> > Do we have to calculate all that manually, and enter in GC as two separate 
> > txs?
> 

> 

> My suggestions:
> 

> 1. Read the "Multiple Currencies" section of the GnuCash Tutorial and
> Concepts Guide
> https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_currency.html
> 

> 

> 2. Enable trading accounts (see 12.3 Automatically Recording Currency
> Transactions?). I have always used trading accounts in GnuCash, so I
> have no experience without trading accounts.
> 

> 3. Know that each transaction has a default currency, but GnuCash does
> not easily show you which currency that is. GnuCash sets the default
> currency to be the currency of whichever account you were in when you
> created the transaction.? If you have three currencies, $AA, $BB, and
> $CC, and you want the transaction's default currency to be $CC, then go
> to an account register which has $CC as its currency, and create the
> transaction there.
> 

> 4. You will have to establish an exchange rate between the currency of
> each split of the transaction, and the default currency of the
> transaction. For each split, if the account for that split uses the
> transaction's default currency, GnuCash will accept the amount you type
> in for that transaction. If the account for that split uses a different
> currency, then GnuCash will display a "Transfer Funds" dialogue (See
> 12.3.2.2. Transfer of Funds to a Foreign Currency). You will have to
> determine an amount of the transaction's default currency which
> corresponds to the split amount, in the split account's currency.
> 

> 4.example. Suppose you have a transaction where you pay $AA 4.00, and
> the payment processor pays out $BB 2.00 and $CC 1.00. Go to the source
> account, which uses $AA. Enter a split for that account with the amount
> 4.00. Add a split with an account which receives the $BB 2.00. Enter the
> amount 2.00. A "Transfer Funds" dialogue appears. Enter the amount of
> $AA which corresponds to $BB 2.00. (You need to determine this yourself,
> if the payment processor does not document it for you.) Then add another
> split with an account which receives the $CC 1.00. Enter the amount
> 1.00. In a similar way, fill out the Transfer Funds dialogue to set up
> an exchange rate between $AA and $CC.
> 

> 5. GnuCash enforces a rule that, within every transaction, the sum of
> all splits using a currency sum to zero. This includes splits with
> trading accounts, which GnuCash creates based on what you entered in the
> "Transfer Funds" dialogue.
> 

> 5.example. In the transaction with a source payment of $AA 4.00, there
> will be one split involving the source account, with a value of $AA
> 4.00, and one or two splits involving the TRADING:$AA account, summing
> to -$4.00. The sum for all the splits in $AA is zero.
> 

> 6. Note that you can use GnuCash as a calculator, by entering
> expressions in amount fields. See GnuCash Guide, 2.9.2.4. Using Entry
> Shortcuts. I use this for splitting the calculating a fraction of the
> total for individual splits.
> 

> This is complicated to describe in words. I recommend doing some trial
> and error to experiment, and learn it that way.? Save a copy of your
> Book file as another name. Open that copy, and make some test
> transactions. When you understand what you want to do, open your
> original Book file, and enter the transaction.
> 

> Does that help?
> 

> Best regards,
> ? ?Jim DeLaHunt
> 


Thank you very much, Jim DeLaHunt, for such detailed response!
It's most helpful!

Previously tried unsuccessfully to figure it out with trading accounts, but if 
I understand correctly, the key is to start in the source account.

So, we'll try that next.

HSC


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

Re: [GNC] Bitcoin Lightning payments

[HSC]

> --
> 

> Message: 2
> Date: Sun, 19 Jun 2022 15:02:33 +0100
> From: "Dr. David Kirkby" drkir...@kirkbymicrowave.co.uk
> 

> To: Peter West p...@pbw.id.au
> 

> Cc: gnucash-user@gnucash.org, stepbystepf...@comcast.net
> Subject: Re: [GNC] Bitcoin Lightning payments
> Message-ID:
> CANX10hDqudKB9KuF=fmjds7+sumtn9f0e7wz-uwawuvv+4u...@mail.gmail.com
> 

> Content-Type: text/plain; charset="UTF-8"
> 

> On Sun, 19 Jun 2022 at 12:08, Peter West p...@pbw.id.au wrote:
> 

> > If you wait for 4217, you?ll be waiting a long time.
> > 

> > Or so it seems to me.
> > 

> > ?
> > Peter West
> > p...@pbw.id.au
> 

> 

> 

> According to the ISO website, they are looking at crypto, but it will not
> be part of ISO 4217. That was written 2.5 years ago ???
> 

> https://www.iso.org/news/ref2466.html
> 

> 

> 

> Dave
> 

> 

> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
> 

> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> 

> 


> --
> 

> Message: 5
> Date: Sun, 19 Jun 2022 11:19:49 -0400
> From: Michael or Penny Novack stepbystepf...@comcast.net
> 

> To: "Dr. David Kirkby" drkir...@kirkbymicrowave.co.uk
> 

> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Bitcoin Lightning payments
> Message-ID: 5d7e263c-424a-28a6-3aaf-b12ec86f1...@comcast.net
> 

> Content-Type: text/plain; charset=UTF-8; format=flowed
> 

> > Obviously BTC
> > 

> > In general I think standards are good - especially internationally
> > agreed ones. But according to the ISO website
> > 

> > https://www.iso.org/news/ref2466.html
> > 

> > ISO 4217 is never going to cover cryptocurrencies.? ISO are apparently
> > looking at crypto.
> 

> No, I thought I explained why it COULDN'T be "BTC"
> 

> That choice would violate an existing ISO standard. Unless Bhutan
> adopted Bitcoin as a currency << hey, it might be easier/quicker to get
> Bhutan to do that then getting the ISO to agree. >> The first thing the
> 

> ISO would need to do is settle on what first two characters would be "no
> state". There are lots cryptocurrencies so maybe want several character
> pairs for "no state"
> 

> Michael D Novack
> 


This might speed Bitcoin through ISO, IF actually happens at BIS first:
https://finbold.com/bank-for-international-settlements-to-allow-banks-to-keep-1-of-reserves-in-bitcoin/

ISO is hardly a real NGO; doubtful that they would ever approve a code that 
central bankers don't.

Keeping a separate Bitcoin book, where 1$ is assumed to be 1 sat is workable so 
far, including for milisat accounting.
How to link it to our fiat ledger is the next question.

Should it be done by using GC as an sql file and setting up some database 
connector between the fiat and the Bitcoin files?

HSC
  


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

Re: [GNC] Printing Chart of Accounts WITHOUT balances

[David T. via gnucash-user]

I remember this bug. I submitted it. As noted in the bug, I found problems with 
the option, but was informed that it was behaving as expected. I didn't agree, 
but never could determine how it actually was behaving in order to explain how 
it ought to behave instead. That's why I marked it NOTABUG.

As noted there, I found that certain selected balances disappeared, but not all 
of them. Perhaps someone could better describe the behavior. 

David T. 

On July 1, 2022 2:11:31 PM EDT, Adrien Monteleone 
 wrote:
>On 7/1/22 11:33 AM, Stan Brown wrote:
>> Re-sending to the list this time.
>> 
>> Somebody remind me why the list manager program doesn't set reply-to to
>> the list? :-)
>
>That's a function of your e-mail/newslist reader. Some do not auto-detect 
>lists, so don't present the option. (or hide it under a drop-down or menu) 
>Others only offer a 'reply-all' option.
>
>For some, like Thunderbird, they name that button 'Followup'.
>
>So, it's on you to make sure you're addressing to the right party.
>> 
>> Thank you, David.
>> 
>> Could you (or someone) enter a bug, please? (Accounts Summary report
>> displays account balances though that option is deselected in Report
>> Options.)
>
>I don't ever recall this being a thing. Thus that would be a Request for 
>Enhancement. But unless it would be really easy to implement, I don't see it 
>appearing any time soon. And you have options to get what you are looking for 
>as you noted.
>> I tried to enter it, but GnuCash Bugzilla rejected my login credentials
>> for some reason. And in any case, I wouldn't be able to attest from my
>> own knowledge that the bug still exists in the current version.
>
>I just logged in fine, so again, seems to be a user thing.
>
>As for the bug report, it already exists from 11 years ago: 
>https://bugs.gnucash.org/show_bug.cgi?id=657530
>
>But determined 'Not A Bug'.
>
>It works, but maybe not as you expected.
>
>It is arguable that the wording of the option should be improved, or the 
>option should be modified in behavior, or additional options added to decide 
>what level of account balances to exclude. (it presently only operates on 
>top-level accounts)
>
>Regards,
>Adrien
>
>
>___
>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] Printing Chart of Accounts WITHOUT balances

[Stan Brown]

On 2022-07-01 18:30, David T. via gnucash-user wrote:
> I remember this bug. I submitted it. As noted in the bug, I found problems 
> with the option, but was informed that it was behaving as expected. I didn't 
> agree, but never could determine how it actually was behaving in order to 
> explain how it ought to behave instead. That's why I marked it NOTABUG.
> 
> As noted there, I found that certain selected balances disappeared, but not 
> all of them. Perhaps someone could better describe the behavior.

Thanks for the historical information. David.


I know everyone coding GnuCash is a volunteer, but I really, really,
REALLY don't understand how anyone can call this "not a bug". It seems
crystal clear to me: The option on the Display tab says "Account
Balance", I remove the tick mark, and it still shows account balances.
How can anyone _possibly_ say that is not a bug? Whether it leaves all
account balances visible, or only some of them, it's still not doing
what the option says.

If the intent was to have unticking this option suppress only _some_
balances -- and I must say that I cannot conceive how that might be
useful -- there is still a bug because the GUI text does not describe
what the option is actually intended to so.

In software, "software performance doesn't match GUI options" is a
common class of bug. "Well, the software does what I intended for it to
do, so there's no bug even though the GUI doesn't describe the behavior
correctly" seems like merest sophistry to me.

That said, the programmers are going to do what they're going to do, so
I won't post on this point again.

Stan Brown

Tehachapi, CA, USA

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

Re: [GNC] Printing Chart of Accounts WITHOUT balances

[john]

> On Jul 1, 2022, at 7:20 PM, Stan Brown  wrote:
> 
> I know everyone coding GnuCash is a volunteer, but I really, really,
> REALLY don't understand how anyone can call this "not a bug".

Simple: It's an account summary report, not a list of accounts report. If you 
take away the line item balances then there's no summary going on.

There are two options for balance on the Account Summary Report: Subaccount 
balances/roll-up/none and final balance. Maybe the name or tooltip of the last 
one could be more clear, but it doesn't mean produce a list of accounts with no 
actual financial information.

Regards,
John Ralls

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