I am working in a form that has de following structure:

Purchase Order Detail (form)

Reference (lookup field)

Description (multi line)

Unit Cost (numeric field - currency)

IVA (numeric field - porcentage)

Unit cost with IVA (numeric field - currency)

Quantity (numeric field)

Total Cost (numeric field - currency)

I set all numeric fields to not allow decimals. Also in the lookup related form.

So when the user select an option in the Reference lookup, the Description and IVA fields auto populate with the propper information but the IVA is filled with decimal porcentage and I get this message (Invalid value found FieldName: IVA). I can close this message, erase the decimals in the IVA field and continue the operation. Then I fill the Unit Cost a code is executed (mathematical interaction between Unit Cost and IVA) and then the outcome in the Unit cost with IVA correct,but with decimal numbers again. If I execute the next operation without deleting the decimals I get an error, so I delete them and the operation is complete and correct but I do not want the users to deal with this every time. How can I fix this?

Any help will be appreciated.

Regards!