Variable Freight which needs to be splitted on the PO lines based on the quantity

Hi,

We have a requirement where we receive a purchase order from our supplier and the Freight is different each time. We then split the freight on each item based on the quantity and update the cost of the item on the purchase order line.

We can't us the cost components in the landed cost (P41291) since it's not a fixed percentage or a fixed value by item. Is there any standard functionality or any workaround which we can use?

Thanks,

Mahjubah