You are previewing Implementing Microsoft Dynamics NAV 2013.
O'Reilly logo
Implementing Microsoft Dynamics NAV 2013

Book Description

Get to grips with the full capabilities of Dynamics NAV through this step-by-step guide to implementing the powerful Enterprise Resource Planning application. For newcomers and seasoned users alike, it’s an essential companion.

  • Successfully handle your first Dynamics NAV 2013 implementation

  • Explore the new features that will help you provide more value to your customers

  • Full of illustrations and diagrams with clear step-by-step instructions and real-world tips extracted from years of experience

  • In Detail

    Microsoft Dynamics NAV 2013 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 and purchases processing, logistics, or manufacturing. But it also allows companies to grow the application by customizing the solution to meet specific requirements.

    "Implementing Microsoft Dynamics NAV 2013" explains all you need to know to successfully handle your first Dynamics NAV 2013 implementation. You will learn what the application can do out of the box, how you can extend it to meet any kind of requirements, and how to manage real implementation projects with real customers.

    This book does not only cover typical topics when implementing the new version of an ERP system; topics that are not found in any previous documentation of Dynamics NAV, such as the implementation process at the customer side, or implementing functional changes on existing Dynamics NAV implementations are included in here. This approach makes this book different.

    After reading "Implementing Dynamics NAV 2013" you will be empowered with the skills and knowledge you need for successful implementations.

    Table of Contents

    1. Implementing Microsoft Dynamics NAV 2013
      1. Table of Contents
      2. Implementing Microsoft Dynamics NAV 2013
      3. Credits
      4. About the Authors
      5. Acknowledgement
      6. Acknowledgement
      7. About the Reviewers
      8. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
        2. Why Subscribe?
        3. Free Access for Packt account holders
        4. Instant Updates on New Packt Books
      9. 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. Errata
          2. Piracy
          3. Questions
      10. 1. Introducing Microsoft Dynamics NAV 2013
        1. Understanding Microsoft Dynamics NAV
        2. History of Dynamics NAV
        3. Functional areas
          1. Financial Management
            1. Accountancy
            2. G/L budgets
            3. Account schedules
            4. Cash management
            5. Fixed Assets
            6. VAT reporting and intrastat
            7. Intercompany transactions
            8. Consolidation
            9. Multicurrency
          2. Sales & Marketing
            1. Customers
            2. Order processing
            3. Approvals
            4. Pricing
            5. Marketing
          3. Purchase
            1. Vendors
            2. Order processing
            3. Approvals
            4. Pricing
            5. Planning
          4. Warehouse
            1. Items
            2. Locations
            3. Transfer orders
            4. Assembly
            5. Pick and put-away
            6. Inventory
          5. Manufacturing
            1. Product design
            2. Capacities
            3. Planning
            4. Execution
            5. Costing
            6. Subcontracting
          6. Job
            1. Job card
            2. Phases and tasks
            3. Planning
            4. Time sheet
            5. Invoice jobs
            6. Work in process (WIP)
          7. Resource planning
            1. Resource card
            2. Pricing
          8. Service
            1. Service items
            2. Contracts
            3. Price management
            4. Service orders
            5. Service tasks
            6. Fault reporting
          9. Human resources
            1. Employees
            2. Absence registration
            3. Country localizations
          10. Vertical and horizontal solutions
        4. Access Dynamics NAV
          1. Windows client
          2. Web client
          3. SharePoint client
          4. Web Services
          5. Development environment
        5. Summary
      11. 2. What's New in NAV 2013
        1. Application changes
          1. Improvements to the Windows client
            1. Ribbon
            2. Select all
            3. Copy/paste rows
            4. Quick Entry
            5. New keyboard shortcuts
            6. Business Intelligence and KPIs
            7. User collaboration tools
          2. Application features
            1. Financial Management
              1. Cash flow
              2. Cost accounting
              3. VAT Rate Change Tool
              4. VAT Reports
            2. Assembly management
              1. Assembly items
              2. Assembly orders
            3. Warehouse management
            4. Inventory
            5. Supply planning
              1. New planning parameters
              2. Order modifiers
              3. Setup best practices
            6. Jobs
            7. Resources
            8. RapidStart Services
            9. CRM integration
            10. Payment services
        2. Development changes
          1. Development Environment
            1. Debugging
            2. Page development
            3. Page testing
            4. Report development
            5. Query development
            6. XMLport development
            7. Start ID Offset
            8. Changes to C/AL functions, data types, properties, and triggers
            9. .NET interoperability
            10. Enhancements in RoleTailored client control add-ins
          2. Standard C/AL code redesign
            1. G/L Entry table locking redesign
            2. Storing dimension entries
              1. Dimension sets
              2. Dimension set entries
              3. Performance improvement
            3. ADCS
        3. IT changes
          1. Installation
          2. Dynamics NAV Server Administration
          3. Windows PowerShell 2.0 cmdlets
          4. Web client
          5. Portal Framework for SharePoint 2010
          6. User and credential types
          7. NAS services
          8. OData web services
          9. Database changes
          10. Unicode
          11. ClickOnce
        4. Deprecated features
          1. Deprecated application features
          2. Deprecated developer and IT features
        5. Summary
      12. 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 data checked
          3. The main contra
        3. The posting routines
          1. Checking the posting routine with an example
          2. Posted data cannot be modified (or deleted)
        4. Navigating through your data
          1. The Navigate functionality
          2. Other ways to navigate
          3. Filtering to find the data you need
        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
      13. 4. The Implementation Process
        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. Support
        5. Summary
      14. 5. The Implementation Process on the Customer Side
        1. Definition of goals
        2. Defining the internal processes
          1. Questions to be asked
        3. Improve before automating
        4. Getting the requirements
        5. Change management
        6. Get involved in testing the system
        7. Involve end users
        8. Summary
      15. 6. Migrating Data
        1. Tools to migrate data
          1. RapidStart Services
            1. Configuration wizard
            2. Configuration packages
              1. Creating a configuration package
              2. Applying a configuration package

            3. Configuration worksheet
              1. Creating the migration structure
              2. Migrating your data
            4. Configuration templates
              1. Creating a configuration template
              2. Using configuration templates
            5. Configuration questionnaire
              1. Creating a configuration questionnaire
              2. Completing the configuration questionnaire
            6. Summary of 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 suit Dynamics NAV's needs
        3. Master data
        4. Open entries
          1. Customer entries
          2. Vendor entries
          3. Bank entries
          4. Item entries
          5. Fixed-asset entries
          6. Accounting balances
        5. Historical data
        6. Open documents
        7. Choosing a go-live date
          1. Going live at the beginning of the fiscal year
          2. Going live in the middle of a fiscal year
        8. Summary
      16. 7. Upgrading to Microsoft Dynamics NAV 2013
        1. Upgrading philosophy
        2. Upgrading process checklist
          1. Preparing to upgrade
          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
        3. Upgrading steps in detail
          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
            6. Revising and modifying customized code
          3. Upgrading the data
        4. 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
        5. Summary
      17. 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
            2. The final picture
        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. Checking data
          3. Batch jobs
        5. How to write customized code
          1. Language
          2. Spacing and alignment
          3. Comments
          4. Text constants

          5. C/AL statements
          6. Naming conventions
            1. Naming objects
              1. Table objects
              2. Page objects
              3. Report objects
              4. Table fields
              5. Codeunit objects
              6. Variables
              7. User-defined functions
          7. Using small functions
        6. Summary
      18. 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
            5. Undoing the Sales Shipment posted 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
      19. 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
          4. Rules for flattening data
          5. Report design guidelines
        10. Summary
      20. 11. Debugging
        1. The art of debugging
        2. Debugging in Dynamics NAV 2013
          1. Starting the debugger
          2. Break Rules
          3. Placing breakpoints
            1. From the Object Designer
            2. In the current statement of the debugger
            3. Conditional breakpoint
            4. The 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. Watch variables
            1. Adding variables from the Debugger Variables List window
            2. Adding variables from the code viewer
        3. Code Coverage
          1. Importing the Code Coverage objects
          2. How to use the Code Coverage feature
          3. When to use the Code Coverage feature
        4. Summary
      21. 12. The Query Object
        1. What is a query
        2. Query Designer
          1. Defining our first query
            1. Adding complexity to the query
          2. The DataItemLinkType property
        3. Where to use queries
          1. C/AL code
          2. Charts
          3. Web services
          4. External applications
            1. Excel and PowerPivot
        4. Query performance
        5. Summary
      22. 13. Applications Included in Dynamics NAV
        1. Jet Reports Express
          1. Downloading Jet Reports Express
          2. Installing Jet Reports Express
            1. Installing Jet Reports Express on client machines
            2. Installing Jet Reports Express on Dynamics NAV 2013
          3. Configuring Jet Reports Express
          4. Creating your first Jet Reports Express report
            1. Adding filters
          5. Analyzing the data
          6. Using Jet Reports to retrieve data
        2. Zetadocs Express
          1. Installing the Zetadocs client
          2. Adding Zetadocs SharePoint Extensions
          3. Importing NAV objects into Microsoft Dynamics NAV
          4. Configuring Zetadocs in Dynamics NAV
          5. Installing the Zetadocs help files
        3. Summary
      23. Index