We currently use Web Services to create customer and salesOrder records inside NetSuite from our network of websites. When the orders are sent to NetSuite an e-mail notification generated from OUR system, as well as an e-mail notification generated from NetSuite gets sent to my address.
I have noticed there are several instances in which sales tax calculations are NOT happening consistantly. Below I have included a table of the sales tax calculation being made by our websites versus NetSuite:
[NOTICE THAT THE "TAXCALCULATED" COLUMN DOES NOT PROPERLY ROUND IN THE "TAXASSIGNED" COLUMN]
<span style="font-size:'"1"'"><span style="font-family:'"Lucida Console"'">orderType subTotal shipping discount taxAssigned total taxCalculated websiteOrder 31.5 6.38 6.38 2.44 33.94 2.44125 salesOrder 31.5 6.38 6.38 2.45 33.95 2.44125 websiteOrder 55.85 6.38 6.38 4.05 59.9 4.049125 salesOrder 55.85 6.38 6.38 4.05 59.9 4.049125 websiteOrder 61.89 7.18 7.18 4.49 66.38 4.487025 salesOrder 61.89 7.18 7.18 4.49 66.38 4.487025 websiteOrder 26.94 6.38 6.38 1.95 28.89 1.95315 salesOrder 26.94 6.38 6.38 1.96 28.9 1.95315 websiteOrder 38.85 6.38 6.38 3.01 41.86 3.010875 salesOrder 38.85 6.38 6.38 3.02 41.87 3.010875 websiteOrder 76.33 6.65 6.65 5.53 81.86 5.533925 salesOrder 76.33 6.65 6.65 5.54 81.87 5.533925 websiteOrder 134 6.72 6.72 9.72 143.72 9.715 salesOrder 134 6.72 6.72 9.71 143.71 9.715 websiteOrder 322.92 12.87 12.87 25.03 347.95 25.0263 salesOrder 322.92 12.87 12.87 25.02 347.94 25.0263 websiteOrder 69.03 7.23 7.23 5 74.03 5.004675 salesOrder 69.03 7.23 7.23 5.01 74.04 5.004675 websiteOrder 80.45 6.38 6.38 5.83 86.28 5.832625 salesOrder 80.45 6.38 6.38 5.84 86.29 5.832625 websiteOrder 50.8 6.38 6.38 3.68 54.48 3.683 salesOrder 50.8 6.38 6.38 3.69 54.49 3.683</span></span>
After finding out that sales tax wasn't calculating correctly, I develed into some different methods of rounding to see if the problem was with our application versus NetSuite. So I ran some diagnostics on several different kinds of rounding, and was never able to consistantly match the numbers NetSuite was producing... <span style="font-size:'"1"'"><span style="font-family:'"Lucida Console"'">round: 2 nearest: 2.44 nearest_ceil 2.44 nearest_floor: 2.44 nearest_rand: 2.44 nlowmult: 2.44 nhimult: 2.45 round: 4 nearest: 4.05 nearest_ceil 4.05 nearest_floor: 4.05 nearest_rand: 4.05 nlowmult: 4.04 nhimult: 4.05 round: 4 nearest: 4.49 nearest_ceil 4.49 nearest_floor: 4.49 nearest_rand: 4.49 nlowmult: 4.48 nhimult: 4.49 round: 2 nearest: 1.95 nearest_ceil 1.95 nearest_floor: 1.95 nearest_rand: 1.95 nlowmult: 1.95 nhimult: 1.96 round: 3 nearest: 3.01 nearest_ceil 3.01 nearest_floor: 3.01 nearest_rand: 3.01 nlowmult: 3.01 nhimult: 3.02 round: 6 nearest: 5.53 nearest_ceil 5.53 nearest_floor: 5.53 nearest_rand: 5.53 nlowmult: 5.53 nhimult: 5.54 round: 10 nearest: 9.72 nearest_ceil 9.72 nearest_floor: 9.71 nearest_rand: 9.72 nlowmult: 9.71 nhimult: 9.72 round: 25 nearest: 25.03 nearest_ceil 25.03 nearest_floor: 25.03 nearest_rand: 25.03 nlowmult: 25.02 nhimult: 25.03 round: 5 nearest: 5 nearest_ceil 5 nearest_floor: 5 nearest_rand: 5 nlowmult: 5 nhimult: 5.01 round: 6 nearest: 5.83 nearest_ceil 5.83 nearest_floor: 5.83 nearest_rand: 5.83 nlowmult: 5.83 nhimult: 5.84 round: 4 nearest: 3.68 nearest_ceil 3.68 nearest_floor: 3.68 nearest_rand: 3.68 nlowmult: 3.68 nhimult: 3.69</span></span>
Can anyone provide any assistance, or KNOWS how sales tax SHOULD be calculated? If nothing else, has anyone NOTICED this issue?