Advanced Pricing - EBS (MOSC)

MOSC Banner

Pricing formula

edited Aug 28, 2014 5:01AM in Advanced Pricing - EBS (MOSC) 1 commentAnswered

Hi

We have unit of measure conversion requirement from GALLON to EACH.

As per standard UOM conversions, 1 GALLON = 3.785 LITER. We also have item specific conversions from LITER to EACH. When an item is entered in sales order, the conversion value should be calculated to EACH. For example take item A001, which has primary UOM as EACH and inter-class conversion as 1 LITER = 0.001 EACH. When this item is entered in sales order, a surcharge of $300 (this is a constant value)*UOM converted value (1 EACH = 1/0.001/3.785, which comes to 264.2 GALLON) should apply automatically.

Inter-class conversion is item-specific. So the approach we thought was to define a formula with 2 steps - step 1 is a modifier value and step 2 is GET CUSTOM PRICE. Modifier value in step 1 is amount of $300. Is this approach correct? Formula can return the calculated UOM converted value or it requires other attributes like price list line etc.?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center