Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

FRx Tree Examples

Posted on by 75,730

Can anyone provide some links and/or tips on how to set up an FRx consolidated income statement that spans multiple companies? I am looking to have each column be a company. All companies have the exact same gl account structure.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: FRx Tree Examples

    Frank, I am looking at a tree with over 7600 rows in it. The report takes 20 minutes to run in FRx and when I converted it to MR 2012 it takes over an hour to run. I have a meeting set up with the person that created the tree and I hope to find out the logic in this tree. There are 17 companies and in the tree he is setup rows for various accounts in the GL. From what I remember about FR tree I believe I can get rid of most of these rows but I want to understand the logic of its original creation.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: FRx Tree Examples

    Richard, you would set up a Reporting Tree where each of the business units is defined as a Reporting Unit in the tree.  Then, in the column layout, you identify the business unit in the column.  I think the name of the field in the column layout is Reporting Unit, but I'm not in front of FRx and it's been awhile since I've used it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans