Select more expensive rate
Good morning,
I am planning 3 orders into one shipment. I need OTM to sequence the shipment stops in such a way that it picks the most expensive rate (the one corresponding to the last stop).
Example:Rate structure: 1 Rate Record per origin-destination per carrier:
RR | Carrier | Origin | Destination | Cost |
---|---|---|---|---|
1 | 103643 | BR23 | A | 43,806 |
2 | 103643 | BR23 | B | 112,187 |
3 | 103643 | BR23 | C | 112,187 |
OTM should generate the shipment as follows:
Origin > Stop A > Stop B > Stop C
Total cost: $112,187
I understand that there are other rate structures that could achieve this result, but we are not able to modify them at this time. OTM trend is always to optimize in this case, but the client wants the trip to be made with the most expensive rate, and this combination is variable.