Rounding Problem

hansika · June 21, 2010, 9:57am

Hi all,

Could you share the what parameters do i need to define to round the amount in the Purchase Invoice / Sales Invoice.

For example:

Line amount - 1000.48 ( This should not round )

Tax amount - 44.15 ( This value should round to nearest value)

Total value - 1148.03.

When i post the Purchase / sales Invoice Inoivce then system should round the value to 1148.00

To achieve the value what setup i need to do?

hansika · June 22, 2010, 7:47am

Hi Pioneers,

Please help me to solve the problem.

Thanks in advance.

alok_dida · June 22, 2010, 9:12am

check it out following links

hansika · June 23, 2010, 10:35am

Thanks for suggestion.

It doesnot work to my scenrio.

What I am asking is there any standard solution is availble.

alok_dida · June 23, 2010, 10:38am

what you exactly want can you please tell me so i can try on my side and get back to you. I didnt get your first post.

sangam.shrestha · June 23, 2010, 12:15pm

Hi Hansika,

Here is the solution for your query.

There are many possibilities for rounding like >,< and =.

Like wise you have to give precision for rounding and direction of rounding which is Less than ‘<’ or greater than ‘>’ and Equals ‘=’

Go through the example below you will understand the utilization of rounding function.

RequiredNumber := ROUND(Actual Number,[Precision],[Direction]);

Eg:-

AmountToRound := 1148.03; //Assignment of value to a variable.

Amount := ROUND(AmountToRound,1,’=’); //Actual rounding goes here.

MESSAGE(‘Rounded amount is %1’,Amount); //This is to check the value after rounding.