Microsoft Dynamics NAV Administration

A quick book and eBook guide to installing, configuring, deploying, and administering Microsoft Dynamics NAV with ease

Microsoft Dynamics NAV Administration

Starting
Amit Sachdev, Sharan Oberoi

A quick book and eBook guide to installing, configuring, deploying, and administering Microsoft Dynamics NAV with ease
$10.00
$36.00
RRP $23.99
RRP $39.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection
Free Sample

Book Details

ISBN 139781847198761
Paperback190 pages

About This Book

  • Install, configure, deploy and administer Dynamics NAV with ease
  • Install Dynamics NAV Classic Client (Dynamics NAV C/SIDE), Dynamics NAV Role Tailored Client (RTC), and Dynamics NAV Classic Database Server on your computer to manage enterprise data
  • Connect Dynamics NAV clients to the Database Server in the earlier versions and also the latest Dynamics NAV 2009 version
  • A step-by-step guide filled with examples to help you to accomplish administrative tasks such as securing and maintaining databases using Dynamics NAV

 

Who This Book Is For

If you want to get started in administering Dynamics NAV, this book is for you. Readers do not need any previous experience with Dynamics NAV.

Table of Contents

Chapter 1: Setting up the Environment for Dynamics NAV
Considerations for deploying Dynamics NAV
Summary
Chapter 2: Installing Dynamics NAV
Installing a Classic client
Installing a C/SIDE database server
Preparing a Microsoft SQL Server database for Dynamics NAV installation
Connecting a Dynamics NAV client (Classic) to the NAV Classic database server
Connecting a Dynamics NAV client (Classic) to a Microsoft SQL Server database
Installing the RoleTailored client for Dynamics NAV
Installing the Dynamics NAV server (the middle-tier component)
Connecting a RoleTailored client to the database
Summary
Chapter 3: Integrating Dynamics NAV with the Microsoft Platform
Integrating Dynamics NAV and the Microsoft Office system
Summary
Chapter 4: Securing Dynamics NAV Applications
Security with SQL Server installation
Dynamics NAV security models
Users, logins, and passwords
Roles and permissions
Sarbanes Oxley compliance
Summary
Chapter 5: Backing up and Restoring a Dynamics NAV Database
Creating and restoring backups using a Dynamics NAV client
Using HotCopy backup
Testing the database
Backing up and restoring with SQL Server
Synchronizing a SQL database
Expanding the database
Things to consider while defining the backup strategy
Summary
Chapter 6: Performance Tuning
Configuring a SQL Server database for Microsoft Dynamics NAV
Writing less expensive C/AL code for customizations
Fine-tuning the SQL Server database for Dynamics NAV
Investigating the performance of the database
Summary
Chapter 7: Setting up Periodic Activities, Stylesheets, and Rapid Implementation Methodology
Job Queue
Managing stylesheets in Dynamics NAV
Rapid Implementation Methodology
Summary
Chapter 8: Updating Objects and Virtualization with Dynamics NAV
Objects in NAV
Virtualization with Dynamics NAV
Summary
Chapter 9: Business Intelligence
Importance of Business Intelligence
Dynamics NAV and Business Intelligence
Reporting capabilities in NAV
Summary

What You Will Learn

  • Understand various user requirements and how Dynamics NAV will fit into your business needs
  • Implement Dynamics NAV on a secure internal company network
  • Define user access policies and Windows network access policies and extend them to the Dynamics NAV security system as well
  • Create and restore backups using Dynamic NAV Classic Client option
  • Implement the RIM (Rapid Implementation Methodology) approach to import and set up data in a simple and easy way by using predefined templates and questionnaires
  • Use Job Queue to set up periodic jobs that run automatically at the scheduled time
  • Attain flexibility by modifying existing sets of objects—tables, reports, codeunits, forms, pages, dataports, and XMLports
  • Implement virtualization in Dynamics NAV on Windows Server 2003 SP2, Windows Server 2008, and Windows Server 2008 R2

In Detail

Microsoft Dynamics NAV is an Enterprise Resource Planning (ERP) software product that integrates financial, manufacturing, supply chain management, sales and marketing, project management, human resources, and services management information from across your organization, into a centralized database. It can take hours to browse through documentation and references available online to learn how to install, configure, deploy and administer Dynamics NAV. This book aims to offer quick-start information in one place.

You will be amazed to find out how easily you can administer Dynamics NAV using this quick step-by-step guide. This book also has recommendations for software and hardware requirements including operating system considerations and hardware considerations for administering Dynamics NAV to your advantage. It covers some advanced functions to set up periodic activities, common batch jobs, and create object files. It will also guide you to secure your database by creating backups and improving performance with practical examples.

First you will look at the considerations for deploying Dynamics NAV and best practices and the most important aspects of every ERP installation. Then you will install Dynamics NAV—client and server components and use Dynamics NAV with the Microsoft Stack.

We discuss the Dynamics NAV Security Architecture including security recommendations and best practices. You will then create and restore backups. This book covers some recommendations about performance tuning—using appropriate code syntax, proper hardware sizing, and considerations for writing customized C/AL code while using SQL Server database.

Finally, you will set up procedures for scheduling pre-defined reoccurring processes, error and exception handling procedures, and provide mechanisms for automatic data processing on the server. Also, you will learn different methods used in handling, promoting to the database, and creating object files—tables, reports, codeunits, forms, pages, dataports and XMLports.

Authors

Table of Contents

Chapter 1: Setting up the Environment for Dynamics NAV
Considerations for deploying Dynamics NAV
Summary
Chapter 2: Installing Dynamics NAV
Installing a Classic client
Installing a C/SIDE database server
Preparing a Microsoft SQL Server database for Dynamics NAV installation
Connecting a Dynamics NAV client (Classic) to the NAV Classic database server
Connecting a Dynamics NAV client (Classic) to a Microsoft SQL Server database
Installing the RoleTailored client for Dynamics NAV
Installing the Dynamics NAV server (the middle-tier component)
Connecting a RoleTailored client to the database
Summary
Chapter 3: Integrating Dynamics NAV with the Microsoft Platform
Integrating Dynamics NAV and the Microsoft Office system
Summary
Chapter 4: Securing Dynamics NAV Applications
Security with SQL Server installation
Dynamics NAV security models
Users, logins, and passwords
Roles and permissions
Sarbanes Oxley compliance
Summary
Chapter 5: Backing up and Restoring a Dynamics NAV Database
Creating and restoring backups using a Dynamics NAV client
Using HotCopy backup
Testing the database
Backing up and restoring with SQL Server
Synchronizing a SQL database
Expanding the database
Things to consider while defining the backup strategy
Summary
Chapter 6: Performance Tuning
Configuring a SQL Server database for Microsoft Dynamics NAV
Writing less expensive C/AL code for customizations
Fine-tuning the SQL Server database for Dynamics NAV
Investigating the performance of the database
Summary
Chapter 7: Setting up Periodic Activities, Stylesheets, and Rapid Implementation Methodology
Job Queue
Managing stylesheets in Dynamics NAV
Rapid Implementation Methodology
Summary
Chapter 8: Updating Objects and Virtualization with Dynamics NAV
Objects in NAV
Virtualization with Dynamics NAV
Summary
Chapter 9: Business Intelligence
Importance of Business Intelligence
Dynamics NAV and Business Intelligence
Reporting capabilities in NAV
Summary

Book Details

ISBN 139781847198761
Paperback190 pages
Read More