About Apex InfoTech Information Services Products Consulting Online Courses Certifications Course Schedule Reserve your seat Search Apex InfoTech Home Page
Course ScheduleSearch by Course NumberPrint this documentEmail this documentRegister for this course

Microsoft Business Solutions—Navision Financial Series II
Course 8405: 2.5 days; Instructor-led

Prerequisites
Before attending this course, students must have:

• General knowledge of Microsoft Windows®

• The ability to use Navision financials for financials processing

In addition, students should have:

• Basic knowledge of accounting principles and procedures

Course Outline
Introduction

This chapter gives students a general overview of the Microsoft Navision Financial Series II training course.

Main Topics

• To introduce students to the Microsoft Navision Financial Series II training course

• To establish class guidelines and review administrative details


After completing this chapter, students should be able to:

• Understand the purpose of the Financial Series II training course

• Understand class guidelines and details

Chapter 1: Multicurrency Operations

This chapter focuses on various Multicurrency Operations used in Microsoft Navision. The chapter, in detail, explains how to set up and use these operations.

Main Topics

• Updating Currency Exchange Rates for Foreign Currency Balances

• Additional Reporting Currencies

Labs

• Change the Relational Exchange Rate

• Add an Additional Reporting Currency

After completing this chapter, students should be able to:

• Understand and use Currency Exchange Rates

• Understand and use Additional Reporting Currencies

Chapter 2: Financial Reporting

This chapter demonstrates how to use the methods of financial reporting within Microsoft Navision.

Main Topics

• Chart of Accounts Analysis

• Account Schedules

• Annual Closing Operations

Labs

• Create an Account Schedule

• Create Detailed Account Schedules

• Close an Income Statement

After completing this chapter, students should be able to:

• Analyze the Chart of Accounts

• Create Account Schedules displaying various row and column combinations

• Perform standard end of year financial closing operations

Chapter 3: XBRL

This chapter discusses XBRL functionality in Microsoft Navision.

Main Topics

• XBRL – eXtensible Business Reporting Language

• Importing the Taxonomy

• Entering XBRL Line Definitions

• Exporting the XBRL Lines

Lab

• Stock Exchange Reporting with XBRL

After completing this chapter, students should be able to:

• Understand basic XBRL vocabulary and taxonomy

• Enter XBRL Line Definitions

• Export XBRL Lines

Chapter 4: Financial Analysis Using Dimensions

This chapter focuses on the multiple ways within Microsoft Navision to analyze financial data.

Main Topics

• Entering Dimensions in Journals and Documents

• Viewing Posted Dimension Information

• Analyzing Financial Information Using Dimensions

• Exporting Analysis Views to Microsoft® Excel®

Labs

• Creating Analysis Views

• Combining Analysis Views with Account Schedules

• Exporting Analyses by Dimensions to Excel

After completing this chapter, students should be able to:

• Enter Dimensions in Journals and Documents

• Create Analysis Views

• View Posted Dimension Information

• Combine Analysis Views with Account Schedules

• Analyze Financial Information Using Dimensions

• Export Analyses by Dimensions to Excel

Chapter 5: Business Analytics

This chapter covers the Business Analytics features of Microsoft Navision. It provides a short overview of the basis of Business Analytics then explains the various ways in which Business Analytics may be used in Microsoft Navision and Excel.

Main Topics

• 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

Lab

• Create a New Cube

After completing this chapter, students should be able to:

• Understand Business Intelligence and Business Analytics

• Use and understand Business Analytics terminology

• Use the Data Configurator

• Use the Data Warehouse

• Set up the Navision Configurator

• Create New Cubes

• Set up BA Databases

• Create Virtual Cubes

Chapter 6: Multicompany Operations I

This chapter explains the basics of managing multicompany operations.

Main Topics

• Setting up the consolidation company and subsidiaries

• Exporting data for Consolidation (if necessary)

• Testing data to be consolidated

• Consolidating the data

• Processing Consolidation Eliminations

• Consolidated reports

Labs

• Setting up the Chart of Accounts in the Subsidiary Companies

• Setting up the Business Units in the Consolidation Company

• Creating a Consolidation Export File

• Testing the Data Prior to Consolidation

• Consolidating the Subsidiaries within the Database

• Printing the Consolidated Trial Balance

After completing this chapter, students should be able to:

• Set up consolidation companies and subsidiaries, including the chart of accounts for subsidiaries

• Set up business units in consolidation companies

• Export data for consolidation

• Test data prior to consolidation

• Create consolidated reports

• Process consolidation eliminations

Chapter 7: Multicompany Operations II

This chapter builds on the previous chapter to explain the more advanced multicompany operations available in Microsoft Navision.

Main Topics

• Overview

• 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

Lab 1: Intercompany Partner

• Intercompany Partner

• Assigning an IC Partner to a Customer and/or Vendor

• Setting 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 / Handling an IC Document

• Rejecting an IC Document

• Returning an IC Document in the IC Outbox to the IC Inbox

• Posting an IC Journal

• Allocating Cost to IC Partners

After completing this chapter, students should be able to:

• Set up Intercompany partners

• Allocate costs to IC partners

• Create IC documents

• Reject IC documents

• Set up dimensions for IC documents

• Set up the Chart of Accounts for IC Documents

• Post to an IC General Journal