Skip to Content
avatar image
Former Member

Pricing calculation in sales order with quantity scales UoM

Hi,

I am having an issue for pricing calculation in sales order with scales.

My scenario is that, my sales UoM and base UoM is same which is CS (case)

I have maintained CS to Pal ( Case to Pallet) conversion in material master

I want to maintain the scales in Pallet. as if customer purchases 0-5 pallet then price is 10 USD per case, 5-10 pallets then 9 USD per case, 10-20 pallets than 8.5 USD per case and anything above 20 pallets is 8.25 USD per case.

When I try to maintain the scales in this way, and create a sales order with say 10 CS, it considers CS as pallets and gives me 10 pallet pricing which is 9 USD per case.

I have maintained the pricing condition as Scale basis: C ( quantity scale), check value as A ( descending), i tried with scale type A and without it as well. I could not figure out the solution to this. Can anyone help.

Thanks

Nikhil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 12, 2012 at 05:29 PM

    Dear Nikhil

    The above scenario described by you best suited in TO-Scale Scenerio, I have made a scenerio where 1 Case equal to 24 Bottle and maintained Scales on the basis of Bottles and sold in cases and system is doing exactly what it should do:

    Material Master:

    In Material Master don't put anything in sale unit.

    Now in the condition record

    Now condition Details

    Now Scales

    Now Sale Order

    You can see I have made it into CV

    Now, at item conditions

    You can clearly see that its doing what it should do!

    This will resolve your issue!

    Regards

    Ashish Mishra



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Nikhil,

      For your information I had followed Ashish Mishra's configuration step by step and it worked fine.

      As per my understanding still if your problem is not solve, do deselect "sales unit not var"

      Because in the time of testing I had also same problem.

      Hope this will help you

      Regards

      AJC

      pastedImage_0.png (24.5 kB)
  • avatar image
    Former Member
    Nov 12, 2012 at 06:32 AM

    Hi Nikhil,

    In your query I have 1 doubt that is 1 pallet= how many cases???

    for eg. 1 pallet=10 cases

    maintain it in MM01---basic data-- additional data--- unit of measure in both way 1 pallet=10 cases and 10 cases=1 pallet

    Now you need to maintain price scale properly in VK11/12 as per you requirement, try to crate a new sales order (if new price is not coming click on "update" in pricing procedure---- carry out new pricing )

    Hope this will solve your problem.

    Happy to Help You.

    AJC

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashish,

      I have maintained the pricing condition records for this price scales. In addition, i have already maintained the CS to PAL conversion in material master -> additional data.

      The UoM conversion is maintained as 1 CS = 1CS ( base unit)

      1 PAL = 20 CS

      The pricing condition is maintained as

      Material -ABC       Amount 10  USD per CS and scales as

      0 PAL = 10 USD per case

      10 PAL = 9 USD per case

      15 PAL = 8.5 USD per case

      20 PAL = 8 USD per case

      When I enter in the order 10 CS of order, it takes the value as 9 USD. It should have taken the value as 10 USD instead.

      In MM01, it will not allow you to maintain the UoM both ways. the screen locks the base unit and only allows you to enter other units. So I have 1 CS = 1 CS, 1 PAL = 20 CS. I cannot add 20 CS =1 PAL

      Thanks

      Nikhil

  • avatar image
    Former Member
    Nov 11, 2012 at 06:11 PM

    Hi Nikhil ,

    System calculates the Unit Price based on the UoM mentioned in the Condition Record. Whereas the net price will be calculated on the UoM mentioned in the Sales Order.

    Please check in your document. It should work. Also check with the conversion you have mentioned in the material master.  I have mentioned 1 PAL = 3 CV. Refer the screen shot attached.

    Regards

    Vinu


    Uom.jpg (11.2 kB)
    price.jpg (19.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vinu,

      I have maintained the pricing condition records for this price scales. In addition, i have already maintained the CS to PAL conversion in material master -> additional data.

      The UoM conversion is maintained as 1 CS = 1CS ( base unit)

      1 PAL = 20 CS

      The pricing condition is maintained as

      Material -ABC       Amount 10  USD per CS and scales as

      0 PAL = 10 USD per case

      10 PAL = 9 USD per case

      15 PAL = 8.5 USD per case

      20 PAL = 8 USD per case

      When I enter in the order 10 CS of order, it takes the value as 9 USD. It should have taken the value as 10 USD instead.

      Thanks

      Nikhil

  • avatar image
    Former Member
    Nov 15, 2012 at 01:21 PM

    Nikhil, Ashish,

    I am likewise having a very similar issue with pricing scales where the UofM in the sales order is not being considered when working through the UofM on the scales in the pricing condition.

    However, in my case, the UofM used in the scales is not defined for the material being priced. Yet the quantity value is used to find the right scale irrespective of UofM and is finding a match.

    In my case, the pricing condition is a percentage to be applied to the replacement cost of the material to compute a price to the customer.  My pricing condition (ZTMG) uses a series of condition tables in the access sequence where the keys in these tables define a group of similar materials from a very specific group to a very broadly defined group as the tables are traversed top to bottom in the sequence. 

    The UofM in the scales is UNIT (UNT).  Each specific material can have a different number of each’s (EA) in a UNT.  So the percentage applied must be by UNT.

    The scales for ZTMG are:

    From 0 to 2 UNT = 30%

    From 2 to 5 UNT = 25%

    From 5 up   UNT = 20%

    My test material does not have the alternate UofM of UNT defined.  However, if I create a sales order of 1 EA, it prices using 30% from ZTMG. If I order 4 EA, it prices using 25%. If I order 5 or more EA it prices at 20%.

    However, to your issue, if I DO define UNT in the material, such as 1 UNT = 300 EA, then when I create my sales order, I can order in either UNT or EA and get the correct pricing percentage.  So I can order 1 UNT or up to 599 EA and get 30%.  I can order 2, 3, or 4 UNT or from 600 EA up to 1499 EA and get 25% as my pricing percentage, and so on.  On my materials, only the base UofM is defined, in this case, as EA.

    My goal is that pricing should not find a valid condition record at all if UNT is not defined for the material. Then the user will have to maintain pricing manually until the material master is updated.

    Regards,

    Jay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks guys, the issue is resolved. The issue was that in the base unit of measure in the pricing condition, i maintained Pallets. Once this was done, it worked correctly.

      Thanks for all your help on this.