|UPS Rate Table|
But then you see that when Everest imports the rate from UPS, it makes an assumption that everything is in 1 lb increment. So you can clearly see that if a weight falls between, 74.01 to 75 lbs, it will not calculate the shipping rate, because it simply does not exist.
|Everest Freight Rate Table|
I did contact Everest before, I don't remember when, but it was a long time ago, but they have not recognize it as a bug at that time. Well it is a bug. But very simple to fix. All they have to evaluate the two rates and this way they won't make the wrong assumption. But that is Everest. So..... I am going to post the sql script to fix the problem.
where zonecode=634 and docwtfrom>50 and docwtfrom<100
where zonecode=634 and docwtto>100
Replace the 634 with the appropriate zone. Remember this will only work for UPS format, others I do not know.