80041 Finance in Microsoft Dynamics NAV 2009

Code: 80041
Course duration: 3 days
Price: 2495

80041: Finance in Microsoft Dynamics NAV 2009 (3 Days)

About this Course

The three-day course, Microsoft Dynamics Finance NAV 2009, covers the basic financial functionality available for Microsoft Dynamics NAV 2009. Students learn how to set up the General Ledger, Accounts Payable, Accounts Receivable, and Bank Management modules in Microsoft Dynamics NAV.

The student also learn how to create transactions, use the VAT module and create reporting in more than one currency. This course gives you hands-on experience in setting up financials in Microsoft Dynamics NAV 2009.

This course provides the necessary tools for students to handle the key financial functions within an organization, hereunder create postings, process cash management, develop journals, and follow the transactions. The student will also be able to process the receivables and payables management module in NAV and manage VAT in NAV.

Audience Profile

The audience for this course includes individuals on the implementation team that are administrating or using the financial management functions in Microsoft Dynamics NAV 2009. 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 for customers who want to learn the basic features and develop a working knowledge of the typical daily procedures required to effectively use Finance in Microsoft Dynamics NAV 2009.
Additionally, individuals responsible for training or supporting Microsoft Dynamics NAV 2009 benefit from the course.

Prerequisites

Before attending this course, students must have a:

  • Introduction to Microsoft Dynamics NAV 2009
  • General knowledge of Microsoft Windows
  • General knowledge of Microsoft Office
  • Basic knowledge of accounting principles and procedures

At Course Completion

After completing this course, students will be able to:

  • 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 Prepayments
  • Setup and work with multicurrency.
  • Setup and work with VAT and Intrastat
  • Perform standard end of year financial closing operations.

Course Outline

Module 1: Financial Management Setup

This module explain the fields on the General Ledger Setup window. It also explainshowset up Accounting Periods,and how to set up Trail Codes, Source Codes, and Reason Codes

Lessons

  • General Ledger Setup
  • Accounting Periods
  • Trail Codes

Lab : Create a Fiscal Year

After completing this module, students will be able to:

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

Module 2: General Ledger

This module explain the use of the Chart of Accounts and theelements of the Chart of Accounts and theG/L Account Card.

It also explain the Budgets feature and the G/L Budgets page. It describesthe process of setting up budgets manually, theadditional budget processes, such as deleting budget entries,the process of creating budgets by using the Copy Budget function and theprocess of creating budgets by using the Export Budget and Import Budget functions.

Lessons

  • Chart of Accounts Overview
  • G/L Account Card
  • Chart of Accounts Page
  • Budget
  • Create Budgets Manually
  • Copy Budgets
  • Export and Import Budgets

Lab : Create a Revenue Account

Lab : Create a VAT Account

Lab : Create a BudgetLab : Copy a Budget

After completing this module, 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 3: General Journals

This module explain the General Journal entry and posting system. It describes how to create and post General Journal entries.

It also describe Recurring Journals, including the fields and allocations to recurring journals and itdemonstrate how to use Recurring Journals with allocations and how to record accruals. It also explain the process of reversing and correcting journal entries.

Lessons

  • Journal Overview
  • Creating and Posting Journal Entries
  • Recurring Journals Overview
  • Processing Recurring Journals
  • Reversals and Corrections

Lab : Create a Journal Entry

Lab : Create and Post a Recurring Journal

After completing this module, 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 4: Cash Management

This module describe the Bank Account Card. It demonstrate the process for entering and posting payments received from customers and theprocess for entering and posting payments to vendors.

This module explain and demonstrate the process of financially voiding a check.
It alsodescribe the Bank Account Reconciliation window, the options for populating the bank reconciliation lines and demonstrate how to process a bank reconciliation.

Lessons

  • Bank Account Overview
  • Entering and Posting Receivables Payments
  • Entering and Posting Payables Checks
  • Financially Voiding Checks
  • Bank Reconciliation

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

After completing this module, students will be able to:

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

Module 5: Receivables Management

This module describesthe Payments FastTab on the Customer Card.

It explain the Cash Receipt Journal, which is used to post payments received,the process of applying cash receipt paymentsand theprocess of unapplying entries to customer ledger entries. It also explain the process of reversing customer ledger entries.

This module explains how touse payment discounts and describes thetransactions for various situations that benefit from payment discounts.

It explains how touse payment tolerance and describes thetransactions for various situations that benefit from using payment tolerance.

This module alsoexplain why and when Reminders and Finance Charge Memos are used, it explain how touse reminders andthe process of creating and issuing reminders.

It also explainhow to use finance charge memos and theprocess of creating and issuing finance charge memos.

Finally it describes how to review the Customer Ledger Entries and Detailed Customer Ledger Entries.

Lessons

  • Customer Card
  • 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 Terms
  • Create and Issue Finance Charge Memos
  • Analyzing Receivables

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 : Create and Issue Finance Charge Memos

