GET CUSTOM PRICE - Issue with Price on Sales Order Creation
We are having an issue when we create a price list using formulas.
Issue is described below
- Create a Formula as NVL(1,2)*3 where 1 is derived from GET_CUSTOM_PRICE (custom code), step 2 is constant 100 and step 3 is constant 1.3
- Assign a dynamic formula in the price list for an Item.
- Create SO using the same price list. Enter item and QTY in SO line and tab to next cell.
- Observe that Price gets defaulted as 130 first. Save the record then observe the price change.
This is an issue as the price is getting communicated wrongly at first shot where as without Formula, user can see the price immediatly when they tab out to next field. We need to save the the record to see the actual price whne we use formula.