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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Reporter no...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Management Reporter not registering changes to GL Account user defined fields

(0) ShareShare
ReportReport
Posted on by RJarrell 321

We are using management reporter with dynamics gp. We have recently hit an issue. We have a report where each column is restricted by user defined field #1. So for example, each column is pointed to a different code like 1, 2, 3, 4. We recently realized that two accounts were not pointed to the right code. We switched the user defined field from 2 to 1. When we run the report, they are still showing up under the 2 column. I rebuilt the management reporter datamart but it is still not showing. Anyone have any ideas? 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    JakeF Profile Picture
    JakeF Microsoft Employee on at

    The MR data mart can only see one code per main account number. An example with the TWO demo company:

    -In GP, I found 2 accounts that share the same main account code: 000-5100-00 and 100-5100-00
    -In 000-5100-00, I entered 1 into the User-Defined 1 field.
    -In 100-5100-00, I entered 2 in the User-Defined 1 field.
    -Wait a few minutes for the data to flow through the data mart.
    -In MR, I only see 1 as an available code for User-Defined 1.

    The reason for the above is that the data mart doesn’t look at the full account string for several account-related attributes. It only looks at the main account code. Therefore, all accounts with the same main account code (in this case, 5100) would need to have the same value in the User-Defined field in order to work. This is considered a limitation of how the data mart works. The issue applies to a few different account attributes including the User-Defined values, currency translation type, account category, posting type, typical balance, etc.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 610 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans