Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Monday, April 27, 2015

Management Reporter Data Mart integration with Dynamics GP 2015 | Company Integration

Although this is an oldie piece of information, but it is definitely a “Goldie”. With the release of Management Reporter CU 11 and Dynamics GP 2015, a new feature was introduced to control the integration of newly added companies.

Go to Microsoft Dynamics GP > Tools > Setup > Company > Company.
Click on “Options” to open the “Company Setup Options” window

Company Options

As shown above, there is a separate section for management reporter integration with Dynamics GP when deploying the data mart provider. If these options are unchecked, then the financial data of this company will not be integrated into Management Reporter data mart.

Technical Perspective:

Within the data mart database (by default Management Reporter DM db) , there is a table named “Organization” retrieving the companies to be integrated from Dynamics db according to the configuration above.

Organization Table

Within Dynamics database, the company master table stores all the companies within Dynamics DB. There are two fields corresponding to the configuration within the company setup options, which are:

  • Enable GL Reporting
  • Enable AA Reporting

SY01500

In this essence, you can no longer import companies manually from Management Reporter configuration console, when a new company is added to Dynamics GP, the configuration mentioned above will determine whether this company will be integrated or not.

Best Regards,
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete