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

To report this post you need to login first.

31 Comments

You must be Logged on to comment or reply to a post.

  1. Nazeer Shaik

    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

    (0) 
  2. 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

    (0) 
  3. 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

    (0) 
    1. PRASOON AK 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

      (0) 
  4. 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

    (0) 
    1. PRASOON AK 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

      (0) 
  5. Phanikumar Valiveti

    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

    (0) 

Leave a Reply