Implementing Microsoft Dynamics NAV - Third Edition电子书

Implementing Microsoft Dynamics NAV Third Edition

Table of Contents

Implementing Microsoft Dynamics NAV Third Edition

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the color images of this book

Errata

Piracy

Questions

1. Exploring Microsoft Dynamics NAV – An Introduction

Understanding Microsoft Dynamics NAV

The functional areas within Dynamics NAV

History of Dynamics NAV

Functional areas

Financial Management

General Ledger

G/L budgets

Account Schedules

Cash Management

Fixed Assets

VAT reporting and intrastat

Sales tax

Intercompany transactions

Consolidation

Multicurrency

Sales and marketing

Customers

Order processing

Approvals

Pricing

Marketing

Purchase

Vendors

Order processing

Approvals

Pricing

Planning

Warehouse

Items

Locations

Transfer orders

Assembly

Pick and put-away

Inventory

Manufacturing

Product design

Capacities

Planning

Execution

Costing

Subcontracting

Job

Job card

Phases and tasks

Planning

Time sheet

Invoice jobs

Work in process (WIP)

Resource planning

Resource card

Pricing

Service

Service items

Contracts

Price management

Service orders

Service tasks

Fault reporting

Human resources

Employees

Absence registration

Country localizations

Vertical and horizontal solutions

Accessing Dynamics NAV

Windows client

Web client

Tablet client

SharePoint client

Web Services

Development Environment

Summary

2. What's New in NAV 2016?

Application changes

Improvements for the application users

Cues with color indicator

Mandatory fields

Simplified user interface for small businesses

Tablet client

New application features

Automatic payment and bank reconciliation

Signing up for the Bank Data Conversion Service

Reconciling payments automatically

Reconciling bank statements automatically

Social Listening

Power Business Intelligence

RapidStart services

Schedule reports

E-mailing documents

Document exchange service (OCR Services)

Exchange rates update

Native integration with Dynamics CRM

Universal app

Workflow management

Posting Preview

Deferrals

Development changes

Document reporting

Upgrade automation – an overview

Upgrade automation – the application code

Upgrade automation – data

Enhancement in security and encryption

Changes to C/AL functions, data types, properties, and triggers

.NET interoperability

Enhancements in RoleTailored client control add-ins

IT changes

Dynamics NAV Server administration

Windows PowerShell cmdlets

Summary

3. Dynamics NAV – General Considerations

The data model

Master data

Documents

Journals

Entries

Creating ledger entries

Combining all concepts

No save button

The main advantage

When is the data verified?

The main drawback

The posting routines

Posted data cannot be modified (or deleted)

Navigating through your data

The Navigate functionality

Other ways to browse data

Sorting on list pages

Filtering for the data you need

Saving views for the filters you've set

Real-time data gathering – the SIFT technology

Everything leads to accounting

The Dynamics NAV database

The TableRelation property

Coded data rules

Summary

4. The Implementation Process – From the Reseller

What is an implementation?

Methodology

The Waterfall approach

The Agile approach

Using the best of both

Microsoft Dynamics Sure Step

Project types based on the Waterfall approach

The Rapid project type

The Standard project type

The Enterprise project type

The Upgrade project type

The Agile project type

Roles

Salesperson

Project manager

Business consultant

Key users

Analyst

Developer

Implementer

End users

Summarizing the roles

Phases

Presales

Getting the project requirements

Designing the solution

Configuration

Modifying standard Dynamics NAV functionality

New functionalities

Data migration

Development

Deployment

Software and hardware installation

Configuration

Data migration

User-acceptance test

End users' training

Go-live!

Post Implementation Support

Summary

5. The Implementation Process on the Customer Side

Definition of goals

Measuring goals

Defining the internal processes

Questions to be asked

Improve before automating

Getting the requirements

Change management

Get involved in testing the system

Involve end users

Summary

6. Migrating Data

Tools to migrate data

RapidStart Services

Creating a new company using PowerShell

Changing the profile to RapidStart Services Implementer

Using the configuration wizard

Creating a data conversion package

Creating a configuration package

Applying a configuration package

Configuration worksheet

Creating the migration structure

Copying related tables

Using Excel templates

Configuration templates

Creating a configuration template

Using configuration templates

Configuration questionnaire

Creating a configuration questionnaire

Completing the configuration questionnaire

Summarizing RapidStart Services

Using XMLports to migrate data

The XMLport structure

Running the XMLport

Writing code inside the XMLport

The document structure

Filling data not included in the XML file

Validation order may change our data

Writing your own tools

Converting data from the old system to Dynamics NAV's needs

Fields particular to Microsoft Dynamics NAV

Master data

Open entries

Customer entries

Vendor entries

Bank entries

Item entries

Fixed-asset entries

General Ledger balances

Historical data

Open documents

Choosing a go-live date

