Course 80338A:

Microsoft Dynamics AX 2012 Public Sector - Financials

Length:2 Days
Published:November 17, 2011
Language(s):English, French
Audience(s):Information Workers
Level:200
Technology:Microsoft Dynamics AX 2012
Type:Course
Delivery Method:Instructor-led (online)
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 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 Entity
  • Create a Fund Entity
Lab : 2.2: Set Up a Chart of Accounts
  • Set up an account in the 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 Control
  • Configure budget control
Lab : 3.2: Process a Provisional Budget
  • Post and reverse a provisional budget
Lab : 3.3: Post an Apportionment Budget
  • 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 Accounts
  • Distribute a line amount to one or more ledger accounts
Lab : 4.2: Perform Commitment Accounting
  • Create a purchase order from a purchase requisition and review the subledger journal entries
Lab : 4.3: Perform General Ledger Year-End Processes
  • Process “nominal” and “real” accounts at year end
  • 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 Agreements
  • Invoice a purchase agreement without creating a release order
Lab : 5.2: Create a Confirming Purchase Order
  • Set up a confirming PO code and its associated message text and create a confirming purchase order
Lab : 5.3: Generate 1099-S Tax Reports
  • Set up 1099-S information, pay an invoice with that 1099-S information, and process a 1099-S tax statement.
  • 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 Codes
  • Create a billing code
Lab : 6.2: Create a Free Text Invoice Using a Billing Code
  • Create a free text invoice by using a billing code
Lab : 6.3: Set Up Billing Classifications
  • Set up billing classifications, associate a billing code with a billing classification, and set a classification settlement order
Lab : 6.4: Process Free Text Invoices by Billing Classification
  • Create, post, and print free text invoices according to a billing classification
Lab : 6.5: Process Recurring Invoices by Billing Classification
  • Process recurring invoices by billing classification
Lab : 6.6: Process and Settle Payments by Billing Classification
  • Enter customer payments and execute settlements of transactions by billing classifications
Lab : 6.7: Process Reimbursements by Billing Classification
  • Process a reimbursement by billing classification
Lab : 6.8: Process Dunning Documents by Billing Classification
  • Generate interest notes and collection letters by billing classification
Lab : 6.9: Use Customer Reporting Attributes
  • 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
  • Manage multiple funding sources for a project
  • 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 Classification
  • Generate Accounts receivable reports by billing classification
Lab : 8.2: Generate a Customer Report
  • Generate a customer report by billing classification
Lab : 8.3: Generate a Budget Control Report
  • Generate a budget control report
Lab : 8.4: Set Up Derived Financial Hierarchies
  • 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
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.
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

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France