Sage 100

Does anyone know a trick to allow a numeric UDF to work like built-in fields with regard to decimals? My particular situation is a UDF that I would like to work just like the sales order QuantityOrdered column in the data entry grid. With QuantityOrdered, one can enter a single numeric digit and it will be accepted as a whole number. A mask of 0.00 converts a single digit (say ""1"") to be ""0.01"". I cannot find a mask that will do the same as QuantityOrdered (I tried ""0.0"", ""0.#"", ""0."", ""0"", ""#.#""). I don't even think I can use a script to help since entering ""1"" is indistinguishable from having entered a decimal (e.g. ""0.01"").

Try ""####0.00"" then when 1 is entered should produce "" 1.00

Didn't work. No Kewpie doll for you. Thanks for playing.

I've run into this before and didn't find a solution. No Kewpie doll for me either.

Isn't that due to some logic programmed into Sage based on the number of decimal places selected n Common Information Options. I don't think its related to a mask

Might the 'implied decimal' setting in User Maint help?

...and the Kewpie doll goes to Brett! Turning off ""Implied decimal"" changed the way UDF decimals work and didn't change how decimals in the QuantityOrdered worked.

#QuickTipFromZip

#Sage100 Quick Tip from Zip @NetatWork_corp: Here's an old setting that's easy to forget about: Implied Decimal Poinhttps://lnkd.in/eDHfZzD https://twitter.com/MAS90_Zip