@michoel I am not sure if our company is looking to round-off the weight column that I am working on. So, wanted to know both the options - how to round-off & how not to but still keep a good output format like nlapiFormatCurrency does. Is it safe to say that the best practice is to round-off to two digits any decimal digit field?

ntiwari1309: It really depends what type of information is in the field, and on the users' preference

Got it. I am really trying to store weight of items in the decimal field but not sure about the rounding-off preference.