NAV is missing basic rounding functionality

Hi all,

I am working on Nav 2009.

Amount to be round in the PO/SO and Purchase Invoice / Sales Invoice.

For example:

Line Amount - 1000.48

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

Total value - . 1045 .00 ( =1044.63).

There is no setup for rounding as mentioned above

Could i know the reason why NAV is missing the rounding as explained above.

there is…use precision codes…it does what you want

check this …is this what you want?

http://dynamicsuser.net/forums/p/24129/126868.aspx#126868

I hope that you did not understand what i required.

It does not work what you shared.

I would suggest you explain what is required then.

Purchase Invoice / Sales Invoice value should round to nearest value when user posted as explained above means line amount should not round , Total amount should round to nearest value.

So you want the lines of an order to never match the total and therefore any confirmation never matches an invoice.

Not sure why you would expect this to be basic functionality, it will mess up Tax and reconciliation and payment.

If you need it modify it. But question why you need it, really why you need it in this manner, first.

hi,

actually this is wrong. Government will not allow you to get 37c tax free… If you apdate total amount you have to recalculate tax because by rounding you just changed your price.

Hi all,

Sorry the example is like these .

For example:

Line Amount - 1000.48

VAT amount - 44.15 = 44.00( This value should round to nearest value)

Total value - . 1044 .00 ( =1000.48+44.00 = 1044).

There is no setup for rounding as mentioned above

In General Ledger Setup > Tax Information Tab> VAT Rounding Precision: 1.00

VAT Rounding Type: Nearest

And General Ledger Setup > General Tab > Invoice Rounding Precision: 1.00

Invoice Rounding Type (LCY): Nearest

Hope this will help you.

Hi Debapriya,

It does not work .

No of course it would not work - it would give you a TAX/LINE/TOTAL inbalance. No business in the UK would ever pay an invoice issued in this manner.