Hi all,
where can I format this to lessen decimal nos.? Thanks!
Answer
how to set decimal
Best answer by aaghaei
Also see below post for reference
+10Also see below post for reference
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
For system settings, the decimal places under companies and currencies are both set to 2. In my project quote, the quote total pulls only two places, but my line items all pull four.
Here’s the formula for the field value:
=IIf([CROpportunityProducts.CuryAmount]<> 0.00, '$' + [CROpportunityProducts.CuryAmount], '') which I believe is the out of box Acumatica coding.
I entered #,##0.00, as mentioned above for the appearance formatting, but it still isn’t pulling correctly. Any ideas?
+10When a string character like ‘$’ is added the returned value becomes a string and number formatting won’t work. Either remove ‘$’ + or encapsulate the value into the Round function and set the desired number of decimal something like Round(FieldName, 2)
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.