Skip to Content
Author's profile photo PRASOON AK

Round off Condition Values – Pricing Configuration

Hi,

   I would like to share a small configuration regarding the rounding off for the condition types in pricing. Case 1 explains how to round off a condition value directly and Case 2 explains how to round off and post the rounded value to separate GL.

   Let us discuss the scenarios in detail:

Case 1: How to Round off the condition values:

     You can round off particular condition values based on the rounding figures, like 10th place, 100th place etc. For example, suppose you have a condition type, say ZMOP. The client requirement is to round up the condition values for this condition type to two decimal places.

   The configuration steps are as follows. (The same is applicable in case of MM pricing procedure as well as tax procedure.)

1. Maintain the rounding rule in the condition type (M/06 or OBQ1) as shown. It could be round up or round down.

/wp-content/uploads/2013/09/1_281248.png

2.  Maintain the calculation type “17” in the pricing procedure.

/wp-content/uploads/2013/09/1_281248.png

3. Now Maintain the rounding rule for the company code in the transaction OB90.

          If its 100, the value will round off to 100 place, means the 2 decimals will be rounded off to upper or lower  value based on the condition rule specified in condition type.

/wp-content/uploads/2013/09/1_281248.png

    After these configuration steps, you can test the scenario. The values for the respective condition types will be rounded off accordingly.

Example: Condition value before the above settings:

/wp-content/uploads/2013/09/1_281248.png

Condition Value after the settings made:

/wp-content/uploads/2013/09/12_281329.png

Case 2: How to round off and post the Rounding Difference to separate GL:

    If you want to post the rounded value to separate GL, you may proceed with below steps: Here. there will be different condition types for capturing the rounding values.

1. Create a new condition type, say Z001 (in OBQ1 or M/06 or V/06 or similar) for rounding off value.

  •      Maintain the condition class as D if its tax condition type. Else, maintain it as A.
  •      Maintain the access sequence if its tax procedure. Else, keep it blank.

/wp-content/uploads/2013/09/12_281329.png

2. Create a new condition type (in OBQ1 or M.06 or V/06 or similar) for rounded value – You can copy the parent condition type which is to be rounded and change the key.

  •     Suppose we need to round off JMOP condition and post the difference to separate GL. Then copy JMOP and create a new condition, say ZMOP.
  •     In this example, JMOP will show the value without rounding and ZMOP will show the value after rounding.
  •     Maintain the access sequence for the new condition type. We will be maintaining the condition record as 100% for this condition type.

/wp-content/uploads/2013/09/5_559087.png

3. Go to the Calculation schema (Tax procedure or MM/SD pricing Procedure) and maintain the condition types in the procedure, as below.

  •     Z001 is the condition type to post the rounding difference.
  •     ZMOP is the condition type to calculate the value of the parent condition type JMOP after rounding off.

/wp-content/uploads/2013/09/6_559092.png

  • Calculation type 16 will bring only the round off value, based on the OB90 (configuration explained in case 1).
  • The parent condition type is made as statistical in the pricing procedure.
  • Now, the system will split the value of the parent condition type (JMOP in example) to ZMOP (rounded value) and Z001 (Round off value).
  • Maintain the account key / acruel key for the new condition types depending on tax procedure / pricing procedure.
  • Maintain the step number (from and to) accordingly.

Save the procedure.

4. Maintain the GL account for the account keys.

5. If its tax condition type, maintain the condition record for the round off condition type (Z001) as 100% in FV11.

/wp-content/uploads/2013/09/7_559104.png

6. Maintain the condition record for the rounded value condition type (ZMOP in example) as 100%.

7. Test the scenario with a new PO:

/wp-content/uploads/2013/09/8_559105.png

Result:

   The condition value (12.06 in example) for the condition type (JMOP in example) is splitted as round off value ( 0.06-) and rounded value (12.00). The splitted values will be posted to the corresponding GL.

MIRO GL Postings:

/wp-content/uploads/2013/09/9_559130.png

Note: Same procedure (Case 1 and Case 2) is applicable for all similar scenarios in MM / SD / Tax procedure.

Thanks for reading and your valuable suggestions / comments.

Thanks & Regards,

Prasoon

Assigned Tags

      32 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jürgen Lins
      Jürgen Lins

      you could have added screen shots from a conditions screen before and after this change to proof the customizing change

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi JL,

         Thanks for the feed back. I have done it and updated the doc.

      Regards,

      AKPT

      Author's profile photo Former Member
      Former Member

      Helpful one...Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member

      Hi,

      Nice way of presentation.

      If you could add the below scenario, it would be more helpful.
      IF Business wants to add all rounding values into one new condition type and requested to track into separate G/L.

      Regards

      Nazeer

      Author's profile photo Nishu Shah
      Nishu Shah

      Hi AKPT,

      Document is useful - Thanks

      In order to further enhance this document, request you to show how to settle differential round off difference to a new GL

      Best Regards

      Nishu

      Author's profile photo sreehari tokala
      sreehari tokala

      Hi AKPT,

      you have done Nice job. keep it .

      thank you for sharing your valuable time and information with us.

      Thanks & Regards,

      Sreehari.

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu

      Hi AKPT,

      Nice document.

      Regards,

      Bisweswar

      Author's profile photo Satish Babu
      Satish Babu

      HI AKPT,

      Nice document & very helpful. Thanks for sharing

      Regards

      Satish

      Author's profile photo Former Member
      Former Member

      Thanks

      Author's profile photo Sanjeet Kumar Yadav
      Sanjeet Kumar Yadav

      Nice and very informative. Thanks for sharing with us.

      Regards

      Sanjeet Kumar

      Author's profile photo Former Member
      Former Member

      It's really helpful....thanx for sharing

      Regards,

      Deepak Mankeshwar

      Author's profile photo Cecil D'Souza
      Cecil D'Souza

      Nice. Thank you for sharing your knowledge.

      Author's profile photo Former Member
      Former Member

      Helpful document. Thanks for sharing AKPT.

      Author's profile photo Former Member
      Former Member

      Very Helpful document, Thanx for sharing,

      Author's profile photo Former Member
      Former Member

      Thanks for your valuable input on this.

      Narayanan

      Author's profile photo Preeti Kashyap
      Preeti Kashyap

      Thanks for valuable information.

      Regards.

      Author's profile photo Former Member
      Former Member

      Nice work. Thank you for sharng your Knowledge..

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli

      Hi AKPT,

      Can you please ellaborate the field of Cal type. Why you are using 17 , why you are not using 16. Please let me know what is use of this field. If you have idea then please let me know all the fields with examples. It is very help full to all.

      Regards,

      Ravindra

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi,

         If you are using the cal type 17, you can manually define the rounding rule/ up to how many digits the value to be rounded off, say 10th digit, 100th digit etc. The cal type 17 will take the rounding defined in table T001R, which is maintained in OB90 transaction as explained in the doc. The cal type 16 doesnt have this option.

         I'll try to upload another document with the details of cal type.

      Regards,

      AKPT

      Author's profile photo Nilesh Sawant
      Nilesh Sawant

      Hi,

      Thanks for sharing above scenario

      As per snapshot below snapshot it is rounding as per your scenario but I need rounding off to be with gross value = 4090 (amount) column

      Can any one help me ? $407F88224A5B6956.jpg

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi,

         As of my knowledge, the rounding off functionality will work with condition types only. In your case, the gross value is a statistical step without any condition type.

         You may round off each condition vales accordingly.

      Regards,

      AKPT

      Author's profile photo Siva Prasad V
      Siva Prasad V

      Hi,

      Good Solution Helpful to Many.

      Author's profile photo Sudeep A
      Sudeep A

      Hi AKPT,

      Useful information. Keep sharing.

      Regards,

      Sudeep.

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi,

         Thanks all...:)

      Regards,

      AKPT

      Author's profile photo Former Member
      Former Member

      Hello AK,

      When rounding is done, is there a difference GL account assigned for the difference?

      Regards,

      BOW

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hello Benjamin Onyango

         Sorry for late reply. I have enhanced the document to include your requirement as well. Please check "Case 2" of the document.

      Regards,

      AKPT

      Author's profile photo Former Member
      Former Member

      Excellent sir keep up the same..

      Author's profile photo SANJIT BHATTACHARYA
      SANJIT BHATTACHARYA

      outstanding explanation

      Author's profile photo Former Member
      Former Member

      Excellent article on rounding. It helped us configure rounding in our system. Thanks a lot.

      Hanif

      Author's profile photo Phanikumar V L
      Phanikumar V L

      Very Nice document & new learning for me.

      Till date i use to feel this type of requirement will  effect created accounting docs in the required company code.Now clarified.

      Phanikumar

      Author's profile photo RAJESH KUMAR SONI
      RAJESH KUMAR SONI

      Very useful documents.

      Best Wishes...

       

      Regards,

      Rajesh Kr. Soni

      Author's profile photo Jeet Mukherjee
      Jeet Mukherjee

      Hi Pasoon,

      Can you tell me why I am geeing different Condition value in different line , when same tax condition is getting called for all lines in each line against same amount:

      Line 30 & 40

      where as line 10 and 20 is showing