cancel
Showing results for 
Search instead for 
Did you mean: 

Two postive condition type in sales order

Former Member
0 Kudos

Dear All,

The requirement is, how's two positive condition type makes subtract in sales order.

e.g: suppose in first condition type rate is rs 100 

In second condition type rate is rs 50

Net amount should be 50 (100-50)

Please suggest.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks to all,

As jitendra told right but want to confirm is there any standard process?

srinu_s1
Active Contributor
0 Kudos

Deepak,

What do you mean by standard process for the above requirement, please elaborate it .

Srinu.

Former Member
0 Kudos

Srinivas,

I mean to say that without routine its possible, any standard configuration occur?

srinu_s1
Active Contributor
0 Kudos

Deepak,

In the definition of the condition type subtraction calculation is not available hence you need to assign the routine only to calculate the value.

you may need to use standard routine 11 in Alt cal type field in pricing procedure,you may try with that.

I assume you know how profit margin is calculated.

Similarly you can assign the routine 11 against the ZZ13 condition type in Alt cal type in the pricing procedure.

Check and let me know.

Srinu.

mahendra_jani3
Contributor
0 Kudos

Hi Deepak,

This is very well possible in Standard process.

Condition 1 = ZZ11 = 100 INR (+ Ve)

Condition 2 = ZZ12 = 50 INR ( + Ve)

  • Create new Condition type ZZ13 with (- Ve) sign and as % Calculation Type.
  • Maintain Condition Record with 100%.
  • Update From field next to it as ZZ12 condition type step Number.
  • Subsequently have Addition of ZZ11 and ZZ13 with the help of From to TO steps fields.

Another way is to Use Standard Alt Cal Type Routine 12 (XWORKD-XWORKE)

  • Update Sub Total D next to Condition 1 = ZZ11 = 100 INR (+ Ve)
  • Update Sub Total E next to Condition 2 = ZZ12 = 50 INR ( + Ve)
  • Create New Condition Type ZZ13 without Access Sequence. And Update 12 in Alt Cal. Type field.

You will achieve desired result.

Regards,

MJ.

Former Member
0 Kudos

Hi Mahendra,

Firstly thank u so much..

The second process is working rather than first, can you help me for first process.

mahendra_jani3
Contributor
0 Kudos

Hi Deepak,

What issue did you face while trying first option?

Regards,

MJ.

Former Member
0 Kudos

Hi Mahendra,

During first process ,difference is not triggering .

mahendra_jani3
Contributor
0 Kudos

Hi Deepak,

Can you share Screenshot of Pricing Procedure where you have done mentioned settings and then in Sales Order Condition Tab where respective conditions are determined?

Based on that we can check why it is not working.

In Normal way, by FROM and TO fields, you can have addition of condition type values. By creation of New condition type with (- Ve) sign and 100 % value referring we have made it negative, so now by FROM and TO fields (Steps) we can have addition of condition type values where it will consider now (-Ve) value.

Regards,

MJ.

Former Member
0 Kudos

Hi Mahendra,

ok, i'll share it just give some time.

srinu_s1
Active Contributor
0 Kudos

Just to add to Mathur, you need to assign the newly developed routine in field Alt Cal type against the condition type ZZ13 in the relevant pricing procedure.

Srinu.

Former Member
0 Kudos

Hi Deepak,

The first condition type can be the base pricePR00  say 100 rs & the second one can be your discount. This discount can be k004.....or any when you define your records, you can have a gross price & then the 2nd condition type as discount & then  Net value which is 1 minus 2 the  you can do this.

Can you elaborate your query  .

Thanks

j_mathur
Explorer
0 Kudos

Hi Deepak,

In your case mentioned above you will need three condition types

E.g.

Condition 1 = ZZ11

Condition 2 = ZZ12

Condition 3 = ZZ13

Where ZZ11 - ZZ12 = ZZ13

To achieve the above result a new VOFM routine will required to be developed which will take the value from ZZ11 and ZZ12,  Calculate the difference and provide that as value to the condition type ZZ13.

Hope this helps.

Jitendra