Course 80338A: Microsoft Dynamics® AX 2012 Public Sector - Financials

Type:Course
Audience(s):information workers
Technology:Microsoft Dynamics AX
Level:200
This Revision:A
Delivery method:
Instructor-led (online)
Length:2 days
Language(s):English, French

First published:

17 November 2011
Overview
About this course
This two-day instructor-led course, Microsoft Dynamics® AX 2012 Public Sector-Financials, provides students with the necessary tools and resources to perform advanced tasks using Microsoft Dynamics AX 2012 Public Sector.  
Audience profile
The intended audience includes partners and customers who want to learn the features and develop a working knowledge of the typical bookkeeping and accounting processes that are required to effectively use Microsoft Dynamics AX 2012 Public Sector.
The class is also suitable for accounting managers, accountants, bookkeepers, accounts payable and receivable managers, budgeting managers, project managers, and other people in public sector organizations responsible for the setup and administration of various accounting functionalities.
At course completion
After completing this course, students will be able to:
  • Describe the features of Microsoft Dynamics AX 2012 Public Sector.
  • Set up the account structures and financial dimensions for the organization.
  • Perform financial budget-related activities in the Budgeting module.
  • Perform activities related to commitment accounting, transactions, and line amounts in the General ledger module.
  • Perform activities related to purchases, invoices, and vendor details in the Procurement and sourcing and Accounts payable modules.
  • Perform activities related to payments due in the Accounts receivable module.
  • Perform project accounting activities in the Project management and accounting module.
  • Describe Role Centers and generate public sector-related reports.
Course details
Course OutlineModule 1: Overview
This module provides a general overview of public sector accounting requirements and the features of Microsoft Dynamics AX 2012 Public Sector.
Lessons
  • Introduction
  • Public Sector Requirements
  • Microsoft Dynamics AX 2012 Public Sector Features
  • Microsoft Dynamics AX 2012 Public Sector License
  • Describe the requirements of the public sector industry.
  • Describe features of Microsoft Dynamics AX 2012 Public Sector.
  • Verify the Microsoft Dynamics AX 2012 Public Sector license.
Module 2: Account Setup
This module concentrates on how to set up the account structures and financial dimensions for the organization.
Lessons
  • Introduction
  • Overview of General Ledger Setup
  • Configure Account Structures
  • Create Financial Dimensions
  • Set Up a Chart of Accounts
Lab : 2.1:Create a Fund EntityLab : 2.2: Set Up a Chart of Accounts
  • Set up fiscal calendars and a fiscal year.
  • Set up posting definitions.
  • Configure account structures.
  • Describe financial dimensions.
  • Create a financial dimension and a fund entity.
  • Plan a Chart of Accounts and set up accounts in the Chart of Accounts.
  • Create bank accounts.
  • Assign a fund entity to an account.
Module 3: Budgeting
This module concentrates on how to create budgets and use budget control.
Lessons
  • Introduction
  • Budgeting Overview
  • Configure Budget Control
  • Create an Original Budget
  • Work with Budgets
  • Use Budget Control
  • Process a Provisional Budget
  • Process an Apportionment Budget
  • Budget Reporting
