Thread: Tax rate calculation question

We need to use tax rates for NY state that are 8.875 but the calculations are coming out for only 8.87

Can anyone provide some guidance as to a code adjustment to help correct this.

ML 7.0.2.0 C# with source

Are you serious that they are carrying tax out to the hundred-thousandth place? This is going to require mods in a few different areas due to rounding, etc. We'll have to have our dev team take a look at updating future builds. I'll get it logged on the to-do list.

OK, so can you provide an ETA on the update? The website is not usable until it can collect the appropriate tax. Are we the only ones collect NY state sales tax? What are others doing?

No ETA on this. Sorry. It just went into the queue yesterday. This is absolutely the first we have seen of states carrying taxes out to a thousandth of a percent.

OK. We hope this is being given a high priority. Please let us know as soon as the update is expected.

Texas has been carrying out sales tax calculations to the thousandth place (eg. 8.875%) for years.

Can someone please provide an update on this. If there an update available yet that will address this? If not, ETA?

California (8.975) has the same issue, any word on on when this will be corrected?

We're going to try to get it in ML9, but that's not definite yet. What definitely WILL be available then is the Avalera AvaTax addin, which will allow you to get realtime rax totals from their service, which will account for changes like this and save you from having to manage tax rates yourself.

Any ETA on v9 with the Avatax support? We're getting slammed in NY on the sales tax stuff.

not sure if this will directly solve your problems, but I ran into something similar...
my problem was that taxes were being miscalculated as follows.

item 1) 19.95
item 2) 23.95

tax rate 9.25%

calculated tax was 4.07
correct tax should have been 4.06

The problem was that the rate was applied to each item, then rounded and then added. I *believe* the correct method is to only round at the end.

To fix this, I modified this stored proc: aspdnsf_GetCartSubTotalAndTax

starting around like 225, changed this:

UPDATE @tblsubtotal
SET Tax = CASE sc.IsTaxable
WHEN 1 THEN
case @vatroundingmethod
when 1 then round(FinalDiscountedPrice*((isnull(cr.taxrate, 0)+isnull(sr.taxrate, 0)+isnull(zr.taxrate, 0))/100), 2)*Qty
else round((FinalDiscountedPrice*Qty)*((isnull(cr.taxra te, 0)+isnull(sr.taxrate, 0)+isnull(zr.taxrate, 0))/100), 2)

to this:

UPDATE @tblsubtotal
SET Tax = CASE sc.IsTaxable
WHEN 1 THEN
case @vatroundingmethod
when 1 then round(FinalDiscountedPrice*((isnull(cr.taxrate, 0)+isnull(sr.taxrate, 0)+isnull(zr.taxrate, 0))/100), 4)*Qty
else round((FinalDiscountedPrice*Qty)*((isnull(cr.taxra te, 0)+isnull(sr.taxrate, 0)+isnull(zr.taxrate, 0))/100), 4)

notice rounding change to 4 decimal places.

Further down that procedure, the final value gets rounded anyway, so it should fix the problem:

select
round(sum(FinalDiscountedPrice*Qty)+sum(case when @IncludeTaxInSubTotal = 1 then Tax else 0 end), 2) SubTotal,
round(sum(Tax), 2) TotalTax
from @tblsubtotal


mod at your own risk.

Can someone please provide an update/status on this.

This sounds a lot like the VAT/Tax rounding issue where prices can sometimes end up 1p out due to rounding errors.

We've fixed this for clients in the UK but it involved a fair amount of change in the source code covering prices, shopping cart, receipts, discounts, coupons, customer levels, you name it!

Prices.cs is where the bulk of changes have to be made by updating the rounding from 2 decimal places to 4.

I found changing the data type on the ZipTaxRate table to numeric(18,6) from money worked.

Originally Posted by webopius

This sounds a lot like the VAT/Tax rounding issue where prices can sometimes end up 1p out due to rounding errors.

We've fixed this for clients in the UK but it involved a fair amount of change in the source code covering prices, shopping cart, receipts, discounts, coupons, customer levels, you name it!

Prices.cs is where the bulk of changes have to be made by updating the rounding from 2 decimal places to 4.

Hi There,

I am facing same issue of price/VAT rounding to two places of decimal. I have looked at the code and changed few bits of it., but still struggling to change price at few places.

It would be really helpful if you could tell me what all files i need to change or if there any fix available.

Regards

Anil