AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
AR Balance by GL Ac...
 
Notifications
Clear all

AR Balance by GL Account  

    Last Post
RSS

NickSM
Posts: 28
 NickSM
September 3, 2020 2:26 am
(@nicksm)
21-50 Posts
Joined: 8 months ago

Hi,

Does anyone know of a simple way to suppress zero balances on the Customer Summary option for AR Balance by GL Account (AR632000). It is a slightly more confusing as I first thought, due to the multiple layers. Can a variable be passed as into a Filter? That would be my first optio, however it won't let me.

Any advice as always is gratefully accepted.

Regards

Nick Savage-Mady

4 Replies
megan.friesen
Posts: 51
 megan.friesen     ★★ All-Star ★★
September 3, 2020 10:22 am
(@megan-friesen)
51-100 Posts
Joined: 10 months ago

Hi, What I've noticed in this report is that it doesn't show all customers with $0, it just shows customers that had transactions during the period, so their ending balance might be zero, but at some point during that period they had at least one transaction.

I'm not sure about the variables, but another option you could look at would be some sort options, to sort by dollar value, so that the highest balances are at the top of the list and the $0 are at the bottom.

Reply
NickSM
 NickSM
(@nicksm)
Joined: 8 months ago

21-50 Posts
Posts: 28
September 3, 2020 5:15 pm
Reply tomegan.friesenmegan.friesen

Hi @megan-friesen,

That is good suggestion and I think I might have to go that way.

I did think that might be an easy option to start off with, however I wanted to hide them completely. The client in question has about forty zero balance customers.

I might be able to do a condition based on the calculation of the transactions i.e. visibility on sum of Invoice Totals. It can be my Hail Mary, then sort order is the way to go.

Thanks for the suggestion 🙂

Nick Savage-Mady

Reply
NickSM
 NickSM
(@nicksm)
Joined: 8 months ago

21-50 Posts
Posts: 28
September 3, 2020 5:49 pm
Reply toNickSMNickSM
megan.friesen

I've figured it out now. If you add [ARHistory.FinYtdBalance]<>0 to the VisibleExpr, then it hides any account with 0.00 YTD Balance.

Managed to also add a Suppress Zero check box to fire as well. It is pretty standard I know, but always good to see it work.

image

Just add the following code to the end of the VisibleExpr

AND iif(@SuppressZero=TRUE AND [ARHistory.FinYtdBalance]=0, FALSE, TRUE)

 

Simple !!!

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2488
October 7, 2020 10:09 pm
Reply toNickSMNickSM
NickSM
megan.friesen

@nicksm Nice solution! It would still be interesting to see if you could put in a condition. I think it's basically the equivalent of the HAVING clause in a SQL statement which is like the WHERE clause, but it operates on the GROUP BY clause to filter against aggregate values rather than individual record values. I'm just not sure if it's possible to do in Report Designer.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
3 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×