Lab : 3.1: Configure Budget ControlLab : 3.2: Process a Provisional BudgetLab : 3.3: Post an Apportionment Budget
  • Describe budgeting terms and budgeting basics.
  • Explain budget control and set up budget control parameters.
  • Set up over budget permissions and define the budget funds available calculation.
  • Select source documents and journals for budget control.
  • Assign budget models and define budget control rules.
  • Select main accounts for budget control and define budget groups and message levels.
  • Activate budget control.
  • Enable budget appropriations.
  • Create budget register entries and allocate budget amounts across dimension values and periods.
  • Revise and transfer a budget.
  • View the status and history of budget register entries.
  • Describe execution of budget reservations against the budget.
  • Perform budget control.
  • Post, reverse, and perform budget control on a provisional budget.
  • Define an apportionment budget code.
  • Create and perform budget control on an apportionment budget.
  • Describe the Actual versus budget, Budget funds available, Budget details, Budget control account detail history, and Budget control activity by project reports.
  • Describe budgeting terms and budgeting basics.
  • Explain budget control and set up budget control parameters.
  • Set up over budget permissions and define the budget funds available calculation.
  • Select source documents and journals for budget control.
  • Assign budget models and define budget control rules.
  • Select main accounts for budget control and define budget groups and message levels.
  • Activate budget control.
  • Enable budget appropriations.
  • Create budget register entries and allocate budget amounts across dimension values and periods.
  • Revise and transfer a budget.
  • View the status and history of budget register entries.
  • Describe execution of budget reservations against the budget.
  • Perform budget control.
  • Post, reverse, and perform budget control on a provisional budget.
  • Define an apportionment budget code.
  • Create and perform budget control on an apportionment budget.
  • Describe the Actual versus budget, Budget funds available, Budget details, Budget control account detail history, and Budget control activity by project reports.
Module 4: General Ledger
This module focuses on functionalities in the General ledger module. It discusses the various activities related to commitment accounting, distributing of line amounts, and modifying transactions. Additionally, steps to perform general ledger year-end activities are discussed.
Lessons
  • Introduction
  • Distribute Line Amounts across Ledger Accounts
  • Advanced Ledger Entries
  • Commitment Accounting
  • Perform Encumbrance Year-End Processes
  • Perform General Ledger Year-End Processes
Lab : 4.1: Distribute Line Amounts across Ledger AccountsLab : 4.2: Perform Commitment AccountingLab : 4.3: Perform General Ledger Year-End Processes
  • Distribute line amounts across ledger accounts.
  • Describe the setup of advanced ledger entries.
  • Create, preview, and post advanced ledger entries.
  • Describe commitment accounting.
  • Record general ledger pre-encumbrances for a purchase requisition.
  • Record general ledger encumbrances for a purchase order.
  • Set up encumbrance year-end processing options.
  • Define close and open transaction posting definitions for encumbrance year-end processing.
  • Define a default encumbrance year-end process for a specific fund.
  • Describe general ledger year-end processes.
  • Set a closing type on accounts.
  • Define close and open transaction posting definitions for general ledger year-end processing.
  • Process "nominal" accounts and ending balances of "real" accounts.
Module 5: Procurement and Accounts PayableThis module focuses on purchase-, invoice-, and vendor-related activities. It explains steps for creating and invoicing purchase agreements, confirming an unplanned purchase, and invoicing payments to various vendor bank accounts. It also discusses setting up 1099 information and assigning a DUNS+4 number for vendors.Lessons
  • Introduction
  • Manage Purchase Agreements
  • Manage Unplanned Purchases
  • Purchase Order Year-End Processing
  • Invoice a Purchase Agreement without a Release Order
  • Track and Report 1099 Information
  • Assign a New DUNS+4 Number
  • Disburse Invoice Payments to Multiple Vendor Bank Accounts
Lab : 5.1: Manage Purchase AgreementsLab : 5.2: Create a Confirming Purchase OrderLab : 5.3: Generate 1099-S Tax Reports
  • Enable information on purchase agreements by classification.
  • Set up confirming PO codes and message text.
  • Flag a purchase order as confirming.
  • Print a purchase order with a special message.
  • Run the purchase order year-end process.
  • Invoice a purchase agreement without a release order.
  • Set up 1099 information for a vendor.
  • Pay an invoice with 1099 information.
  • Process a 1099 tax statement.
  • Assign a DUNS+4 number to multiple vendor bank accounts.
  • Disburse an invoice payment to different vendor bank accounts.
Module 6: Accounts Receivable
This module explains how to set up billing codes and classifications. It also  focuses on processing invoices, payments, dunning documents according to a billing classification, processing settlements in a pooled cash scenario, and  how to add attributes for customer reporting.
Lessons
  • Introduction
  • Set Up Billing Codes
  • Set Up Billing Classifications
  • Process Free Text Invoices by Billing Classification
  • Process Recurring Invoices by Billing Classification
  • Process Payments by Billing Classification
  • Process Dunning Documents by Billing Classification
  • Process Settlements in a Pooled Cash Setup
  • Add Customer Attributes
