AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Analytica...
In a report where e...
 
Notifications
Clear all

Questions In a report where every row is set up the same, one row produces an odd looking result

 
Acumatica Analytical Report Manager (Financial Report Writer)
Last Post by Tim Rodman 4 years ago
5 Posts
3 Users
1 Reactions
1,702 Views
RSS
Michael Peck
Posts: 26
 Michael Peck
Topic starter
December 7, 2021 9:08 am
(@michael-peck)
Trusted Member
Joined: 5 years ago

When I generate a report from one particular row set, the output is displayed as:

(466.52)
- 0.07%
0.00
0.00%
0.00
0.00%
0.00
0.00%
 
 
 
 
(466.52)000000
 

Thgis line is a normal debit balance account but has a Credit Balance for the period and the YTD Column. No problem with the period display but the YTD value has 6 zeroes appended to the actual period. The YTD Column is the result of a calculation rather than a database value.

If anyone knows what would cause this display, and how to correct it, I would appreciate the assistance.


4 Replies
Donna Boes
Posts: 27
 Donna Boes
December 7, 2021 10:05 am
(@bodonna)
Eminent Member
Joined: 8 years ago

Do you have something in the format row on the column set?

 

image

Reply
Michael Peck reacted
Michael Peck
Posts: 26
 Michael Peck
Topic starter
December 7, 2021 4:50 pm
(@michael-peck)
Trusted Member
Joined: 5 years ago

Yes. This occurs on only one output row. The entry is: #,##0.00;(#,##0.00)#,##0.00;(#,##0.00), which I now see appears to have been added twice. I was looking for something on the Row Set, but I believe this is occurring because of the negative value (Credit balance in a Debit Balance account)

Thank you.

 


Reply
Michael Peck
Posts: 26
 Michael Peck
Topic starter
December 7, 2021 4:56 pm
(@michael-peck)
Trusted Member
Joined: 5 years ago

That was it. How do I mark your response as the solution? I don't see any way to do that other than a 'Like'


Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3199
December 7, 2021 10:38 pm
Reply toMichael PeckMichael Peck

@michael-peck "Like" is the closest thing to "Solution" unfortunately.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 55 Online
  • 2,414 Members
Our newest member: Megan Pawlowski
Latest Post: Credit Reference Report Needed
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • russ
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×