Solved

Unit Set roll up Companies to print combined Enterprise Balance Sheet, P & L Not Working

  • 16 January 2024
  • 7 replies
  • 126 views
Laura02
Rank
Badge +18

Hello Community,

I feel like this should be simple - what have I missed?

Unit set has only two company branches rolling up to a total. All Comp node has NO DATA SOURCE:

Unit Set - 2 companies rolling up to All Companies node.

Report ‘Building Blocks’:

Result is: Both Companies print correctly but the All Companies Roll-up includes only the LAST company, Company 2:

Why is Company 1 left out of the All Companies Roll-up? 

We have no Company Roles active. This is version 2023 R1, Build 23.114.0025 .

Thank you!

Laura

icon

Best answer by Laura02 18 January 2024, 15:26

View original
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

7 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @Laura02 

You are usually the ARM reporting guru, so for you not to know, I doubt I will. I did have one thought just to try though:

Put the start and end branch in anyways just to see if you get the roll? (Unless of course you tried that)

 

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

Hi @Kandy Beatty ,

Thank you for the compliment!  You have a great idea, but there is no From/To Company.

I thought of entering both like 001,002 but it doesn’t work like Start Subaccount works. I could not enter 001,002 in Company.

 

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

Is it a requirement to have Companies with Branches, in order to use Unit Sets to Roll up?  

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

Hi @Laura02  I think with Branches is a requirement. 

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*.
bryanb39
Rank
Userlevel 6
Badge +5

Can you remove company as a requested field and use something else such as sub accounts to achieve the same thing?  

https://www.fiverr.com/acudatica
Laura02
Rank
Badge +18

Hello Community,

I’d like to give a shout out and a big THANK YOU to @MinushaWeerasuriya76 of Acumatica Support for solving my problem!

I think this is a new feature, because I’ve built about 1762 Financial Reports (estimate 🤣) and never had to add calculations to the nodes of Unit Sets to get a roll-up to work.  Minusha showed me how configure as follows:

 

Add Calculation to Value Column of Parent/roll-up node in Unit Set

Thanks to everyone who posted ideas.

 

Laura

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

That looks very useful, thanks for sharing.  

https://www.fiverr.com/acudatica

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