Purchase Order Total Errors

[Kristy]

I'm getting a validation error of "maximum of 4 digits after the decimal
allowed" in the total column of my Purchase Order the strange thing is its
only with certain figures for example 6 x 1.95 produces this error however 6
x 1.94 works fine. I've tried using - round(@Quantity * @UnitPrice * 100) *
..01 which fixed some of the amounts but theres still others that don't work.

Is anyone else having this problem?

 

[Renee in Juneau]

I haven't seen this, but it makes me wonder....

Do you have your involved textboxs set to integer or decimal, and the
format set to number or currency, and the number of decimal places set
to 2?

 

[Kristy]

I thought it might be something like that too and I tried changing the data
type of the field with no success, but your suggestion prompted me to look at
this further and I've found that the problem seems to be fixed by setting the
data type to nvarchar.

Thanks for your help...