bugs + wishlist

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

bugs + wishlist

Bob Hunter-2
GnuCash 1.8.11


BUGS (mostly related to International Support):
 1. If you create a "Cash on Hand" account in the
Assets column, and then   create three sub-accounts
with different currencies, the Total of "Cash   on
Hand" is equal to the sub-account with the same
Commodity, if any.   The correct value should be equal
to the sum of the sub-accounts,   converted to the
"Cash on Hand" selected Commodity at current exchange
rate;

  EXAMPLE:
  EUR 5700.00
  GBP 40.00
  USD 28.00
  TOTAL = 5700.00 EUR (error)

  The above error occurs with any similar construction
in any account (Assets, Liabilities, etc.).

2. It is not possible to list "Real Estate" assets in
the Assets column. GnuCash should be extended to
include a "Real Estate" Account Type, which entries
include relevant information, such as "type" (example,
3Bedrooms/2Bathrooms), "down payment" and "cost".

3. Suppose you have the following fictitious financial
statement:

    Income      = EUR 0.00
    Expenses    = EUR 0.00
    Assets      = EUR 8616.10
       Bank Accounts = EUR 2916.10 (wrong)
           account1 = EUR 500
           account2 = GBP 275.38
           account3 = EUR 2416.10
       Cash on Hand  = EUR 5700.00 (wrong)
           account4 = EUR 5700
           account5 = GBP 40
           account6 = USD 28
    Liabilities = EUR 0.00

    The toolbar above the accounts says:

    Net Assets grand total (EUR): EUR 6200.00  
Profits (EUR): EUR 0.00

    There is no need to remark they are "EUR".
    Both the Net Assets total and grand total are
wrong.

    If you click on the arrow, you get the following:

    Net Assets (EUR): EUR 6200.00 .......... (correct)
    Net Assets (GBP): GBP 315.38 ........... (correct)
    Net Assets ($): $ 28.00  ............... (correct;
should display "USD")
    Net Assets total (EUR): EUR 6200.00 .... (wrong)
    Net Assets grand total (EUR): EUR 6200   (wrong)

  The correct value should be equal to the sum of the
Asset accounts, converted to the selected Commodity
(EUR) at current exchange rate.

  I recommend removing this toolbar information in the
first place; a well-written Report is more useful.

4. The above error 3 occurs in any Report.


WISHLIST

1. Auto-save, as option.


Best regards,
B.H.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Christian Stimming
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bob Hunter schrieb:
> GnuCash 1.8.11

Note that some of your bugs may already be fixed in the 2.0.x versions.
In particular, I think the issues with the toolbar and multiple
currencies have been improved in 2.x, so some of your complaints might
already be fixed.

> BUGS (mostly related to International Support):
>  1. If you create a "Cash on Hand" account in the
> Assets column, and then   create three sub-accounts
> with different currencies, the Total of "Cash   on
> Hand" is equal to the sub-account with the same
> Commodity, if any.   The correct value should be equal
> to the sum of the sub-accounts,   converted to the
> "Cash on Hand" selected Commodity at current exchange
> rate;

You are referring to the balance numbers in the "account hierarchy"
window, right? In that case we agree - yes, there is no on-the-fly
currency conversion implemented in that view of your accounts. Instead,
only one currency is shown and the others ignored. The on-the-fly
currency conversion *is* implemented in the "Balance sheet" and "Account
Summary" reports, though, including various different options about how
to calculate the actual exchange rates. (Yes, there are indeed multiple
ways to do this; it is definitly a non-trivial operation.) So the
currently proposed workaround for your request is that you open one of
these reports, set the options so that they show what you want, and
leave this report window open forever.

If you are asking to have this currency conversion implemented in the
account hierarchy window as well, feel free to file an enhancement
request in bugzilla, http://bugzilla.gnome.org/enter_bug.cgi?product=GnuCash
but I'm afraid none of the developers will be working on this in the
short term, because the reports are considered a sufficiently good
workaround for the time being. I'd love to be proven wrong, though. :-)

> 2. It is not possible to list "Real Estate" assets in
> the Assets column. GnuCash should be extended to
> include a "Real Estate" Account Type, which entries
> include relevant information, such as "type" (example,
> 3Bedrooms/2Bathrooms), "down payment" and "cost".

