You are previewing Implementing Microsoft Dynamics NAV - Third Edition.
O'Reilly logo
Implementing Microsoft Dynamics NAV - Third Edition

Book Description

Explore the capabilities of Dynamics NAV 2016 and discover all you need to implement it

About This Book

  • Learn the key roles of your Dynamics NAV partner and the roles within your customer’s organization

  • Create configuration packages and perform data migration on your own

  • Find out how to troubleshoot your problems effectively with your Dynamics NAV partner

  • Who This Book Is For

    This book is for Dynamics NAV partners and end users who want to know everything about Dynamics NAV implementations. It is aimed at those who want to be project managers or get involved with Dynamics NAV, but do not have the expertise to write code themselves.

    What You Will Learn

  • Study the roles within a Dynamics NAV partner and within a customer’s company

  • Create reusable data migration packages

  • Work with the debugger to pinpoint error messages

  • Get to grips with the key tables used in data reporting and analysis

  • Successfully upgrade your installation to the latest version

  • Manage and expand your existing installation with additional functionalities

  • Explore the free third-party add-ons that can leverage your existing installation

  • In Detail

    Microsoft Dynamics NAV 2016 is an Enterprise Resource Planning (ERP) application used in all kinds of organizations around the world. It provides a great variety of functionality out-of-the-box in different topics such as accounting, sales, purchase processing, logistics, or manufacturing. It also allows companies to grow the application by customizing the solution to meet specific requirements.

    This book is a hands-on tutorial on working with a real Dynamics NAV implementation. You will learn about the team from your Microsoft Dynamics NAV partner as well as the team within the customer’s company. This book provides an insight into the different tools available to migrate data from the client’s legacy system into Microsoft Dynamics NAV.

    If you are already live with Microsoft Dynamics NAV, this books talks about upgrades and what to expect from them. We’ll also show you how to implement additional or expanding functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, debug error messages, and implement free third-party add-ons to your existing installation.

    This book will empower you with all the skills and knowledge you need for a successful implementation.

    Style and approach

    This book is step-by-step guide to implementing Dynamics NAV from start to finish.

    Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

    Table of Contents

    1. Implementing Microsoft Dynamics NAV Third Edition
      1. Table of Contents
      2. Implementing Microsoft Dynamics NAV Third Edition
      3. Credits
      4. About the Authors
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers, and more
          1. Why subscribe?
          2. Instant updates on new Packt books
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the color images of this book
          2. Errata
          3. Piracy
          4. Questions
      8. 1. Exploring Microsoft Dynamics NAV – An Introduction
        1. Understanding Microsoft Dynamics NAV
        2. The functional areas within Dynamics NAV
        3. History of Dynamics NAV
        4. Functional areas
          1. Financial Management
            1. General Ledger
            2. G/L budgets
            3. Account Schedules
            4. Cash Management
            5. Fixed Assets
            6. VAT reporting and intrastat
            7. Sales tax
            8. Intercompany transactions
            9. Consolidation
            10. Multicurrency
          2. Sales and marketing
            1. Customers
            2. Order processing
            3. Approvals
            4. Pricing
            5. Marketing
          3. Purchase
            1. Vendors
            2. Order processing
          4. Approvals
            1. Pricing
            2. Planning
          5. Warehouse
            1. Items
            2. Locations
            3. Transfer orders
            4. Assembly
            5. Pick and put-away
            6. Inventory
          6. Manufacturing
            1. Product design
            2. Capacities
            3. Planning
            4. Execution
            5. Costing
            6. Subcontracting
          7. Job
            1. Job card
            2. Phases and tasks
            3. Planning
            4. Time sheet
            5. Invoice jobs
            6. Work in process (WIP)
          8. Resource planning
            1. Resource card
            2. Pricing
          9. Service
            1. Service items
            2. Contracts
            3. Price management
            4. Service orders
            5. Service tasks
            6. Fault reporting
          10. Human resources
            1. Employees
            2. Absence registration
            3. Country localizations
          11. Vertical and horizontal solutions
        5. Accessing Dynamics NAV
          1. Windows client
          2. Web client
          3. Tablet client
          4. SharePoint client
          5. Web Services
          6. Development Environment
        6. Summary
      9. 2. What's New in NAV 2016?
        1. Application changes
          1. Improvements for the application users
            1. Cues with color indicator
            2. Mandatory fields
            3. Simplified user interface for small businesses
          2. Tablet client
          3. New application features
            1. Automatic payment and bank reconciliation
            2. Signing up for the Bank Data Conversion Service
            3. Reconciling payments automatically
            4. Reconciling bank statements automatically
            5. Social Listening
            6. Power Business Intelligence
            7. RapidStart services
            8. Schedule reports
            9. E-mailing documents
            10. Document exchange service (OCR Services)
            11. Exchange rates update
            12. Native integration with Dynamics CRM
            13. Universal app
            14. Workflow management
            15. Posting Preview
            16. Deferrals
        2. Development changes
          1. Document reporting
          2. Upgrade automation – an overview
            1. Upgrade automation – the application code
            2. Upgrade automation – data
          3. Enhancement in security and encryption
            1. Changes to C/AL functions, data types, properties, and triggers
            2. .NET interoperability
            3. Enhancements in RoleTailored client control add-ins
        3. IT changes
          1. Dynamics NAV Server administration
          2. Windows PowerShell cmdlets
        4. Summary
      10. 3. Dynamics NAV – General Considerations
        1. The data model
          1. Master data
          2. Documents
          3. Journals
          4. Entries
            1. Creating ledger entries
          5. Combining all concepts
        2. No save button
          1. The main advantage
          2. When is the data verified?
          3. The main drawback
        3. The posting routines
          1. Posted data cannot be modified (or deleted)
        4. Navigating through your data
          1. The Navigate functionality
          2. Other ways to browse data
          3. Sorting on list pages
          4. Filtering for the data you need
          5. Saving views for the filters you've set
        5. Real-time data gathering – the SIFT technology
        6. Everything leads to accounting
        7. The Dynamics NAV database
          1. The TableRelation property
          2. Coded data rules
        8. Summary
      11. 4. The Implementation Process – From the Reseller
        1. What is an implementation?
        2. Methodology
          1. The Waterfall approach
          2. The Agile approach
          3. Using the best of both
          4. Microsoft Dynamics Sure Step
            1. Project types based on the Waterfall approach
              1. The Rapid project type
              2. The Standard project type
              3. The Enterprise project type
              4. The Upgrade project type
            2. The Agile project type
        3. Roles
          1. Salesperson
          2. Project manager
          3. Business consultant
          4. Key users
          5. Analyst
          6. Developer
          7. Implementer
          8. End users
          9. Summarizing the roles
        4. Phases
          1. Presales
          2. Getting the project requirements
          3. Designing the solution
            1. Configuration
            2. Modifying standard Dynamics NAV functionality
            3. New functionalities
            4. Data migration
          4. Development
          5. Deployment
            1. Software and hardware installation
            2. Configuration
            3. Data migration
            4. User-acceptance test
            5. End users' training
            6. Go-live!
          6. Post Implementation Support
        5. Summary
      12. 5. The Implementation Process on the Customer Side
        1. Definition of goals
        2. Measuring goals
        3. Defining the internal processes
          1. Questions to be asked
        4. Improve before automating
        5. Getting the requirements
        6. Change management
        7. Get involved in testing the system
        8. Involve end users
        9. Summary
      13. 6. Migrating Data
        1. Tools to migrate data
          1. RapidStart Services
            1. Creating a new company using PowerShell
            2. Changing the profile to RapidStart Services Implementer
            3. Using the configuration wizard
            4. Creating a data conversion package
              1. Creating a configuration package
              2. Applying a configuration package
            5. Configuration worksheet
              1. Creating the migration structure
              2. Copying related tables
            6. Using Excel templates
            7. Configuration templates
              1. Creating a configuration template
              2. Using configuration templates
            8. Configuration questionnaire
              1. Creating a configuration questionnaire
              2. Completing the configuration questionnaire
            9. Summarizing RapidStart Services
          2. Using XMLports to migrate data
            1. The XMLport structure
            2. Running the XMLport
            3. Writing code inside the XMLport
              1. The document structure
              2. Filling data not included in the XML file
              3. Validation order may change our data
          3. Writing your own tools
        2. Converting data from the old system to Dynamics NAV's needs
          1. Fields particular to Microsoft Dynamics NAV
        3. Master data
        4. Open entries
          1. Customer entries
          2. Vendor entries
          3. Bank entries
          4. Item entries
          5. Fixed-asset entries
          6. General Ledger balances
        5. Historical data
        6. Open documents
        7. Choosing a go-live date
          1. Going live at the beginning of the fiscal year
            1. What cons do we have?
          2. Going live in the middle of a fiscal year
        8. Summary
      14. 7. Upgrading Microsoft Dynamics NAV
        1. Upgrading philosophy
        2. Upgrades prior to Dynamics NAV 2013
        3. Upgrades from Dynamics NAV 2013 forward
        4. Upgrading process checklist
          1. Upgrading from 2013, 2013 R2, or 2015
            1. Technical upgrade (converting the database)
              1. Connecting the Dynamics NAV Server
              2. Application code upgrade
              3. Merging the code
              4. Importing the merged code
              5. Upgrading the application data
              6. Automating upgrading using PowerShell
          2. Upgrading from 2009, 2009 SP1, or 2009 R2
            1. Upgrading the 2009 application code
            2. Upgrading the 2009 data
          3. Upgrading from 5.0 or 5.0 SP1
            1. Upgrading the 5.0 application code
            2. Upgrading the 5.0 data
          4. Upgrading from 4.0, 4.0 SP1, 4.0 SP2, or 4.0 SP3
            1. Upgrading the 4.0 application code
            2. Upgrading the 4.0 data
          5. Upgrading from 3.60 or 3.70
            1. Upgrading the 3.60 or 3.70 application code
            2. Upgrading the 3.60 or 3.70 data
        5. Upgrading steps to NAV 2013
          1. Preparing to upgrade
            1. Migrating to SQL Server
            2. Testing the database
          2. Upgrading the application code
            1. Getting object versions
            2. Converting objects to the Dynamics NAV 2013 format
            3. Carrying out customizations to the new version
            4. Transforming forms to pages
            5. Transforming reports
          3. Upgrading the data
        6. Upgrading tools
          1. Upgrade toolkit
          2. Text format upgrade
          3. Form transformation
          4. Report transformation
            1. Upgrading hybrid reports
            2. Upgrading classic reports
          5. Comparing text tools
          6. MergeTool
            1. Downloading MergeTool
            2. Installing MergeTool
            3. Using MergeTool
              1. Importing the old base version
              2. Importing the old custom version
              3. Importing the new base version
              4. Comparing the old base and new base versions
              5. Merging all versions
              6. Exporting the new custom version
              7. Importing the new custom version to a Dynamics NAV 2013 database
        7. Summary
      15. 8. Development Considerations
        1. Setup versus customization
        2. Data model principles
          1. Basic objects
            1. Object elements
          2. How tables are structured
            1. Understanding table structures
              1. Master tables
              2. Secondary tables
              3. Setup tables
              4. Document tables
              5. Entry tables
              6. Journal tables
            2. The final picture
          3. The structure of pages
            1. Understanding page structures
              1. Role center pages
              2. Card pages
              3. List pages
              4. Document pages
              5. ListPart pages
              6. Worksheet pages
              7. ConfirmationDialog pages
              8. NavigatePage pages
        3. The posting process
          1. The codeunit structure for sales posting
          2. The codeunit structure for General Journal posting
        4. Where to write customized code
          1. Validating fields
          2. Batch jobs
        5. Formatting customized code
        6. Summary
      16. 9. Functional Changes on Existing Implementations
        1. General guidelines
        2. What is a functional change?
          1. The Requisition Worksheet
          2. Fixed Assets
          3. Item Tracking
          4. Extending a customized functionality
        3. Interactions with other functionalities
          1. The Requisition Worksheet
          2. Fixed Assets
          3. Item Tracking
            1. Creating a new item
            2. Creating and posting a purchase order for the new item
            3. Creating and posting a sales order for the new item
            4. Turning on Item Tracking for the new item
          4. Extending a customized functionality
        4. Writing a to-do list to implement a change
          1. The Requisition Worksheet
          2. Fixed Assets
          3. Item Tracking
          4. Extending a customized functionality
        5. Choosing the right time
          1. The Requisition Worksheet
          2. Fixed Assets
          3. Item Tracking
          4. Extending a customized functionality
        6. Planning the change
          1. The Requisition Worksheet
          2. Fixed Assets
          3. Item Tracking
          4. Extending a customized functionality
        7. Summary
      17. 10. Data Analysis and Reporting
        1. Using filters and FlowFilters
        2. Creating views
        3. Statistics
        4. Charts
          1. The Show as Chart option
          2. Adding charts to the Role Center page
          3. Creating and configuring charts
        5. Using reports
          1. Finding reports
          2. Running reports
          3. Types of reports
            1. List reports
            2. Test reports
            3. Posting reports
            4. Transaction reports
            5. Document reports
              1. Report selection
            6. Other reports
        6. Account schedules
        7. Analysis views
          1. Understanding dimensions
            1. Setting up new dimensions
            2. Categorizing dimensions
            3. Accessing dimensions
          2. Creating an analysis view
          3. Updating analysis views
          4. Using analysis views
            1. Analysis by dimensions
            2. Analysis views as a source for account schedules
        8. Extracting data
          1. Sending data to Microsoft Office applications
            1. Sending data to Microsoft Word
            2. Sending data to Microsoft Excel
          2. Extracting data through web services
          3. Other ways to extract Dynamics NAV data
        9. Understanding report development
          1. Reports anatomy
          2. Defining the dataset
          3. Designing the visual layout
        10. Summary
      18. 11. Debugging
        1. The art of debugging
        2. Debugging in Dynamics NAV 2016
          1. Break Rules
        3. Placing breakpoints
          1. From the Object Designer
          2. In the current statement of the debugger
          3. Conditional breakpoint
          4. Debugger Breakpoint List
        4. Line-by-line execution
          1. The Step Into option
          2. The Step Over option
          3. The Step Out option
          4. The Continue option
        5. The Call Stack FactBox
        6. The Watches FactBox
          1. Adding variables from the Debugger Variables List window
          2. Adding variables from the code viewer
        7. Summary
      19. 12. Popular Reporting Options with Microsoft Dynamics NAV
        1. What is a query?
        2. Query Designer
          1. Defining our first query
          2. Adding additional data to the query
        3. Charts
        4. Web services
          1. External applications
            1. Excel and PowerPivot
        5. Power BI
        6. Jet Reports Express
          1. Downloading Jet Reports Express
          2. Installing Jet Reports Express
          3. Report pack for Jet Reports Express
        7. Summary
      20. Index