[grahampage]

We have had a request to track whenever a user manually overrides the carrier selection on a shipment and bypasses carriers. I know the planned carrier and cost information is on the shipment table and this can be used to compare the first choice with the current carrier, but our management team wants to know (and possibly alert people) when the user has selected Carrier #5 instead of Carrier #3 when Carrier #1 and #2 have declined the shipment. The cost order of the shipment is Carrier #1, Carrier #2, Carrier #3, etc…

I know the audit tables are available but I cannot fathom the SQL to accomplish this. I have told people that this is not really practical but I wanted to get other peoples thoughts to see if they have tackled a problem like this.

Thanks

[bob_romijn]

Hi,

The tender-history is stored in the tender collaboration part. You can see there per shipment how many tenders are sent out and whether they were declined, accepeted etc.

If the planner selects a carrier without going first to the proposed carriers, you will only find 1 record in this table.

Hope this helps.

[grahampage]

Thanks for the reply Bob.

If the planner tenders the shipment then I does an insert into this table, but how do you them determine that the carrier selected on this tender was not the next best carriier that has not refused the load in the past. For example, If SWFT is the 5th cheapest carrier for the shipment and it has already been declined by JBHT and HAEI who were 1st and 2nd cheapest then how to I catch the planner who picks SWFT and bypasses the 3rd and 4th best carrier in cost?

I just see that the record in this rable tells me who the planner chose and not whether the planner made the right choice.

[bob_romijn]

Hi,

I onlly gave you the possibilities you currently have..... I do agree with you that your scenario won't work.
It doesn't tell you anything about who was the cheapest carrier.