Skip to Content
avatar image
Former Member

Rounding rule issue - Ex: value 30.49 is converted to 31 instead of 30 in Pricing Conditions

Dear Experts,

I have an requirement where the Tax conditions needs to be rounded of to the nearest value in GST as per Govt law.

From client side, it has been informed that if any part is fifty paise or more, it shall be increased to one rupee and if such part is less than fifty paise (i.e 0.49) it shall be ignored.

In Order to do the above requirement, below configurations are made.

Step1: OB90 transaction

Company Code: XXXX

Currency: INR

Rounding Unit: 100

Step2: V/06 Transaction

For Condition types: JOSG, JOCG, JOIG, JOUG & JCOS

Rounding Rule: 'A' - Round Up

Step3: V/08 Transaction

For DIFF condition type: Statistical needs be ticked.

For Condition types JOSG, JOCG, JOIG, JOUG & JCOS: The Calculation type is maintained with 17.

After the configuration, I tried to test many cases for this configuration.

In the Sales Order, the condition is rounded off as below.

If the condition Value is 30.50, system rounded the value to 31. (Which is correct)

If the Condition value is 30.48, system rounded the value to 30. (Which is correct)

If the Condition value is 30.49, system rounded the value to 31 (which is not correct) instead of 30.

My client requirement is also to round off the value to 30 instead of 31 (if the value is 30.49).

Kindly advise on how to round off the value to 30 when the condition value is 30.49.

I had checked in forum for the Solution. However I could not able to find the correct solution. So, please advise me in this issue.

Regards,

Ramkumar Lalaram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 17, 2017 at 11:15 AM

    Whether those condition types listed in Step2 are checked for "Group condition"? If not, check that, create a new sale order and check how it is working. Next execute OBYZ and check whether you could see those condition types. If so, you need to check "Group condition" there also. Even after doing all these changes, still if you face issue, then you need to look at OSS notes 80183 & 403254

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2017 at 07:26 AM

    Please refer to OSS note 2501537 - GST IN: How to round off GST tax value.

    Add comment
    10|10000 characters needed characters exceeded