web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Frx to Management repo...
Microsoft Dynamics GP (Archived)

Frx to Management reporter

(0) ShareShare
ReportReport
Posted on by George Harmon

After a successfull migration,  I was trying to run a report and got the following error

 

The report definition must include at least one reporting unit with an account mask and the default company

Any thoughts on how to bypass this error

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sueconrod Profile Picture
    sueconrod 337 on at

    Yes, sounds like the exact same error message I got, because looks like you have a tree on this report and none of the trees come over.  You need to go back into your trees and setup the account mask like you did before.  You actually have to open the dimensions and put back in the &&&&& and the ??? that you used to have there before.  Unlike FRx you cannot just paste them in the dimensions box like we used to.  Make sure you open the dimensions up and go in and put in your tree structure.

    None of my trees brought in the dimensions, and fortunately there weren't that many trees that had to be cleaned up.  The references to the trees all existed, but without the dimension it just wouldn't work.

  • Ryan Sandness Profile Picture
    Ryan Sandness on at

    Hey Susan,

    Slight clarification. The amerpsand character (&) is no longer valid in trees in MR. You also can use dimensions with nothing in it, as that will just pull all data.

    This error is most likely because of either:

    1. A failure in the migration and there are no links in the FD column of the row format

    2. The company in the Report Definition is not included in the companies listed in the attached reporting tree

    Thanks

    Ryan

  • sueconrod Profile Picture
    sueconrod 337 on at

    Than when is the documentation all going to be cleaned up.  You have all this documentation out there that shows &&& for trees.  To me this is garbage and confusing.  Most of the documentation is taken right out of the old FRx manuals and was never corrected.  This is right off of the documentation in MR  Version 2.0.1700.31.

    I wish Microsoft would get their act together.  They decided to push this product out the door and the documentation they put out with it is so full of holes.  I finally got all of my reports working but spent hours doing it and I was considered an expert in FRx for my VAR (16 years of supporting FRx).  At least when FRx first came out the documentation was good and reliable.  

    The following table shows the hierarchy and the reporting tree definition of the completed sample reporting tree. Use this table as a reference while you are working on the procedure in this section.

    Company

    Unit Name

    Unit Description

    Dimension

    SUMMARY

    1

    @ANY

    SUMMARY

    Summary of All Units

    Denver-Sales

    2

    FW

    Denver-Sales

    Denver-Sales

    Retail

    3

    FW

    Retail

    Retail

    &&&&-1100-001

    Wholesale

    4

    FW

    Wholesale

    Wholesale

    &&&&-1100-002

    See Also

    Create a sample report definition

    Create and populate a sample row definition

    Generate and view the sample report

    Insert reporting units from dimensions

    Modify the sample row definition

    Send comments about this topic to Microsoft Dynamics Content Publishing Team.

    Build date: 2010-03-29 [01:58]

  • Ryan Sandness Profile Picture
    Ryan Sandness on at

    Sorry for the frustration Susan. We weren't able to do as much with the doc as we had originally hoped. We have this fixed in the doc that will relase with MR2012, but we weren't able to fix it in an earlier release. If you have any concerns with other doc feel free to msg me and I can verify that we will have it fixed in the next release.

  • Alan Cederquist Profile Picture
    Alan Cederquist 185 on at

    Please note that I also had this error on an FRx to MR migration.  In this case the problem was caused by inconsistent segment names accross companies.   Client had set up the main segment description as 'ACCOUNT' in most companies, but left the default 'Segment 1' in a couple.  FRx couldn't care less about the Segment Description.  MR uses that description as the 'dimension'.  If you want to pull data from multiple companies, that description should be the same for all companies.  Correct it via Tools-Setup-Company-Account Format.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans