Ver 6.31 - Tax Included - Rounding problem

tmdavenport · Post by **tmdavenport** » Thu Apr 28, 2005 2:17 pm

I run a youth centre and have all my products in inventory including taxes. I have POS set to have tax included. I just upgraded from version 6.20a to 6.31 and in the new version something has gone weird with the calculations.

For example: In my inventory, I have a can of coke set at $1.00 and the tax rate for it is 7%. With 6.20a it would calculate correctly and charge $0.93 and $0.07 tax and come up with $1.00. With the new version, it comes up with $0.92 and $0.07 for a total of $0.99 instead of the $1.00 that is stored in the inventory.

I've tried playing with the partial cent amount in the tax area, but cannot seem to get it to end up with the amount that I entered that I want the total to be.

I changed my entire inventory over to be included tax because I hated having to use the round on each transaction, especially those that had multiple items. With 6.20a it was working wonderfully, but now I appear to be back to that point where I have to round again.

Did I do something wrong in the upgrade?

Trent

Post by **Andrew** » Thu Apr 28, 2005 3:11 pm

I just tried this in the latest BETA (6.32 beta 1), I can confirm DHPOS calculates the $1.00 item as 0.92 using 7% included tax, instead of 0.93.

Interestingly, if you sell 2 of the $1.00 items in a sale, it totals as $2.00 perfectly.

tmdavenport · Post by **tmdavenport** » Thu Apr 28, 2005 7:02 pm

I seem to be experiencing the same. If you do multiple quantities, it seems to be ok, just certain single items are the problem.

So where do we go from here?

Post by **Andrew** » Thu Apr 28, 2005 11:28 pm

tmdavenport,

Well it's up to Dale to look into it, he is the chief (and in fact only) programmer of DHPOS.

tmdavenport · Post by **tmdavenport** » Fri Apr 29, 2005 12:35 am

Do I need to send in a bug report?

Post by **Andrew** » Fri Apr 29, 2005 2:13 am

This is your bug report.

tmdavenport · Post by **tmdavenport** » Fri Apr 29, 2005 9:43 am

Just wanted to make sure now that we've determined there was a problem, that it was going to get into the right hands.

Thanks

Dale, thanks for an awesome product and all the work you do to keep us all in POS.

Dale Harris · Post by **Dale Harris** » Fri Apr 29, 2005 10:33 pm

Try this http://keyhut.com/pos632b2.zip

Remember to backup first!

Post by **Andrew** » Sat Apr 30, 2005 6:48 am

Thanks Dale - that works great now with 6.32b2

Guest · Post by **Guest** » Sat Apr 30, 2005 8:08 am

Dale, I know this is a bit picky, but no matter whatever fraction of a penny is used, it still stays the same tax.

by definition, the tax should not be more than 10% tax (australia)
or 1/11 of the price.

If something is say 6 cents (eg a little light emitting diode), then 1/11th of that is .545 of a penny. even though my rounding of a penny is set at .99, it still shows up even when its below the level I have set.

If I set my fraction of a penny to .99, the tax should round down as the fraction penny does not success .99

eg:
(sale total, DHPOS tax cal)
qty 3 ($0.18 total, $0.02 tax) = should be $0.01636 tax, round to $0.01
qty 5 ($0.30 total, $0.03 tax) = should be $0.02727 tax, round to $0.02
qty 7 ($0.42 total, $0.04 tax) = should be $0.03818 tax, round to $0.03
qty 9 ($0.54 total, $0.05 tax) = should be $0.04909 tax, round to $0.04

can this rounding of a penny be fixed?

it's strange really.... the odd quantities are the only one's that do it...

Dale Harris · Post by **Dale Harris** » Sat Apr 30, 2005 8:35 am

Guest,

You do not say what version you are using. This could already be fixed.

Guest · Post by **Guest** » Sun May 01, 2005 10:14 pm

dear dale,

i am using the 6.32 beta 2.

i have set rounding to .99 of a penny.

Cheers.

Dale Harris · Post by **Dale Harris** » Sun May 01, 2005 11:07 pm

I have looked at this and it will be really tough to fix.

Let's see what happens.

tmdavenport · Post by **tmdavenport** » Tue May 03, 2005 10:43 pm

Just wanted to let you know, I used 6.32b all day today and it worked great and as expected.

Thanks Dale.

DHES

Ver 6.31 - Tax Included - Rounding problem

Multiples seem to be ok

Bug report

Thanks

Fixed?

What version?

Rounding error

My problem is fixed

Who is online