Aarto
Reputable Poster
Hi List!
We're setting up Transportation rates for a new implementation. (Payable rate only, not billable) One of the offices are using per-ton rates in their current systems but the payable weight is rounded up to nearest 100 kilos.
i.e if the shipment weights 460 kilos, the rate is calculated on 500 kilos
I know this could be done using a lookup table, but i wonder if there is some other way of accomplishing this that does not require setting up a lookup table (As the shipment weights can vary from 100 kilos up to 250 metric tons)
OneWorld B733.2 (sigh) , no mods
NT server
Regards..
Aarto Reponen
We're setting up Transportation rates for a new implementation. (Payable rate only, not billable) One of the offices are using per-ton rates in their current systems but the payable weight is rounded up to nearest 100 kilos.
i.e if the shipment weights 460 kilos, the rate is calculated on 500 kilos
I know this could be done using a lookup table, but i wonder if there is some other way of accomplishing this that does not require setting up a lookup table (As the shipment weights can vary from 100 kilos up to 250 metric tons)
OneWorld B733.2 (sigh) , no mods
NT server
Regards..
Aarto Reponen