Re: [GNC] Odd Invoice Total (Rounding Issue Maybe)
Hi List, Updated Comments on bug 612957. It seems this has been around for a while. How are others using GnuCash in Australia with 10% GST (or other locations with Tax Included amounts being the normal way of expressing prices) entering Invoices to get around this issue? Any advice appreciated, as I would like to upgrade to a more current version of GnuCash, but may need to stick with the old version while this issue is around if I can't find a workable solution. Note, I have had the odd Invoice/Bill on the old system where the TAX amount is a cent different from the shops Receipt, but the Invoice/Bill total has always been correct. I guess maybe this is the same rounding issue, just affecting the calculated values rather than the entered values. Thanks, Jeff. On 4/6/22 10:46, Jeff wrote: Thanks Adrien, I will report it with the details. On 4/6/22 00:20, Adrien Monteleone wrote: I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through or wasn't exposed/tested to catch it. Regards, Adrien On 6/3/22 8:49 AM, Jeff wrote: 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? ___ 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] Odd Invoice Total (Rounding Issue Maybe)
Thanks Adrien, I will report it with the details. On 4/6/22 00:20, Adrien Monteleone wrote: I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through or wasn't exposed/tested to catch it. Regards, Adrien On 6/3/22 8:49 AM, Jeff wrote: 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? ___ 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] Odd Invoice Total (Rounding Issue Maybe)
I'd file a bug, label it as 'Regression' since a change broke something that worked. Be sure to indicate the version that worked and the tested versions that do not. I vaguely recall some work done to 'improve' rounding due to other bugs around the 3.x series. I guess this slipped through or wasn't exposed/tested to catch it. Regards, Adrien On 6/3/22 8:49 AM, Jeff wrote: 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? ___ 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] Odd Invoice Total (Rounding Issue Maybe)
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.
Re: [GNC] Odd Invoice Total (Rounding Issue Maybe)
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.
[GNC] Odd Invoice Total (Rounding Issue Maybe)
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 Thanks in advance for any suggestions. Regards, Jeff. ___ 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.
