Hi All,
Is there any way we can increase the decimal points from 2 to 4 of a numeric field or any standard field?
Please help if anyone have an idea.
Thanks,
Hi All,
Is there any way we can increase the decimal points from 2 to 4 of a numeric field or any standard field?
Please help if anyone have an idea.
Thanks,
In Common Information>Setup>Common Information Options, you can change the decimal places for Prices, Quantity, Cost , and UOM Conversion fields. This is a global change and you will see it in all data entry screens. For example, if you change Quantity, you will see it in Sales Orders and Purchase Orders, as well as any other modules that have a quantity field.
Common Information Options. Standard fields not changed by those settings are fixed format. UDF's are limited to 3 decimals.
Yes, I want to create a UDF field with the 4 decimal points, is there any way that we can script it?
Create your UDF as text and do the string / numeric conversions via script.
Hi Kevin,
Thanks for the reply, If you have any sample script, please share with me.
Appreciate your help.
Thanks,
SF
I'd do a column post validate script to check for isnumeric on the value before accepting it ( if not isnumeric... then SetError...). Still stored as a string... you just want to make sure the numeric conversion will work later.
Whenever you want to use the value in a script, just get the text value and cDbl it into a number before you use it.
*Community Hub is the new name for Sage City