80220 Financials II in Microsoft Dynamics AX 2012

Code: 80220
Course duration: 3 days
Price:

80220: Financials II in Microsoft Dynamics AX 2012

About this Course
This course explores topics such as the setup and usage of budgeting, cash flow management, multicurrency, intercompany, and consolidated accounting. Additionally, students learn about the multiple advanced payment options, how to produce customer account statements, collection letters, complete year-end close functionality, and produce financial statements. This course is an extension of the Financials I course.

Audience Profile
This course is intended for partners, customers and other end users of the financial modules in Microsoft Dynamics AX.

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

  • Set up Basic Budgeting and configure Budget Controls.
  • Enter Budget Data.
  • Define an Encumbrance and complete year-end Commitments.
  • Set up Cash Flow Forecasting and create and calculate Cash Flow transactions.
  • Set up and run Foreign Currency Revaluation.
  • Set up and process Advanced Payments.
  • Set up Intercompany Accounting and post and trace Intercompany transactions.
  • Set up Consolidation and Subsidiary Companies.
  • Print Customer Statements, process Collection Letters, set up Interest Codes and calculate Interest.
  • Define Workflows and create financial module Approvals.
  • Complete Year-End steps and procedures.
  • Create and print Financial Statements.

Course Outline

Module 1: Budgeting
This module discusses the concepts of budgeting, how to set up basic budgeting and budget controls including budgeting rules and attributes.

Lessons

  • Budgeting Overview
  • Basic Budgeting Setup
  • Budget Control
  • Configuring Budget Control

After completing this module, students will be able to:

  • Set up Basic Budgeting.
  • Discuss the use of Budget Control.
  • Define Rules and specify Attributes of Budget Control.

Module 2: Use and Manage Budgets
This module examines how to view the status and history of a budget. The process for using budget control on source documents and accounting journals is also discussed.

Lessons

  • Budget Amounts
  • Using Budget Control
  • Budget Reporting and Inquiries
  • Budget Transaction Web Services
  • Integrated Budgeting
  • Transfer Budgets To and From General Ledger

Lab : Create and Manage Budgets
Lab : Create a Budget Transfer
Lab : Use Budget Control on a Purchase Order

  • Create Budget Register Entries
  • Use Budget Control on a Purchase Order

After completing this module, students will be able to:

  • Describe how to enter Budget data.
  • Describe how to use Budget data on a Purchase Order.
  • View the status of Budget register entries.
  • Inquire about Budgets.
  • Describe the features to support transferring Budget data.
  • Review Budgeting Integrations.
  • Describe the steps to transfer a Budget.

Module 3: Commitment Accounting
This module discusses the process of defining an encumbrance and creating a purchase order encumbrance. It also discusses the entry and analysis of an encumbrance transaction and the processing of year-end commitments.

Lessons

  • Defining Purchase Order Encumbrances
  • Setting Up Encumbrances
  • Purchase Order Encumbrance Transactions
  • Encumbrance Year-End Process

After completing this module, students will be able to:

  • Define an Encumbrance.
  • Create a Purchase Order Encumbrance.
  • Analyze a Purchase Order Encumbrance Transaction.
  • Process Year-End Commitments.

Module 4: Cash Flow Management
This module discusses the relationship of cash flows to modules in Microsoft Dynamics AX. It discusses how to set up cash flow forecasting and define a cash flow forecast budget model. It also demonstrates how to create and calculate cash flow transactions.

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

After completing this module, students will be able to:

  • Explain 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 online data and print Cash Flow reports.

Module 5: Multicurrency
This module discusses the setup required for foreign currency revaluation. It also discusses how to run revaluation in different modules in Microsoft Dynamics AX.

Lessons

  • Setup
  • Foreign Currency Revaluation
  • Accounts Receivable and Accounts Payable Exchange Rate Adjustments

Lab : Accounts Receivable Foreign Currency Revaluation

  • Review the Customer Information
  • Verify each Currency has an Exchange Rate Set Up
  • Run the Exchange Rate Adjustment
  • Review the Customer Information for any Updates

After completing this module, students will be able to:

  • Complete the setup steps that are required for Foreign Currency Revaluation.
  • Run Foreign Currency Revaluation in General Ledger.
  • Run Foreign Currency Revaluation in Accounts Receivable and Accounts Payable.

Module 6: Advanced Payments
This module describes the processing and setup of advanced customer and vendor payments in Microsoft Dynamics AX including bridging accounts, electronic payments, centralized payments, bills of exchange and prepayments.

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

After completing this module, students will be able to:

  • Create and process a Bridging Account Method of Payment.
  • Set up and process Electronic Vendor Payments.
  • Set up and process Electronic Customer Payments.
  • Set up and process Centralized Payments.
  • Set up and process Prepayments.
  • Set up and process Bills of Exchange.
  • Set up and apply Ledger Accruals.

Module 7: Intercompany Accounting
This module introduces the concepts of intercompany accounting. Topics discussed in this course include the review and posting of intercompany transactions, the setup of for intercompany accounting, and how to trace an intercompany transaction.

Lessons

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

Lab : Enter and Post an Intercompany Transaction
Lab : Trace an Intercompany Transaction

After completing this module, students will be able to:

  • Post an Intercompany Transaction.
  • Complete the setup for Intercompany Accounting.
  • Trace an Intercompany Transaction.

Module 8: Consolidations
This module discusses the capabilities of Microsoft Dynamics AX to consolidate subsidiary companies into a single consolidated company. Topics that are covered include how to set up a subsidiary company, setup of a consolidated company and how to perform a consolidation.

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

  • Review the General Ledger Parameter.
  • Designate the System Account.
  • Define the Consolidation Exchange Rates.

Lab : Perform a Consolidation

After completing this module, students will be able to:

  • Set up a Consolidation Company.
  • Set up a Subsidiary Company.
  • Perform a Consolidation.
  • View the Consolidation Inquiry.
  • View and Delete Consolidation Transactions.
  • Describe Intercompany Eliminations.

Module 9: Collections Management
This module describes how to set up and process customer statements, collection letters and interest notes to help in the collection process.

Lessons

  • Customer Account Statement
  • Set Up Collection Letters
  • Process Collection Letters
  • Set Up Interest Codes
  • Calculate Interest
  • Managing Collections and Collection Agents
  • View and Manage Collections Information
  • Advanced Collections Management Tasks

Lab : Set Up a Collection Letter

  • Set the Accounts Receivable Parameters
  • Create and Define a Collection Letter Sequence
  • Attach the Collection Letter Sequence to a Posting Profile

Lab : Collection Letter

  • Create a Collection Letter
  • Review, Print, and Post the Collection Letter

Lab : Set Up an Interest Code

  • Create an Interest Code
  • Attach the New Interest Code to the Posting Profile
  • Check the Accounts Receivable Parameters

Lab : Manage the Collections Process

  • Update the Customer Aging Snapshot
  • Update the Status of the Invoice
  • Send an Email including the Customer Statement

After completing this module, students will be able to:

  • Print Customer Statements.
  • Set up and create Collection Letters.
  • Process Collection Letters.
  • Set up Interest Codes.
  • Calculate Interest.
  • Work with the Collections List Page and Detail Forms.
  • Waive, reinstate or reverse Interest and Fees in one step.
  • Create Write-off transactions in one step.
  • Process Non-Sufficient Funds payments in one step.

Module 10: Financial Workflows
This module describes how to set up one or more workflow configurations, select a configuration and activate workflow.

Lessons

  • Workflow Types
  • Workflow Configurations
  • Workflow Approvals
  • General Ledger Workflow
  • Accounts Payable Workflow
  • Accounts Receivable Workflow
  • Managing Workflows

After completing this module, students will be able to:

  • Define Workflow Types.
  • Configure Financial Workflows.
  • Define Approval Processes.
  • Create a General Ledger Approval.
  • Create an Accounts Payable Approval.
  • Create an Accounts Receivable Approval.
  • Modify an Existing Workflow.

Module 11: Year-End Close
This module discusses the year-end processes necessary in Microsoft Dynamics AX. Topics covered in this course include creating a new fiscal year, how to hold or close a period, create a closing sheet and setting up fiscal year parameters.

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

After completing this module, students will be able to:

  • Create a new Fiscal Year.
  • Understand Control Transactions in a Closing Period.
  • Hold or Close a Period.
  • Create a Closing Sheet.
  • Make Adjustments or Transfers between Accounts.
  • Transfer Opening Balances.
  • Set up Fiscal Year Parameters.

Module 12: Financial Statements
This module discusses the steps and processes to create a financial statement in Microsoft Dynamics AX. Topics covered include creating row and column definitions, creating and printing financial statements, and creating and printing dimension statements.

Lessons

  • Financial Statement Setup
  • Financial Statement Row Definition
  • Financial Statement Column Definition
  • Print a Financial Statement
  • Create a Balance Sheet
  • Dimension Reports
  • XBRL Taxonomy

After completing this module, students will be able to:

  • Create a Financial Statement.
  • Create a Row Definition.
  • Design the structure of a Row Definition.
  • Create a Column Definition.
  • Print a Financial Statement.
  • Create and print a Dimension Statement.
  • View Balances by Dimension Sets.
  • Import XBRL Taxonomies.



Before attending this course, students must have:
Completed Course 80219A, Financials I in Microsoft Dynamics AX 2012. Working knowledge of Microsoft Dynamics AX. Grasp of basic accounting knowledge and terms.

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