Going live at the beginning of the fiscal year

What cons do we have?

Going live in the middle of a fiscal year

Summary

7. Upgrading Microsoft Dynamics NAV

Upgrading philosophy

Upgrades prior to Dynamics NAV 2013

Upgrades from Dynamics NAV 2013 forward

Upgrading process checklist

Upgrading from 2013, 2013 R2, or 2015

Technical upgrade (converting the database)

Connecting the Dynamics NAV Server

Application code upgrade

Merging the code

Importing the merged code

Upgrading the application data

Automating upgrading using PowerShell

Upgrading from 2009, 2009 SP1, or 2009 R2

Upgrading the 2009 application code

Upgrading the 2009 data

Upgrading from 5.0 or 5.0 SP1

Upgrading the 5.0 application code

Upgrading the 5.0 data

Upgrading from 4.0, 4.0 SP1, 4.0 SP2, or 4.0 SP3

Upgrading the 4.0 application code

Upgrading the 4.0 data

Upgrading from 3.60 or 3.70

Upgrading the 3.60 or 3.70 application code

Upgrading the 3.60 or 3.70 data

Upgrading steps to NAV 2013

Preparing to upgrade

Migrating to SQL Server

Testing the database

Upgrading the application code

Getting object versions

Converting objects to the Dynamics NAV 2013 format

Carrying out customizations to the new version

Transforming forms to pages

Transforming reports

Upgrading the data

Upgrading tools

Upgrade toolkit

Text format upgrade

Form transformation

Report transformation

Upgrading hybrid reports

Upgrading classic reports

Comparing text tools

MergeTool

Downloading MergeTool

Installing MergeTool

Using MergeTool

Importing the old base version

Importing the old custom version

Importing the new base version

Comparing the old base and new base versions

Merging all versions

Exporting the new custom version

Importing the new custom version to a Dynamics NAV 2013 database

Summary

8. Development Considerations

Setup versus customization

Data model principles

Basic objects

Object elements

How tables are structured

Understanding table structures

Master tables

Secondary tables

Setup tables

Document tables

Entry tables

Journal tables

The final picture

The structure of pages

Understanding page structures

Role center pages

Card pages

List pages

Document pages

ListPart pages

Worksheet pages

ConfirmationDialog pages

NavigatePage pages

The posting process

The codeunit structure for sales posting

The codeunit structure for General Journal posting

Where to write customized code

Validating fields

Batch jobs

Formatting customized code

Summary

9. Functional Changes on Existing Implementations

General guidelines

What is a functional change?

The Requisition Worksheet

Fixed Assets

Item Tracking

Extending a customized functionality

Interactions with other functionalities

The Requisition Worksheet

Fixed Assets

Item Tracking

Creating a new item

Creating and posting a purchase order for the new item

Creating and posting a sales order for the new item

Turning on Item Tracking for the new item

Extending a customized functionality

Writing a to-do list to implement a change

The Requisition Worksheet

Fixed Assets

Item Tracking

Extending a customized functionality

Choosing the right time

The Requisition Worksheet

Fixed Assets

Item Tracking

Extending a customized functionality

Planning the change

The Requisition Worksheet

Fixed Assets

Item Tracking

Extending a customized functionality

Summary

10. Data Analysis and Reporting

Using filters and FlowFilters

Creating views

Statistics

Charts

The Show as Chart option

Adding charts to the Role Center page

Creating and configuring charts

Using reports

Finding reports

Running reports

Types of reports

List reports

Test reports

Posting reports

Transaction reports

Document reports

Report selection

Other reports

Account schedules

Analysis views

Understanding dimensions

Setting up new dimensions

Categorizing dimensions

Accessing dimensions

Creating an analysis view

Updating analysis views

Using analysis views

Analysis by dimensions

Analysis views as a source for account schedules

Extracting data

Sending data to Microsoft Office applications

Sending data to Microsoft Word

Sending data to Microsoft Excel

Extracting data through web services

Other ways to extract Dynamics NAV data

Understanding report development

Reports anatomy

Defining the dataset

Designing the visual layout

Summary

11. Debugging

The art of debugging

Debugging in Dynamics NAV 2016

Break Rules

Placing breakpoints

From the Object Designer

In the current statement of the debugger

Conditional breakpoint

Debugger Breakpoint List

Line-by-line execution

The Step Into option

The Step Over option

The Step Out option

The Continue option

The Call Stack FactBox

The Watches FactBox

Adding variables from the Debugger Variables List window

Adding variables from the code viewer

Summary

12. Popular Reporting Options with Microsoft Dynamics NAV

What is a query?

Query Designer

Defining our first query

Adding additional data to the query

Charts

Web services

External applications

Excel and PowerPivot

Power BI

Jet Reports Express

Downloading Jet Reports Express

Installing Jet Reports Express

Report pack for Jet Reports Express

Summary

Index