Microsoft - Dynamics AX 2012 R2 Project

Curriculum

Project Essentials

Module 1: Working with Projects

This module provides an overview of the Project management and accounting module in Microsoft Dynamics AX. It describes creating a project, project hierarchies, and activity breakdown structures. It also describes project details, project groups, and project stages.

• Overview
• Project Details
• Project Group
• Project Numbering
• Project Hierarchies
• Report Sort Fields
• Work Breakdown Structure
• Project Copy Wizard
• Project Stages
• Create a Project
• Create a Subproject
• Set Report Sort Fields
• Create a Work Breakdown Structure
• Creating and Renaming Project Stages

After completing this module, you’ll be able to:

• View the list of projects
• Edit project details
• Change project group
• Specify project ID numbers
• Define project hierarchies
• Review report sorting fields
• Review the work breakdown structure
• Use the Project Copy Wizard
• Set the project stage

Module 2: Understanding Project Types

This module discusses the accounting principles involved with the project types supported in Microsoft Dynamics AX module, Project management and accounting.

• Project Types
• Time and Material Projects
• Processing a Time and Material Project
• Time and Material Project Example
• Fixed-Price Projects
• Fixed-Price Project Example
• Internal Projects
• Cost Project Example
• Time Projects
• Investment Projects
• Project Groups
• Ledger Principles
• Run a Basic Time and Material Project
• Run a Basic Fixed-Price Project
• Create a Cost Project

After completing this module, you’ll be able to:

• Name the six project types
• Set up time and material projects
• Describe a time and material project
• Run a time and material project
• Describe a fixed-price project
• Run a fixed-price project
• Describe an internal project
• Run a cost project
• Describe a time project
• Describe an investment project
• Describe project groups

Module 3: Working with Project Transactions

This module explains how transaction types are managed and processed in the Microsoft Dynamics AX Project management and accounting module.

• Transaction Types
• Categories and Category Groups
• Project Pricing
• Line Properties
• Hour Transactions
• Hours Journal
• Expense Transactions
• Expense Journals
• Invoice Journals and Invoice Registers
• Free Text Invoices
• Item Transactions
• Item Journals
• Item Requirements
• Purchase Orders
• Purchase Requisitions
• Production Orders
• Sales Orders
• Beginning Balances
• Review Project Transactions
• Adjusting Transactions
• Journal Setup
• Journal Approval
• Journal Descriptions
• Ledger Posting Setup
• Posting Setup by Project Group or Category
• Create a New Category Group and Category
• Set Up Prices for a New Contract
• Enter an Invoice Journal
• Create a Project Production Order
• View Project Transactions
• Adjust a Posted Transaction

After completing this module, you’ll be able to:

• List the four project transaction types
• Define categories and category groups
• Set up cost prices, sales prices, and price groups
• Define line properties
• Define project hour transactions
• Enter project hour transactions
• Enter project expense transactions
• Enter project expense transactions
• Charge an invoice journal and use the invoice register
• Create free text invoices
• Define project item transactions
• Enter project item transactions
• Define the item requirements form
• Define purchase orders
• Define purchase requisitions
• Define production orders
• Define sales orders
• Define and enter beginning balances
• Review project transactions
• Adjust project transactions
• Set up the journals
• Set up journal approval
• Set up journal texts
• Set up ledger posting
• Set up posting by project group or category

Module 4: Project Timesheets

This module explains how workers (employees and contractors) use project timesheets to enter and approve hours through the Enterprise Portal or the Microsoft Dynamics AX client.

• Timesheet Periods
• Set Up Timesheet-Related Parameters
• Configuring Timesheet Workflows
• Set Up Favourites
• Set Up Delegates
• Timesheet Creation
• Timesheet Approval
• Missing Timesheets Report
• Create a Timesheet Workflow
• Create a Timesheet

After completing this module, you’ll be able to:

• Set up timesheet periods
• Set up timesheet-related parameters
• Configure timesheet workflows
• Set up My favourites
• Set up My delegates
• Create timesheets
• Approve timesheets
• Use missing timesheets report

Module 5: Project Invoicing

This module describes how Microsoft Dynamics AX uses two methods to invoice based on the type of project. While time and material (T&M) projects use the invoice proposal form to create invoices based on the transactions posted to the project, fixed-price projects use predefined payment amounts that are based on predefined milestones in the project.

• Invoicing Setup
• Project Contracts
• Billing Requirements for Transactions
• Invoice Proposals
• On-Account Invoicing
• View Posted Invoices
• Credit Notes
• Create a New Project Contract
• Create an Invoice Proposal
• Create an On-Account Invoice

