decimal places in field amount

kanika

Hello experts!!

NAV 2009 SP1

I need to show 5 decimal places in the field amount (item journal) but I only see 2,

I've already changed the decimal places in the table 83 (Item Journal Line) and in form 40 (item journal) to 2:5

but still showing only two

I've already changed too the fields unit cost and unit amount to 2:5, in the same way, without problems

Why not work in the field Amount?

Thanks!!

SonGoten13

Maybe there are just 2 decimal places?
As far as I know amount gets often calculated with ROUND(X*Y).

Table 83
UpdateAmount()
Amount := ROUND(Quantity * "Unit Amount");

kanika

oh yes!!!!

thank you

kanika

I have another problem regarding this issue

Item journal Line (table 83): decimal places = 2:5, that's ok for all fields, unit cost, unit amount, quantity, etc.....

Value Entry (table 5802): fields cost amount(actual) and cost posted to G_L = 2:5 decimal places

But when I post the item journal lines the values ​​in the table 83 only have 2 decimal places

That depends of a codeunit?

Thanks again

geordie

Is "Amount Rounding Precision" in General Ledger Setup properly modified to manage more than 2 decimal places?
This field is user all over NAV to set roundings.

kanika

and that, How may affect the movements already posted?

geordie

kanika wrote:

and that, How may affect the movements already posted?

It works only on new entries, simply because it can only be done on an empty database: if there are already any entries won't be possible to change this setup due to an error raised during field validate.

kanika

but, if I change that value by sql server?

geordie

kanika wrote:

but, if I change that value by sql server?

It's even possible to change it from NAV commenting temporarily the code but in this way you could compromise database integrity.

kanika

Respect to integrity I think if the precision is lower, then fail, but to be superior not think there are problems...................