Skip to main content
Solved

Negative Value view change

  • December 10, 2023
  • 3 replies
  • 290 views
  • Translate All
Semi-Pro III
Forum|alt.badge.img+9

Hi Team,

I have a Generic Inquiry in which i want to change the visual of a negative number to be viewed in Parentheses rather than -### of the fields Credit amount, Debit amount and Net amount.

I attempted to use the this format function in the Generic Inquiry, but did not worked.

#,##0.00;#,##0.00

Attached is my Generic Inquiry 

 

Regrads,

Sweta

Best answer by sweta68

@Naveen Boga , 

Thanks for your solution. I appreciate your efforts. I have converted the field into string to view the negative value into the Parentheses and it works for me and client is happy with this.

Regards,

Sweta

View original

    3 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+20

    @sweta68  As you are using the Total Aggregate Functions for these fields, it will consider only the Numeric fields. If we add the Parenthesis for the -ve numbers Total Aggregate functions will not work.

    As an alternate, you can highlight the -ve amount fields with the ROWStyles. 

     

    Hope this helps!

    Translate
    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      Semi-Pro III
      Forum|alt.badge.img+9
      • sweta68
      • Author
      • Semi-Pro III
      • Answer
      • December 14, 2023

      @Naveen Boga , 

      Thanks for your solution. I appreciate your efforts. I have converted the field into string to view the negative value into the Parentheses and it works for me and client is happy with this.

      Regards,

      Sweta

      Translate
        Naveen Boga
        Captain II
        Forum|alt.badge.img+20

        @sweta68  Awesome :) Thanks for sharing the update.

        Translate
        Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
          Terms & ConditionsAccessibility statement
          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