Freight and Special Charges based on Special/Master Price List instead of Customer Price List
We have a below business requirement.
On each sales order line, the item unit price should default from the Customer Price List (CPL), while freight and special charges must be calculated based on the Master Price List (MPL).
Example
- Item: ITEM-A
- CPL unit price: 80
- MPL unit price: 100
- Charge rate: 30%
- Expected freight/special charge: 30% of 100 = 30
Is this achievable in Oracle Order Management R12. where the sales order line price comes from the CPL but freight and special charges are calculated as a percentage of the MPL unit price? Could you please advise the step to achieve this? Thanking you in anticipation.