Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

FRX & Multiple Companies & Spec Sets

Posted on by 35

We have multiple companies in FRX and the main company is the default.  I run all company reports from the default without changing companies.  My boss changes companies and noticed that the row formats were not being updated even though I had.  Well I discovered that our main company had one spec set and all of the rest of the companies had another.  What is the simplest most correct solution?  Use one spec set for all companies and only log in to one or log in to each seperately each time you want to run a specific company report.  From the research I have done, there is not a right or wrong way to do it, I just need some confirmation that I am understanding how default companies & spec sets work correctly.

I think we were originally setup to run all from one spec set, but our IT department does not fully understand FRX and we are still learning.  Any help or suggestions would be appreciated.

*This post is locked for comments

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: FRX & Multiple Companies & Spec Sets

    Hi,

    I'm replying from the perspective of an IT side and I couldn't give any best practices about how to use FRx, but I know for sure that I don't play in those settings, unless the Finance users are asking for help :-). Where Dan is right is the fact that FRx is going to be phased out and Microsoft is already providing a replacement for it in the Management Reporter tool. We started to migrate all the FRx reports a few months back in our company and it was pretty straightforward, aside of a few hickups that had to be fixed in the row and column sets. The latest version was release about a month back I think and can be downloaded from Customer Source. If you are a regular FRx registered customer, the upgrade to MR 2012 will be free of charge to you.

  • Verified answer
    Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: FRX & Multiple Companies & Spec Sets

    You are correct  in your assumptions.   You can have one spec set for each or one for all.   If all have the same accounts and the same reports to run, then 1 spec set for all would work.  You just need to change the company on the catalog when you run the report.   The spec sets contain the rows, columns, trees, and catalogs.  As far as answering your question on the simplest, most correct solution?  That depends on the variability of what you have.  

    On a side note, you are aware that support for FRx (at least from Microsoft) is soon to end (last I heard was 2013) so Frx may not be a long term solution anyway.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans