Skip to main content
Answer

Rounded Dollar Without Decimals in Inquiry

  • December 2, 2024
  • 8 replies
  • 264 views
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.

darylbowman

8 replies

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

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

Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
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’.

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

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.

Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • December 3, 2024

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

 

Chris Hackett
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. 

C
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.

Laura03
Chris Hackett
rconandrewl
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!

C
Chris Hackett
B
B
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 !!

C
Chris Hackett
Terms & ConditionsCookie settingsAccessibility 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