Finance in Microsoft Dynamics NAV 5.0

8871: Finance in Microsoft Dynamics NAV 5.0 (3 Days)

About this Course

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 Profile

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

Course Outline

Module 1: Introduction

Lessons

• Structure of the Finance in Microsoft Dynamics NAV 5.0 course

Module 2: Financial Management Setup

Lessons

• General Ledger Setup
• Accounting Periods
• Trail Codes, including Source Codes and Reason Codes

Lab : Create a Fiscal Year

After completing this chapter, students will be able to:

• Understand the General Ledger Setup card.
• Understand and work with accounting periods.
• Navigate the audit trail.

Module 3: General Ledger

Lessons

• Chart of Accounts
• Chart of Accounts Card
• General Ledger Budgets

Lab : Create a VAT Account

Lab : Create a Budget

Lab : Copy a Budget

After completing this chapter, students will be able to:

• Understand and maintain the chart of accounts.
• Understand the General Ledger Setup card.
• Set up and work with budgets.
• Copy and export budgets.

Module 4: General Journals

Lessons

• Journal Overview
• Journal Templates
• Journal Batches
• Journal Lines
• Creating and Posting Journal Entries
• Recurring Journals
• Reversals and Corrections

Lab : Create and Post a Recurring Journal

After completing this chapter, students will be able 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.

Module 5: 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 : Apply and Post Cash ReceiptsLab : Enter and Post Manual ChecksLab : Suggest Vendor Payments for a Single Vendor After completing this chapter, students will be able to:

• Set up new bank accounts.
• Enter and post payments.
• Suggest vendor payments.
• Reconcile a bank account.

Module 6: 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 : 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

After completing this chapter, students will be able 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.

Module 7: 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 : Suggest, Print, and Post a Vendor Payment

Lab : Void and Reprint a Check

Lab : Apply a Credit Memo After Posting

Lab : Unapply a PaymentLab : Reverse a Posted Journal Entry

Lab : Adjust an Invoice to Include Payment Discounts After completing this chapter, students will be able 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.

Module 8: 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 : Create a Prepayment Sales Order

After completing this chapter, students will be able 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.

Module 9: 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 : Adjust a VAT Amount in a Purchase Journal

After completing this chapter, students will be able 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.

Module 10: 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 : Post Expenses in Foreign Currency

Lab : Update the USD:GBP Exchange Rate

Lab : Add an Additional Reporting Currency

After completing this chapter, students will be able to:

• Understand and use currency exchange rates.
• Understand and use additional reporting currencies.

Module 11: 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 : Post an Entry into a Closed Fiscal Year

After completing this chapter, students will be able to:

• Perform standard end of year financial closing operations
• Introduction to Microsoft Dynamics NAV 5.0
• General knowledge of Microsoft Windows
• Basic knowledge of accounting principles and procedures