Hi. I have an order of three lines. Each line has UOM units with packaging (containers ) each container contains different number of units. I am trying to add shipping cost as landed cost , i get an issue with the calculation (not an error) it is a business case). I would like to explain the shipping cost: Line 1 of the PO has two containers , the second line has 3 containers and the third line has one container , each container cost 2,000 USD. Now how can I compute the landed cost for each line of the the receipts of the three line where each has different number of units ? The expected calculation is the following:
1- Line 1 (6000 USD/number of units of the related goods receipt of line 1)
2- Line (4000 USD /number of units of the related goods receipt of line 2)
3- Line (2000 USD /number of units of the related goods receipt of line 3)
The computation landed cost of each unit in each line is not right.
I got a solution of receive each individual line separately and add create a separate landing cost for each line. This solution will not be feasible because it requires a lot of work if you have a lot of orders and each has several lines of different number have to be treated separately.
I would be grateful, if any one has suggestion?