WWW.BOOK.DISLIB.INFO
FREE ELECTRONIC LIBRARY - Books, dissertations, abstract
 
<< HOME
CONTACTS



Pages:   || 2 |

«Management Reporter Integration Guide for Microsoft Dynamics® NAV July 2013 Find updates to this documentation at the following location: ...»

-- [ Page 1 ] --

Microsoft Dynamics

®

Management Reporter

Integration Guide for

Microsoft Dynamics® NAV

July 2013

Find updates to this documentation at the following location:

http://go.microsoft.com/fwlink/?LinkID=162565

Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your

people to make business decisions with greater confidence. Microsoft Dynamics works like and with familiar

Microsoft software, automating and streamlining financial, customer relationship and supply chain processes in a way that helps you drive business success.

U.S. and Canada Toll Free 1-888-477-7989 Worldwide +1-701-281-6500 www.microsoft.com/dynamics Information in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2013 Microsoft Corporation. All rights reserved.

Active Directory, Microsoft, Microsoft Dynamics, and Windows are trademarks of the Microsoft group of companies.

All other trademarks are property of their respective owners.

MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV

Table of Contents Introduction

System setup

System prerequisites

User account requirements

Configuring the data integration

Configure the data integration

Import companies

Select the default company

Appendix

Data mart displays only attributes associated with transactions

Unposted transactions are not supported in the data mart

Renaming companies from Microsoft Dynamics NAV

Changing report timeout settings

Modifying fiscal years in the data mart

Integrating a data mart with a second ERP database

Integrations might fail when customizations are made to database field lengths

MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV

Introduction Management Reporter 2012 for Microsoft Dynamics® ERP uses a data mart database to integrate data between Microsoft Dynamics NAV and Management Reporter. You can view and use the data from Microsoft Dynamics NAV to create financial reports in Management Reporter 2012 without affecting the original data in the ERP database.

A data mart integration creates a database of information from the original ERP database to create financial reports in Management Reporter 2012. This integration provides high level of integration with a Microsoft Dynamics NAV system, and offers enhanced report generation options.

Data for the following entities are available for integration into Management Reporter 2012:

 Actual balance  Budgets  Multiple currency information, for functional and reporting currencies  Fiscal Periods  Dimensions  Companies The Microsoft Dynamics NAV data mart is compatible with Management Reporter 2012. Earlier versions of Management Reporter must be updated to Management Reporter 2012.

System setup Before you configure the Microsoft Dynamics NAV data mart integration, your system must meet the minimum requirements for Management Reporter. For more information, see the System requirements for Management Reporter. Additional prerequisites are listed below.

System prerequisites The following components must be installed before the data mart integration can be configured on your system.

 Microsoft Dynamics NAV 2009 R2 The data provider is compatible with Microsoft Dynamics NAV 2009 R2. Earlier versions of this system must be upgraded to Microsoft Dynamics NAV 2009 R2 to integrate with Management Reporter 2012.

Note: The data provider does not require the Microsoft Dynamics NAV 2009 R2 client to be installed on the same computer, but the data provider requires access to the ERP database.

 Management Reporter 2012 server components Data providers must be configured on any computer that hosts the Management Reporter 2012 application service and process service. To configure these components, see the Management Reporter installation guide.

MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV

User account requirements Security permissions for the Microsoft Dynamics NAV integration user must be set up before configuring Management Reporter. The user account that is used to configure the data mart





integration must meet the following requirements:

–  –  –

In addition, Management Reporter 2012 requires database access to the Microsoft Dynamics NAV SQL Server database. When you configure the data integration, you must enter credentials that have access to the Microsoft Dynamics NAV database. Depending on the verification option that you select, different permissions are required for the user account that is assigned to the Management Reporter

process service, also known as the Service account:

 If you are using Windows Authentication, the Service account credentials must be assigned to the db_datareader role in the Microsoft Dynamics NAV database.

 If you are using SQL Server authentication, the SQL Server credentials that you provide must be assigned the db_datareader role in the Microsoft Dynamics NAV database. No additional permissions are required for the Management Reporter user account.

For more information about the Service account, see the Management Reporter installation guide.

Note: All Management Reporter users must have Active Directory domain accounts for authentication.