After completing this module, you’ll be able to:

• Describe invoicing project concepts
• Set up project invoicing
• Set up project contracts
• Define billing requirements for transactions
• Create, adjust, and post invoice proposals
• Invoice on-account transactions
• View posted invoices
• Reverse transactions using credit notes

Module 6: Project Budgeting

This module explains the project budgeting functionality within Microsoft Dynamics AX. By comparing budget and actuals, your organization can reallocate money and resources to meet budgetary goals.

• Budget Approval Workflow
• Original Budgets
• Project Budget Properties
• Allocate Budgets
• View Budget Impact
• View Budget Balances
• Budget Revisions
• Committed Costs
• Carry Forward Budget Amounts at Year End
• Manage a Project Budget

After completing this module, you’ll be able to:

• Create ledger posting groups
• Review general ledger budgeting and forecasting concepts
• Define the budget approval workflow
• Create an original budget
• Configure project budget properties
• Allocate budgets across fiscal periods and years
• View budget impact
• View budget balances
• Review and approve budgets
• Manage committed costs
• Carry forward budget amounts at year end

Module 7: Project Inquiries and Reports

This module includes inquiries, reports, and statistics forms so you can access information needed to run projects effectively. It also describes the Microsoft Excel and Microsoft Online Analytical Processing (OLAP) integration.

• Project Control
• Excel Integration with Project Control
• Reports
• OLAP Integration
• Using the Hour Utilization Screen

After completing this module, you’ll be able to:

• Use the project control forms
• Use the Microsoft Excel integration
• Generate reports on project base data, forecasts, revenue, and transactions
• Describe the Microsoft Online Analytical Processing (OLAP) integration

Module 8: Project Management and Accounting Setup

This module provides a reference for the set up of parameters of the Project management and accounting module in Microsoft Dynamics AX. The correct setup is necessary to use this module.

• Settings

After completing this module, you’ll be able to:

• Configure the core project management and accounting functionality
• Enter default information that is used by the system if the information is not specified at a lower level (for example project, contract).

Project Advanced

Module 1: Project Validation

This module discusses the project validation system.

• Project Validation Parameters
• Enable Validation for Workers
• Validation Groups
• Enable Project Assignments
• Create a New Validation Group

After completing this module, you’ll be able to:

• Explain project validation
• Set up project validation parameters
• Enable validation for workers
• Set up validation groups
• Set up project validation category assignments

Module 2: Project Forecasting

This module discusses forecasting within the Project management and accounting module. It describes how the concepts are closely linked within this module and how they can be used in all types of projects.

• Forecast Models
• Enter Forecasts
• Forecast Scheduling
• Forecasting Hours
• Edit a Forecast

After completing this module, you’ll be able to:

• Use forecast models
• Enter forecasts for hours, expenses, fees, items, and on-account payments
• Set up forecast scheduling
• Define forecasting on hours

Module 3: Advanced Project Invoicing

This module describes advanced features of project invoicing in the Project management and accounting module of Microsoft Dynamics AX 2012, including funding sources, funding limits, funding rules and allocations. The module also covers grants, which are most often used by the public sector and research facilities.

• Project Invoicing Parameters
• Funding Sources
• Funding Limits
• Funding Rules
• Fixed-Rate Agreements
• Grant Management
• Manage Contract Funding Sources and Limits
• Manage Grants

After completing this module, you’ll be able to:

• Set up project invoicing parameters
• Set up funding sources
• Set up funding limits
• Set up funding rules and allocations
• Set up fixed-rate agreements
• Manage grants
• Approve or revoke invoice proposals

Module 4: Advanced Internal Project

This module describes the accounting principles involved with running advanced internal projects in the Microsoft Dynamics AX Project management and accounting module.

• Internal Projects with Work in Progress (WIP)
• Internal Project with WIP Example
• Investment Projects
• Investment Project Example
• Run an Internal Project with WIP
• Run an Investment Project

After completing this module, you’ll be able to:

• Explain internal projects with WIP
• Track the financial effects of an internal project with WIP
• Explain investment projects
• Track the financial effects of an investment project

Module 5: Advanced Time and Material Project

This module describes the accounting principles involved with running advanced time and material projects in the Microsoft Dynamics AX Project management and accounting module.

