cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding off Issue (Net Value not equal to Net Price * quantity)

samjalees2000
Participant
0 Kudos
2,554

Dear Gurus,

Here is an interesting issue.The default calculation done in the pricing procedure is two decimal places.Now we consider a real scneario,consider the net value of 324 quantities of an item calculated is 36,049.86 .When it is divided by quantity the resulting value of net price is 111.265 but the system shows 111.27 by rounding it off.

Now here comes the problem,my client needs the rate to be shown on the order script to be two decimal places and the net value should be equal quantity * net price.So if we apply this,

324 * 111.27 = 36051.48

But the net value calculated by the system is 36,049.86.So it can be consluded that:

"Quantity * Net Price Shown is not Equal to Net Value calculated by the System"

Need an urgent resolution,project is stuck on this

Regards,

Sam Ahmed

Edited by: Lakshmipathi on Nov 3, 2011 12:14 PM Please dont add URGENT in subject or in your post

Accepted Solutions (0)

Answers (6)

Answers (6)

samjalees2000
Participant
0 Kudos

SAP Note did the job through condition type NETP

suresh_s9
Participant
0 Kudos

This message was moderated.

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

This topic use to be related with a lot of items, header conditions and huge amounts, and suddenly, you have rounding troubles by a couple of cents. Usually these notes help to understand the source and ways to solve it:

SAP Note 80183 - Rounding

SAP Note 315792 - Group conditions of the same amount on item

SAP Note 201830 - Calculation of the net price of an item

SAP Note 886532 - Pricing: Displaying and rounding numbers

SAP Note 24944 - Group conditions

I hope this helps you

Regards

Eduardo

samjalees2000
Participant
0 Kudos

Here is the pricing procedure,

We start with the amount condition types

Unit Price Units Condition Value

ZMRP MRP 1,700.00 10 PAC 55,080.00

ZTRP Trade Price 1,445.00 10 PAC 46,818.00

ZDPR Dist. Price 1,445.00 10 PAC 46,818.00 (GL)

Using Trade Price we apply the product discount of 23%

ZPRD Product Discount 23.000- % 10,768.14-

Then we send discount amount to the gl by using condition type ZDIS

ZDIS Discount Value 100.000- % 10,768.14- (GL)

tHE RESULTING NET VALUE IS 36,049.86 as 46818.00 - 10,768.14

Order Item value 111.27 1 PAC 36,049.86

And the Net Price is 111.27

samjalees2000
Participant
0 Kudos

Dear Lakhsmipati,

There are many condition types involved in the pricing procedures including amounts and discounts.The rates are not directly inputted by the customer.They are calculated by the system.

Should I still try what u said or it wouldn't work,

Regards,

Sam Ahmed

Former Member
0 Kudos

Customer has to understand the trades off of using 2 decimal point for rates.

net price is always calculated with Rate * Qty. How system will do that net price divide by qty that the rate of 111.265 is to be used?

Using 2 decimal for rates will cause more rounding issues. Advisable to use 3 decimal. Note 3 decimal will still have rounding issues, but minimized.

Unless, you have a condition type where user will always key in the required amount for the item. More work for user.

For your considerations.

Lakshmipathi
Active Contributor
0 Kudos

Maintain the price per 10 instead of 1 in VK11. In your case, it would be 1112.65 per 10 so that system will calculate the net value exactly.

G. Lakshmipathi