Skip to Content
Author's profile photo Former Member

Quantity conversion in Sales order

There are instances when user wants to alter sale terms for a material. We can enable the user to enter quantity conversions directly in sales order by configuring relevant condition types. In V/06, go to Changes which can be made section for the condition type and choose Qty relation indicator. User will now be able to directly enter quantity conversions in sales order without maintaining the same in material master.  If sale unit is EA and user wants to specify price per KG, the same can be entered directly in sales order pricing without maintaining conversion in material master. Condition type has to be set with ‘No limitations’ or ‘Manual entry has priority’ along with ‘Qty relation’ as allowed.

I maintained EA as base unit of measure for material and Gross weight as 10 Kg. If I require to change my rate of conversion, I can do so directly in the sales order. I enter price per KG and System prompts user to enter conversions and user can specify, say 1 EA = 25 Kg.

However, there is little control over user input and this can lead to user errors. This can be used where both product pricing & packing is as per demand or sale conducted.

***

Assigned Tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo venu gopal
      venu gopal

      Dear Karuna

      one doubt on this plz let me know

      User will now be able to directly enter quantity conversions in sales order without maintaining the same in material master.

      Here in c. type where we can maintain EA or BAG or Cartans bz it is possible in MMR ONLY

      And while creating sales order when ever we want to enter 2 EA and Cartons we have to use additional factor in mmr  but you are telling only in c.type we can control .. how it is possible

      What my doubt is if not maintaine EA ,CARTONS then where we maintain for material

      plzlet me know

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Venu,

      Here your units of measure are specified in MMR, however rate of conversion can be changed in sales order.

      Author's profile photo venu gopal
      venu gopal

      Hai now i got clear bz in last post ( before updating your post .. it was confusing ) now ok clear

        

      Thank you so much for sharing 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Glad its clear... 🙂 Test it as well.

      Author's profile photo venu gopal
      venu gopal

      Dear Karuna one doubt

      for which condition we can activate --QNTY REACTION bz so many conditions we will have so this is my doubt 

      Author's profile photo venu gopal
      venu gopal

      Dear Karuna One thing let me know

      Generally we maintain  unit of measurement) based on the product

      but you are telling that is possible in sales order at condition type level  , but in sales order level we have so many condition types so on which condition and in which business process  we will fallow this scenario

      For which condition type we will maintain bz we have so many condition

      thanks a lot ..

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Venu,

      Use it for prices, & discount conditions and that too only if user requirement is such. One industry where this can be used is retail, and also industrial products like steel where output material dimensions are not exact.

      Author's profile photo venu gopal
      venu gopal

      Dear One clarification

      suppose i have maintained pr00 c. type( cartnos) i can change in sales order but discounts (ea) maintained but in sales order which will come

      as per my knowledge system will maintain price based on condition types 

      Author's profile photo Suman Sardar
      Suman Sardar

      Nice document but would appreciate much if you write with detail and with real time business need.

      Thanks,

      Suman$

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Noted your suggestion Suman, Thank you... 🙂

      Author's profile photo Former Member
      Former Member

      Thanks a lot for your helpful information

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Glad you found it helpful Moshira.. 🙂

      Author's profile photo Former Member
      Former Member

      Thanks Karuna,

      Its a nice information !!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Jay 🙂

      Author's profile photo Amala Srinivasa Rao
      Amala Srinivasa Rao

      Appreciable effort dear 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Srinivasa 🙂

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      This is something new for me. Thanks for sharing dear.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you MoazzaM 🙂

      Author's profile photo Former Member
      Former Member

      Hi Karuna Ravi,

      Kindly clear my doubt.

      We want to use a condition for freight which is a proportionate on Gross value but the factor has many decimals but default decimal allowed is only 3.

      E.G Gross value 1000000 the factor for freight is 0.00851 so the freight value should be 8510 but the value flows is 9000. How to deal with this.

      Thanks and Regards,

      G.Sethuraman

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Sethuraman,

      What are the units being used?  Is your freight 8.51 per Kg?

      Accordingly, you can specify condiiton values.

      Thanks,

      Karuna

      Author's profile photo Former Member
      Former Member

      Hi Karuna,

      Thanks.

      The unit is % on Gross sales value so we cannot specify it correctly to last decimal. Example factor is 0.0000851 so even if we use as % it comes to 0.00851% but we could enter only 0.008% bcoz it allows only 3 decimals.

      Kindly suggest.

      Thanks,

      G.Sethuraman

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Sethuraman,

      If your % rate is expected to be that low, then it is better to use fixed amount or gross weight as calculation type of your freight condition instead of percentage. In such cases we can use qty conversions.

      However in case of % of sales value cannot be changed to anything else. The main issue in your case is rounding; so please check SAP notes on rounding. They might be of help.

      Karuna

      Author's profile photo Former Member
      Former Member

      Hi Karuna,

      Thanks for your suggestions

      Author's profile photo Siva Prasad V
      Siva Prasad V

      This is good to know

      thank you for sharing

      Author's profile photo Former Member
      Former Member

      Very Nice, Hope to see more, Good Learning

      Author's profile photo Pradeep Mani
      Pradeep Mani

      Good Document..Keep sharing

      Author's profile photo Former Member
      Former Member

      Very Informative, Karuna. Thanks.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Glad you all find it useful.

      Thank you. 🙂

      Author's profile photo Former Member
      Former Member

      Hi Karuna,

      Very much informative.

      The doubt asked by venu gopal clear all the confusion.

      keep sharing such new things.

      Regards

      Bijay