Course 8637B:

Financials II in Microsoft Dynamics AX 4.0

Length:	2 Days
Published:	September 07, 2006
Language(s):	English, Chinese (Simplified), Danish, Dutch, French, German, Italian, Japanese, Portuguese (Brazil), Russian, Spanish
Audience(s):	Information Workers
Level:	200
Technology:	Microsoft Dynamics AX 4.0
Type:	Course
Delivery Method:	Instructor-led (classroom)

About this Course

This 2 day course explores the advanced financial functionality available in Microsoft Dynamics AX. Some of the topics covered include the set up and usage of budgeting, cash flow management, multi-currency, intercompany, and consolidated accounting. Additionally, students learn the multiple advanced payment options available in Microsoft Dynamics AX, XBRL taxonomy, collection letters and interest and year-end close functionality. This course is meant to be an extension of the Financials I - Microsoft Dynamics AX course by adding advanced topics to the base knowledge covered in Financials I.

Audience Profile

This course is intended for individuals on the implementation team, administrating or using the financial management modules in Microsoft Dynamics AX. This audience typically includes individuals tasked with assessing a customer's business needs and advising them on the use, configuration and customization of the application. Additionally, individuals responsible for training or supporting Microsoft Dynamics AX benefit from this course.

At Course Completion

After completing this course, students will be able to:

Understand how to set up and maintain budgets within Microsoft Dynamics AX.
Understand the cash flow functionality in Microsoft Dynamics AX.
Setup multicurrency and know how to create multicurrency transactions.
Understand the steps involved in using the Advanced Payments functionality within Microsoft Dynamics AX.
Understand how to set Intercompany accounting and create transactions in more than one company.
Understand the setup and steps involved in consolidating companies.
Understand the steps necessary to set up and process collection letters.
Understand how to create and use dimensions hierarchies.
Understand how to import and use XBRL taxonomy for financials statements.
Understand the processes available for a year end close within Microsoft Dynamics AX.

Course OutlineModule 1: Budgeting

The purpose of this chapter is to introduce students to the budgeting functionality within Microsoft Dynamics AX. Microsoft Dynamics AX uses a budget model/submodel setup and students learn how to set up each of these. Students are also shown how to use period allocation keys, generate and print budgets, copy and modify budgets and how to view budget data.

Lessons

Create Budget Models and Submodels
Create Period Allocation Keys
Enter Budget Numeric Data
Generate and Print Budgets
Additional Budgeting Functionality
Copy and Modify Budgets
View Budget Data

After completing this chapter, students will be able to:

Create budget models and submodels within Microsoft Dynamics AX.
Create period allocation keys.
Generate and print budgets.
Copy and modify budgets.
View budget data.

Module 2: Cash Flow Management

This chapter focuses on the cash flow functionality in Microsoft Dynamics AX. Every company needs to know how much cash they have available at any given time. Students learn how the modules interrelate to generate cash flow numbers. They also learn the steps involved in setting up cash flow forecasting as well as how to inquire and report on the cash flow transactions.

Lessons

Understand the 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
View On-line Data and Print Cash Flow Reports

After completing this chapter, students will be able to:

Identify and understand the relationship of cash flow and other modules.
Set up cash flow forecasting.
Define a cash flow forecast budget model.
Create cash flow transactions.
Calculate cash flow transactions.
View on-line data and print cash flow reports.

Module 3: Multi-Currency

The purpose of this chapter is to introduce students to the budgeting functionality This chapter focuses on the multi-currency capabilities of Microsoft Dynamics AX. Microsoft Dynamics AX has the ability to work with multiple currencies. Students learn how to set up multi-currency as well as the different options available such as the currency rounding and how to run exchange rate adjustments.

Lessons

Exchange Rate Adjustments
Accounts Receivable and Accounts Payable Exchange Rate Adjustment
Set Up Currency Rounding

After completing this chapter, students will be able to:

Make exchange rate adjustments.
Set up currency rounding.

Module 4: Advanced Payments

This chapter is dedicated to the processing and setup of advanced customer and vendor payments in Microsoft Dynamics AX. These advanced payments include bridging accounts, electronic vendor and customer payments, prepayments and bills of exchange. Students also learn several of the options available when setting up a method of payment.

Lessons

Create and Process a Bridging Account Methods of Payment
Set Up and Process Electronic Vendor Payments
Set Up and Process Electronic Customer Payments
Set Up and Process Prepayments
Set Up and Process Bills of Exchange
Set Up and Apply Ledger Accruals

After completing this chapter, students will be able to:

Set up Methods of Payment.
Set up and process the following advanced payments, including:
Bridging Accounts
Vendor and Customer Electronic Payments
Prepayments
Bills of Exchange
Ledger Accruals

Module 5: Intercompany Accounting

The focus of this chapter is the intercompany accounting functionality in Microsoft Dynamics AX. Since Microsoft Dynamics AX companies reside in the same database, intercompany functionality requires limited set up. Students learn the necessary steps involved in the setup as well as how to create journal transactions that affect more than one company's ledger.

Lessons

Review Posting Intercompany Transactions
Review Setup for Intercompany Accounting
Post an Intercompany Transaction
Trace an Intercompany Transactions

After completing this chapter, students will be able to:

Set up intercompany accounting.
Create an intercompany accounting transaction.
Trace an intercompany transaction.

Module 6: Consolidations

Lessons

Set Up Consolidation Company
Set Up a Subsidiary Company
Perform a Consolidation
Consolidation According to the FASB 52 Regulation
Consolidations Inquiry
View and Delete Consolidation Transactions

After completing this chapter, students will be able to:

Set up a consolidation company.
Set up a subsidiary company.
Perform a consolidation.
Understand how to perform a consolidations inquiry.
View and delete consolidation transactions.

Module 7: Collection Letters and Interest

This chapter explains how to set up, create and process collection letters and interest notes in Microsoft Dynamics AX. Although most customers pay their invoices on time, it is still necessary to have the ability to handle those invoices that are not paid by the due date. This chapter teaches students how to set up Microsoft Dynamics AX to handle these situations.

Lessons

Set Up and Create Collection Letters
Process Collection Letters
Set Up and Create Interest Codes

After completing this chapter, students will be able to:

Set up and create collection letters.
Process collection letters.
Set up and create interest codes.

Module 8: Dimension Hierarchy

This chapter explains the dimension hierarchy in Microsoft Dynamics AX. Financial figures must be analyzed through different financial dimensions as a supplement to voucher and account numbers. The implementation of dimension sets with hierarchies makes it possible to control the values entered in the system and thus ensures more reliable data. Students learn how to use the dimension hierarchy structure with Microsoft Dynamics AX.

Lessons

Overall Concept of Dimension Sets, Hierarchies, and Rules
Create a Dimension Set
Create a Dimension Subset
Activate Dimension Set Hierarchy
Create a Dimension Set Hierarchy
Create a Dimension Set Rule

Lab : Lab 8.1: Dimensions, Sets, Hierarchies and Rules

After completing this chapter, students will be able to:

Understand the concept of dimension sets, hierarchies, and rules.
Create a dimension set.
Create a dimension subset.
Activate a dimension set hierarchy.
Create a dimension set hierarchy and a dimension set rule.

Module 9: XBRL Taxonomy

This chapter explains the concept of XBRL taxonomy in Microsoft Dynamics AX. XBRL is a global financial reporting initiative undertaken by numerous ERP software companies and international accounting organizations. Students also learn the goal of XBRL, and how to import XBRL taxonomy, as well as how to create a reference to a row structure, and how to create an XBRL file from the financial statement.

Lessons

Concept of XBRL Taxonomy
Import XBRL Taxonomy.
Create a Reference to a Row Structure
Create an XBRL File from the Financial Statement

Lab : Lab 9.1: Import XBRL Taxonomy

Import XBRL Taxonomy

After completing this chapter, students will be able to:

Understand the concept of XBRL taxonomy.
Import XBRL taxonomy.
Create a reference to a row structure.
Create an XBRL file from the financial statement.

Module 10: Year-End Close

This chapter covers the year-end functionality in Microsoft Dynamics AX including the processes of creating and closing fiscal years. At year end, it is always necessary to make adjustment entries that reflect transactions from the previous year. Also, a new fiscal year must be created and opening balances must be transferred. Students learn the options available for closing a fiscal year in Microsoft Dynamics AX.

Lessons