The real estate is an Asset, so why don't you simply add this as an
account of type Asset? I guess you agree it won't make much sense to add
an extra account type for every kind of asset that someone might come up
with.

> 3. Suppose you have the following fictitious financial
> statement:
> (...)
>     The toolbar above the accounts says:
>
>     Net Assets grand total (EUR): EUR 6200.00  
> Profits (EUR): EUR 0.00
>
>     There is no need to remark they are "EUR".

Why is that?

>     Both the Net Assets total and grand total are
> wrong.

As noted above: The "account hierarchy" window and also the toolbar
numbers don't calculate any currency conversion. So they give you the
numbers only in the specified currency.

>   I recommend removing this toolbar information in the
> first place; a well-written Report is more useful.

It is up to any user whether the toolbar should be shown or not. In
fact, I haven't ever used it, probably for similar reasons as you, but
for some other users it might be useful, so it's still there.

> 4. The above error 3 occurs in any Report.

We are not aware of errors concerning the currency exchange in the
reports (with the exception of "advanced portfolio" and "cash flow"). If
you found an error in any of the other reports, please report them into
bugzilla, preferrably with a screenshot of the error and/or a small
example gnucash file to demonstrate the error.
http://bugzilla.gnome.org/enter_bug.cgi?product=GnuCash

> WISHLIST
>
> 1. Auto-save, as option.

http://bugzilla.gnome.org/show_bug.cgi?id=107365
Feel free to add more comments to that bugzilla entry.

Thank you for all the constructive feedback.

Christian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQCVAwUBRTi9V2XAi+BfhivFAQL55gQAt2HYw148DzBVduZywXv/QlGqJ7vrKurw
gNPdHGZ1T19iJ2Y2L6DxwHTCbrCwnf95ou4O7veN4F7SL7OjKE++7yHyFNY83iTu
VemLMjXdnSjlvK/teBTAWME6SEO1/dNhaGNz87YD0l6EnWnwf9RGds9o3Rbmmb90
cE6wO4dznwY=
=BPX9
-----END PGP SIGNATURE-----
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Tim Wunder (Lists)
In reply to this post by Bob Hunter-2
On Friday 20 October 2006 6:45 am, Bob Hunter wrote:
> GnuCash 1.8.11
<snip>

If you want the developers to pay attention to your bugs and wishlist items,
please use http://bugzilla.gnome.org/enter_bug.cgi?product=GnuCash

Thanks,
Tim

--
Fedora Core release 5 (Bordeaux), Linux 2.6.18-1.2200.fc5
 08:15:01 up 1 day, 10:10,  5 users,  load average: 1.06, 1.23, 0.85
MP3/OGG archive Total playlength : 8 days, 3 hours, 28 mins 17 seconds
"It's what you learn after you know it all that counts" John Wooden

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

