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) / Management Reporter Ch...
Microsoft Dynamics GP (Archived)

Management Reporter Check Links?

(0) ShareShare
ReportReport
Posted on by bcool 2,469

Is there any kind of Check Links process available for Management Reporter?

I ask because while developing some queries to help locate account numbers used in Dimension Filters, I noticed there are a few records in the controlrow----- and controlcolumn---- tables that are from old, no longer used definitions.

 It seems like row and/or column definitions were deleted at some point, but some of the underlying detail definitions didn't get removed.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    MR does have a refresh under Tools -> Refresh Cached Financial Data but I don't believe it changes the data you are referring to. It doesn't hurt to give it a try though.

    If the issue persists, I would be curious to know if you can see any of the data you referred to from the front end of MR.

  • bcool Profile Picture
    bcool 2,469 on at

    Yeah, the 'Refresh Cached Financial Data' didn't help.

    Regarding your second thought, I have records in the ControlRowMaster table referring to row layouts which do not appear in the MR 'Row Definitions' pane in Report Designer. I wonder if they were created in MR from some invalid FRx data when I ran the conversion?

  • Community Member Profile Picture
    Community Member on at

    I wasn't able to find any information on records in MR that get left behind so I think the theory that they might have come from an FRx upgrade is valid. I would also recommend the following as a test.

    1. Make a backup of the MR SQL database.

    2. In MR, go to Company -> Building Block Groups.

    3. Select a building block group and click Export.

    4. Click the Select All button under each tab and Export.

    5. Repeat Steps 3 and 4 for all building block groups.

    6. Next, make new building block groups and import the reports.

    7. Assign the companies to use the new building block groups under Company -> Companies -> Modify.

    8. Delete the old building block groups.

  • Verified answer
    bcool Profile Picture
    bcool 2,469 on at

    I'm embarrassed to admit this, but I wasn't restricting my results by specification set - so they were including records for ALL the specification sets (doh!). The 'bad' records were coming from an old specification set that we haven't used in a long time. Once I deleted the old set the 'bad' records went away.

    Needless to say, I've fixed all my queries to restrict future results by specification set :-) Thanks for your help!

  • Community Member Profile Picture
    Community Member on at

    Glad to hear you were able to figure it out! I hadn't seen where anything gets left behind before so it makes sense the records were tied to an old spec set.

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