Introduction
The three-day Microsoft Business Solutions – Navision® Financial Management course explores all accounting activities and the processes required to enter financial data into the system. This course demonstrates how to perform functions such as bank reconciliation, budgeting, general journal entries, accounts receivable and accounts payable. Financial reporting and analysis is also covered, as well as VAT processing, XBRL, and system security and maintenance.
Audience
The intended audience for this course is partners wishing to learn how
to set up Financial Management in Microsoft Navision for their customers.
The class is targeted toward sales people, consultants and implementers who need to understand the technical aspects of Microsoft Navision Financial Management and gain foundational knowledge of the application functionality.
It is also targeted at anyone who wants to become certified in Microsoft Navision 3.70 Financial Management, as there are questions on the Financial Management test which are related to this area.
At Course Completion
After completing this course, students should be able to:
Enter General Ledger Journal
entries
Process bank reconciliations
Process financial information using multi-currencies
Perform financial analysis and reporting
Enter financial budgets
Process multi-company consolidations
Process VAT transactions and reports
Analyze and process Accounts Receivable
Analyze and process Accounts Payable
Have a basic understanding of system security and maintenance
Have a basic understanding of XBRL functionality
Prerequisites
Before attending this course, students must have:
General knowledge of Windows
Completed the Microsoft Navision Essentials classes or tutorials
Basic knowledge of accounting principles
Course Outline
Chapter 1: Introduction
The purpose of this chapter is to give students a general overview of
the features and benefits of Microsoft Navision Financial Management.
It also focuses on how all of the various application areas are integrated
with each other in Microsoft Navision.
Main Topics
Financial Management Features and Benefits
Financial Management Overview
Integration
After completing this chapter, students should be able to:
Identify the features and benefits
available when using Financial Management
Discuss integration that takes place between General Ledger and other
modules within Microsoft Navision
Chapter 2: Journals
This chapter focuses on entering General Journals in Microsoft Navision.
We examine the processes for entering recurring journals, which includes
allocations and accruals. We also learn how to enter correcting journal
entries. There is also a section that focuses on the process of clearing
up rounding discrepancies for currency conversions within the General
Journal.
Main Topics
Recurring Journals
Allocations
Accruals
Correction Journal Entries
Currency Conversion and Rounding Discrepancies
Lab: Creating and Posting Recurring Journals
Create and Post a Recurring Journal
Lab: Recording Accruals and Allocations
Enter an Accrual in a Recurring Journal
Enter an Allocation for the Accrual
Lab: Recurring Journals Using the Balance Method
Enter a Recurring Journal Using the Balance Method
Lab: Posting a Correction Journal
Enter and Post a General Journal Correction Entry
Lab: Conversion to LCY Rounding Function
Enter a General Journal using the Conversion to LCY Rounding Function
After completing this chapter, students should be able to:
Set up and post Recurring Journals
Process Allocations and Accruals
Enter General Ledger Correcting Journal Entries
Adjust the General Journal for rounding errors that result from currency
conversions
Chapter 3: Banking
The purpose of this chapter is to show how to process a bank reconciliation.
Within this process, we examine various situations that may occur during
the reconciliation process, and look at how to resolve them.
Main Topics
Bank Reconciliation Process
Alternate Process for Bank Reconciliation
Lab: Step 1 - Filling in the Bank Reconciliation
Run the Function to Populate the Bank Reconciliation Window
Lab: Step 2 - Correcting the Bank Reconciliation Lines and Applying Entries
Record an entry that appears in Microsoft Navision, but not on the Bank
Statement
Record an entry that appears on the Bank Statement, but not in Microsoft
Navision
Apply one bank statement transaction to multiple bank ledger entries
Apply multiple bank statement transactions to one bank ledger entry
Lab: Step 3 - Recording Differences in Transaction Amounts
Record an entry for a Discrepancy in a Transaction Amount
Lab: Step 4 - Posting the Bank Reconciliation
Post the Bank Reconciliation
Lab: Alternative Method for Completing the Bank Reconciliation
Use the Alternative Method for Completing the Bank Reconciliation
After completing this chapter, students should be able to:
Process a standard bank reconciliation
Use an alternative method for processing a bank reconciliation
Chapter 4: Multicurrency Operations
In this chapter we discuss how to update system entries to account for
fluctuations in the currency exchange rates. We also see how to set up
the system to allow reporting in another currency, in addition to the
local currency. Then, we discuss how to view information in this additional
currency on reports and on display windows.
Main Topics
Updating Currency Exchange Rates
Adding an Additional Reporting Currency
Lab: Updating Currency Exchange Rates
Update Currency Exchange Rates
Lab: Adding an Additional Reporting Currency
Entering and posting an intercompany transaction
After completing this chapter, students should be able to:
Update currency exchange rates
Set the system to allow reporting in an additional currency
View financial information, on reports or on screen, for the additional
currency
Chapter 5: Financial Reporting
This chapter focuses on viewing and reporting on the financial data in
the system. Analyzing financial information from the chart of accounts
is discussed, as well as how to create customized views and reports of
financial data. We also walk through the year-end closing process, and
discuss the effects of this process on past and future general ledger
entries.
Main Topics
Analyzing Information on the Chart of Accounts
Creating Account Schedules
Year-End Closing Process
Lab: Creating an Account Schedule
Create the Row Layout
Create the Column Layout
Combine the Rows and Columns
Lab: Exporting Account Schedule to Microsoft® Excel
Export Account Schedule to Excel
Lab: Posting an Entry to a Closed Year
Post a General Journal Entry to a Closed Year
Run the Close Income Statement Batch Job
After completing this chapter, students should be able to:
Analyze general ledger and
budget information from the chart of accounts
Create account schedules and view and print them
Export account schedules to Excel
Close the fiscal year
Enter transactions in closed fiscal years
Chapter 6: Financial Analysis Using Dimensions
This chapter examines the use of dimensions to analyze financial information.
We take a look at how to post by dimensions when entering transactions
through documents and journals. We discuss how to view information by
dimensions after the transactions have been posted. Exporting dimension
information to Excel is also covered. Time is also spent discussing additional
dimension setups.
Main Topics
Entering dimensions in journals and documents
Viewing posted dimension information
Analyzing financial information using dimensions
Exporting analysis views to Excel
Dimension setup
Lab: Creating an Analysis View
Create an Analysis View
Open the Analysis View in the Analysis By Dimensions window
Lab: Combining Analysis Views with Account Schedules
View Combinations of Analysis Views and Account Schedules
Lab: Exporting Analyses by Dimensions to Excel
Export an Analysis by Dimensions to Excel
Lab: Creating Single Default Dimensions
Create a Single Default Dimension
Lab: Creating Dimensions for Use in Documents
Add a New Dimension
Create a Transaction and Include the New Dimension
After completing this chapter, students should be able to:
Add dimensions to transactions
Create Analysis Views
View and analyze posted dimension information
Export Analysis by Dimension info to Excel
Setup Default Dimensions, Dimension Priorities, and Dimension Combinations
Chapter 7: XBRL
This chapter examines the XBRL- eXtensible Business Reporting Language
process of creating and exporting an XML file for external financial reporting.
We step through the importing of a taxonomy, the creation of a line definition,
and the exporting of the XML format file.
Main Topics
The purpose of XBRL – eXtensible Business Reporting Language
Importing a taxonomy
Entering XBRL Line Definitions
Exporting the XBRL Lines
Lab: Stock Exchange Reporting with XBRL
Import the Taxonomy
Create the Line Definition
Export the XBRL Lines
After completing this chapter, students should be able to:
Import an XBRL taxonomy
Enter XBRL Line Defintions
Copy from one taxonomy to another
Export the XBRL lines
Chapter 8: Budgeting
This chapter examines how to enter General Ledger Budgets. Entering budgets
by dimensions is discussed, and then we take a look at copying from one
budget to another. We also see how to Export and Import to and from Excel.
Main Topics
Creating a Budget
Entering a Budget with Dimension Filters
Copying a Budget
Exporting Budgets to Excel
Importing Budgets from Excel
Lab: Creating and Copying Budgets
Create a new Budget
Copy the Budget
After completing this chapter, students should be able to:
Create General Ledger Budgets
by dimensions
Enter Budgets for various period lengths
Drill down to see the budget line details
Copy from one budget to another
Copy from one period to another within the same budget
Export a budget to Excel
Import a budget from Excel
Chapter 9: Multicompany Operations
In this chapter we discuss the consolidation process for combining the
financial data of multiple companies. We walk through the steps required
for consolidations, including setup, consolidating the data, processing
eliminations, and printing consolidation reports.
Main Topics
Performing consolidations of multiple companies
After completing this chapter, students should be able to:
Add and setup a consolidated
company
Setup consolidation information for business units
Process elimination entries
Print consolidation reports
Chapter 10: VAT and Intrastat Reporting
This chapter examines the setup requirements and procedures for calculating
and reporting on VAT and Intrastat. We walk through all of the steps required
to process VAT on journals and sales and purchase documents, as well as
discussing VAT corrections and settlements. We take a look at the reports
that are available for VAT and Intrastat.
Main Topics
Manual VAT Calculation in Journals
VAT Calculation in Sales and Purchase Documents
Importing VAT
VAT Corrections
VAT Reporting
VAT Settlement
Unrealized VAT and Payment Discount VAT Adjustments
Intrastat Reporting
Lab: Manually Entering VAT in a Journal
Manually enter a VAT journal
Lab: Importing VAT
Set up the G/L VAT Account and VAT Posting Setup
Post the Import VAT using Journals and Documents
After completing this chapter, students should be able to:
Enter VAT in journals and documents
Enter corrections to VAT
Process VAT settlement
Print VAT and Intrastat reports
Chapter 11: Receivables Management
This chapter focuses on the receivables area of the Sales and Receivables
application. We examine the processing activities involved in the receivables
area. We take a look at receivables analysis, customer ledger entries,
payment discounts and tolerances, and reminders and finance charge memos.
Main Topics
Analyzing receivables
Applying customer ledger entries
Applying customer ledger entries in a foreign currency
Processing payment discounts
Setting payment tolerances
Processing reminders and finance charge memos
Lab: Exchange Rate Adjustment to Customer Transactions
Set up a new Customer
Post Invoices for the New Customer
Run Adjust Exchange Rates Batch Job
Lab: Detailed Customer Ledger Entries Example – Payment Discount
Enter a Cash Receipt
View the Detailed Customer Ledger Entries
Run the Balance to Date report
Lab: Applying a Cash Receipt to Multiple Invoices
Enter a Cash Receipt and Apply it to Multiple Invoices
Lab: Applying Entries after Posting
Post an Unapplied Cash Receipt
Apply the Cash Receipt to an Open Invoice
Lab: Foreign Currency Application Example
Post a Sales Journal with Invoices in Different Currencies
Enter the Cash Receipt and Apply it
Post the Journal
Lab: Apply customer entries with partial payments in different foreign
currencies
Enter and Post a Cash Receipt in the First Currency
Enter and Post a Cash Receipt in the Second Currency
Lab: Applying a Payment Involving Payment Discount Changes
Enter and Post an Unapplied Payment
Modify the Discount Information on the Customer Ledger Entries
Post the Application of the Payment
Lab: Setting Up Payment Tolerance for LCY
Set up the Payment Tolerance Settings
Set Up Payment Tolerance for Currencies
Posting and Applying with Payment Tolerance
Lab: Creating Reminders Automatically
Run the Create Reminders Batch Process
Lab: Creating Reminder Terms and Reminders
Create a Reminder Term
Enter a Reminder
Issue the Reminder
Lab: Creating Finance Charge Terms
Create a Finance Charge Term
Lab: Creating Finance Charge Memos
Create a Finance Charge Memo
Issue the Finance Charge Memo
After completing this chapter, students should be able to:
Analyze Receivables
Apply Customer Ledger Entries
Apply Customer Ledger Entries in different currencies
Process payment discounts
Set payment tolerances
Process reminders and finance charge memos
Chapter 12: Payables Management
This chapter focuses on the payables area of the Purchase and Payables
application. We examine the processing activities involved in the payables
area. We take a look at processing payments to vendors, payment discounts
and tolerances, and voiding checks.
Main Topics
Payment Journals
Payment Discounts
Voiding Checks
Lab: Manual Selection of Invoices for Payment
Manually Enter a Line in the Payment Journal
Lab: Paying Invoices and Taking Credit Memos
Run the Suggest Vendor Payments Batch Process
Lab: Using Vendor Priority and Available Amount (LCY)
Run the Suggest Vendor Payments Batch Process with Vendor Priority and
Available Amount
Change Vendor Priorities and rerun the Suggest Vendor Payments Process
Lab: Suggesting a Payment with a Discount
Enter and Post a Purchase Invoice with a Discount
Run the Suggest Vendor Payments Batch Process
Lab: Voiding Checks that have been Printed but not Posted
Run the Suggest Vendor Payments
Print Checks
Void a Check
Lab: Voiding Posted Checks – Financial Voiding of Checks
Run the Suggest Vendor Payments
Print a Check
Post a Check
Void a Check
After completing this chapter, students should be able to:
Process Payment Journals
Print and Post Checks
Process Payment Discounts
Void Checks
Chapter 13: System Security and System Maintenance
This chapter examines the security and maintenance required in Microsoft
Navision. We review the procedures required for setting up users and setting
security for users. Editing roles and permissions are covered. We discuss
how to set time/date limits for users and how to track user changes to
data. The Date Compression function is discussed as a means to reduce
the amount of data in the database. We also set up printer selections
for users and reports.
Main Topics
Security Setups
Changing Passwords
User Time Limits and the Time Register
Tracking User Changes to Data
Date Compression
Printer Selections
Lab: Creating Database Logins and Assigning Them Roles
Create database logins
Assign roles to the logins.
Lab: Creating a Microsoft® Windows Login
Create a windows login
Lab: Creating a Role
Create a new role
Lab: Setting up Time Limits for a User
Set up time limits on the User Setup
Turn on the Time Register for the user
Lab: Change Log Setup
Setup the Change Log
After completing this chapter, students should be able to:
Create user logins and passwords
Attach roles to users
Modify permissions on roles
Set user time limits
Track usage of users with the time register
Track user changes to data
Perform Date Compression to reduce the amount of data
Set up printer selections for users
For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100