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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR 2012 Lists accounts...
Microsoft Dynamics GP (Archived)

MR 2012 Lists accounts as missing that do no even exist in GP

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,852 Moderator
I was just working on a row definition and I ran the missing GL account routine to check for any missing accounts. It is listing six accounts that do not even exist in GP. Why would it do that? How could it do that? In our case with have a 3 segment GL and it only lists the main segment on the report so I cannot see the exact account number that is missing. I did notice that for these accounts not all segments exist for the main account. for example, on the report is 01-00-5037. There is no 00-00-5037 in GP. But it lists 5037 as missing. Is it trying to find a 00-00-5037?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,588 on at

    Because Management Reporter 2012 is dimension based, and not account based like FRx was, I am going to say that this is working as designed.

    The reason for this is that there is a segment created in Dynamics GP, and it falls within the range of accounts that are included in the report, so it is going to be considered as missing.  While 00-00-5037 is not an account, 00 is a segment and that segment(dimension) is missing.  

    Another possibility is that 00-00-5037 did exist at one point.  There is a record for it in the DDM and it is marked as not active.  We've recently seen where this inactive account is read by the missing account analysis.  To fix this, you could rebuild the DDM.  Doing that would not include the account in the DDM since it no longer exists in the GL.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Well then that explains it. The DataMart has been rebuilt. For only six accounts I am not going to worry about it. The reports come out all balanced. I just wanted to confirm my suspicions. Thank you.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans