Dear all,

I try to extend field tdpur041.pric to have 11 digits after decimal sign on form field, but I cann't. Our item's price is 0.01652247056 and I need to appear in document. Has anybody and idea to do this job?
We use version IVc4 and I also changed format in form field to
zzz9vd99999999999, but it didn't work. The form show only six digits after decimal.

Thank in advance.

Vicki.:(

Is it actually stored in the table with 11 digits? You may also have to check the script to see if it does any rounding. I know from the maintain units session it looks like things only go out 6 decimal places. I know the pegging routines use the units to determine the number of decimal places, but I am not sure about the tdpur041.pric field.

Mark

Hi Vicki, as Mark says there is some rounding thats occuring, I was able to change the form to dsiplay 11 digits after the decimal point, but when entering you see the rounding occuring to six digits:

number entered:1.12345678999
number is rounded to : 1.123457

If you have a 3rd party product such as Qkey or Rush (available on this board), you can get around this problem with the following). This would also be in additon to the form field change.

tdpur041.pric:
before.checks:
tdpur041.pric = round (tdpur041.pric,11)

Thanks Mark & NR. for your reply.

I have no script ,so I think 6 digits is the best choice.


Vicki