• Time and Material Project with WIP
• Example: Time and Material Project with WIP
• Post Costs Form
• Time and Material Project with Accruals
• Example: Time and Material Project with Accruals
• Reversing Accrued Revenue
• Run a Time and Material Project with WIP
• Using Post Costs
• Run a Time and Material Project with Accruals
• Reversing Accrued Revenue

After completing this module, you’ll be able to:

• Describe a time and material project with WIP
• Run a time and material project with WIP
• Describe post costs form
• Describe time and material project with accruals
• Run a time and material project with accruals
• Reversing accrued revenue

Module 6: Advanced Fixed-Price Projects

This module describes the handling of advanced fixed-price projects. Its main focus is on how to deal with work in process (WIP), and how to use the estimate system for revenue accruals on these projects.

• Completed Contract Assessment Principle
• Completed Percentage Principle
• The Estimate Process
• Period Types
• Cost Templates
• Estimate Projects
• Creating Estimates
• Create a Cost Template
• Create and Post an Estimate

After completing this module, you’ll be able to:

• Review concepts of fixed-priced projects
• Describe the completed contract method
• Describe the completed percentage principle
• Describe how advanced fixed-price projects are run using the estimate system
• Set up estimate period types
• Set up cost templates
• Set up estimate projects
• Use the estimate process

Module 7: Fixed-Price Project with Completed Contract

This module describes the accounting principles involved with running the advanced fixed-price project with the completed contract method of revenue recognition.

• Fixed-Price Project with Completed Contract Example
• Run a Fixed-Price Project with Completed Contract

After completing this module, you’ll be able to:

• Describe the completed contract method for advanced fixed-price projects

Module 8: Fixed-Price Project with Completed Percentage

This module describes the accounting principles involved with running advanced fixed-price projects with the completed percentage method of revenue recognition.

• Fixed-Price Project with Completed Percentage and Sales Value
• Fixed-Price Project with Completed Percentage and Sales Value Example
• Fixed-Price Project with Completed Percentage and Production Plus (+) Profit
• Fixed-Price Project with Completed Percentage and Production Plus (+) Profit Example
• Create and Run a Fixed-Price Project Using Completed Percentage

After completing this module, you’ll be able to:

• Describe the completed percentage and sales value method for fixed-price projects
• Track the financial effects of a fixed-price project with the completed percentage and sales value method
• Describe the completed percentage and production plus (+) profit method for fixed-price projects
• Track the financial effects of an advanced fixed-price project example using the completed percentage and production plus (+) profit method

Service Industries

Module 1: Work Breakdown Structure

This module provides an overview of the functionality to add activities to a project in a hierarchical order. You can achieve this by copying activities from a WBS template or from existing projects. The activities can also be directly added to a project.

• Introduction
• Work Breakdown Structure Template
• Creating a Project Work Breakdown Structure
• Rate Card

Create a Work Breakdown Structure Template

After completing this module, you’ll be able to:

• Create the activity structure
• Enter the information needed to plan and schedule the various tasks involved in the execution of a project
• Save the structure as a template and know how activities within the WBS can be modified or deleted
• Create an activity hierarchy from a project
• Copy an activity from a WBS template and from an existing project
• Set up rate cards for projects

Module 2: Project Quotations

This module explains how to create the basic set up to create project quotations and define the quotation activities, schedule the activities, assign resources, submit, and approve quotations and convert the quotation to a project.

• Introduction
• Project Quotation
• Creating Project Quotes
• Resource Assignment
• Quotation Business Process
• Transferring the Quotation to the Project

Create the Project Quotation and Generate Quotation Lines from the WBSLab : Submit the Project Quotation for Approval and Confirm the Quote.

After completing this module, you’ll be able to:

• Create and send project quotations
• Furnish quotations for repetitive services
• Convert quotes for projects when work is received from customers
• Define a work breakdown structure for a quotation
• Copy activities to the quotation from a work breakdown structure template and know how to generate quotation lines based on these activities
• Review the quote before it is sent to the customer
• Submit a quotation for approval
• Confirm the quote after the confirmation is received from the customer
• Transfer the quotation lines to a new or an existing project
• Create budgets automatically, transfer the work breakdown structure, and perform the scheduling and resource assignment from the quote to the project

Module 3: Resource Scheduling

This module explains the resource scheduling functionality in Microsoft Dynamics AX 2012 R2 to use an organization’s resources when they are needed.

• Introduction
• Configuring Resource Competencies
• Defining Project Requirements
• Assigning Resources to a Project Based on Resource Availability
• Assigning Resources to a Project Based on Project Demand
• Integration with Microsoft Project Integration Server 2010
• Resource Assignment and Utilization – Inquiries and Reports

Configure Resource Competencies for Workers.

After completing this module, you’ll be able to:

• Schedule resources for various project activities
• Perform scheduling by matching project activities with similar resource requirements as the competencies of the workers
• Define competencies such as education, skills, certifications and other competencies for employees
• Set up parameters, such as a skill set match threshold and availability match threshold
• Define the requirements for performing activities on the work breakdown structure of the project
• Schedule resources based on the availability of resources
• Assign resources to project activities based on the project demand
• Calculate a skill match percentage and availability percentage when matching resources to project activities
• View the various inquiry forms and reports and analyze the usage of resources

Module 4: Project Contracts with Billing Rules

This chapter explains the concept of project contracts and the set up required to use the feature. It explains the concept of billing rules in project contracts.

• Introduction
• Creation of Project Contracts
• Overview of Billing Rules
• Invoice Formats

Create a Time and Material Billing Rule Associated to a Project Contract

After completing this module, you’ll be able to:

• Create project contracts and associate the billing rules
• Bill the customer based on the completion of specific milestones in the project
• Invoice the project based on the percentage of work completed

Module 5: Project Invoicing

This chapter shows how to manage project invoices in Microsoft Dynamics AX 2012. It describes the procedure to reformat invoices and display the details of the transactions in the format required by the customer. The chapter also provides a detailed description of the customer advance feature.

• Introduction
• Invoice Processing
• Customer Advance

Reformat and Present InvoiceLab : Define and Request a Customer Advance

After completing this module, you’ll be able to:

• Initiate the invoicing process
• Create an invoice proposal
• Reformat the invoice based on the customer’s demand
• Submit and post the invoice
• Define and request a customer advance
• Post an invoice for the customer advance
• Reconcile the actual amount with the customer advance payments

Module 6: Payment Retention

This chapter explains how to use the functionality of Customer payment retention and Vendor payment retention in Microsoft Dynamics AX 2012 R2.

• Introduction
• Customer Payment Retention
• Vendor Payment Retention

Create a Retention Term and Post an Hour JournalLab : Assign a Vendor Payment Retention Term and Invoice the Purchase Order.

After completing this module, you’ll be able to:

• Assign customer payment retention terms to the different levels of projects
• Create and invoice transactions with customer payment retention terms attached
• Review the amount retained by the customer, and then release the retailed amount
• Make inquiries about customer payment retentions, and how to generate the Customer payment retention report
• Process payment retentions
• Create and invoice purchase orders by attaching the payment retention term, and know how to review accounting transactions
• Post an invoice to release the retained vendor payment
• Make inquiries on vendor payment retentions that are based on purchase orders and invoices
• Print the Vendor payment retention report in two views

Module 7: Subcontracting Terms

This chapter covers the processes to set up the PWP terms, create and invoice a project purchase order with PWP terms, post the customer invoice, receive customer payments, and release the vendor payment. Additionally, it explains how to inquire on the PWP transactions and print the PWP report.

• Introduction
• Pay When Paid
• Inquiries and Reports

Assign a PWP Term to a Vendor for a ProjectLab : Invoice a Purchase Order with the Pay When Paid Term.

After completing this module, you’ll be able to:

• Set up the PWP clause
• Create and invoice purchase orders by attaching the PWP term
• Create corresponding customer invoices
• Review the payment status of vendor invoices with regard to the related customer invoice
• Receive customer payments
• Release vendor payments in accordance with the PWP threshold criteria
• Inquire on outstanding payments based on vendor invoices subject to the PWP clause
• Print the Pay when paid report in two layouts

Module 8: Cost Control

This chapter shows you how to work with indirect costs in Microsoft Dynamics AX 2012 R2. It also describes the set up required for indirect costs and how to assign the costs to a project, project contract and billing rule. It also shows how to generate invoices with indirect costs.

• Introduction
• Basic Setup
• Defining Rules for the Indirect Cost Calculation
• Assigning Indirect Cost Component Groups
• Processing an Indirect Cost Transactions
• Splitting Indirect Costs between Multiple Funding Sources
• Adjusting Indirect Costs

Create an Indirect Cost Components Group

After completing this module, you’ll be able to:

• Set up a project category as an indirect cost category
• Set up indirect cost components
• Set up an indirect component group
• Specify a project category as an indirect cost category
• Create the compounding rules and assign the indirect cost component category to projects, project contracts, a resource and billing rules
• Post and process different transactions with indirect cost components attached and know how to review the indirect costs calculated and posted for the transactions