Skip to main content
Answer

Mask to omit accounts in ARM Report row set

  • November 10, 2020
  • 3 replies
  • 352 views
P
Semi-Pro II
Forum|alt.badge.img

Hello everyone,

 

Maybe I am overlooking things here, but is it possible to add a mask to omit or not display an account in a certain range of accounts? 

For example let’s say I have account class 500 on my chart of accounts with accounts:

500000

500010

500020

500043

500057

500081

500100

and I want to show all accounts between and including 500000 and 500100 but I do not wish to see 500043 on my report. Is there a mask or would I be better off creating 2 rows, starting 500000 ending 500020 and then another row starting 500057 ending 500100?

 

Thanks

Best answer by vkumar

Hi @podonnell11 

As you mentioned, creating two rows with only GL accounts to be visible is the only option in this case. I don't see a way of excluding random GL accounts from a range of GL accounts on Data source on ARM row set.

Hope this clarifies,

Regards,

3 replies

V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • Answer
  • November 10, 2020

Hi @podonnell11 

As you mentioned, creating two rows with only GL accounts to be visible is the only option in this case. I don't see a way of excluding random GL accounts from a range of GL accounts on Data source on ARM row set.

Hope this clarifies,

Regards,

VijayKumarU
P
Semi-Pro II
Forum|alt.badge.img
  • podonnell11
  • Author
  • Semi-Pro II
  • November 10, 2020

Hi @podonnell11 

As you mentioned, creating two rows with only GL accounts to be visible is the only option in this case. I don't see a way of excluding random GL accounts from a range of GL accounts on Data source on ARM row set.

Hope this clarifies,

Regards,

Thanks Vijay

Gabriel Michaud
Captain II
Forum|alt.badge.img+11

@podonnell11 have you heard of Velixo? I received a similar enhancement request from another customer and we added the ability to exclude specific accounts or ranges of accounts from an account class. It helps make the report cleaner:

In the example above, i’m including account class “SALES”, except accounts 40010 and 40020.

This is something Acumatica could implement as well in ARM, you can make the suggestion in the Ideas section.

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
P
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