Course Details

Microsoft Dynamics Financials Corporate Online Training

Microsoft Dynamics Financials Course Content:

Financials I in Microsoft Dynamics AX 2009 

Module 1: General Ledger Setup 

This module explains how to set up the General Ledger in Microsoft Dynamics AX. It shows how to set up a company currency, additional currencies, and exchange rates. It also explains how to create periods, a new fiscal year, dimension value, and a dimension focus. 

Lessons 

• Currency and Exchange Rate Setup 
• Periods and Fiscal Year Setup 
• Date Intervals 
• Reason Codes 
• Dimensions 
• Dimension Focus 
• Generated Allocations 

Module 2: Chart of Accounts 

This module explains how to set up the Chart of Accounts. It also shows how to create and set up account allocation terms, system accounts, and view inquiries and reports about the Chart of Accounts. 

Lessons 

• Ledger Account Categories 
• Chart of Accounts 
• Account Allocation Terms 
• System Accounts 
• Inquiries and Reports Related to the Chart of Accounts 

Module 3: Journal Setup 

This module explains how to set up Journals. It shows how to create and work with journal names, journal controls, journal texts, and how to set up balance control accounts, and General Ledger parameters. 

Lessons 

• Journal Setup 
• Journal Controls 
• Journal Texts 
• Balance Control Accounts 
• General Ledger Parameters 

Module 4: Financial Features 

This module explains how to use features that can be used across the finacial series. It shows how to create, modify, and delete reason codes, and how to use the Fill Utility. 

Lessons 

• Reason Codes 
• Fill Utility 

Module 5: General Ledger Daily Procedures 

This module explains how to enter transactions in the General Ledger. It shows how to create general journals, enter and post General Ledger journal transactions, post multiple journals, create approval journals, period journals, and retrieve period journals. It also explains General Ledger transaction reversal and the inquiry and reports about General Ledger journal transactions. 

Lessons 

• Create General Ledger Journals 
• Enter General Ledger Journal Transactions 
• Create Journal Batch Processing 
• Create Approval Journals 
• Create and Use Voucher Templates 
• Create and Retrieve Periodic Journals 
• General Ledger Transaction Reversal 
• Create and Use General Ledger Reversing Entries 
• Inquire and Report on Daily Journal Transactions 

Module 6: Sales Tax Setup 

This module explains how to set up sales tax. It also explains how to set up the different components of sales tax, and sales tax exempt data, and how to calculate and post withholding sales tax. 

Lessons 

• Sales Tax Overview 
• Create Ledger Posting Groups 
• Create Sales Tax Authorities 
• Create Sales Tax Settelements Periods 
• Create Sales Tax Codes 
• Create Sales Tax Codes Intervals 
• Create Sales Tax Group 
• Use Sales Tax Jurdisdictions 
• Create Sales Tax Transactions 
• Create Sales Tax Exempt Data 
• Calculate and post withholding Sales Tax 

Module 7: Bank Management Setup 

This module explains how to set up the Bank module in Microsoft Dynamics AX. Logically, a bank account is needed before you create a check to pay an invoice. This chapter explains how to set up bank transaction types and transaction groups, bank groups, and bank parameters. It also explains how to create a bank account, and defines the check layout for a bank account. 

Lessons 

• Bank Transaction Types 
• Bank Transaction Groups 
• Bank Management Parameters 
• Payment Purpose Codes 
• Bank Groups 
• Bank Accounts 
• Check Layout 

Module 8: Accounts Payable Setup 

This module explains how to set up Accounts Payable within Microsoft Dynamics AX. It explains the importance of setting up vendor groups and posting profile, and shows the different Accounts Payable setup option, procedures, and defaults related to vendor payments. 

Lessons 

• Payment Schedule 
• Terms of Payment 
• Payment Days 
• Cash Discount 
• Payment Fee 
• Methods of Payment 
• Vendor Groups 
• Accounts Payable Posting Profiles 
• Account payable vendors 

Module 9: Accounts Payable Daily Procedures 

This module explains the various journals available in Microsoft Dynamics AX Accounts Payable. It describes what each journal is used for and how transactions are entered into each journal. 

Lessons 

• Invoice Journals in Accounts Payable 
• Invoice Register 
• Invoice Approval Journal 
• Invoice Pool Excluding Posting 
• Invoice Journal 
• Voucher Template 
• Payment Journals 
• Invoice Matching 
• Edit Open Transactions 
• Reverse a Closed Transaction 
• Print Management 

Module 10: Accounts Receivable Setup 

