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

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