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

Finance in Microsoft Dynamics NAV 5.0

Course 8871: Three days; Instructor-Led

Introduction

The three-day Finance in Microsoft Dynamics NAV 5.0 course explores the activities required to handle key financial functions within the organization such as the Cash Management, the management of VAT, Journal development and transactions, the General Ledger, and Receivables and Payables Management.

Audience

This course is intended for individuals on the implementation team, administrating or using the financial management functions in Microsoft Dynamics NAV 5.0. This audience typically includes individuals who are tasked with assessing a customer’s business needs and advising them on the use, configuration, and customization of the application.

It is also designed for customers wishing to learn the basic features and to develop a working knowledge of the typical day-to-day procedures required to effectively use Finance in Microsoft Dynamics NAV 5.0 activities.

Additionally, individuals responsible for training or supporting Microsoft Dynamics NAV 5.0 benefit from the course.

At Course Completion

The goal of this course is to enable students to identify, describe, and use basic Microsoft Dynamics NAV features:

Maintain and work with the General Ledger

Process a bank reconciliation

Use Journals and Batches

Understand Receivables Management

Understand Payables Management

Setup and work with Multicurrency

Perform standard end of year financial closing operations

Prerequisites

Introduction to Microsoft Dynamics NAV 5.0

General knowledge of Microsoft Windows

Basic knowledge of accounting principles and procedures

Microsoft Certified Professional Exams

No Microsoft Certified Professional exams are associated with this course currently.

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline

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 in Microsoft Dynamics NAV 5.0 course.

Understand class guidelines and details.

Chapter 1: Financial Management Setup

Lessons

General Ledger Setup

Accounting Periods

Trail Codes, including Source Codes and Reason Codes

Lab

Lab – 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 2: General Ledger

Lessons

Chart of Accounts

Chart of Accounts Card

General Ledger Budgets

Lab

Lab – Create a Revenue Account

Lab – Create a VAT Account

Lab – Create a Budget

Lab – Copy a Budget

Lab – 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 3: General Journals

Lessons

Journal Overview

Journal Templates

Journal Batches

Journal Lines

Creating and Posting Journal Entries

Recurring Journals

Reversals and Corrections

Lab

Lab – Create a Journal Entry

Lab – Create and Post a Recurring Journal

Lab – 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 4: Cash Management

Lessons

Bank Account Card Overview

Create a Bank Account

Entering and Posting Receivables Payments

Demonstration: Enter a Cash Receipt Payment

Entering and Posting Payables Checks

Demonstration – Post Manual Checks

Demonstration – Suggest Vendor Payments for Local Vendors

Financially Voiding Checks

Bank Reconciliation

Demonstration – Complete a Bank Reconciliation

Lab

Lab – Create a Bank Account

Lab – Apply and Post Cash Receipts

Lab – Enter and Post Manual Checks

Lab – Suggest Vendor Payments for a Single Vendor

Lab – 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 5: Receivables Management

Lessons

Customer Card and Receivables

Cash Receipt Journals Overview

Applying Cash Receipt Payments

Demonstration – Applying Entries After Posting

Unapply Customer Ledger Entries

Reversal of Posted Journals

Set up Payment Discounts

Process Payment Discounts

Demonstration – Posting Partial Payments with Discounts

Demonstration – Add Discounts After Posting Sales Transactions

Demonstration – Apply Posted Payments to Sales Documents with Discounts

Set up Payment Tolerance

Demonstration – Set up Payment Tolerance

Process Payment Tolerance

Demonstration – Discount Taken Past the Discount Date

Demonstration – Discount Calculated Incorrectly

Demonstration – Erroneous Totaling of Two Invoices

Reminders and Finance Charge Memos

Set up and Assign Reminder Terms

Demonstration – Create a Reminder Term

Create and Issue Reminders

Demonstration – Create Reminders Automatically

Set up and Assign Finance Charge Items

Create and Issue Finance Charge Memos

Demonstration – Create Reminders Automatically

Create Finance Charge Memos Automatically

Analyzing Receivables

Lab

Lab – Apply and Post a Cash Receipt

Lab – Applying a Payment After Posting

Lab – Unapply Posted Ledger Entries

Lab – Reverse a Posted Journal Entry

Lab – Post a Payment with a Discount

Lab – Apply Posted Partial Payments with Discounts

Lab – Set up a Payment Tolerance

Lab – Process a Payment Tolerance

Lab – Set up a Reminder Term

Lab – Create and Issue Reminders

Lab – Set up a Finance Charge Term

Lab – 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 6: 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

Demonstration – Use Vendor Priority and Available Amounts

Print and Post Payables Checks

Demonstration – Print Computer 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

Demonstration – Suggest Payment Lines Without a Discount

Demonstration – Adjust Payment Discounts

Set up Payment Tolerance

Demonstration – Set up Payment Tolerance

Process Payment Tolerance

Demonstration – Discount Taken Past the Discount Date

Demonstration – Adjust the Payment Amount to Reflect Discount

Analyze Payables

Lab

Lab – Enter a Manual Check

Lab – Suggest, Print, and Post a Vendor Payment

Lab – Void and Reprint a Check

Lab – Apply a Credit Memo After Posting

Lab – Unapply a Payment

Lab – Reverse a Posted Journal Entry

Lab – Adjust an Invoice to Include Payment Discounts

Lab – 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 7: 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

Lab

Lab – Set up Prepayments for Sales

Lab – Create a Prepayment Sales Order

Lab – 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 8: VAT and Intrastat

Lessons

Display VAT Amounts in Sales and Purchase Documents

Adjust VAT Amounts in Sales and Purchase Documents and Journals

Demonstration – Adjust a VAT Amount in a Purchase Document

Demonstration – Adjust a VAT Amount in a General Journal

Import VAT

Demonstration – Set up and Post Import VAT

VAT Correction

VAT Statements

Demonstration - Define, Preview, and Print a VAT Statement

VAT Settlement

Intrastat Reporting

Set up Intrastat

Report Intrastat

Lab

Lab – Adjust a VAT Amount in a Sales Document

Lab – Adjust a VAT Amount in a Purchase Journal

Lab – 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 9: Multicurrency

Lessons

Currency Card and Currency Exchange Rates

Demonstration – Setting Payment Tolerance

Set Up Multicurrency for Customers, Vendors, and Bank Accounts

Demonstration – Process a Purchase Invoice

Process Cash Receipts

Demonstration – Process a Cash Receipt Journal

Demonstration – Print and Post Checks

Convert Journal Entries to Local Currency

Demonstration - Use the Insert Conversion LCY Rounding Lines Function

Use the Adjust Exchange Rates Batch Job

Demonstration – Adjust Currency Exchange Rate

Additional Reporting Currency

Consolidations with Multiple Currencies

Lab

Lab – Process a Sales Invoice

Lab – Post Expenses in Foreign Currency

Lab – Update the USD:GBP Exchange Rate

Lab – Add an Additional Reporting Currency

Lab – 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 10: Year End Closing Processes

Lessons

Closing a Fiscal Year

Demonstration – Prior-Year Entry Confirmation

Transferring Income Statement Account Balances

Demonstration – Run the Close Income Statement Batch Job

Demonstration – Review Entries and Post the General Journal

Lab

Lab – 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.

For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100