This two-day instructor-led collection explores the advanced financial functionality of Microsoft Dynamics AX. Some topics that are covered include the setup and usage of budgeting, cash flow management, multicurrency, intercompany, and consolidated accounting. Additionally, students learn multiple advanced payment options, XBRL taxonomy, customer account statements, collection letters, interest, year-end close functionality, and financial statements. This course is an extension of the Microsoft Dynamics AX 2009 Financials I collection.

Course Outline

Module 1: Budgeting
Budgets are tools that are used to predict what the results of operations will be for a company. In addition, they can be used to compare actual and predicted (budgeted) results, to evaluate the effectiveness of operations.
Lessons

• Create a Budget Model
• Period Allocation Keys
• Enter Budget Numeric Data
• Generate a Ledger Budget Report
• Apply Setup Features to the Budget
• Simulate Budgets
• Edit Budgets
• Budget Revisions
• View Budget Data and Reports

Lab : Create a Budget Model

Lab : Create Period Allocation Keys Using the Wizard

Lab : Enter and Generate a Budget

Module 2: Cash Flow Management
Cash flow forecasting is used to estimate the company's future need for cash.
Lessons

• Relationship of Cash Flow to Other Modules
• Set Up Cash Flow Forecasting
• Define a Cash Flow Forecast Budget Model
• Create Cash Flow Transactions
• Calculate Cash Flow Transactions

Lab : Set Up a Ledger Account for Cash Flow Forecasting

Lab : Set Up a Dependent Ledger Account

Lab : Create a Budget Entry to Include in Cash Flow

Lab : Calculate Cash Flow Transactions

Module 3: Multicurrency
Microsoft Dynamics AX 2009 works with multiple currencies and provides several methods to meet the accounting requirements in different countries. The basics of setting up currencies and exchange rates are covered in the Financials I collection. This course describes advanced currency topics such as exchange rate adjustments. Exchange rates constantly fluctuate; therefore, exchange rate adjustments are necessary for correct periodic accounting. If they are not periodically adjusted to reflect the current rates, foreign amounts converted and posted to the General Ledger, and displayed in reports can be misleading.
Lessons

• Setup
• Exchange Rate Adjustments
• Accounts Receivable and Accounts Payable Exchange Rate Adjustments

Lab : Accounts Receivable Exchange Rate Adjustment

Module 4: Advanced Payments
This module describes the processing and setup of advanced customer and vendor payments. These advanced payments include bridging accounts, electronic payments, bills of exchange, and prepayments. Also included are several of the options available when setting up a method of payment, and how to use the ledger accrual functionality to defer costs or income throughout the year.
Lessons

• Bridging Accounts
• Electronic Vendor Payments
• Electronic Customer Payments
• Centralized Payments
• Prepayments (Deposits)
• Bill of Exchange Administration

Ledger Accrual

Lab : Bridging Accounts

Lab : Prepayments Setup

Lab : Ledger Accrual

Module 5: Intercompany Accounting
Intercompany accounting may be used when accounting processes are centralized for subsidiaries or branch offices. With Intercompany accounting, a single entry can be made which posts to multiple companies.
Lessons

• Post Intercompany Transactions
• Intercompany Posting Setup Demonstration
• Post an Intercompany Transaction Demonstration
• Trace an Intercompany Entry Demonstration

Lab : Enter and Post an Intercompany Transaction

Lab : Trace an Intercompany Transaction

Module 6: Consolidations
This module demonstrates the functionality and flexibility of Microsoft Dynamics AX 2009 in consolidating subsidiary companies into a single consolidated (parent) company. Some key features include the ability to consolidate companies whether they reside in the same database or in different databases, map the Chart of Accounts and dimensions in a subsidiary to the consolidated company, specify how the exchange rate should be calculated for the consolidation, and designate the percentage of ownership that should roll into the consolidated company from the subsidiary.
Lessons

• Set Up a Consolidation Company
• Set Up a Subsidiary Company
• Perform a Consolidation
• Consolidations Inquiry
• View and Delete Consolidation Transactions
• Intercompany Eliminations

Lab : Set Up a Consolidation Company

Lab : Perform a Consolidation

Lab : Consolidations Inquiry

Lab : View and Delete Consolidation Transactions

Module 7: Customer Account Statement, Collection Letter, and Interest
This module demonstrates three processes that are useful in the collection process. Customer account statements are used to provide an accounting of all amounts due from a customer for a period of time. Although most customers pay their invoices on time, it is necessary to be able to process invoices that are not paid by their due date. Collection letters and interest notes can be used for these situations.
Lessons

• Customer Account Statement
• Set Up Collection Letters
• Process Collection Letters
• Set Up Interest Codes
• Calculate Interest

Lab : Set Up a Collection Letter

Lab : Collection Letter

Lab : Set Up an Interest Code

Lab : Calculate Interest

Module 8: Dimension Hierarchies

Financial figures must be analyzed through different financial dimensions as a supplement to voucher and account numbers. However, it can be difficult to control the assignation of financial dimension values. Sometimes dimension values are assigned to the wrong financial transactions making reports and statistics incorrect. The implementation of dimension sets with hierarchies makes it possible to control the values entered in the system and therefore ensures more reliable data.
Lessons

• Dimension Sets, Hierarchies, and Rules
• Dimension Sets
• Dimension Subsets
• Dimension Set Hierarchy
• Dimension Set Rules

Lab : Dimensions, Sets, Hierarchies, and Rules

Module 9: XBRL Taxonomy
XBRL is a global financial reporting initiative started by numerous ERP software companies and international accounting organizations. The goal of XBRL is to provide a standard for uniform reporting of financial information for banks, investors and government authorities.
Lessons

• XBRL Taxonomy
• Import XBRL Taxonomy
• Create an XBRL File from the Financial Statement

Lab : Import XBRL Taxonomy

Module 10: Year-End Close
This module describes the year-end functionality in Microsoft Dynamics AX 2009 and provides assistance in the processes for creating and closing fiscal years. At year-end, it is always necessary to make adjustment entries that reflect transactions from the previous year, print reports, including Financial Statements, back up data, create a new fiscal year, and transfer opening balances.
Lessons

• Create a New Fiscal Year
• Control Transactions in a Closing Period
• Create and Post a Closing Sheet
• Transfer Opening Balances

Lab : Year-End Close

Module 11: Financial Statements
The Financial Statement feature in Microsoft Dynamics AX 2009 enables the building of a custom reporting structure. It is a powerful reporting tool that explores financial figures depicted in a company context and from a business perspective.
Lessons

• Dimension Focus
• Financial Statement Row Definition
• Financial Statement Column Definition
• Print a Financial Statement
• Demonstration: Create a Balance Sheet
• Dimension Reports and Inquiries

Lab : Create and Print a Financial Statement

Lab : Create a Dimension Statement

 

Trajanje: 2 dni
Lokacija: Housing, Vodovodna 100, Ljubljana
Cena: 820 EUR + DDV/dan

Prijava in informacije: trzenje@housing.si

Prijava na tečaje je možna samo za registrirane uporabnike.

O predavatelju:

Pieter Thijsse Claase
Microsoft Certified Business Management Solutions Professional (Master) since 2004.
Microsoft Certified Trainer since 2004.

Certified on: Dynamics AX Finance, Trade&Logistics, Projects, HRM, CRM, Questionnaire.
Worked recently with customers in the retail, financial services and construction industry.
Working with Dynamics AX since 2001.
Worked with Dynamics NAV in 2004 and 2005.

Created course 80016, Dynamics AX 2009 Finance Localized Dutch Functionality published by Microsoft and created course 8752, Dynamics AX 40 Finance Localized Dutch Functionality published by Microsoft.
Created and rolled out the what's new training of Dynamics AX 2009, AX 4.0 and NAV 4.0 in The Netherlands and Belgium
Pieter Thijsse Claase’s Specialties:
Highly experienced on Dynamics AX.
Highly experienced in knowledge transfer.
Good teammanaging skills.
Optimizing business processes in companies working with Dynamics AX

Audience Profile
This collection is intended for people on the implementation, training, or support teams or those who administer or use the financial management modules.

At Course Completion
After completing this course, students will be able to:

• Set up and maintain budgets.
• Understand cash flow functionality.
• Set up and maintain multicurrency.
• Understand advanced payment functionality.
• Set up and process intercompany accounting.
• Setup and process company consolidations.
• Set up and process customer account statements, collection letters, and interest.
• Create and use dimension hierarchies.
• Import and use XBRL taxonomy.
• Perform a year-end close.
• Set up and print financial statements.