Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jessica Krakowiak]

In Management Reporter, is there a way to build a report using the Legal Entities on the rows?  Currently, we only have reports built using accounts on the rows.?  Any advice would be appreciated, including confirmation that this function may not be possible.
Thank you!
~Jessica

#UnifiedOperations
#ManagementReporter
#AX2009
#AX2012
#CRM2011
#CRM2013
#CRM2015
#CRM2016
#CustomerEngagement

——————————
Jessica Krakowiak
Universal Leaf Tobacco Company, Inc.
Richmond VA
——————————

[Steve Latta]

?I haven’t tested this, so it may not work, but it looks like if you build a reporting tree with each of your legal entities as a separate summary line, you can set a specific one for a row by using the Related Formulas/Rows/Units column to specify which unit you want summarized on that row. In the report definition, you would need to run for company ANY and specify the reporting tree you created there as well.

That’s the only workaround I can find since legal entity isn’t an available financial dimension.
?

——————————
Steve Latta
Accountant
Ortec, Inc.
Easley SC
——————————
——————————————-

[Jessica Krakowiak]

??Hi Steve,

Thank you for your response! We will try your suggestion and if you don’t mind, resource your expertise!

FYI – Our company is on the platform Dynamics 365 Finance and Operations – Enterprise Edition.

Thank you,
Jessica

——————————
Jessica Krakowiak
Universal Leaf Tobacco Company, Inc.
Richmond VA
——————————
——————————————-

[Carol Holmes]

Please post an update for your results. We are in the process of bringing on another legal entity which we cannot roll into our Consolidation account, but will have to report on as a separate company. Your testing and results might help our finance department with their reporting.

thanks,
Carol

——————————
Carol Holmes
Business Systems Supervisor
Vesta Solutions, Inc.
Temecula CA
——————————
——————————————-

[Jessica Krakowiak]

Hi Everyone,

Below is the advice we received from MS, hope this is helpful! ~Jessica

—Begin Msg—

There are a couple of ways to add the Legal Entity to a Row Definition depending on the Dimensions that are defined in the system.

1. If the Legal Entity is specified as a Dimension then that Dimension could be added to the Row instead of the MainAccount.
2. The more common way is to use a Reporting Unit restriction on the row that is specific to the branch of the Tree for the particular Entity. 

 

As an example. Tree as follows: (see MS1 (Tree))

 Row: (see MS2 (Row))

*If possible do not use the same dimensions between the Tree and the Row. 

 Column: (see MS3 (Column))

——————————
Jessica Krakowiak
Universal Leaf Tobacco Company, Inc.
Richmond VA
——————————
——————————————-