on 12-17-2008 10:29 AM
I have to round of the condition value for excise which is coming in decimal 73.51 to 74, similarly other excise value using routine, plz guide me for the use exit available for the same and how will i create a routine for rounding off the value for excide, cess and SH-cess
Good Afternoon,
1. If you have access to OSS notes, please review NOTE 80183 regarding Rounding.
Values calculated in pricing are always rounded to the amount of
decimal places which the used document currency owns. As subsequent
processing steps setup on this rounded value rounding differences c
occur in the calculation of the price per unit or in subtotal line.
To bypass such effects note 80183 describes possible solutions to
reduce / bypass this effect.
A few problems in rounding after applying note 80183, variant 2 hav
been recorded where it was recommended to use the formulas 919 and
920 on all discounts and surcharges that appear before NETP and the
problem was solved.
2. In transaction V/06 there is a field under header 'Control data1'
which can effect how the system rounds off condition values during
pricing:
->> Rounding rule
The rule that determines how the system rounds off condition
values during pricing. The last digit will be rounded.
Example
In the standard rounding rule '_', values are rounded off according
to business standards:
10.454 -> 10.45 DEM
10.455 -> 10.46 DEM
In rounding rule 'A', values are always rounded up:
10.459 -> 10.46 DEM
10.451 -> 10.46 DEM
In rounding rule 'B', values are always rounded down:
1045.9 -> 1045 LIT
1045.1 -> 1045 LIT
In this example, the currency of the condition rate is Italian Lira.
The Italian Lira does not have any places after the point.
3. Also check if the condition type is set as item condition as well
as group condition in transaction V/06. What this means is that
the system will calculate the value of the condition on header level
and compares it with the sum of item values in the document.
Any rounding difference (KONV-KDIFF) detected, will be populated
in the line item with greatest value or in first line item if all are
of equal value.
In other cases where there is no adjustment because there is no
rounding difference when comparing the header value and the sum of
item values.
->> Solution to this scenario -
If you remove the 'group condition' setting, the system will then
calculate amount for the items directly and you will not get the
rounding. You must decide which setting is more suited for your
business. This is not a bug, but works as per designed.
EXAMPLE: MWST - tax condition (a group condition)
Item 10 16% of 100.90 = 16.14
Item 20 16% of 100.90 = 16.14
Total = 32.28
I hope you find this information very helpful and hopefully it will solve your problem.
Regards,
Martina McElwain
SD - Forum Moderator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Martina,
with reference to your post,
EXAMPLE: MWST - tax condition (a group condition)
Item 10 16% of 100.90 = 16.14
Item 20 16% of 100.90 = 16.14
Total = 32.28
Total instead of 32.28 it has to be rounded as per commercial rounding rule. how to acheive this for each and every condition type.
Item level pricing but at header level it has to show values for each condition type rounded as per commercial rounding rule. this is my requirement.
Thanks in advance
Sreekantha Reddy
Hi,
Go to V/08 and select your pricing procedure and go to control data.
In that go to your condition type and give these value to your condition type.
Requirement - 13
Calty u2013 16
Save this setting.
Now go to OB90 and select new entry over there.
Assign 10 to your company code and currency combination.
Save this setting and exit.
Now try to create sales order and check whether rounding is happening or not.
Regards
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. Assign a subtotal to excise condition types at pricing procedure.
2. Create a rounding condition type and assign in pricing procedure with step referance to respective
excise condition type. This rounding condition type can be copy of standard DIFF condition type.
3. Assign standard rounding off routine "16" against this new rounding condition type.
If my answer is fits you, please give points to me.
Regards,
Shabeer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
For rounding Off you can refer other threads.
https://www.sdn.sap.com/irj/scn/profile?editmode=true&userid=3776637
Above things will help you in Order and Invoice level.
For excise invoice - SPRO-Logistics - General-Tax on Goods Movements-India-Basic Settings-Maintain Company Code Settings
Regards
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.