attachment0 (196 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Bob Hunter-2
In reply to this post by Christian Stimming

> GnuCash 1.8.11

> Note that some of your bugs may already be fixed in
the 2.0.x versions. In particular, I think the issues
with the toolbar and multiple currencies have been
improved in 2.x, so some of your complaints might
already be fixed.

In my former post I have mentioned the difficulty to
run the latest version under osx, which difficulty
overlaps with my reluctance to make gnucash from
source under osx. Me, and the most of the world, we
shall wait until either the main site or Fink will
overcome their problems and start distribute the
binary for osx too.

> BUGS (mostly related to International Support):

>  1. If you create a "Cash on Hand" account in the
> Assets column, and then   create three sub-accounts
> with different currencies, the Total of "Cash   on
> Hand" is equal to the sub-account with the same
> Commodity, if any.   The correct value should be
equal
> to the sum of the sub-accounts,   converted to the
> "Cash on Hand" selected Commodity at current
exchange
> rate;

>You are referring to the balance numbers in the
"account hierarchy" window, right?

Yep!

>In that case we agree - yes, there is no on-the-fly
currency conversion implemented in that view of your
accounts. Instead, only one currency is shown and the
others ignored. The on-the-fly currency conversion
*is* implemented in the "Balance sheet" and  "Account
Summary" reports, though, including various different
options about how to calculate the actual exchange
rates. (Yes, there are indeed multiple ways to do
this; it is definitly a non-trivial operation.) So the
currently proposed workaround for your request is that
you open one of these reports, set the options so that
they show what you want, and leave this report window
open forever.

I guess you are referring to gnucash 2.0.2, because
the Reports in version 1.8.11 are broken on this
respect.

>If you are asking to have this currency conversion
implemented in the account hierarchy window as well,
feel free to file an enhancement request in bugzilla,
http://bugzilla.gnome.org/enter_bug.cgi?product=GnuCash
but I'm afraid none of the developers will be working
on this in the short term, because the reports are
considered a sufficiently good workaround for the time
being. I'd love to be proven wrong, though. :-)

I'm willing to file the request, provided they are
willing to take it into account. I am sure the
developers reading this forum will just take a note,
as the error is macroscopic.

> 2. It is not possible to list "Real Estate" assets
in
> the Assets column. GnuCash should be extended to
> include a "Real Estate" Account Type, which entries
> include relevant information, such as "type"
(example,
> 3Bedrooms/2Bathrooms), "down payment" and "cost".

>The real estate is an Asset, so why don't you simply
add this as an account of type Asset? I guess you
agree it won't make much sense to add an extra account
type for every kind of asset that someone might come
up with.

I tried, but the item is managed like a bank account,
which is not. Specific r.e. information requires
specific management. The value of the r.e. is the down
payment + the cost, but you do not want to merge the
two values in a bank-like transaction with a single
entry. On the other hand, when computing the value of
the asset, the two values should be added.

> 3. Suppose you have the following fictitious
financial
> statement:
> (...)
>     The toolbar above the accounts says:
>
>     Net Assets grand total (EUR): EUR 6200.00  
> Profits (EUR): EUR 0.00
>
>     There is no need to remark they are "EUR".

>Why is that?

Because it takes space?


>     Both the Net Assets total and grand total are
> wrong.

>As noted above: The "account hierarchy" window and
also the toolbar numbers don't calculate any currency
conversion. So they give you the numbers only in the
specified currency.

I spotted that. However, the bug is still in place.

>   I recommend removing this toolbar information in
the first place; a well-written Report is more useful.

>It is up to any user whether the toolbar should be
shown or not. In fact, I haven't ever used it,
probably for similar reasons as you, but for some
other users it might be useful, so it's still there.

The toolbar has two lines. If I hide the second line,
where those numbers are displayed, the first one is
hidden too. But I need the first one, so I get the
second as an unwanted bonus? :-P

> 4. The above error 3 occurs in any Report.

>We are not aware of errors concerning the currency
exchange in the reports (with the exception of
"advanced portfolio" and "cash flow").  If you found
an error in any of the other reports, please report
them into bugzilla, preferrably with a screenshot of
the error and/or a small example gnucash file to
demonstrate the error.
http://bugzilla.gnome.org/enter_bug.cgi?product=GnuCash

I thought this forum was sufficient...


> WISHLIST
>
> 1. Auto-save, as option.

>http://bugzilla.gnome.org/show_bug.cgi?id=107365
>Feel free to add more comments to that bugzilla
entry.

I got the idea.

>Thank you for all the constructive feedback.

You are welcome.

-bob


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Derek Atkins
In reply to this post by Christian Stimming
Christian Stimming <[hidden email]> writes:

> You are referring to the balance numbers in the "account hierarchy"
> window, right? In that case we agree - yes, there is no on-the-fly
> currency conversion implemented in that view of your accounts. Instead,
> only one currency is shown and the others ignored. The on-the-fly
> currency conversion *is* implemented in the "Balance sheet" and "Account
> Summary" reports, though, including various different options about how
> to calculate the actual exchange rates. (Yes, there are indeed multiple
> ways to do this; it is definitly a non-trivial operation.) So the
> currently proposed workaround for your request is that you open one of
> these reports, set the options so that they show what you want, and
> leave this report window open forever.

Actually, if you enable the "total in report currency" column you CAN
get what you want, even in 1.8 and 2.0.

>>   I recommend removing this toolbar information in the
>> first place; a well-written Report is more useful.
>
> It is up to any user whether the toolbar should be shown or not. In
> fact, I haven't ever used it, probably for similar reasons as you, but
> for some other users it might be useful, so it's still there.

Indeed, you can turn off the toolbar in your Preferences.

-derek
--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Bob Hunter-2

>Actually, if you enable the "total in report
currency" column you CAN get what you want, even in
1.8 and 2.0.

I did not find this option. Could you be more precise?

>you can turn off the toolbar in your Preferences.

Yes, I did it. However, hiding wrong numbers does not
really solve the problem.

--bob

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Derek Atkins
Quoting Bob Hunter <[hidden email]>:

>
>> Actually, if you enable the "total in report
> currency" column you CAN get what you want, even in
> 1.8 and 2.0.
>
> I did not find this option. Could you be more precise?

In 1.8, on the Chart of Accounts page, click the "options" button.
That controls the list of columns.   In 2.0 there's a pulldown menu
on the upper right hand corner of the CoA.

>> you can turn off the toolbar in your Preferences.
>
> Yes, I did it. However, hiding wrong numbers does not
> really solve the problem.

It's not a problem (except in your own mind).  The feature works
exactly as it's designed to work.  See previous description of the
status bar.

> --bob

-derek

--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Bob Hunter-2


> "total in report currency" column

I can see it now. A new column appears on the right
side, however, its values are null. I think gnucash
should download the conversion rates automatically,
but it does not. I added the currencies in the Price
Editor, then enabled the relevant accounts to get
online quotes. The values were still null. Then I
selected Get Quotes in the Price Editor, enabled the
firewall, and got this message: "There was a system
error while retrieving the price quotes". Oddly
enough, the system is up and running. The error
message is as good as it gets...

>> you can turn off the toolbar in your Preferences.

> Yes, I did it. However, hiding wrong numbers does
not
> really solve the problem.

>It's not a problem (except in your own mind).  The
>feature works exactly as it's designed to work. See
>previous description of the status bar.

Ah, it is the "this is a feature, not a bug" thing.

--bob

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Derek Atkins
Bob Hunter <[hidden email]> writes:

>> "total in report currency" column
>
> I can see it now. A new column appears on the right
> side, however, its values are null. I think gnucash
> should download the conversion rates automatically,
> but it does not. I added the currencies in the Price
> Editor, then enabled the relevant accounts to get
> online quotes. The values were still null. Then I
> selected Get Quotes in the Price Editor, enabled the
> firewall, and got this message: "There was a system
> error while retrieving the price quotes". Oddly
> enough, the system is up and running. The error
> message is as good as it gets...

It means you don't have Finance::Quote installed properly.

-derek
--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

David Reiser
Derek Atkins wrote:

> Bob Hunter <[hidden email]> writes:
>
>>> "total in report currency" column
>> I can see it now. A new column appears on the right
>> side, however, its values are null. I think gnucash
>> should download the conversion rates automatically,
>> but it does not. I added the currencies in the Price
>> Editor, then enabled the relevant accounts to get
>> online quotes. The values were still null. Then I
>> selected Get Quotes in the Price Editor, enabled the
>> firewall, and got this message: "There was a system
>> error while retrieving the price quotes". Oddly
>> enough, the system is up and running. The error
>> message is as good as it gets...
>
> It means you don't have Finance::Quote installed properly.
>
> -derek
And that's harder using Fink than you'd think. The version Bob has is
probably 1.08. Version 1.12 is available only in the unstable tree at
the moment (and only since last week). The crypt-ssleay issue delayed it
for a while. At least it won't get stuck in unstable forever, as the
Apple supplied openssl will allow both f-q and ssleay to escape crypto
classification.

For perl modules, I almost think the fink folk ought to instruct users
about CPAN...

Dave
--
David Reiser
[hidden email]

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: bugs + wishlist

Bob Hunter-2

I've been writing programs in perl for about a
decade... I had no clue that gnucash used perl
modules. It's fantastic! The website says that its
code is C+SCHEME, but no mention to perl!

perl -MCPAN -e 'install Finance::Quote'

Voila!


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel