We need to built formula based on item weight. how to get item weight in to advanced pricing
We are on EBS 12.2.11
We need to built formula based on item weight. how to get item weight in to advanced pricing
User will enter sales order, in the sales order line we have item and ship from org. based on this combination we need to fetch the item weight in to advanced pricing to calculate the final price for the item, below are the details
tem: XXXXXX
item weight: 26.4 ( this value is from organization item form)
item base price:172.08 (From price list)
Metal Constant: 0.080 (Constant value or from pre defined lookup values)
Assembly price:10.98 (Constant value or from pre defined lookup values)