Thanks Adrien,
Yes, since posting I have done some more testing, and it does appear to
be a rounding issue when using Inclusive Tax.
I have also tried the same example in 4.10 Flatpak, and the issue
remains the same.
I assume that in version 2.6.17 the calculation was made in a different
way. I can't see any preferences that may be set differently, that may
be able to change the behaviour.
It appears that when entering Inclusive Tax amounts, behind the scene it
actually calculates the Exclusive amount, then adds those figures
together to work out the Invoice Total.
Is there any way to get the calculation behaviour back to how it worked
in 2.6.17?
Thanks all,
Jeff.
On 3/6/22 22:57, Adrien Monteleone wrote:
Looks like a rounding issue when using inclusive tax.
The latest GnuCash is 4.10. You can get a .deb for it in the Debian
Archives (see the wiki) or try the Flatpak to see if the issue still
exists.
Regards,
Adrien
On 6/3/22 2:07 AM, Jeff wrote:
Hi Group.
I am just doing some testing testing with updated versions (to me) of
GnuCash.
I have been using GnuCash for a while on an older machine, it is
running 2.6.17 and it is working perfectly, unfortunately the machine
it is on is starting to have issues, so am in the process of
migrating to a newer machine, and therefore a newer version of
GnuCash (finally).
The issue I'm having is on a specific Invoice the TOTAL shown down
the bottom is 1 cent out. I could understand it if I was doing %
discounts etc, but the invoice is very basic, and the total seems to
be correct, until the last entry.
Invoice Details:
Date Description Action Quantity Unit Price
Discount Type Discount How Discount Tax Subtotal Tax
Today Item 1 Material 1 $1049.00 %
< X $953.64 $95.36
Today Item 2 Material 1 $222.00 %
< X $201.82 $20.18
Today Item 3 Material 1 $15.00 %
< X $13.64 $1.36
Today Item 4 Material 1 $30.00 %
< X $27.27 $2.73
Today Item 5 Material 1 $59.15 %
< X $53.77 $5.38
Today Item 6 Project 1 $200.00 %
< X $181.82 $18.18
The Discount Type and Discount How, are just the prepopulated values
and are not used as there is no Discount amount.
The TOTAL at the bottom left of the Invoice entry screen is correct
until adding the last entry, where it then shows: $1,575.16 instead
of the expected $1,575.15.
I have tried adding in the Invoice details to a new Invoice, and
using two different versions of GnuCash, both seem to show the same
behaviour. Are there any suggestions as to why this may be
happening, and how to fix it? It is not very comforting that what
appears to be a simple Invoice, with not discounts etc, is added up
wrong. If I change the Item 5 entry to $59.14 I correctly get
$1,575.14. But once again changing the Item 5 to $59.15 gives a
Total of $1,575.16.
Tested on
OS GnuCash
Kubuntu 21.10 3.8, Build ID: 3.8b+(2019-12-29) Finance::Quote:
1.49 Installed via Package Manager
Kubuntu 22.04 4.8, Build ID: 4.8a+(2021-09-28) Finance::Quote:
1.51 Installed via Package Manager
_______________________________________________
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.