Shipment Charges calculation
Hello
We need to calculate charges for a shipment. Rates are defined for PL and based on unit amount. UOM conversion is defined for pallet as 1 PL = 120 KG. 1 PL = $10. Rates are created based on the unit amount.
For example, if the shipment weight is 2000 KG (based on a sales order), then the number of pallets will be 16.67 PL. In this case, we should calculate it as 16 PL (round to down value) to include the actual weight only and calculate the amount as $160 instead of $166.7. Currently the system calculates $166.7.
Please help me on how to configure this, so that system calculates the charges as $160. Thank you.