Sage 100

Rounding of UDF fields -- customer is using 4.5.3 with UDF fields. One field is defined as 3 decimal places. When the item posts it is updating to another UDF and the field is rounding to a whole number. Example 41.611 becomes 42.000 Is this any type of known issue with UDF in 4.5? I could find a prior Sage KB about 2 digit rounding back in 4.2.

You said ""One field is defined as 3 decimal places"", it sounds like the ""other"" field is defined with none and this is wad. No?

No sorry one of the UDF is 3 decimals all the way through

Is it updating the other UDF just as a flow through, or as result of some BOI stuff?

Sorry I just interpreted what the customer told me by following the steps. They have 3 decimal place UDF on a form. I enter in 1.234 and can see before my eyes it changes to 1.000 when I move off the entry field I'm not able to duplicate this so I am guessing it's a custom form issue or something with the UDF. I'll have to wait until everyone is out to look further.

Unit of Measure? Did someone make that particular UOM an integer unit of measure?

How did this turn out? I am seeing a similar issue with 4.5.5 were a conversion left UDF's defined with a 2 decimal mask (#,##0.00 confirmed) rounding as if the mask were (#,##0). During data entry the grid would reflect the decimals entered and remain on the screen as one moved to additional lines, but after the records were Accepted and the records were recalled the UDF's had been rounded.

I think the customer decided to live with the issue.

I've seen issues where a field was initially defined as no decimal places, added to the grid, then later changed to more decimal places. Once I removed the field from the grid and insured the user did the Reset Grid, then field started working properly. You could check the SY_GridDefinitions table to see what mask the grid is holding for that field.