Solved

How to create a formula to get Branch Name Dynamically in ARM Reports

  • 20 June 2023
  • 2 replies
  • 115 views
F
Rank
Userlevel 3
Badge

Hi,

I customized a ARM Balance Sheet Report to reflect 6 different branches at a time. What formula can I use in each column to pull the branch name automatically versus having to input manually for each colums? Here is a snapshot of the column set and highlighted fields. 

 

 

Thanks,

Frances 

 

 

icon

Best answer by Laura02 20 June 2023, 01:15

View original

2 replies

Laura02
Rank
Badge +18

Hi Frances,

I like your idea; have you considered adding it to the Ideas section of this Community?

Did you already try the function for Branch Name in Parameters?  I have a feeling it might print the Branch from Report Parameters in every column, instead of pulling the Branch from the Data Source of each column, but I’m not 100% sure.

 

Otherwise you might consider Velixo.  We find that ARM reports meet the needs of 80-90% of our clients and those with the most complex reporting needs use Velixo. Search this community for Velixo if you’re not already familiar.

 

Laura

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

Hi Laura,

Thanks for your help. I will look into your suggestions. 

 

Frances

 

 

 

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