Purchase Order Total Errors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kristy - 28 Jun 2005 16:51 GMT

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?

Reply to this Message

Renee in Juneau - 29 Jun 2005 15:07 GMT

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?

>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
[quoted text clipped - 3 lines]
>
>Is anyone else having this problem?

Reply to this Message

Kristy - 29 Jun 2005 16:26 GMT

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...

> I haven't seen this, but it makes me wonder....
>
[quoted text clipped - 9 lines]
> >
> >Is anyone else having this problem?

Reply to this Message