After completing this module, 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 6: Payables Management

This module describe the Payments FastTab on the Vendor Card window. It explain the Payment Journal, which is used to process payments. It also explain the Apply Vendor Entries window, used to apply payments to vendor ledger entries.

This module explain the process of entering and posting manual checks. it decribes the Suggest Vendor Payments batch job, which is used to generate open payables entries in the Payment Journal and how to create payments using the Suggest Vendor Payment batch job.

This module explain the process of printing and posting payments and explain the process of voiding printed but unposted payments.

It demonstrate how to apply payments to vendor ledger entries after posting, explain the process of unapplying vendor ledger entries and explain the process of reversing vendor ledger entries posted using journals.

It explains how to usepayment discounts and describes thetransactions for various situations that benefit from using payment discounts.

It explainshowto use payment tolerance and thetransactions for various situations that benefit from payment tolerance.

Finally it describes how to review Vendor Ledger Entries and Detailed Vendor Ledger Entries

Lessons

  • Vendor Card
  • Payment Journal Overview
  • Apply Vendor Entries Window
  • 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
  • Set up Payment Discounts
  • Process Payment Discounts
  • Set Up Payment Tolerance
  • Process Payment Tolerance
  • Analyze Payables

Lab : Enter a Manual Check

Lab : Suggest, Print, and Post a Vendor Payment

Lab : Void a Check

Lab : Apply a Credit Memo after Posting

Lab : Unapply a Payment

Lab : Reverse a Posted Journal Entry

Lab : Adjust the Payment Discount Amount

After completing this module, 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 7: Prepayments

This module explain the requirements for setting up prepayments and how to set up and assign prepayment General Ledger accounts,for sales and purchases, and how to set up default prepayment percentages on customers and vendors andCustomer-Item and Vendor-Item combinations.

It describes how toset up prepayment posting verification for sales and purchases and explain the prepayment processing flows for sales and purchase orders. It also describe the prepayment-specific fields on sales and purchase orders and how to create sales and purchase orders with prepayment percents and amounts andprepayment invoices from sales and purchase orders.

This module explain the processes available to correct posted prepayment invoices.

Lessons

  • Prepayments Setup Overview
  • Set Up Prepayment General Ledger Accounts
  • Set Up Number Series for Prepayment Documents
  • Set Up Prepayment Percentages for Customers and Vendors
  • Set Up Prepayment Percentages for Customer-Item and Vendor-Item Combinations
  • 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 : Set Up Prepayments for Sales

After completing this module, 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 8: VAT and Intrastat

This module explain the VAT settings on sales and purchase documents. It also explain the process of adjusting calculated VAT amounts in sales and purchase documents and journals.

This module demonstrate the process of recording Import VAT.

This moduledescribe how tocorrect a posted VAT entry andprint a VAT Statement. It explain and run the Calc. and Post VAT Settlement batch job.

This module explain the requirements of reporting Intrastat, how to set up Intrastat and theprocess of running and submitting Intrastat reports.

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

Lab : Adjust a VAT Amount in a Sales Document

Lab : Adjust a VAT Amount in a Purchase Journal

After completing this module, 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 9: Multicurrency

This module explain thesetup requirements for currencies and exchange rates when using multiple currencies.
Italso explainsthe setup requirements using multiple currencies with Customers, Vendors, and/or Bank Accounts and the additional functionality forusing Purchase and Sales documents that have foreign currency.

This module describetheadditional functionality when posting multicurrency transactions in the Cash Receipts Journal orthe Payments Journal.
It describes the process of running the Adjust Exchange Rates batch job for Customers, Vendors, and/or Bank Accounts.
And It also explain the set up, viewing amounts, daily processing, and periodic processes when using an Additional Reporting Currency.

Finally this moduleexplain the process of consolidations with companies using different currencies.

Lessons

  • Currency Card and Currency Exchange Rates
  • Set Up Multicurrency for Customers, Vendors, and Bank Accounts
  • Process Sales and Purchase Documents
  • Process Cash Receipts
  • Process Payments
  • Use the Adjust Exchange Rates Batch Job
  • Additional Reporting Currency
  • Consolidations with Multiple Currencies

Lab : Process a Sales Invoice

Lab : Post Expenses in Foreign Currency

Lab : Update the USD:GBP Exchange Rate

Lab : Adjust the ACY Exchange Rate

After completing this module, students will be able to:

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

Module 10: Year End Closing Processes

This module explains how to close the accounting periods for the fiscal year,run the Close Income Statement batch job process and complete the closing process by posting the General Journal.

Lessons

  • Closing a Fiscal Year
  • Transferring Income Statement Account Balances
  • Posting the Journal

Lab : Post an Entry into a Closed Fiscal Year

After completing this module, students will be able to:

  • Perform standard end of year financial closing operations

*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.

Course Reviews

No reviews found for this course.

Be the first to write a review