Carrier Allocation per Sales Order

[riccardopetriccioli]

Hello I am triyng to fit carrier to sales order

I have 2 tables:

Table1: this is the table of sales order.

this table has 2 columns:

1) Lane ID: Code to identify source/destination

2) Sales Order Number: sales order number (each row is a sales order)

Table 2: this table is the table of the trasportation carrier

This table has 3 column:

1) LaneID: Code to identify source/destination

2) Carrier ID: Code to identify trasportation carrier

3) Number of order per LaneID/CarrierID: this is the carrier availability per routeID/CarrierID

I need to assign to each sales order a carrier ID.

Please see excel file where you have row data and desidered output.

Thanks

[rzdodson]

@riccardopetriccioli is there a specific order you need to iterate through the CarrierIDs, or is sequential order okay (CDT1, then CDT2, then CDT4)?

[riccardopetriccioli]

No doesn`t matter the order. thanks

[sergejs_kutkovics]

@riccardopetriccioli , try something like this.

Hope, it helps.