Course 8405: 2.5 days; Instructor-led
On This Page
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
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 |
|