Transport name in sales order

Dear Team.,

Kindly let me know how to add transporter name field in sales order which is linked to supplier, but the condition is it should show only the ‘Is Transporter’ supplier’s in the transporter name field

You’ll need to write a custom script to filter out the Suppliers with Is Transporter set.