These credentials are used by the data provider to connect to Microsoft Dynamics NAV. For more information, see “How to create a domain account in Active Directory” on MSDN (http://msdn.microsoft.com/en-us/library/aa545262(CS.70).aspx).

After Management Reporter is installed and fully configured, you can add users and modify security permissions. See the Management Reporter Help documentation for more information.

MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV

Configuring the data integration The data mart for Microsoft Dynamics NAV is installed at the same time as the Management Reporter server components. For more information and installation procedures, see the see the Management Reporter installation guide.

The following procedures explain how to configure the data integration for Management Reporter.

Configure the data integration Management Reporter uses a data mart to integrate information from a Microsoft Dynamics NAV system. You can configure these components during initial configuration or after you have set up the application service and process for Management Reporter 2012.

Note: Management Reporter 2012 can integrate with multiple ERP systems, but you can configure only one instance at a time.

1. Click Start, select Programs, select Microsoft Dynamics, select Management Reporter 2012, and then select Configuration Console to open the Management Reporter configuration console.

2. In the Management Reporter configuration console, click File, and then select Configure to open the Custom Configuration dialog.

3. Under Management Reporter Application Service, select the Add Microsoft Dynamics NAV Data Mart check box, and then click Next.

4. On the Prerequisite Validation page, review any failed prerequisites or warnings and resolve issues before continuing with the installation process. Click Revalidate to run the validation again.

5. Click Next.

6. On the Settings page, under Dynamics NAV connection information, enter the name of the Microsoft Dynamics NAV server to connect to in the Database server field.

7. Enter the domain, user name, and password of the Service account, or select Use Windows authentication to connect to the ERP database using the user account that the services are running under.

For more information about this account, see User account requirements and the Management Reporter installation guide.

8. If the SQL Server is configured to use Secure Lockets Layer (SSL) for encryption, select Encrypt Connection. The data that is transmitted between the SQL server and Management Reporter 2012 services is encrypted.

Note: to use this option, you must configure SSL on the server and install certificates. For more information, see “Encrypting connections to SQL Server” on MSDN (http://msdn.microsoft.com/en-us/library/ms189067.aspx).

9. In the Database field, select the Microsoft Dynamics NAV database to connect to.

10. Under Data mart connection information, in the Database server field, enter the name of the SQL server that hosts the Microsoft Dynamics NAV database.

11. To connect to an existing data mart database, select Connect to an existing database.

12. Enter the user name and password of a user account that has permissions to connect to the data mart database. To configure the database using your current credentials, select Use Windows authentication.

13. In the Data mart database field, select an existing database to connect to, or enter a unique name to create a new data mart database.

MANAGEMENT REPORTER INTEGRATION GUIDE FOR MICROSOFT DYNAMICS® NAV

14. Click Next.

15. Review the configuration information, and then click Configure.

16. When a message is displayed that indicates that the data mart integration has been successfully configured, click Close.

17. To integrate with another instance of Microsoft Dynamics NAV, repeat steps 1 through 16. To integrate with another ERP system, see the integration guide for that ERP system.

18. After all integrations are configured for Microsoft Dynamics NAV, you must import companies. For more information, see Import companies.

Import companies After you have installed Management Reporter 2012 services and integrated with a Microsoft Dynamics NAV system, you must import company information from the Microsoft Dynamics NAV database into Management Reporter 2012.

Note: If you are upgrading from a previous version of Management Reporter, you must import all companies that you want to access in Management Reporter 2012. This includes companies that you have integrated with previous versions of Management Reporter.

1. In the Management Reporter 2012 configuration console, verify that the application service is running.

Note: The application service must be running to import company information.

2. In the navigation pane of the Management Reporter configuration console, expand the Management Reporter 2012 services node. Under ERP Integrations, select the integration to import companies from.

3. Click Import in the display pane.

4. Enter the domain, user name, and password of a user account that has access to the data mart database. For more information, see User account requirements.

5. Review the list of available companies. If a company has already been imported, Already imported will be selected. To not import a company, select Skip import.

6. Click Import companies.

7. When a message is displayed that indicates that the companies have been successfully imported, click OK.



Pages:   || 2 |


Similar works:

«Lead agencies: Ministry of Social Affairs (MoSA), Presidency of the Council of Ministers (PCM) & UNHCR BASIC ASSISTANCE Contact information: Chadi Ghajar ghajar@unhcr.org Carla Lacerda lacerda@unhcr.org PEOPLE IN NEED PEOPLE TARGETED REQUIREMENTS (US$) 1,341,240 889,500 288.6 million # OF PARTNERS GENDER MARKER Humanitarian $260.9 m 1 Stabilization $27.7 m SECTOR OUTCOME OUTCOME 1: Targeted severely (socio) economiINDICATORS cally vulnerable populations have improved % of total affected...»

«RWI : Discussion Papers Hiltrud Nehls and Torsten Schmidt No. 6 RWI ESSEN Rheinisch-Westfälisches Institut für Wirtschaftsforschung Board of Directors: Prof. Dr. Christoph M. Schmidt, Ph.D. (President), Prof. Dr. Ullrich Heilemann (Vice President), Prof. Dr. Wim Kösters Governing Board: Heinrich Frommknecht (Chairman); Eberhard Heinke, Dr. Dietmar Kuhnt, Dr. Henning Osthues-Albrecht (Vice Chairmen); Prof. Dr.-Ing. Dieter Ameling, Manfred Breuer, Prof. Dr. Walter Eberhard, Prof. Dr. Harald B....»

«75 Scrambles In Oregon The Best Non Technical Ascents Of pdf on the risk, it 75 Scrambles In Oregon: The Best Non-technical ascents will manage to be to grow a service software of offensive. The Craigslist Groomer-Pet hounding of business by the careful something of these Mortgage York Security using a session,. The finances say the morning to sell liquids at 75 Scrambles In Oregon: The Best Non-technical ascents the online questions on your loan performance address the type in same online...»

«Die Rezeption Bourdieus in der deutschen Wirtschaftssoziologie von Robert Stieber 2013, Jg. 3, S. B1-44. ISSN 2196-615X Inhalt 1 Einleitung 2 Analyseinstrument: Das Konzept der sozialen Felder 3 Die deutsche Wirtschaftssoziologie als soziales Feld 3.1 Abgrenzung zur Ökonomie 3.2 Internationale Einflüsse 3.3 Der programmatische Kern 3.4 Kämpfe und Feld der Macht 3.5 Gesellschaftspolitische Bedingungen 3.6 Institutionalisierung 4 Rezeptionsanalyse: Auseinandersetzung mit Bourdieu in der...»

«Einflussgrössen auf die Leistung globaler Teams Semesterarbeit am Institut für Strategieund Unternehmensökonomik Universität Zürich Lehrstuhl für Human Resource Management Prof. Dr. Bruno Staffelbach Betreuer: Martin Bannwart Fachgebiet: Betriebswirtschaftslehre I Fach: Human Resource Management Verfasser: Thomas Schneider Manessestrasse 104 8045 Zürich E-Mail: tom_schneider@bluewin.ch Matrikelnummer: 98-707-278 Studienrichtung: Sozialund Wirtschaftspsychologie Abgabedatum: März 2008...»

«Die école de la régulation: Französische Wirtschaftstheorie mit Ausstrahlung jenseits des Rheins Christoph Scherrer Erschien in: Der Intellektuelle und der Mandarin, Festschrift für Hans Manfred Bock, Kassel, Kassel University Press, 143-160 (2005). Das deutsche Wirtschaftswunder und später die Dominanz der deutschen Bundesbank haben lange Zeit in Frankreich für reichlich Diskussionen gesorgt. Umgekehrt wurde und wird in Deutschland der französischen Wirtschaft wenig akademische...»

«Liebe Leserinnen und Leser, Demokratie lebt vom Meinungsaustausch und – in einem positiven Sinn vom Streit um die beste Lösung. Deshalb braucht Demokratie Menschen, die sich einmischen und sich vernehmbar zu Wort melden. Eine wichtige Voraussetzung dafür ist die politische Bildung. Nur wer politische, gesellschaftliche und wirtschaftliche Zusammenhänge versteht, kann sich ein eigenes Urteil bilden und unsere Gesellschaft mit gestalten. Ich möchte junge Menschen, also auch Euch, für...»

«Fakultät Medien Kröhnert, Nadiné Asiens Wirtschaftskrise von 1997 und die Struktur einer asiatischen Tageszeitungsgruppierung ASIA NEWS NETWORK Hochschule Mittweida University of Applied Sciences Fakultät Medien Kröhnert, Nadiné Asiens Wirtschaftskrise von 1997 und die Struktur einer asiatischen Tageszeitungsgruppierung ASIA NEWS NETWORK -eingereicht als BachelorarbeitHochschule Mittweida University of Applied Sciences Erstprüfer Zweitprüfer Prof. Dr. phil. Otto Altendorfer M.A. Prof....»

«Improving Quality in Business Process Outsourcing through Technology Hongyan Li CORAL, Department of Business Studies, Aarhus School of Business, Aarhus V 8210, Denmark, Hojl@asb.dk Joern Meissner* Department of Management Science, Lancaster University Management School, Lancaster LA1 4YX, UK, joe@meiss.com Sufficient evidence shows that Business Process Outsourcing (BPO) is growing rapidly. Technological and communication advances help realize the wide-spread adoption of BPO, due to their...»

«ASSET OPTIMIZATION SYSTEMS: 5 LESSONS FROM 10 YEARS IN MINING Greg Johnson Schneider Electric Mining, Minerals and Metals Greg1.Johnson@schneider-electric.com ASSET OPTIMIZATION SYSTEMS: 5 LESSONS FROM 10 YEARS IN MINING ABSTRACT Maintenance needs information about assets to optimize availability and production needs information about performance and consumption to maximize output. In considering both these needs together as, “Asset Optimization”, the information systems that support them...»





 
<<  HOME   |    CONTACTS
2016 www.book.dislib.info - Free e-library - Books, dissertations, abstract

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.