This module explains how to set up the Accounts Receivable module in Microsoft Dynamics AX. The set up of Accounts Receivable is almost a mirror image of the set up of Accounts Payable. The main topics covered are specific to Accounts Receivable or are covered as a review from Accounts Payable. 

Lessons 

• Payment Schedule 
• Terms of Payment 
• Payment Days 
• Cash Discount 
• Payment Fee 
• Methods of Payment 
• Customer Groups 
• Accounts Receivable Posting Profiles 

Module 11: Accounts Receivable Daily Procedures 

This module explains the journals available for invoice entry within Accounts Receivable. Students learn how to enter a free text invoice (non-inventory) invoice and the payment journal. 

Lessons 

• Customer Process Overview 
• Create a Free Text Invoice 
• Create a Payment Journal 
• Edit open Transactions 
• Place a Transaction on Hold 
• Reverse Settelements 
• Reimburse a customer 
• Use Reasons Codes in Accounts Receivable 
• Work with Print Management in Accounts Receivable 

Bank Management Daily Procedures 

This module explains the various procedures available to manage bank transactions in Microsoft Dynamics AX. 

• Create Checks 
• Delete Checks. 
• Deposit Slips 
• Void Unposted Checks 
• Refund Checks 
• Bank Remmintance 
• Payment Reversal 
• Reconcile a Bank Account 

Financials II in Microsoft Dynamics AX 2009 

Module 12: 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 

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 
• Setup Cash Flow Forecasting 
• Define a Cash Flow Forecast Budget Model 
• Create Cash Flow Transactions 
• 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 

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 

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 

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 

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 

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 

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 a XBRL 
• Create an XBRL File from the Financial Statement 

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 

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 
• Fixed Assets in Microsoft Dynamics AX 2009 

Module 1: Introduction 

This module explains the basic Fixed Assets concepts and components. It also describes the integration between Fixed Assets and the General Ledger, Accounts Payable, Accounts Receivable, and Inventory Management modules. 

Lessons 

• Fixed Assets Overview 
• Functionality That Is Required for Fixed Asset Accounting 
• Structure and Integration With Other Modules 

Module 2: Setup Procedures 

This module explains how to perform the necessary setup of the system and the Fixed Assets module. It also describes some country specific setup requirements. 

Lessons 

• System Setup for Fixed Assets 
• Fixed Assets Module Setup- Depreciation Profiles, Asset Calendars and Depreciation Books 
• Fixed Assets Module Setup- Value Models, Asset Groups, Disposal and Posting Profiles 
• Fixed Assets Module Setup- Parameters 
• Capitalization Threshold- Fixed Assets 
• Parameters- Purchase Orders Field Group 
• Reason Codes in Fixed Assets 
• Depreciation Methods 
• Depreciation Conventions 
• Depreciation Books Overview 
• Extended Functionality Features - Provision Types and Bonus Depreciation 
• Mass Update Depreciation Conventions for a Depreciation Book 
• Country and Region Specific Features 

Module 3: Setup of Assets 

This module explains how to set up the company’s fixed assets in the application. It also covers lending assets, assigning bar codes to assets, and budgeting with assets. Project module integration will also be discussed. 

Lessons 

• Fixed Asset Form 
• Setting Up Assets in the Fixed Asset Module 
• Inquiries In The Fixed Assets Form 
• Inquiries In The Depreciation Book Form 
• Lending Assets 
• Assigning Bar Codes to Assets 
• Asset Budgeting 
• Project Module Integration to Fixed Assets 

Module 4: Asset Transactions 

This module explains how to use and record different Fixed Assets transaction types. It covers acquisition, depreciation, value adjustments, and disposal. Procedures for creating and acquiring fixed assets using Accounts payable Purchase orders are also discussed. Maintenance of asset transactions is explained, such as transaction reversal, updating replacement costs and insured values, copying fixed assets and changing groups, and fixed asset additions. 

Lessons 

• Typical Fixed Asset Transaction Types 
• Recording Asset Transactions - Acquisitions 
• Creating and Acquiring Fixed Assets From Purchase Orders in Accounts Payable 
• Recording Asset Transactions - Depreciation 
• Recording Asset Transactions - Value Adjustments 
• Recording Asset Transactions - Disposals 
• Other Asset Transactions 
• Transaction Reversals - Fixed Assets 
• Replacement Cost and Insured Value Update 
• Copying Fixed Assets and Changing Fixed Asset Groups 
• Fixed Asset Additions 

Module 5: Inquiries and Reports 

ReportsThis chapter explains how to create and view the inquiries and reports available in the Fixed Assets module. 

Lessons 

• Inquiries 
• Reports