Solved

Mask to omit accounts in ARM Report row set

  • 10 November 2020
  • 3 replies
  • 236 views
P
Rank
Userlevel 3
Badge

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

icon

Best answer by vkumar 10 November 2020, 10:34

View original

3 replies

V
Rank
Userlevel 7
Badge +11

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
Rank
Userlevel 3
Badge

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
Rank
Userlevel 7
Badge +10

@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

Reply


Terms & ConditionsCookie settings
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