[ic] Tax caluculation problem

murahashi interchange-users@interchange.redhat.com
Thu Nov 15 00:05:01 2001


I did more tests about tax caluculation round off.

 TAXArea JP
 TAXField JP
 TAX Rate JP=5.0

(CASE-A)
frac_digits = 0
Checkout.html showed below.
Order-A1:  Subtotal 190Yen ; Tax  10Yen (Correct)
Order-A1:  Subtotal 170Yen ; Tax  8Yen (This should be 9Yen)
Order-A1:  Subtotal 30Yen ; Tax  2Yen (Correct)
Order-A1:  Subtotal 10Yen ; Tax  0Yen (This should be 1Yen)

In Japan, we have no decimal for calculated tax value.
It seems IC rounded off in case of even, but not rounded off in case of odd.
Is that right? Am I worng?

Of course, when frac_digits = 2 , all of calclation are right . See below.

(CASE-B)
frac_digits = 2
Checkout.html showed below.
Order-A1:  Subtotal 190.00Yen ; Tax  9.50Yen
Order-A1:  Subtotal 170.00Yen ; Tax  8.50Yen
Order-A1:  Subtotal 30.00Yen ; Tax  1.50Yen
Order-A1:  Subtotal 10.00Yen ; Tax  0.50Yen

 Any help would be appreciated.
 ---------------------------------------------------------------
 KIDA Net Business Ltd
 Shozo Murahashi


----- Original Message -----
From: "murahashi" <murahashi@ayayu.com>
To: <interchange-users@interchange.redhat.com>
Sent: Tuesday, November 13, 2001 3:37 PM
Subject: [ic] Tax caluculation problem


> Sales tax value calculation was wrong in case of below on both Interchange
> 4.6 and 4.8.
>
> TAXArea JP
> TAXField JP
> TAX Rate JP=5.0
>
> ( Case 1)
> On checkout.html,
> Subtotal 8250Yen
> Tax  412Yen
>
> Tax = 8250 * 0.05 = 412.5
> Wrong!
> Tax should be 413Yen.
> It seems that Round off is not correct.
>
> (Case 2)
> On checkout.html
> Subtotal 46790Yen
> Tax 2340Yen
>
> Tax =46790 * 0.05 = 2339.5
> This case correct!
>
> >From experiences, most of cases are right on calculation of round off.
>
> Where should  I look into sales tax module? Any pointer?
>
> Any help would be appreciated.
> ---------------------------------------------------------------
> KIDA Net Business Ltd
> Shozo Murahashi
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>