PO Freight Condition Header Level (Percentage)
I have business requirement from my users that the PO Freight Condition is maintained at header level with calculation type in percentage. They specifies freight condition i.e 5%, and PO total value was $2000, so the value of freight was $100.
My query, the amount $100 is possible to apportion at the item wise based on gross wight after GRN? let say the;
Material A gross weight 10Kg, Qty = 1, Net Price = $1000
Material B gross weight 5Kg, Qty = 1, Net Price = $1000
as result the stock value will be Material A (10Kg/15Kg) x $100 + $1000 = 1066,67 while Material B (5Kg/15Kg) x $100 + $1000 = $1033.33
Your input is very much appreciated.