Hi Michele

" $18,948." looks like the number has been truncated.  I wonder if the .net page that is generating this, is truncating the value.  

Who created the .NET page?

With the number of decimal places set to zero, floating point numbers will be rounded to the nearest integer.

When I need to have more decimal places than the set number I use a text field to store the string equivalent of the number.  The string then needs to be converted into a number if calculations are to be done.  In your case where you don't have access to the dll code I would create a new text field and add a table script to convert the numeric value to a string and save it in the new field. 

Eg if the numeric field is called 'enty_quantity' and the new text field is called 'enty_quantitystr' then in the tls Insert() and Update() functions add:

Values("enty_quantitystr") = Values("enty_quantity").toFixed(2); 

Use the text field in your list screen instead of the numeric.

You will need to initialise the new field with the string equivalents of the numeric values in SSMS.  From then on the text field will be updated from the numeric field when a record is saved.

The .net page was created by another partner that we work with.  I think the .net page is rounding the value which is why when I changed the user preference to show decimal places, it did not change what was displayed. 

I had reached out to the partner that created the .net page previously for assistance.  However, what was returned didn't help.  The script provided was to add .00 to the end of the value rather than remove the rounding.  The script came with, "you will need to make some changes to this".  However, I have not been able to make it work.  I see a response from Paul C that makes sense to me.  Therefore, I am going to see if I can make that work.

If that does not work, I will reach back out to the partner.

If this had not been a .net page, would the script that is normally used on an entry screen page have worked here?

Your assistance is always greatly appreciated!!

Paul C:  Thank you!  This solution makes sense to me!  I also like it because it will hold after an upgrade.  I am going to give this a go today.  I will let you know if it works out for me.

Again, thank you!