Lab : 6.1: Set Up Billing CodesLab : 6.2: Create a Free Text Invoice Using a Billing CodeLab : 6.3: Set Up Billing ClassificationsLab : 6.4: Process Free Text Invoices by Billing ClassificationLab : 6.5: Process Recurring Invoices by Billing ClassificationLab : 6.6: Process and Settle Payments by Billing ClassificationLab : 6.7: Process Reimbursements by Billing ClassificationLab : 6.8: Process Dunning Documents by Billing ClassificationLab : 6.9: Use Customer Reporting Attributes
  • Describe the features of billing codes and create a billing code.
  • Create a free text invoice by using a billing code.
  • Create a billing classification and associate a billing code with a billing classification.
  • Set a classification settlement order.
  • Post and print a free text invoice by billing classification.
  • Post and print a recurring invoice by billing classification.
  • Enter a customer payment by selecting a billing classification.
  • Create a payment proposal based on a selected billing classification.
  • Generate a reimbursement transaction by billing classification.
  • Generate interest notes and collection letters by billing classification.
  • Assign a collection letter policy to a billing classification.
  • Set up posting definitions for invoice settlements.
  • Settle a free text invoice against a payment.
  • Settle a transaction write off for a customer.
  • Assign a trading partner code, an agency location code (ALC), and a 1099-C indicator.
  • Prevent customer duplication by using a Government Identification Number (GIN).
Module 7: Project Accounting
This module  reviews the process of creating and revising a project budget, performing budget control on the project budget, and allocating it across periods. Also, you will learn how to handle  grant management, and  manage multiple funding sources.
Lessons
  • Introduction
  • Perform Project Budget Control
  • Manage Grants
  • Manage Multiple Funding Sources
Lab : 7.1: Manage Multiple Funding Sources
  • Create a project budget.
  • Allocate a project budget across periods.
  • Create a project budget revision.
  • Create a grant.
  • Track the status of a grant.
  • Add multiple funding sources to a project.
  • Assign a grant to a funding source.
  • Allocate expenses to a funding source.
  • Set up funding source percentage and priority.
  • Invoice costs against funding sources.
Module 8: Role Centers and Reports
In this module , you will be shown various Role Center webpages available in Enterprise Portal. It also discusses how to generate reports and set up derived financial hierarchies.
Lessons
  • Introduction
  • Role Centers
  • Generate Accounts Receivable Reports
  • Generate Customer Reports
  • Generate Payment Approval Report
  • Generate Budget Control Reports
  • Perform Financial Analysis with Derived Financial Hierarchies
Lab : 8.1: Generate Accounts Receivable Reports by Billing ClassificationLab : 8.2: Generate a Customer ReportLab : 8.3: Generate a Budget Control ReportLab : 8.4: Set Up Derived Financial Hierarchies
  • Describe the Accountant, Accounting Manager, and Controller Role Centers.
  • Explain the Accounts Receivable Administrator and Finance Director Role Centers.
  • Generate Accounts receivable transaction, invoice, and payment reports.
  • Generate a Customer aging, Customer balance list, and Detailed due day list report.
  • Set up a cover page for the Payment approval report.
  • Generate a Budget control account detail history and Budget control activity by project report.
  • Create a category hierarchy.
  • Associate a derived financial hierarchy.
  • Slice and dice using the derived financial hierarchy dimension
Prerequisites
Before attending this course, students must have:
  • Completed the Microsoft Dynamics AX 2012 Finance I and Finance II courses.
  • Completed the Microsoft Dynamics AX 2012 Project Essentials and Project Advanced courses.
  • The ability to use Microsoft Dynamics AX 2012 for basic processing. 
  • Knowledge of bookkeeping and accounting processes.
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you