Pricing - Condition Base Calculation

[Former Member]

Hi,

Please help me on the below issue

I have a material with price on two unit of measures.

One price at 80MK level and another price at 25Kg Level.

The material can be sold in multiple UOM like 60MK,50MK, 20KG, 10KG etc.

The base price for 60MK or 50MK is 80MK and Base price for 20Kg and 10KG is 25KG price.

How can i achieve this by using one condition type?

On the current condition record, i am able to maintain price either by 80MK or 25Kg not for both.

Thanks

[sez41]

Technically speaking you can create a new condition table which includes sales unit of measure as a key field (for ex: Sales org / Dist. Chn. / Material / UoM). From there on, user can create two separate condition records, differentiating by UoM. User should be alert enough to enter the same UoM both at condition table header level, and condition table item level.

[Lakshmipathi]

Not sure whether you are aware of alternate UoM in material master

[Former Member]

Hi Lakshmipathi,

Yes, i am aware of alternate UoM but it wont work.

80MK = 21.22 KG in UOM but the price for 80MK and 25KG are same.

Eg: 1 Qty of 80MK = 100$

1 Qty of 25KG = 100$

If i maintain the UOM and price for 80MK then if i create order for 25KG the price showing up on the order is not correct.

This is where i am struggling to see if i can maintain 80MK and 25KG prices at the same time.

or 80MK price condition and fetch 80MK price when ever KG uom comes on the order.

Thanks

Venkat

[VeselinaPeykova]

Is my understanding correct: you have at least two ways to sell a certain product - bulk (by KG) and packaged (in MK)?

I am asking, because, apart from different packaging, I cannot think of another reason at the moment why the same quantity of the same product will have different prices.

If you perform subsequent packaging, is it not more appropriate to show the packaging as a separate item or at least a separate condition?

If you produce both in MK and in KG, this could even be treated as separate products - e.g. I buy a sack of coffee beans of 20kg vs I buy 20 cans of 1 kg of the same coffee. What does the controlling expert in your company say about the case, which you mentioned:

80MK = 21.22 KG in UOM but the price for 80MK and 25KG are same

How did he explain this?

To be fair, I have seen a case, where a company decided to treat products in various sales UoM, different packaging, different sales prices and different cost to produce, as the same material. The end-to-end solution was rather complicated and expensive.

Have you discussed the business case with your colleagues and the solution architect?