Nav 2016 invoice want in decimals 0.00 is not working

everfor007

In nav 2016, in general ledger setup and sales & receivable and purchase & payable setup, all round precision is set 0.00, still when i enter unit price 40.2 for 2 qty, automatically instead 80.4 it's converted in 81 in the line. Also i've done setup the local currency
Please let me know how to turn off round precission

Kishorm

It is because you have set the "Invoice Rounding Precision" & "Inv. Rounding Precision (LCY)" to 1.00 - change it to 0.01

everfor007

In GL setup, tried Inv. Rounding Precision (LCY) showing error with 0.01 and in currencies it has accepted the Invoice Rounding Precision i.e 0.01 but no difference still same it's rounding. I need to turn off round.

ErictP

In the 'General Ledger Setup' there is also a field 'Amount Rounding Precision'.
First set this field to 0.01.
Then automatic the field 'Inv. Rounding Precision (LCY)' is set to 0.01

everfor007

Please advise with error any alternative way?. still we are in trail phase, we are happy to delete the data, let me know how to delete.

logger

@everfor007 ,
1st of all, I want to ask you - who dared to set such strange precision 0.00?
Next, it's REALLY BAD IDEA to delete ledger entries (especially in productive database) but if you want, open table 98 in development ebvironment, find OnValidate trigger for "Amount Rounding Precision" field, find there line with call of error generating function, go to this function and find there a list of ledger tables. But I DO NOT advise you to touch these data.

everfor007

if it's wrong way, please advise what need to be done to achieve below?

"when i enter unit price 40.2 for 2 qty, instead 80.4 automatically it's converted in 81 in the line"

Slawek_Guzek

If you are still testing, you have a few options.

You could export the master data - G/L Accounts / Clients / Vendors / Dimensions / Setups etc. and start over with a fresh database, importing back the master data and setting it up correctly before posting anything.

If you have a developer license you could write a simple process-only report to change the rounding precision on G/L Setup table without invoking validation code, to avoid error.

Or you can edit the General Ledger Setup table and in "Amount Rounding Precision" field comment out temporarily a call to RoundingErrorCheck, then change the "Amount Rounding Precision" to 0.01 and bring the G/L Setup table to the original state

If you don't have dev license you could try to change the "Amount Rounding Precision" directly on the SQL server, and then restart the NST to make sure the new setting will be taken into account.

Once you update "Amount Rounding Precision" to 0.01 you will be able to change invoice rounding field