Skip to main content
Solved

How to make a filed 2 decimal places.

S
Freshman II
Forum|alt.badge.img

hello, i want  make the filed  decimal places like this

i used the Floor() formula it rounded up to a whole ing. 

i used the Math.Round() and Round () formula and its still give me the same issue 

this is the function i have in my data field

IIF([ARInvoice.DocType]='CRM', [ARTran.ExtPrice]*-1,  [ARTran.ExtPrice])

 

Best answer by Naveen Boga

​@SandyA If you are trying this GI, then please add the ARTran.Qty field in the Schema field so that you formula will takes the decimal behavior from Qty field.

 

 

 

 

 

View original
    Did this topic help you find an answer to your question?

    3 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • 711 replies
    • March 18, 2025

    Hi ​@SandyA! One thing to keep in mind is that if you use the field in an expression then it will force the Database value over a UI value. In a GI setting you can get around this by adding a Schema Field in the GI results grid to stop the additional decimal places.

    When using schemas you can use pretty much any table and the great thing is that you do not need to join the table into the GI, meaning you just add the table to the GI and then you can select it in the Schema Field on the results grid. Locate a field which shows as only two decimals in the UI and then add this as a schema and it should work.

    Chris Hackett
    S
    2 people like this
    • Chris Hackett
      Chris Hackett
    • S
      SandyA
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3407 replies
    • Answer
    • March 18, 2025

    ​@SandyA If you are trying this GI, then please add the ARTran.Qty field in the Schema field so that you formula will takes the decimal behavior from Qty field.

     

     

     

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    S
    2 people like this
    • Chris Hackett
      Chris Hackett
    • S
      SandyA
    S
    Freshman II
    Forum|alt.badge.img
    • SandyA
    • Author
    • Freshman II
    • 27 replies
    • March 18, 2025

    ​@Naveen Boga,

    thanks a lot it worked after i set the Schema Field to ARTran.Qty 

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved