Dynamics NAV Training Curriculum

NAV Introduction

Getting Started

• Navigate through Application Windows
• Enter Information
• Edit Information
• Functionality of Menu, Tool and Command Bars
• Accessing 'Help'

Technology

• Overview of Development Environment
• Setting up Server options including Application Server
• Multi language setup

Order Processing - Purchases, Payables, and General Ledger

• Vendor Setup
• Item Setup
• Create a Purchase Order
• Create a Purchase Invoice
• Posting
• Processing Payables
• General ledger entries and adjustments

Order Processing - Sales and Receivables

• Sales Order Processing
• Customer Setup
• Create Sales Quote
• Review Item Ledger Postings
• Receivable Processing
• Review payment receipt postings
  

Finance - Reporting

• Chart of Accounts Reporting
• Standard Finance Reports
• Account Schedules
• Analysis View
• Analysis by Dimensions
• Business Analytics

Manufacturing

• Items and Item cards
• Bill of Material
• Routing
• Calculate Standard Costs
• Production Order

Other Functional Areas

• Marketing
• Resource Planning
• Service Management
• Human Resources
• Business Notification
• eCommerce

What's New in 2009

Financials

• Excel Integration
• Deposits
• Standard Journal and Reversing
• Payment Tolerances
• Analysis by Dimensions
• Bank Reconciliation
• Consolidation
• Intercompany

Inventory

• Kitting
• Record links
• Phys. Inventory Journal - Cycle Count
• Item Tracing

Analysis and Reporting

• Item Budget, Costs
• Item Budget, Sales
• Inventory Analysis Report
• Sales Analysis Report
• Inventory Analysis by Dimensions
• Inventory Periods
• Application Worksheet
• Reconciliation to G/L

Purchasing

• Information panes
• Purchase History
• Prepayments
• Archiving
• Approvals

Sales

• Style Sheets
• Information Panes
• Order Promising
• Return Order Management
• Credit Management
• Customer Order Status

Manufacturing

• Planning Worksheet
• Production Journal
• Gantt chart

Jobs

• Job Budget
• Task Lines
• Other Features

Resources and Jobs

Introduction

• Resources and Jobs Features and Benefits
• Resources and Jobs Ledger Overview and Roadmap
• Integration

Resources

• Resources Overview
• Resource Card
• Resources Prices and Costs
• Changing Resource Prices and Costs
• Resource Groups
• Resource Planning
• Resource Capacity
• Allocating Resource Capacity to Jobs
• Resource Availability
• Resource Journals

Jobs

• Jobs - What are they in Microsoft Navision
• Job Card
• Job Posting Groups
• Job Budgets
• Creation of Job Budgets
• Changes to Budgets
• Copying of Budgets
• Recording Job Costs
• Recording of Job Sales - Invoices
• Recognition of Job WIP
• Recognition of Job Costs and Revenues
• Posting of Job WIP to G/L

Conclusion

• Resources - what are they and how do we use them
• Setting Up Resource Prices and Costs
• Resource Planning
• Resource Capacity
• Resource Availability
• Resource Journals
• Jobs - what are they and how do we use them
• Job Budgets
• Recording Job Costs

Financials I

Posting Groups

• Specific Posting Groups
• General Posting Groups
• General Posting Setup
• Tax Posting Groups
• Determining Posting Groups
• Posting Transactions to the General Ledger

Dimensions Setup

• Dimensions and Dimension Values
• Dimension Combinations
• Default Dimensions
• Default Dimension Priorities
• Mapping Intercompany Dimensions
• Creating Single Default Dimensions
• Creating Dimensions for Use in Documents

VAT and IntraStat

• VAT Setup
• Manual VAT Calculations in Journals
• VAT Calculations in Sales and Purchase Documents
• Import VAT
• VAT Corrections
• VAT Reporting
• VAT Settlement
• Unrealized VAT and Payment Discount VAT Adjustments
• Intrastat Reporting

Journals

• Create a Journal Entry
• Create and Post Recurring Journals
• Working with Recurring Journals Using the Balance Method
• Posting correction Journals

General Ledger

• General Ledger Setup
• The Chart Of Accounts
• Banking
• Budgets

Receivables Management

• Analyzing Receivables
• Applying Customer Ledger Entries
• Applying Customer Ledger Entries in Foreign Currencies
• Unapplying Customer Ledger Entries
• Reversal Of Journal Postings
• Payment Discounts
• Payment Tolerances
• Reminders and Finance Charge Memos

Payables Management

• Payment Journals
• Payment Discounts
• Voiding Checks
• Unapply Vendor Ledger Entries
• Reversal of Vendor Journal Postings

Financials II

Multi-currency Operations

• Updating Currency Exchange Rates for Foreign Currency Balances
• Additional Reporting Currencies

Financial Reporting

• Chart of Accounts Analysis
• Account Schedules
• Annual Closing Operations

XBRL

• XBRL - eXtensible Business Reporting Language
• Importing the Taxonomy
• Entering XBRL Line Definitions
• Exporting the XBRL Lines

Financial Analysis using Dimensions

• Entering Dimensions in Journals and Documents
• Viewing Posted Dimension Information
• Analyzing Financial Information Using Dimensions
• Exporting Analysis Views to Microsoft Excel

Business Analytics

• Overview
• Business Intelligence and Business Analytics
• Terminology associated with Business Analytics
• The Data Configurator
• Data Warehouse
• Setting up the Microsoft Navision Configurator
• Setting up BA Databases
• Creating Virtual Cubes

Multi-Company Operations 1

• Setting up the consolidation company and subsidiaries
• Exporting data for Consolidation (if necessary)
• Testing data to be consolidated
• Consolidating the data
• Processing Consolidation Eliminations

Multi-Company Operations 2

• Consolidated reports
• Setting up the Intercompany Partner
• Assigning an IC Partner to a Customer and/or Vendor
• Setting up the Chart of Accounts for IC Documents
• Setting up Dimensions for IC Documents
• Creating an IC Document
• Sending an IC Document
• Handling an IC Document
• Viewing Handled IC Inbox and Outbox Transactions
• Rejecting an IC document in the IC Inbox
• Returning a Rejected IC document in the IC Outbox to the IC inbox
• Allocating Cost to IC Partners

Trade

Introduction

• About the Microsoft Navision Trade Manual
• Installing Microsoft Navision

Sales Order Management

• Setting up Sales & Receivables
• Processing Blanket Orders
• Processing Sales Orders
• Drop Shipping Orders
• Using Item Reservations
• Shipping Orders
• Handling Sales

Sales Prices and Discounts

• Setting up Prices for a Specific Customer for Specific Items
• Setting up Prices to Target a Specific Customer Segment
• Using the Pricing Mechanism
• Managing Alternative Sales Prices
• Creating Sales Prices for a Campaign
• Working with the Sales Price Worksheet
• Updating Sales Prices
• Updating Sales Prices Using Batch Jobs
• Setting up Line Discounts
• Using the Line Discount Mechanism
• Using the "Best Price" rule
• Creating Sales Line Discounts for a Campaign

Customer Service Features

• Substituting an item for one that is unavailable
• Handling Items with Substitutions
• Setting up Item Cross Reference
• Creating a Sales Order with a Cross Reference
• Handling Items with Cross Reference
• Handling Nonstock Items
• Handling the Sale of a Nonstock Item by Means of Special Order

Purchase Order Management

• Setting up Purchases and Payables
• Managing Purchase Transactions
• Managing Purchase Transactions
• Setting up Alternative Purchase Prices
• Managing Alternative Purchase Prices
• Managing Purchase Line Discounts

Requisition Management

• Calculating a Replenishment Plan
• Using Requisition Worksheet Batch Jobs
• Using Drop Shipment Lines on the Requisition Worksheet
• Calculating a Replenishment Plan from the Requisition Worksheet

Item Charges

• Handling Purchase Item Charges
• Handling Sales Item Charges
• Using Item Charges with Sales Allowances
• Handling Purchase Allowances

Order Promising

• Promising Sales Order Delivery with no Delivery Date Requested
• Promising Sales Order Delivery when Items are not Available for Shipping
• Promising Sales Order Delivery with a Requested Delivery Date
• Promising Sales Order Delivery when a Requested Delivery Date Cannot be Met
• Promising Sales Order Delivery with a Required Shipment Date before the Current Date
• Promising Sales Order Delivery in Other Situations
• Setting up Date Calculations for Purchase Orders
• Estimating Purchase Order Receipt with no Receipt Date Requested
• Estimating Purchase Order Receipt with a Receipt Date Requested
• Estimating Purchase Order Receipt when the Order must have been placed before the Current Date to meet the Requested Receipt Date
• Estimating Purchase Order Receipt in Other Situations
• Estimating Transfer Order Receipts

Returns Management

• Setting up Returns Management
• Managing Returns from Customers
• Registering a Compensation Agreement with the Customer
• Registering a Compensation Agreement when a Returned Item needs to go to the Vendor for Repair
• Processing the Customer Return
• Managing Returns to Vendors
• Registering a Compensation Agreement with the Vendor when a Returned Item needs to go to the Vendor for Repair
• Registering a Compensation Agreement with a Vendor when Items are Damaged during Shipment

Analysis and Reporting

• Customizing Analysis Reports
• Creating Analysis Reports
• Using Customer and Item Groups in Analysis Reports
• Viewing and Presenting Analysis Reports
• Performing Analysis by Dimensions
• Creating a Purchase Budget
• Exporting to and Importing from Excel
• Using Budgets in Analysis Reports

Relationship Management

Relationship Management

• Defining Relationship Management
• Relationship Management Application
• Selling Points for Relationship Management
• Overview the Service Management functionality
• Know about the structure of Service Management

Relationship Management Setup

• The Relationship Management Setup Window
• Automatically Recorded Interactions
• Synchronization with Customers, Vendors, and Bank Accounts
• Duplicate Search
• E-mail Journaling

Contacts

• Setting Up Contacts
• The Contact Card
• Creating Contact Companies
• Creating Contact Persons
• Searching for Contacts
• Searching for Duplicates
• Synchronizing Contacts with Customers, Vendors, and Bank Accounts
• Exporting Contacts
• Contact Statistics
• Contact Reports

Interactions and document management

• Introduction
• Setting Up Interactions
• Using the Create Interaction Wizard
• Phone Calls
• E-Mails
• Automatically Recorded Interactions
• Canceling and Deleting Interaction Log Entries
• Interaction Statistics
• Create an interaction template with an attachment
• Recording interactions
• Making a phone call
• Sending an e-mail
• Creating automatically recorded interactions
• Creating a sales quote and an order for the interaction log

Campaigns and segmentation

• Introduction to Campaigns and Segments
• Setting Up Campaigns
• Creating Campaigns
• Creating Segments
• Creating Interactions for Segments
• Creating Segments by Reusing Logged Segments
• Creating Segments by Reusing Saved Segments
• Campaign Pricing
• Campaign Statistics

Task Management

• Introduction to Task Management
• Setting Up Teams and Activities
• Creating To-dos
• Assigning Activities
• Creating Recurring To-dos
• Modifying To-dos
• Converting Team To-dos
• Sending E-Mail Meeting Invitations
• Closing, Canceling and Deleting To-dos
• Viewing Statistical Information About To-dos

Outlook Integration

• Introduction to Outlook Integration
• Setting Up Outlook Integration
• Synchronizing Contacts and Salespeople in Real-time
• Synchronizing To-dos in Real-time
• Viewing Outlook Items from Navision and Navision Records from Outlook
• Synchronization Batch Jobs
• Conflict Resolution and Error Handling

Opportunity Management

• Introduction to Opportunity Management
• Setting Up Opportunities
• Creating Opportunities
• Updating Opportunities
• Creating To-dos for Opportunities
• Creating Sales Quotes and Orders for Opportunities
• Closing and Deleting Opportunities
• Statistics

Profiling and Classification

• Introduction to Profiling and Classification
• Profile Questionnaires
• Contact Rating
• Entering Contact Profiles
• Creating Segments Using Profile Information
• Updating Profile Questionnaires
• Testing and Printing Questionnaires

The Multilanguage Salutation and Attachment feature

• Introduction
• Creating Salutation Formulas
• Assigning Salutation Code to the Contact
• Creating an Interaction Using Salutation Code
• Creating an Interaction Using a Segment Including Logging of the Segment

The Quote to Contact Feature

• Introduction
• Setting Up Customer Templates
• Making a Sales Quote from the Opportunity List Window
• Making a Sales Quote from the Sales Quote Window
• Creating a Sales Order from the Sales Quote Window
• Assigning a Sales Quote to an Opportunity

Document Logging

• Introduction
• Saving a Sales Quote
• Restoring a Sales Quote or Order
• Logging and Saving a Version of a Sales Order
• Restoring a Sales Order

Inventory Management

Introduction

• Inventory Introduction

Overview

• Inventory Availability
• Reservations
• Order Tracking

Multi-Locations

• Setting Up a Company with Multiple Locations
• Selling and Purchasing in a Company with Multiple Locations
• Controlling Inventory at Multiple Locations
• Link customers and vendors to locations
• Set up responsibility centers
• Link users, customers, and vendors to responsibility centers
• Create and set up stockkeeping units

Location Transfers

• Setting up Transfers
• Transferring Items between Locations
• Viewing Items in Transit

Warehousing

• Setting up a warehouse location
• Receiving and putting away from the purchase document
• Receiving with a warehouse receipt
• Picking and shipping with inventory pick documents
• Shipping with warehouse pick and ship documents
• Moving and adjusting bin contents
• Performing the physical inventory with bins

Item Tracking

• Setting up Item Tracking
• Handling Items with Serial and Lot Numbers
• Tracking Items with Serial and Lot Numbers
• Handling and Tracking Items with Warranty and Expiration
• Transferring Items with Serial and Lot Numbers

Inventory Costing

Introduction

• Introduction

Inventory Costing Overview

• Inventory Costs
• Inventory Accounting
• Understand the basic concepts behind calculation of inventory value
• Understand the relationship of capitalized and non-capitalized costs
• Understand the valuation of cost objects in relation to their direct and indirect costs
• Understand the cost flow assumptions that support the various costing methods

Inventory Costing Principles in Microsoft Navision

• Accounting for Inventory in Navision
• Understand how the program records quantity and value changes in entries
• Understand the different types of information that are recorded in item ledger entries and value entries
• Understand how inventory values are posted in the general ledger

Inventory Costing Functionality

• Inventory Acquisition
• Cost of Goods Sold
• Inventory Transfers and Returns
• Inventory Adjustment
• Rounding

Inventory Valuation Functionality

• Inventory Valuation
• Posting Inventory Costs to the General Ledger
• Inventory Revaluation
• Physical Inventory

Setting Up Inventory Costing

• Inventory Costing Setup

Warehouse Management

Introduction

• WMS Introduction

Setting up WMS

• Setting up WMS
• Setting up zones and bins
• Set up a warehouse
• Set up locations
• Set up put-away templates
• Set up items
• Set up bin types
• Set up bin rankings
• Create bins
• Set up warehouse classes

Receiving Orders

• Receive and Put-away
• Cross-Docking

Internal Warehouse Processes

• Movement
• Internal Pick and Put-away
• Journals
• Counting

Shipping

• Shipping the Items
• Shipping Cross-Docked Items
• Break-bulk

Manufacturing I

System Setup

• Manufacturing Setup
• Inventory Setup, as Related to Manufacturing

Production BOM's

• Production Bill of Materials (BOM)
• Production BOM Advanced Features
• Production BOM Reports

Capacities

• Capacities Set Up
• Routings
• Routings Advanced Features
• Capacity Journals
• Capacity Reports

Production Orders

• Understand the structure and make-up of a production order
• Understand the purpose of a production order
• Define the five statuses of a production order
• Create a new production order
• View the routing and components of a production order
• Reserve components for a production order
• View actual against expected costs, and capacity of a production order
• Make changes to the production order due date
• Make changes to the production order quantity required
• Make changes to the production order components required
• Use item substitution for components
• Make changes to the production order routing
• Understand the reports printed directly from a production order
• Access the Production Schedule from a production order
• Understand the standard reports available for production order reporting
• Understand the purpose of the Replan Production Order batch job
• Understand how the Replan Production Order batch job operates
• Understand the effects of scheduling a production order with a phantom BOM
• Calculate a manufacturing batch unit of measure
• Understand the two methods of changing the status of a production order

Production Order Processing

• Issue components using the Consumption Journal
• Pick and Put Away items used in manufacturing in Warehouse
• Record production order output using the Output Journal
• Register consumption and output from a Production Journal

Finishing Orders and Auto Reporting

• Finish Production Order
• Production Order with Forward Flushing
• Production Order with Forward Flushing and Routing Codes
• Scrap

Manufacturing II

Sales Order Interface & Order Planning

• Use Sales Order Planning to Create Production Orders
• Track from FPO to Sales Order
• Use the Sales Order Planning Window to see updates
• Use Order Planning to create order

Forecast and MPS

• Production Forecast
• Netting Actual Demand and Forecast
• Planning Approach
• Forecasting Sales Items and Components
• MPS Output Provides Input to MRP

Planning

• Planning Overview
• Regenerative Planning
• Net Change Planning
• Order Tracking and Action Messaging

Additional Planning Topics

• Variants
• Locations
• Transfers
• Blanket Sales Orders
• Multi-level Production Orders
• Planning Tools
• Planning Reports

Subcontracting

• Set up a subcontractor
• Set up subcontractor cost by subcontractor or by process
• Set up a routing with a subcontractor
• Process a production order with a subcontractor
• Determine when a purchase order is related to a production order
• Determine the status of subcontractor operations on released production orders

Capacity

• Facilities
• Work Center and Machine Center Calendars
• Absences
• Capacity Journals

Shop Loading

• Shop Load Overview
• Loading Capacities
• Modifying Load from Facilities
• Finite Loading
• Production Schedule
• Modifying Load from Production Schedule

Additional Manufacturing Topics

• Standard Task Codes
• BOM Scrap and Routing Scrap
• Non-Productive Time
• Parallel Scheduling
• Multi-Level Manufacturing
• Serial and Lot Number Processing
• Business Notification
• Additional Features

Manufacturing Costing

Concepts and Terms

• Manufacturing Costs
• Cost Accounting for a Manufacturer
• Understand the basic concepts behind the calculation of inventory value for finished goods
• Understand the valuation of cost objects in relation to their direct and indirect manufacturing costs
• Understand different types of manufactured inventory accounts
• Understand recorded transactions in the G/L accounts
• Understand different methods of standard cost calculations

Manufacturing Costing Principles

• Accounting for Manufactured Inventory in Microsoft Navision
• Understand how the program records quantity and value changes in entries
• Understand production order costing

Manufacturing Costing Functionality

• Manufacturing Costs
• Production Order Costing
• Inventory Valuation
• Posting Inventory Costs to the General Ledger
• Inventory Revaluation
• Set up the different cost elements of standard cost
• Calculate standard cost on single and multi-level
• Understand costing for purchase of raw material and its influence on inventory
• Understand costing for production and its influence on inventory
• Handle special manufacturing situations like using non-inventory items or by-products
• Handle subcontract operations
• Calculate the WIP inventory value
• Post inventory costs to General Ledger
• Revalue the WIP inventory

Standard Cost Worksheet

• Using the Standard Cost Worksheet
• Update costs at the component and capacity levels
• Consolidate and roll up component and capacity costs
• Implement the cost update for standard cost and inventory value

Development I

Basic Tables

• What is a Table?
• Table and Field Properties
• Creating Tables
• What Are Keys?
• Setting Relationships Between Tables
• Special Table Fields
• Modifying Some Properties
• Types of Tables and their Characteristics
• SumIndexFields and FlowFields

Basic Forms

