Solved

ARMS report using contains condition

  • 8 January 2024
  • 3 replies
  • 50 views
estebanperalta54
Rank
Userlevel 6
Badge +3

Is it possible to use a contains filter in an ARMS report Profit and Loss like you can use with a GI? My client heavily uses sub-accounts and they want to be able to use "contains" filters with sub-accounts. For example, they want to be able to filter for the second segment in the subacount. So if they filter for '10' they would see the selected rows as you can see:

 

icon

Best answer by Laura02 8 January 2024, 21:54

View original
If you found the post helpful please like the post or if it answered your question mark it as best answer. Thanks!

3 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @estebanperalta54 

It does not filter like a GI but you could create them a new report and add the report definition for sub accounts. That may get them closer to what they are looking for. 

 

The same with Row Set, you could 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Laura02
Rank
Badge +18

Hello,

Please try a subaccount filter in the Row Set’s Data Source like this: ???CON for contains CON.

Subaccount 000CON in Demo Trial Balance
Filter Start Sub using ??? wildcard to choose second segment

Results:

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
estebanperalta54
Rank
Userlevel 6
Badge +3

Thanks @Laura02 This is exactly what I was looking for.

If you found the post helpful please like the post or if it answered your question mark it as best answer. Thanks!

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