Skip to Content
0
Former Member
Nov 13, 2013 at 05:27 AM

Collective shipment through Single Mode - Cost Calculation

164 Views

Hi,

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.

  1. Ie., assume the following below.

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.

Attachments

1.jpg (132.0 kB)
2.jpg (97.2 kB)
3.jpg (39.1 kB)
4.jpg (27.4 kB)
5.jpg (25.8 kB)