• Blank Forms
• Useful Controls
• Forms Wizard
• Creating Buttons
• Creating subforms
• Form Types and Characteristics
• Standard Navigation

Introduction to C/AL Programming

• Intrinsic Data Types
• Identifiers and Variables
• Assignment Statements
• Simple Expressions, Terms and Operators
• Numeric Expressions
• Logical and Related Expressions
• IF and EXIT Statements
• Compound Statements and Comments
• Arrays
• Repetitive Statements
• Functions
• Using Intrinsic C/AL Functions
• Creating Your Own Functions

Reports

• Types of Reports
• Report Designers
• How Sections Work
• Report and Section Properties
• Grouping Within a Report
• Totaling Within a Report
• Advanced Report Features

Dataports

• Define Dataports and their various components
• Design a Dataport
• Save, compile and run a Dataport
• Export data to a file
• Import data from a file

XML Ports

• Define XMLports and their various components
• Design an XMLport
• Save, compile and run an XMLport
• Export XML data to a file
• Import XML data from a file

Codeunits

• Define Codeunits and their various components
• Create a Codeunit
• Define variables, text constants and functions within a Codeunit
• Use the C/AL Symbol Menu
• Save, compile and run a Codeunit
• Describe the limitations of Codeunits

MenuSuites

• MenuSuite Fundamentals
• Customizing MenuSuites
• Exporting a MenuSuite Object
• Upgrading MenuSuite Content

Integration Tools

• Install and set up the N/ODBC driver
• Access database data using queries
• Write data back to Microsoft Navision
• Install and set up the C/Front System
• Identify the limitations of C/Front
• Install and register OCX controls
• Implement an OCX control
• Discuss the problems and limitations of using OCX controls
• Discuss why automation servers are needed
• Create a report using automation
• Respond to automation events

Navision Implementation Methodology

• Microsoft Navision Implementation Methodology
• Version Control
• Development documentation

Development II

Business Case Diagnosis & Analysis

• Follow the standard Microsoft Navision Methodology used in developing projects
• Understand the business case used, and detail the functional requirements

Managing Master Files

• Write internal documentation
• Enable multilanguage functionality
• Work with event triggers, specifically table event triggers
• Work with the complex data types and their member functions

Managing Registrations

• Export and import objects as text files
• Use multilanguage functionality to create messages for the user
• Know how to create matrix forms
• Use virtual tables
• Use temporary tables

Managing Posting

• Create journal posting routines
• Create document posting routines
• Write internal documentation for modifications to existing objects
• Debug code
• Program for low-impact on the application

Managing Integration

• Expand the MenuSuite
• Implement Navigate functionality

Managing Reporting

• Use report event triggers
• Use special report functions
• Create processing-only reports

Managing Statistics

• Learn how to use FlowFields for calculations

Managing Dimensions

• Learn how to work with dimensions

Managing Interfaces

• Use OCX
• Understand what an automation server is
• Work with an XMLPort

Deployment

• Understand how to roll out customized Microsoft Navision projects out to clients
• Use Dataports
• Understand Microsoft Navision's upgrade procedures

Course Summary

• Course Summary

Review Questions

• Review Questions

Additional Exercises

• Additional Exercises

Jet Reports

Level 1 - 2 days

The Jet Reports Environment

• Modes of Jet Reports
• The Jet Menu
• Jet Options
• Excel's Function Wizard
• Designers vs. Viewers

Jet Reports Functionalities

• Basic Data Retrieval with Jet
• Creating Lists
• Filtering in Jet
• Grouping
• Sorting
• Dynamic Summing and Subtotaling
• GL Function

Designing Your Reports

• Designing a Report for Viewers
• User Options Page
• Tips for Building Reports, Start to Finish

Level 2 - 2/3 days

• Review of several key topics from level I including function basics
• Techniques to make your reports run faster
• Advanced Filtering Techniques
• Adding more advanced report options
• Using flow fields in your reports
• Scheduling and automating your reports
• Advanced Chart and Graph creation

Report workshop - 3rd day (optional)

• To apply what you've learned