Currently we are working on Collective shipment through Single Mode of transport, ie.,
In one truck we will be loading deliveries for 3 different customers in the same route.
Our business requirement on shipment cost calculation is QTY * RATE for that one single shipment.
189930397 - customer 1 - 9.765 kg
189930398 - customer 2 - 10.850 kg
189930396 - Customer 3 - 1.085 kg
Rate/Kg = Rs. 8
When the shipment cost has to be calculated it has to give us the cost of
21.7 kgs * Rs. 8 = Rs.173.6/- (which is rounded off to 174)
In Shipment Document, first delivery considers all the subsequent delivery and its cost. Similarly the second delivery considers the subsequent delivery and its cost.
But the system considers all the legs and adds up the cost which is shown below.
Mail Leg - 189930396/97/98 - 21.7kg - 174
Subsequent Leg - 189930396/98 - 11.935 kg - 95
Subsequent Leg - 189930396 - 1.085 kg - 9
And all these costs get adding up.
174 + 95 + 9 = 278
System has to consider only the Main Leg where all the three deliveries appear.
Pls guide me.