tracking code
LBMC Technology Solutions
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • Sage Intacct
    • Document Management (ECM)
    • Network Engineering and IT Solutions >
      • IT Security
      • Managed IT
      • Business Phone Systems
  • Events
    • All Upcoming Events
    • Training / CPE
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • On-Demand Webinars
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Partner with Us
    • Community
    • Contact Us

Consolidating companies with differing account segments in MS Management Reporter

2/19/2014

 
Posted by Lisa Suggs

For Microsoft Dynamics GP, GL account segment dimensions are viewed in Management Reporter dimensions based on the segment description. If all of the companies that need to be consolidated on financial statements have the same segments and same descriptions, then creating consolidated financials is easy. But what if the segments are different? You can still produce consolidated reports, but it is slightly more complicated. Here are the steps:

Row format

1.  A separate link must be defined for each company so that the dimensions can be defined for each company.
Picture
2.  Set the first company as the Default under the Company menu > companies. Select the accounts.
Picture
3.  Repeat for the second company. You will not be able to see the accounts from the first company. You should be able to copy the column out to Excel and do a find/replace “Seg2” with “Account” to make it quick and easy.
Picture

Tree format

The tree has to have a few more elements.

1.  The tree can be built manually or by logging into one company and selecting dimensions; then the other.
2.  Define the row format to use in column E.
3.  Define the FD link from the row so that each unit knows which dimension to look for.
Picture

Report format

1.  Set the report for the @ANY company.
2.  Check the “use row definition from reporting tree”.
Picture

Comments are closed.


    Blog

    ​Your one stop shop for technology.

    Categories

    All
    Business Central
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM
​Sage Intacct
​
Network Engineering

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
User Conferences
Training / CPE
Vision
Webinars & Workshops
​

Resources
Blog
Forum
Referral Program
​​YouTube Channel

Company
About Us
Careers
Contact Us
​
Locations
Charlotte
Knoxville
Nashville
Picture
Picture
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

LBMC Technology Solutions