Sage 100

 View Only
  • 1.  UDF Precision

    Posted 06-26-2023 22:00
    Edited by Doug Higgs 06-26-2023 22:01

    I created a numeric UDF in the IM Item Transaction History table that has three decimal places.  When I add it to the Item Maintenance, Transactions tab, only two decimal places appear.  How do I get the accurate amount with three decimal places to display?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 2.  RE: UDF Precision

    Posted 06-27-2023 10:04

    Looks like it has been an issue for some time now.......

    Why can't a numeric UDF with four decimal places b | Sage 100 (90minds.com)



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 3.  RE: UDF Precision

    Posted 06-27-2023 11:35

    Numeric UDF's have always been limited to 3 decimals as far as I know.  After seeing this warning, I've never even tried.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: UDF Precision

    Posted 06-27-2023 11:45
    Edited by Doug Higgs 06-27-2023 11:45

    The issue is when the UDF is 3 decimal places only 2 decimal places display on the panel.  I'm OK with 3 decimal UDFs.  I'm not OK with a 3 decimal UDF only displaying 2 decimal places when I add it to a panel.  How do I display the 3 decimals when the UDF is added to a screen panel?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: UDF Precision

    Posted 06-27-2023 11:47

    It auto-displays the 3rd decimal, when it applies.  If you are desperate to have the 3rd decimal show 100% of the time, you could try to edit the M4L directly.  Sage doesn't allow you to control that.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: UDF Precision

    Posted 06-27-2023 11:30

    It only displays the third decimal when it applies.

    Looking at the M4L, that is shown in the mask.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 7.  RE: UDF Precision

    Posted 06-27-2023 11:52

    I see. So it does actually work.  If there are 3 decimals it displays 3 decimals.  If less than 3 decimals or 0 it displays 2 decimals.  Thanks Kevin!



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------