web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Update Management Repo...
Finance | Project Operations, Human Resources, ...
Suggested answer

Update Management Reporter Account/Sub-Account descriptions

(2) ShareShare
ReportReport
Posted on by JGarcia123 699
Does anyone know the Management Reporter datamart tables that store GL Account and Sub-Account description fields?  We have a scenario where a customer must update some descriptions after the fact.  Again these are account and sub-account descriptions and does not affect transactional data.  For efficiency these updates are done in the accounting application via SQL on a periodic schedule.  The issue is that the periodic updates by pass the datamart updates and the datamart must still be rebuilt from time to time. 
 
If we can identify and update the datamart tables it would eliminate the extra datamart rebuild.  Please advise.  Look forward to a response.
 
JG  
Categories:
Microsoft Dynamics GP
Microsoft Dynamics SL
I have the same question (0)
  • CU17011839-0 Profile Picture
    CU17011839-0 4 on at
    Update Management Reporter Account/Sub-Account descriptions
    To find the account description table in Management Reporter, enter metadata sections, row definitions, and configuration tables. Review the documentation, create a backup, and test your changes before making any changes. If you encounter any difficulties, contact your Microsoft partners or shared users. Use SQL Server Management Studio for detailed analysis.
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    Update Management Reporter Account/Sub-Account descriptions
    Hi,
    There is no way you'd be able to do so.. The content tables in the Management Reporter  DataMart is very intricated and complex. If you updated some GL Acct descriptions in the GP master card, the description might not get updated in MR 2012 until you rebuild the DataMart from scratch (which is why I don't recommend the DM at all with MR 2012.. keep using the Legacy connector which pulls data straight from the GP tables).
    Hope that helps, 
     

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans