Skip to main content

We have a situation now where we have 5 different products. Each product can have 5 different prices (tiers). A customer may have a price agreement for prices from different tiers for the different products. Is there a way to solve this without creating 5x5x5x5x5 price books (one for each combination of products/tiers)? We cannot have multiple price books on contracts, from what I can see. Any bright ideas?

Hi Bjørn,

So your pricing agreement is per customer, not per product. You can define a price book for the customer or even a price book for the contract.

Perhaps if you create a price book for each tier as a contract price book reflecting by that name, you only have to have a separate price book for each tier… thus 5x5.

 

This way you only have to have a price book per tier and define all the product prices there for that single tier.

It sounds like you want to have tier pricing within a single contract and outside of meter readings, Alliance does not support tier pricing (that I am aware of).


Thanks, Phil. Yes, I know I can easily create a price book per contract (or customer), but this will cause a major headache going forward, as we have to maintain them. So we try to have a few price books as possible. And since the prices are all over the place (one customer can have tier 1 pricing for product 1, but tier 3 pricing for product 2, and tier 4 pricing for product 3) we will either have to create (and maintain) price books with all possible combinations of these products. Or have customer specific pricebooks. Or change our pricing structure significantly. It’ll probably be the latter - I am just going to relay the bad news to the responmsible party here


You will need specific price books per customer in Alliance to handle that scenario.

I don’t see a ‘simple’ solution due to your requirements.  Unless someone else has a better idea, I think you would be best served discussing this with one of the business consultants but understand that pricing can be a complicated process and changes to pricing rules depending on a customer ‘mask’ is not a simple task.

By mask, I mean the combination of products/price for the tier applicable for that combination for that customer set.

Customer A: Product 1 tier 1, Product 2 Tier 3, Product 3 Tier 2, etc.

Customer B: Product 1 tier 2, Product 2 Tier 1, Product 3 Tier 3, etc.

You would still be managing managing many different prices across multiple price books, even if you use the same mask for a group of customers.  Just one change would potentially mean a new price book to maintain.

Myself, I don’t see a solution as it currently stands with price books in the Alliance functionality.

If these prices can be formulated, perhaps you can look at code to modify the prices based on a customer set masking table.  E.g.  product has a base price, tier 1 is base price, tier 2 is base + 10%, tier 3 is base + 30%, tier 4 is base + 60%.

Again, I think you need to discuss with one of the IFS business consultants.

 


We created different product ID’s for a similar situation. So product 6077 now has 6077-100; 6077-115.. and so on. 


Reply