Home » Listing Details
Top Websites
  1. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  2. Dynamics GP Help
    Over 2900 resources listed.
  3. Rose Business Solutions Blog New
    Over 1800 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1000 resources listed.
  5. Microsoft Dynamics Partner Community Blog
    Over 800 resources listed.
  6. Mariano Gomez at The Dynamics GP Blogster
    Over 800 resources listed.
  7. Mohammad Daoud's Dynamics GP Blog
    Over 500 resources listed.
  8. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  9. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  10. eOne Business Solutions Blog
    Over 400 resources listed.
  11. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 400 resources listed.
  12. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  13. About Dynamics, Development and Life
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  16. Victoria Yudin's Dynamics GP Website
    Over 100 resources listed.
    Victoria Yudin
  17. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  18. BKD Dynamics GP Insights Blog
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

ID:22566
Title:How Dimension Names Impact Management Reporter
URL:http://blogs.msdn.com/b/dynamicscpm/archive/2012/06/15/how-dimension-names-impact-management-reporter.aspx
Description:

I have seen some confusion about information missing from reports, reports returning zeros, and how to create consolidations for multiple companies. Today we’re going to take a look at how the link to Financial Dimensions column works and some scenarios to watch out for.

In Management Reporter when you log into a company,  the name of the segment for the natural account, and all other segment or dimension names are pulled from your Microsoft Dynamics ERP. The following table illustrates default segments in the demo companies across the different Microsoft Dynamics ERPs:

Microsoft Dynamics ERP

Account

Dimensions

Dynamics GP

Account

Division

Department

 

 

 

 

Dynamics SL

Account

Reporting Unit

Company Segment

Location

Group

Sales Type

Region

Dynamics NAV

Account

Department

Project

Area

Customer Group

Sales Person

Business Group

Dynamics AX 2009

Account

Department

Cost Center

Purpose

 

 

 

Dynamics AX 2012

MainAccount

Department

Cost Center

Purpose

 

 

 

 

Typically, when you open a row definition you’ll see the dimension name in the link to Financial Dimension column.  You can see in the screenshot below the link to Financial Dimension column has +Account.

But, in some cases your row definition may look like the below screenshot.

This could happen because:

  1. You have multiple companies with different charts of accounts or differently named chart of accounts
  2. You are importing a group of report definitions (*.tdbx) from another Management Reporter installation
  3. You are upgrading from Microsoft Dynamics AX 2009 to Microsoft Dynamics AX 2012

As you can see in the screenshot above, this row definition has all of the formatting, but no dimensions. The Link to Financial Dimensions (FD) column is blank except for some + (plus) symbols. The link to FD column stores the dimension name, and if that dimension name isn’t present in the company you are logged into, then the values aren’t recognized in Report Designer.

 To fix this, you can do one of the following:

  1. If it makes sense, ensure all of your companies share similar segment names. In the case of Dynamics GP, many customers never actually set segment names under Tools | Setup | Company | Account Format. If your chart of accounts really is the same across all companies, use consistent names.
  2. If you do have different segments for different purposes, then be sure that you are logged into the correct company that references that segment. If you have companies ‘ONE’ and ‘TWO’ and the ‘Project’ dimension is only used in company ‘ONE’, then make sure you log into company ‘ONE’ when making edits to row definitions that use ‘Project’.  If you need to combine companies with different segment names, follow the suggestions in our blog post here to use multiple links to Financial Dimensions specific to each company.
  3. If someone sends you a *.tdbx with Management Reporter building block definitions, ask the sender for a list of the dimension names. For Partners working on customer reports setup a blank company with the same dimension names to use for troubleshooting or building reports.
  4. If you have no control over segment names, like in the case of upgrading AX2009 to AX2012 where the dimension name changes from Account to MainAccount, you can contact support for assistance in changing this and providing you a new *.tdbx file for your reports. Select your Dynamics solution here from the list of supported products and then click on Support Options for details on how to contact a support representative.

 

Category:
Link Owner:
Date Added:June 15, 2012 10:59:59 PM
Number Hits:3
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.

 
GPWindow.com

Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.