When calculation type is % for any condition type, why PER and UoM columns are grayed out for such condition types in VK11?

[ali-sd]

Hi all,

I have one more ticket on pricing. Hope, would get response quicker.

When calculation type is % for any condition type, why PER and UoM columns are grayed out for such condition types in VK11?

But the same is working fine if calculation type is "fixed amount". I can enter data in PER and UoM columns.

When client can give discount like 300/- per gram why cant he give 3% per gram?

[ali-sd · Accepted solution]

Thanks for giving clarity. However, my client is also expecting discount in % on grams. I can see this is not possible in standard. Is there any way out from routine/user exit point of view?

[moazzam_ali · Accepted solution]

Hi

I am still confused that how your client would like to give discount. Let us take a simple example and you need to confirm me the discount value.

Material A has selling price 100$ per gram. Discount percentage is 3% per gram. You create a sale order with quantity 10 gram. What would be the discount value and how would your client wants you to calculate it? Please elaborate with this example and calculation.

Thank$

[ali-sd]

Hi,

Thanks a million MoazzaM bhai, now I understood your question and stress on amount.

Now my mind shifted from (a) to (b)
(a) 3% per gram
(b) 3% per gram amount/rate/value.

Superb logic!
By writing the scenario as you asked, it clicked my mind (god's grace)

Let me also add the scenario below for others to get an idea if they are following our thread:
         Our each material is based on custom order (MTO). Lets assume that material A is a necklace, and its ordered with expected weight of 20 gms. Lets say the selling price of necklace or any gold article is 1500 per gram (inclusive of vendor charges + other all expenses + mark up). After vendor manufactures and issues it to the company (with 20 gms of weight). Now the selling price of this necklace is 20x1500 = 30,000.

We already have a discount of 50 rupees per gram (so as per this order, discount is 50x20 = 1000).

And now we are expecting 3% of gold rate per gram (so as per this order, discount is 45 per gram (3% of 1500). And then 45 rupees x 20gms = 900.

Therefore, the actual discount of 3% on 20gms necklace  = 900 rupees. Bravo!

May gold bless you!

[Former Member]

Amazing Ali!

Keep it going. Wonderful input from you people.

[moazzam_ali]

I am glad that we came up with a conclusion. Thank you detailed explanation and sharing your understandings.

Thank$

[ali-sd]

Hi MoazzaM,

But my client wants discount at weight level (per gram), it should not be value dependant at all.

This concept is already working in standard but with fixed amount.
Example: I can give discount of 500 rupees per gram (irrespective of the item value). In this key combination, value has no connection.

You may open and zoom this pic to see the discount of 15,560 (500/gm). That is 500 x 31.120 (qty).

[moazzam_ali]

Hi

Fix value and quantity is ok and that is understandable. When we talk about percentage discount this is basic calculation rule that we always calculate percentage of some base amount. Just saying that 3% discount per gram is not workable. Percentage is always calculated for base value not for quantity. You need to take some base value or use fix value discount.

Thank$

[ali-sd]

Dear MoazzaM

I really appreciate for your response. I understood your opinion. However it differs from my requirement. Please see the below picture to get an idea:

[moazzam_ali]

Hi

You want 3% per gram but could you please share 3% of which amount? Let us say your material price is 100$ per gram and order quantity is 3 gram.. Net value would be 300$. Now you want 3% discount per gram but how would system calculate this 3%?

Thank$

[ali-sd]

Please find the below screen shot for better understanding.

[moazzam_ali]

Hi

This percentage condition type always calculate percentage of some base value. In pricing procedure we select the base step for which system will calculate the percentage. Lets say you want to calculate 3% discount on retail price. You need to give step number of retail price condition type in front of percentage condition.

Further you can google it and read the calculation types of condition type in SAP SD.

Thank$