Problem with Accessorial Cost
We are having two accessorial cost (For example A & for FUEL SURCHARGE.
A is effective on 10/11/2011 and will be expired on 10/18/2011 (In the table ACCESSORIAL_COST, effective_date is stored as 10/11/2011 8:00:00 AM and expiration_date is stored as 10/18/2011 8:00:00 AM)
B is effective on 10/18/2011 and will be expired on 10/25/2011 (In the table ACCESSORIAL_COST, effective_date is stored as 10/18/2011 8:00:00 AM and expiration_date is stored as 10/24/2011 8:00:00 AM)
There is a shipment starting on 10/18/2011 at 6.05 PM. Theoritically, the system should apply the FUEL Charge B.
But for some reason, Fuel Charge A & B are getting applied. This results in increase of shipment cost.