Solved

ARM Reports - Unit set by sub account Segment

  • 21 September 2022
  • 5 replies
  • 409 views

Userlevel 5
Badge

Hi,

I’m working on a ARM report. The report shows the data expanded by sub accounts for some accounts. I need to add unit set to the report. the unit set should be triggered by a on segment of the sub account (the report should be filtered by the segment of sub account)

Example - Sub Account 1 - ORG-DEP-000. in here, in the middle shows the expense category. there are multiple expense categories which is the second segment of the sub account. 

How can I create a Unit set to filter the report using that middle segment of the sub account. 

 

Thanks,

Dulanjana 

 

icon

Best answer by Laura02 21 September 2022, 11:41

View original

5 replies

Badge +18

Hello,

Here is an example Unit Set with complete steps attached:

 

Userlevel 5
Badge

Hi @laura01,

This woks perfectly. Thank you for your support.

 

Thank you,

Dulanjana 

Userlevel 1

Is there any way to make the unit set where the subaccounts are selectable? So you can choose which sub accounts you want to show up on the report, either including or excluding certain accounts?

Badge +18

Hello,

On individual reports, we can make the range of subaccounts selectable.

We have the same choice, to include range of subaccounts in the Data Source section of the Row Set, Unit Set, and Column Set.

 

Userlevel 1

Thank you!

Reply


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