Page 1 of 1

Ver 6.31 - Tax Included - Rounding problem

Posted: Thu Apr 28, 2005 2:17 pm
by tmdavenport
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

Posted: Thu Apr 28, 2005 3:11 pm
by Andrew
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. :?

Multiples seem to be ok

Posted: Thu Apr 28, 2005 7:02 pm
by tmdavenport
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?

Posted: Thu Apr 28, 2005 11:28 pm
by Andrew
tmdavenport,

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

Bug report

Posted: Fri Apr 29, 2005 12:35 am
by tmdavenport
Do I need to send in a bug report?

Posted: Fri Apr 29, 2005 2:13 am
by Andrew
This is your bug report.

Thanks

Posted: Fri Apr 29, 2005 9:43 am
by tmdavenport
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.

Fixed?

Posted: Fri Apr 29, 2005 10:33 pm
by Dale Harris
Try this http://keyhut.com/pos632b2.zip

Remember to backup first!

Posted: Sat Apr 30, 2005 6:48 am
by Andrew
Thanks Dale - that works great now with 6.32b2 :D

Posted: Sat Apr 30, 2005 8:08 am
by Guest
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...

What version?

Posted: Sat Apr 30, 2005 8:35 am
by Dale Harris
Guest,

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

Posted: Sun May 01, 2005 10:14 pm
by Guest
dear dale,

i am using the 6.32 beta 2.

i have set rounding to .99 of a penny.

Cheers.

Rounding error

Posted: Sun May 01, 2005 11:07 pm
by Dale Harris
I have looked at this and it will be really tough to fix.

Let's see what happens.

My problem is fixed

Posted: Tue May 03, 2005 10:43 pm
by tmdavenport
Just wanted to let you know, I used 6.32b all day today and it worked great and as expected.

Thanks Dale.