Skip to main content
Solved

Rounded Dollar Without Decimals in Inquiry

  • December 2, 2024
  • 8 replies
  • 441 views
  • Translate All
rconandrewl
Freshman I
Forum|alt.badge.img

Hi, I’m trying to better format a Dashboard Table to show whole dollar rounding for some of our GI’s. I’ve been scouring different DACs and Community posts trying to find a ‘whole dollar’ schema that would provide a right aligned number with comma separators and no decimals. (#,##0).

I’m able to use these parameters for Report Design and Pivot Views, but cannot find a schema to use with this format. I’m hoping I’m just way overlooking the solution to this and maybe someone could help me out. I’d really like to avoid creating a Customization to achieve the formatting.

Best answer by clancour

​@rconandrewl 

Found a dac and a field with PXDecimal(0)

APPaySelReport.SignBalance

Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

View original

    8 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+17

    If nothing else, a virtual DAC with an unbound field specifying [PXDecimal(0)] should give you the schema that you need.

    Translate
    Daryl 🧩 I build Acumatica add-ons 🔗deftstrokesdev.com/products?ref=forum
      rconandrewl
      Freshman I
      Forum|alt.badge.img
      • rconandrewl
      • Author
      • Freshman I
      • December 2, 2024

      If nothing else, a virtual DAC with an unbound field specifying [PXDecimal(0)] should give you the schema that you need.

      That’s my issue, I cannot find a Decimal(0) schema to use as a virtual DAC, unless I’m misunderstanding what you mean by ‘virtual DAC’.

      Translate
      darylbowman
      Captain II
      Forum|alt.badge.img+17

      Yeah, I can't think of anywhere there'd be one. I was suggesting a simple customization. A 'virtual' DAC because it wouldn't be a real table, so no database changes.

      Translate
      Daryl 🧩 I build Acumatica add-ons 🔗deftstrokesdev.com/products?ref=forum
        Varsity I
        Forum|alt.badge.img+4
        • arthia
        • Varsity I
        • December 3, 2024

        Hi ​@rconandrewl , Hope this help you to round off decimals - 

         

        Translate
          rconandrewl
          Freshman I
          Forum|alt.badge.img
          • rconandrewl
          • Author
          • Freshman I
          • December 3, 2024

          Hi ​@rconandrewl , Hope this help you to round off decimals - 

           

          Thank you ​@arthia98 for trying, but unfortunately that does not help resolve my formatting goal. Using the Integer format removes the comma separators and left aligns the values making it very difficult to read dollar values varying in scale. I’m trying to replicate the number formatting I’m able utilize in Pivot Tables of #,### with no concern for rounding. 

          Translate
          Jr Varsity II
          Forum|alt.badge.img
          • clancour
          • Jr Varsity II
          • Answer
          • December 3, 2024

          ​@rconandrewl 

          Found a dac and a field with PXDecimal(0)

          APPaySelReport.SignBalance

          Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

          Translate
            rconandrewl
            Freshman I
            Forum|alt.badge.img
            • rconandrewl
            • Author
            • Freshman I
            • December 3, 2024

            ​@rconandrewl 

            Found a dac and a field with PXDecimal(0)

            APPaySelReport.SignBalance

            Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

            Thank you so much for helping me find this, I just tested in my GI and it worked!

            Translate
              Semi-Pro II
              Forum|alt.badge.img+1
              • bodiec
              • Semi-Pro II
              • April 8, 2025

              ​@rconandrewl 

              Found a dac and a field with PXDecimal(0)

              APPaySelReport.SignBalance

              Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

              This is beautiful thank you so much ​@clancour !!

              Translate
                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