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
Comment