Ratna,
This is happening b'coz amounts get reverse calculated based on condition amount for subtotal's amount in the pricing procedure. Refer following table for calculation
QuantityCondition ValueCalculationAmount
per unit amount
1.10071464.3571464.35 / 1.100 64967.590.60038980.5538980.55 / 0.60064967.58Regards, JP
Hi Ratna,
To control such rounding differenceyou may use alternative calculation with formula which can reduce such arthmatic error.
The issue which you are getting is not SAP issue, This issue coming due to limitation of Mathmatics to handle such number.
To handle such issue you need to work on business process as well as calculation formula.
1. You can write a new calculation formula to handle such condtion value:
for example:
Quantity/ (Condtion Value * 100)
So it means for case 1 you will get result 71464.35/110 = 649.67590 (Take 5 decimal
then multiply result with 100 = 64967.590
in second case it will become 38980.55/60 = 649.67583
Multiply it with 100 = 64967.583
Take result till three decimal and then round up if third decimal is greater than zero
so in first case it will be 64967.59
in second case it will be 64967.59 (round up 3)
This will minimise such decimal difference error.
You may choose multiple unit and formula wisely after analysing the kind of pricing unit business maintain and order units in your business process.
2. Another way is to change in Business process, you may suggest business instead of maintaining records for 1 piece or decimal number quantity, business can use a whole unit say price for 1000 piece in condtion record.
Hope this will help you.
Regards
Hello,
i think, there is only one way to control it -- rounding.
You need to create new rounding routine in VOFM-formulas-condition values and add new condition type with this formula.
Of course, rounding depends on number of decimal places in amount. It's just a math.
Thanks,
Evgenii Sakovich
Add comment