Using best rebate (adjustment) to calculate selling price

Summary:

Hi,

Our customer maintains fixed price for few items, market cost for few items and also pricing based on Actual cost from costing. Once cost is derived, an adjustment is applied to the actual cost or replacement cost to get the selling price.

Adjustment is maintained in rebates and a customer may be eligible for multiple rebate programs; Pricing should pick the best adjustment to get the lowest cost of the item.

Customers are associated with group, sub-groups and to a geography.

Check if price is available for customer else check customer group and sub-group to find the best price.