[soujanya]

hi,
thanq very much for ur reply., but the issue what i am facing is different. while i am uploading the shipment the actual distance between source and destination will be coming into OTM .

Suppose source is A and destination is B then while uploading the shipment , the distance beteen the locations X Kms will be known.This distance will vary for each n every shipment.

then i need to rate 30$ per Km for that shipment.

this Distance is not know until the shipment info comes into OTM.

For this i have tried in the following ways:

Scenario 1:

XKms i am storing in order refnum and tried to update this distance into distance look up table directly using direct SQL Update.

This Update is happening but the same is not reflecting in the front end.


Scenario 2:

The other way tried out is In shipment stop table ,updated this distance in distance travelled filed , even here it is updating in back end.

But while assigning rates., again it is taking form lanes only. not taking the updaed value..


thanks & regards,
Vidya Sowjanya