Rounding problem

hansika

Hi all,

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

For example:

Basic amount - 1000.48

Excise amount -103.4 ( This should be round to neaest value )

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

Total value - 1148.03.


To achieve the values what setup i need to do?

ssingla

Invoice Rounding Precision : 1.00, Inv. Rounding Type : Nearest
Excise Rounding Precision : 1.00, Excise Rounding Type : Nearest
VAT Rounding Precision : 1.00, VAT Rounding Type: Nearest

Further you need to mark Invoice Rounding as True on Sales & Receivable and Purchase & Payable setup.

hansika

ssingla wrote:

Invoice Rounding Precision : 1.00, Inv. Rounding Type : Nearest
.

Thanks,

If i define the Invoice Rounding precision - 1.00 , then system is rounding the Line amount ( 1000.48 = 1000) in statistics and reports , But it should not do like that , the Total amount should round ( after including all tax paramerters) only.

How to acheive that result.?

hansika

Hi all,

Could any expert can explain how to solve the problem ? ](*,)

ssingla

It cannot be acheived thru setup but you should modify the statistics form/report. The statistics form does not have rounding amount text box and the amount is added in Line amount. You can customize to change the behaviour.

hansika

Thanks Ssingla,

The acual Problem is when user post the Invoice that amount is not rounding .

Please suggest the solution.

Thanks in advance.

hansika

Hi Pioneers,

please help me. ](*,) ](*,) ](*,)

hansika

please help me ... [-o<

ssingla

AFAIK there is no other setup for rounding as mentioned by myself earlier in the thread. If the rounding is not happening I suggest you ask a techical to evalueate the code to find out the reason why NAV is missing the rounding.