Chapter
1:
Course outline – Application Setup
|
|
Chapter
2:
Set up a Company with the RIM Toolkit
Lessons:
- Manual Setup versus RIM
- Overview of the Rim Toolkit
- Using the RIM Toolkit
Labs:
- Lab 1.1 - Create a Setup Questionnaire
- Lab 1.2 - Import and Apply a Setup Questionnaire
- Lab 1.3 - Create a New Contact Data Template
- Lab 1.4 - Create and Export the Vendor Data Migration File
- Lab 1.5 - Complete the Migration of Vendor Data
The goal of completing this chapter is to enable students to:
- Explain the dependencies between RIM and manual setup work.
- Introduce the different components and processes of the RIM toolkit.
- Explain and demonstrate all tasks in a RIM process.
- Create a setup questionnaire.
- Initialize a new company with a setup questionnaire.
- Create data templates.
- Migrate data.
|
|
|
Chapter
3:
Set up Number Series
Lessons:
Labs:
- Lab 2.1 – Create a Number Series
The goal of completing this chapter is to enable students to:
- Explain the purpose of company-wide number series.
- Set up number series.
- Create number series relations.
|
|
|
Chapter
4:
Set up Journal Templates and Batches
Lessons:
- Overview
- Create Journal Templates and Batches
Labs:
- Lab 2.1 – Create a Number Series
The goal of completing this chapter is to enable students to:
- Explain the purpose and organization of journal templates and journal batches.
- Create general journal templates and general journal batches.
|
|
|
Chapter
5:
Set up Posting Groups
Lessons:
- Specific Posting Groups
- General Posting Groups
- General Posting Setup
- VAT Posting Groups
- VAT Posting Setup
- Additional VAT Posting Setup
- Determine Posting Groups
Labs:
- Lab 4.1 - Set up an Inventory Posting Group
- Lab 4.2 - Create a Product Posting Group
- Lab 4.3 - Copy a General Posting Setup Line
- Lab 4.4 - Create a VAT Posting Group
- Lab 4.5 - Copy a VAT Posting Setup
The goal of completing this chapter is to enable students to:
- Explain and set up specific posting groups.
- Explain and set up general posting groups.
- Create a general posting setup.
- Create an inventory posting setup.
- Explain and set up VAT posting groups.
- Create a VAT posting setup.
- Review additional VAT posting setup.
- Review posting setups based on the chart of accounts.
- Demonstrate how posting groups direct a sales transaction.
|
|
|
Chapter
6:
Set up Dimensions
Lessons:
- Dimensions and Dimension Values
- Dimension Types
- Dimension Combinations
- Default Dimensions
- Default Dimension Priority
Labs:
- Lab 5.1 - Set up a Dimension with Dimension Values
- Lab 5.2 - Set up a Dimension Combination
- Lab 5.3 - Assign Default Dimensions to a Single Account
- Lab 5.4 - Assign Default Dimensions to Multiple Accounts
- Lab 5.5 - Assign Vendor Account Type Default Dimensions
The goal of completing this chapter is to enable students to:
- Explain and set up dimensions and dimension values.
- Explain the different dimensions types: Global, Shortcut, and Budget.
- Explain and demonstrate how dimension combinations are set up.
- Explain and demonstrate the three levels of default dimensions, including single, multiple, and account type.
- Explain the purpose of default dimension priorities.
- Demonstrate the use of default dimension priorities in general journals.
|
|
|
Chapter
7:
Manage User Rights
Lessons:
- Authentication
- Logins, Roles, and Permissions
- User-specific Setup
- Active Directory Security
The goal of completing this chapter is to enable students to:
- Explain how authentication works in Microsoft Dynamics™ NAV.
- Distinguish database logins from Windows logins.
- Explain the concepts of roles and permissions.
- Assign a role to a database user.
- Assign a role to a Windows user.
- Create a new role and give permissions to it.
- Apply security filters in the SQL Server Option.
- Perform user-specific setup.
- Use Active Directory with Microsoft Dynamics NAV.
|
|
|
Chapter
8:
Customize the Navigation Pane
Lessons:
- Overview
- Design a Navigation Pane
- Export a MenuSuite
- Upgrade Considerations
The goal of completing this chapter is to enable students to:
- Outline basic concepts and features of the navigation pane.
- Create and edit menus with the Navigation Pane Designer.
- Assign menus to users.
- Create a new menu suite.
- Explain what is exported from a menu suite.
- Explain how upgrades affect new menus.
|
|
|
Chapter
9:
Approve Documents
Lessons:
- Set up Document Approvals
- Set up the Notification System
- Send Overdue Notifications
- Delegating Substitute Approvers
Labs:
- Lab 8.1 - Set Up Document Approvals
The goal of completing this chapter is to enable students to:
- Set up the general features of the document approval system.
- Set up approval templates.
- Set up approval users in a hierarchy.
- Set up the notification system for approvals.
- Manage overdue notifications.
- Maintain substitute approvers.
|
|
|
Chapter
10:
Course outline – Finance
|
|
|
Chapter
11:
Introduction
Lesson:
- Structure of the Finance in Microsoft Dynamics NAV 5.0 course
The goal of this chapter is to enable students to:
- Understand the purpose of the Finance 5.0 course.
- Understand class guidelines and details.
|
|
|
Chapter
12:
Financial Management Setup
Lessons:
- General Ledger Setup
- Accounting Periods
- Trail Codes, including Source Codes and Reason Codes
Labs:
- Lab 1.1 – Create a Fiscal Year
The goal of this chapter is to enable students to:
- Understand the General Ledger Setup card.
- Understand and work with accounting periods.
- Navigate the audit trail.
|
|
|
Chapter
13:
General Ledger
Lessons:
- Chart of Accounts
- Chart of Accounts Card
- General Ledger Budgets
Labs:
- Lab 2.1 – Create a Revenue Account
- Lab 2.2 – Create a VAT Account
- Lab 2.3 – Create a Budget
- Lab 2.4 – Copy a Budget
- Lab 2.5 – Export and Import a Budget
The goal of this chapter is to enable students to:
- Understand and maintain the chart of accounts.
- Understand the General Ledger Setup card.
- Set up and work with budgets.
- Copy and export budgets.
|
|
|
Chapter
14:
General Journals
Lessons:
- Journal Overview
- Journal Templates
- Journal Batches
- Journal Lines
- Creating and Posting Journal Entries
- Recurring Journals
- Reversals and Corrections
Labs:
- Lab 3.1 – Create a Journal Entry
- Lab 3.2 – Create and Post a Recurring Journal
- Lab 3.3 – Create and Post a Recurring Journal Using the Balance Method
The goal of this chapter is to enable students to:
- Understand the structure of journals, batches, and lines.
- Create a journal template.
- Create a journal batch.
- Create and post journal entries.
- Understand and use recurring journals.
- Use general journals to post corrections.
|
|
|
Chapter
15:
Cash Management
Lessons:
- Bank Account Card Overview
- Create a Bank Account
- Entering and Posting Receivables Payments
- Entering and Posting Payables Checks
- Financially Voiding Checks
- Bank Reconciliation
Labs:
- Lab 4.1 – Create a Bank Account
- Lab 4.2 – Apply and Post Cash Receipts
- Lab 4.3 – Enter and Post Manual Checks
- Lab 4.4 – Suggest Vendor Payments for a Single Vendor
- Lab 4.5 – Financially Void a Check
The goal of this chapter is to enable students to:
- Set up new bank accounts.
- Enter and post payments.
- Suggest vendor payments.
- Reconcile a bank account.
|
|
|
Chapter
16:
Receivables Management
Lessons:
- Customer Card and Receivables
- Cash Receipt Journals Overview
- Applying Cash Receipt Payments
- Unapply Customer Ledger Entries
- Reversal of Posted Journals
- Set up Payment Discounts
- Process Payment Discounts
- Set up Payment Tolerance
- Process Payment Tolerance
- Reminders and Finance Charge Memos
- Set up and Assign Reminder Terms
- Create and Issue Reminders
- Set up and Assign Finance Charge Items
- Create and Issue Finance Charge Memos
- Create Finance Charge Memos Automatically
- Analyzing Receivables
Labs:
- Lab 5.1 – Apply and Post a Cash Receipt
- Lab 5.2 – Applying a Payment After Posting
- Lab 5.3 – Unapply Posted Ledger Entries
- Lab 5.4 – Reverse a Posted Journal Entry
- Lab 5.5 – Post a Payment with a Discount
- Lab 5.6 – Apply Posted Partial Payments with Discounts
- Lab 5.7 – Set up a Payment Tolerance
- Lab 5.8 – Process a Payment Tolerance
- Lab 5.9 – Set up a Reminder Term
- Lab 5.10 – Create and Issue Reminders
- Lab 5.11 – Set up a Finance Charge Term
- Lab 5.12 – Create and Issue Finance Charge Memos
The goal of this chapter is to enable students to:
- Understand detailed customer ledger entries.
- Analyze receivables accounts.
- Use the Cash Receipts journal to apply cash.
- Understand how to handle partial payments and foreign currencies.
- Make corrections by Unapplying customer ledger entries.
- Reverse journal postings.
- Understand and work with payment discounts.
- Understand and work with payment tolerances.
- Understand and work with reminders and finance charge memos.
|
|
|
Chapter
17:
Payables Management
Lessons:
- Vendor Card and Payables
- Payment Journal Overview
- Apply Vendor Entries Window Overview
- Post Manual Payables Checks
- Suggest Vendor Payments Overview
- Create Payments Using Suggest Vendor Payments
- Print and Post Payables Checks
- Void Unposted Checks
- Apply Payments After Posting
- Unapply Vendor Ledger Entries
- Reversal of Journal Postings
- Reverse a Posted Journal Entry
- Set up Payment Discounts
- Process Payment Discounts
- Set up Payment Tolerance
- Process Payment Tolerance
- Analyze Payables
Labs:
- Lab 6.1 – Enter a Manual Check
- Lab 6.2 – Suggest, Print, and Post a Vendor Payment
- Lab 6.3 – Void and Reprint a Check
- Lab 6.4 – Apply a Credit Memo After Posting
- Lab 6.5 – Unapply a Payment
- Lab 6.6 – Reverse a Posted Journal Entry
- Lab 6.7 – Adjust an Invoice to Include Payment Discounts
- Lab 6.8 – Adjust the Payment Discount Amount
The goal of this chapter is to enable students to:
- Use payment journals, both manually and with the Suggest Vendor Payments feature.
- Work with partial payments.
- Understand payment discounts.
- Understand how to void checks, posted and not posted.
- Unapply vendor ledger entries.
- Reverse journal postings.
|
|
|
Chapter
18:
Prepayments
Lessons:
- Prepayments Set-up Overview
- Set up Prepayment General Ledger Accounts
- Set up Number Series for Prepayment Documents
- Set up Prepayment Percentages for Customers and Vendors
- Set up Check Prepayment When Posting
- Prepayments Processing Flows
- Prepayment Sales and Purchase Orders Overview
- Process Prepayment Sales and Purchase Orders
- Process Prepayment Sales and Purchase Invoices
- Correct Prepayments
Labs:
- Lab 7.1 – Set up Prepayments for Sales
- Lab 7.2 – Create a Prepayment Sales Order
- Lab 7.3 – Invoice a Prepayment Sales Order
The goal of this chapter is to enable students to:
- Set up prepayments in the General Ledger.
- Process prepayments, including the following:
- Create an order requiring prepayment
- Create a prepayment invoice.
- Review the corrections that can be made to prepayments.
|
|
|
Chapter
19:
VAT and Intrastat
Lessons:
- Display VAT Amounts in Sales and Purchase Documents
- Adjust VAT Amounts in Sales and Purchase Documents and Journals
- Import VAT
- VAT Correction
- VAT Statements
- VAT Settlement
- Intrastat Reporting
- Set up Intrastat
- Report Intrastat
Labs:
- Lab 8.1 – Adjust a VAT Amount in a Sales Document
- Lab 8.2 – Adjust a VAT Amount in a Purchase Journal
- Lab 8.3 – Define and Preview a VAT Statement
The goal of this chapter is to enable students to:
- Use VAT Posting Setup.
- Set up VAT posting groups.
- Do manual VAT calculations in journals.
- Show VAT calculations on sales and purchase documents.
- Record/Post import VAT.
- Demonstrate VAT corrections.
- Understand VAT reporting.
- Demonstrate VAT settlement.
- Process unrealized VAT.
- Adjust VAT for payment discounts.
- Understand Intrastat reporting.
|
|
|
Chapter
20:
Multicurrency
Lessons:
- Currency Card and Currency Exchange Rates
- Set Up Multicurrency for Customers, Vendors, and Bank Accounts
- Process Cash Receipts
- Convert Journal Entries to Local Currency
- Use the Adjust Exchange Rates Batch Job
- Additional Reporting Currency
- Consolidations with Multiple Currencies
Labs:
- Lab 9.1 – Process a Sales Invoice
- Lab 9.2 – Post Expenses in Foreign Currency
- Lab 9.3 – Update the USD:GBP Exchange Rate
- Lab 9.4 – Add an Additional Reporting Currency
- Lab 9.5 – Adjust the ACY Exchange Rate
The goal of this chapter is to enable students to:
- Understand and use currency exchange rates.
- Understand and use additional reporting currencies.
|
|
|
Chapter
21:
Year End Closing Processes
Lessons:
- Closing a Fiscal Year
- Transferring Income Statement Account Balances
Labs:
- Lab 10.1 – Post an Entry into a Closed Fiscal Year
The goal of this chapter is to enable students to:
- Perform standard end of year financial closing operations.
|
|
|
Chapter
22:
Additional chapter: Financial journals
Lessons:
- Setting up Financial Journals
- Linking Financial Journals to Banc Accounts
- Posting Bank Account Statement through Financial Journals
The goal of this chapter is to enable students to:
- Process banc statements through a financial journal in a Microsoft Dynamics NAV BE database.
|
|
|
Chapter
23:
Additional chapter: Electronic banking
Lesons:
- Electronic Payments
- Domiciliations
- CODA
- Standard Format Messages
The goal of this chapter is to enable students to:
- Process electronic banc transactions in a Microsoft Dynamics NAV 5.0 BE database.
|
|
|
Chapter
24:
Additional chapter: Multicompany operations – Consolidation
Lessons:
- Consolidation Overview and Backup Restoration
- Set up the Consolidation
- Export Data for Consolidation
- Test Data for Consolidation
- Process the Consolidation
- Process consolidation Eliminations
- Print Consoidation Reports
Labs:
- Lab 1 – Set up Business Units
- Lab 2 – Create a Consolidation Export File
- Lab 3 – Test the Consolidation Data
- Lab 4 – Correct the Consolidation Data
- Lab 5 – Consolidate the Subsidiaries
- Lab 6 – Print the Consolidted Trial Balance
The goal of this chapter is to enable students to:
- Setup consolidation
- Perform consolidation of different companies in one or more Microsoft Dynamics NAV 5.0 database.
|
|
|
Chapter
25:
Additional chapter: Multicompany operations – Intercompany
Lessons:
- Intercompany Overview and Database Preparation
- Set up the Intercompany Partner
- Assign IC Partners to Customers and Vendors
- Set up the Chart of Accounts for IC Transactions
- Set up Dimensions for IC Transactions
- Set up Default IC Parnter G/L Accounts
- IC Outbox and IC Inbox Overview
- Create an IC Document
- Send IC Documents
- Receive and Accept IC Documents
- View Handled IC Inbox and IC Outbox Transactions
- Reject IC Documents
- Return and Cancel IC Documents
- Post an IC General Journal
- Allocate Costs to IC Partners
Labs:
- Lab 1 – Set up an IC Partner
- Lab 2 – Creat an IC Partner Vendor
- Lab 3 – Add an Account and Update the IC Chart of Accounts
- Lab 4 – Remove and Update IC Dimensions
- Lab 5 – Create an IC Sales Document
- Lab 6 – Send IC Documents
- Lab 7 – Accept an IC Document and Create Purchase Invoice
- Lab 8 – Delete a Handled IC Transaction
- Lab 9 – Reject an IC Document
- Lab 10 – Cancel a Rejected IC Document
- Lab 11 – Post and Send an IC General Journal Transaction
- Lab 12 – Allocate Service Costs to IC Partners
- Lab 13 – Allocate Purchase Costs to IC Partners
The goal of this chapter is to enable students to:
- Setup intercompany.
- Perform intercompany transactions between one or more companies in one or more Microsoft Dynamics NAV 5.0 databases.
|
|
|
Chapter
26:
Course outline – Business Intelligence for Information Workers
|
|
|
Chapter
27:
Business Intelligence for Information Workers
Lessons:
- Business Intelligence
- Business Intelligence Overview
The goal of completing this chapter is to enable students to:
- Learn business intelligence concepts and receive a course overview.
- Learn the intentions behind the Business Intelligence for Information Workers course, and related courses.
|
|
|
Chapter
28:
Financial Reporting
Lessons:
- Analyzing the Chart of Accounts
- Account Schedules
Labs:
- Lab 2.1: Create a Detailed Account Schedule
The goal of completing this chapter is to enable students to:
- Describe filtering and analysis windows related to the Chart of Accounts.
- Set up an Account Schedule and explain other processes relating to account schedules.
|
|
|
Chapter
29:
XBRL
Lessons:
- XBRL Terminology
- XBRL Specifications and Taxonomies
Labs:
- Lab 3.1: Stock Exchange Reporting with XBRL
The goal of completing this chapter is to enable students to:
- Explain the terminology associated with XBRL.
- Explain the process of importing and updating taxonomies.
- Explain the process of attaching linkbases to taxonomies.
- Describe windows related to XBRL lines and explain the process of entering XBRL line definitions.
- Export XBRL lines.
|
|
|
Chapter
30:
Financial Analysis
Lessons:
- View Posted Dimension Information
- Using Dimensions
- Dimension Based Reports
Labs:
- Lab 4.1 - Create an Analysis View
- Lab 4.2 - Combine an Analysis View with an Account Schedule
The goal of completing this chapter is to enable students to:
- Describe types of dimensions, and entering dimensions in journals and documents.
- Explain how to view posted dimension information.
- Describe the windows related to analyzing financial information and explain the setup of analysis views.
- Explain how to generate and print dimension analysis
|
|
|
Chapter
31:
Business Analytics
Lessons:
- Data Warehouse
- Setting up the Microsoft Dynamics NAV Configurator
- Setting up BA Databases
- Additional Business Analytics TaskDemonstration: Set up a Virtual Cube
Labs:
- Lab 5.1 - Create a New Cube
The goal of completing this chapter is to enable students to:
- Describe Business Analytics.
- Explain the terminology associated with Business Analytics.
- Describe the data warehouse and the elements of the data warehouse.
- Set up the Microsoft Dynamics NAV Configurator.
- Explain the process of setting up BA Databases.
- Set up virtual cubes and map existing dimensions to a cube
|
|
|
Chapter
32:
Analyze Microsoft Dynamics NAV Data in Microsoft Excel
Lessons:
- Export Analysis Views to Excel
- Work with Data in Excel
Labs:
- Lab 6.1 - Export an Analysis View to Excel
- Lab 6.2 - Review Exported Analysis Views Side-by-Side
The goal of completing this chapter is to enable students to:
- Explain the process of exporting analysis views to Microsoft® Office Excel® and describe the elements of the exported file.
- Describe how to work with analysis data that has been imported into Excel
|