Skip to Content
avatar image
Former Member

how to restrict selling price in Sales order ?

Dear Experts,

I want to restrict the selling price entered in the Sales order for all scrap material codes in our company.

The restriction should be in a way that the selling price entered must greater or equal than the standard price of the scrap material in material master.

e.g 7101 material code is taken. the standard price of if in Material master is Rs. 100.

     Now when 7101 is used in any sales order then the selling price of it entered must be greater than or equal to 100.

So if its possible to achieve this then kindly suggest the procedure.

Thanks,

Vishal.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 29, 2013 at 01:22 PM

    Hi Vishal,

    Please refer below document created by MozzaM about minimum price scenario it will give you some insights.

    http://scn.sap.com/docs/DOC-32943

    Also, you can apply below logic with the help of ABAPer.

    • Add VPRS condition type with Condition category S (Standard Cost) in your Pricing Procedure.
    • Assign Sub Total B field to VPRS condition type

    Above settings will bring Standard Cost of Material in Pricing Procedure and will store in KOMP-WAVWR field.

    • Now, create routine with Logic to read this field of KOMP-WAVWR and compare it with your Base Price condition type. (Store value in Sub Total field D (XWORKD)).

    Now, you have 2 options to decide:

    1) If your base price is lesser then Standard Cost, you can add the difference value with Surcharge condition by Calculation formula based on logic below:

    If KOMP-WAVWR minus XWORKD is > Zero then XKWERT = (KOMP-WAVWR minus XWORKD)

    2) Another option is you can just store the value and check in User Exit MV45AFZZ pass the Delivery Block value.

    Regards,

    MJ.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2013 at 10:18 AM

    Hi Vishal,

    Recently we have done this. Our purpose was restricting any discount which makes our Selling price less than the cost price.

    You can achieve this by writing a requirement module and attach it to your condition type in Pricing procedure.

    You can also put validation in Sales order user exit and if there are violation, you can generate an error.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded