Rounding on posting

paulobc

I'm importing data from a sql server db into Nav (Gen. J. Line) and when I then try to post it i get a error saying that the value of one of the lines need to be rounded.

Any suggestions on what it might be?

Thanks

Sog

a decimal value which exceeds the maximum allowed decimal places (found in administration, application setup, fin. managment, general ledger setup) max allowed rounding is also 5 decimal places.

paulobc

Thanks for the reply.

The amount in the message looks like this: 84.059,697700000004.

but in the Gen. Journ. Line appears as 84.060.

Is this a Nav bug?

Thanks again.

Sog

It appears nav has rounded the number to 0 decimal places.
But you say you get an error but apparently the value is still imported which I find odd because normally the import stops on any error.
Anyways, I don't think it's a nav bug, but a result from the application parameters.
Rounding could stand on '1' (=rounding to 0 decimal places), the maximum rounding navision can handle is 0,00001 (=rounding to 5 decimal places). So your amount 84.059,697700000004 will be rounded to "amount rounding" in the general ledger setup. (max rounding is 84.059,69770, although the zero propably won't be displayed unless "amount decimal places" has a value of '5:5'

Regards

AdamRoue

Sort the data out to meet the excepted parameters of NAV and then it will import fine, not a NAV bug an issue with the data you are trying to import.

paulobc

Thank you guys. It's a problem with the incoming data.