OTM rate record rounding setup
Hello,
Can someone advise if this logic of rounding is possible in OTM please.
Order A - 2.6 pallet place
Order B- 2.2 pallet place
Sum 4.8 pallet place 6 pallets
Rate record with condition >5 pallet places
I want to apply rounding to 0.5 interval on number of reference units (pallet place) so at the time of calculation, 2.6 = 3 and 2.2 = 2.5 which together is 5.5, therefore the rate record would be assigned to shipment.
There are 2 tables where i tried to set it up, RATE_GEO and RATE_GEO_COST.
I have set it up as follows
This does not work. I would appreciate any advise. Thank you!
0