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.