What's new: Project management and accounting features

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

We have changed and added functionality in the Project management and accounting area for Microsoft Dynamics AX 2012. For more information, see the tables that apply to your version of the product.

What’s new in AX 2012

What’s new

Description

Display the status of project budgets in purchasing forms

You can now display the status of a project budget in purchase requisition forms, purchase order forms, and vendor invoice forms. Therefore, you can easily monitor the remaining available budget for projects. This change also supports budget control and the evaluation of proposed purchases during management review or workflow approval.

For more information, see the following topics:

Changes to the Project accounting cube

Several nonessential fields have been removed from the Project cube perspective. However, the fields that are related to measures and attributes remain. Therefore, the cube is easier to work with and maintain, and is less likely to be negatively affected by schema changes.

For more information, see Project accounting cube (ProjCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack.

ID numbers for project contracts can now be assigned automatically

Legal entities can now have ID numbers for project contracts assigned automatically through a number sequence when a new project contract is created in the Project contracts form.

For more information, see Automatically generate project IDs.

Associate any sales order, purchase order, or service-related document with a project

You can assign a project ID to any sales order, purchase order, service agreement, service order, or service subscription. Previously, these types of documents could be associated with a project ID only if they were created in Project management and accounting.

Enter and track detailed information about grants for projects

You can easily enter and track grants, and define relationships to new or existing projects and project contracts. Grant information is stored in a centralized location. Therefore, you can quickly and easily find the information that you require for reporting and informational purposes.

For more information, see Create or modify a grant and About project contract funding.

Evaluate vendor invoices against project budgets

Vendor invoices can now be evaluated against project budgets.

For more information, see About invoicing.

Enhancements to the budget functionality in projects

Project budget capabilities have been enhanced as follows:

Enhancements to project integration with Microsoft Project Server

Project managers can already schedule and manage project activities and resources by using Project Server. In addition, project managers can synchronize activity, costs, and revenue with Microsoft Dynamics AX to support additional analysis of data.

Enhancements support the synchronization of resource assignments and the project hierarchy with Microsoft Project Server 2010.

In addition, custom code enables Microsoft Dynamics AX custom fields to be integrated with Project Server at the table level.

For more information, see About Microsoft Dynamics AX integration with Microsoft Project Server.

Upgrades for item charges on lines for purchase orders, sales orders, and invoices

Item charges on lines for purchase orders, sales orders, and invoices are now recognized in Project management and accounting. The ledger account and the posting type for the charge are derived from the primary line amount. In addition, any taxes for item charges are reflected in an expense account. The item charges and related taxes are also recorded in the project commitments and budget.

For more information, see About posting setup for project transactions.

Enhancements to project timesheets

The forms and pages that are used for timesheet-related tasks now provide a more user-friendly experience that builds on existing support for project timesheets. Approvals at the level of the timesheet line now use support from the workflow framework for lines to achieve consistency with other tasks. The way that comments and the starting and ending dates for a period are used has also changed. In addition, timesheet support in Enterprise Portal for Microsoft Dynamics AX lets you manage favorites, and to quickly create a timesheet based on either a previous timesheet or favorites.

For more information, see Create and maintain timesheets.

Enhancements to project budgeting

Significant improvements to project budgeting simplify the financial management of projects. By using the new budget control method, you can perform the following tasks:

  • Allocate project budget amounts to multiple fiscal periods and fiscal years.

  • Revise budgets.

  • Control whether the budget is verified. In addition, you can control whether transactions that exceed the budget balance are allowed after the user receives a warning, or whether these transactions are blocked.

  • Extend committed costs to purchase requisitions.

  • Apply budget control to all project transactions. These transactions include revenue transactions, purchase requisitions, and purchase orders.

For more information, see About project budgets and About project budgets and forecasts.

Carry forward project budget amounts at year end

If you are working with a project that lasts multiple years, at the end of the year, you can carry forward any remaining budget to future years and make the required changes to the associated general ledger accounts.

For more information, see Carry forward project budgets at year-end.

Support for multiple funding sources

In earlier versions of Microsoft Dynamics AX, you could invoice only one customer per project or contract project. Now, the funding for a single project or project contract can be shared by any number of internal and external parties. You can choose whether any of these parties are subject to funding limits. In addition, by configuring a funding scheme, you can set up funding limits for one or more customers per category, category group, or transaction type, or for all transaction types.

For more information, see About project contract funding.

Collaboration workspaces

You can now create collaboration workspaces where teams can quickly organize and share information about projects, marketing campaigns, and opportunities. Because collaboration workspaces are built on features in Microsoft SharePoint Services and MicrosoftOffice SharePoint Server, they include familiar elements, such as document libraries, announcement lists, calendar items, tasks, and discussion boards. You can add collaboration workspaces to existing projects, campaigns, and opportunities. In addition, you can configure Microsoft Dynamics AX options so that new collaboration workspaces are automatically created for projects, campaigns, and opportunities.

For more information, see Select preferences for collaboration workspaces and Create or link to a collaboration workspace (Project).

Create and manage projects in Enterprise Portal

Project managers can create and maintain projects in the web-based Enterprise Portal. Previously, time and expense entry was the only project-related feature that was available. Web-based support makes it easier for project managers to work remotely, and frees them from having to deal with software installations, upgrades, and patches.

For more information, see Using the Project management site.

Enter and approve worker timesheets in Enterprise Portal

Enterprise Portal includes a timesheet page where workers can enter the hours that they worked each day on one or more projects. In addition, project managers can review and approve worker timesheets in Enterprise Portal.

For more information, see Working with timesheets.

Enter a beginning balance for a project

You can now enter a beginning balance for a new or existing project. By specifying a beginning balance, you can transfer projects to Microsoft Dynamics AX without affecting the general ledger. For example, you have been tracking a project in another program, but recording project costs and revenues in Microsoft Dynamics AX. In this case, you can transfer the project to Microsoft Dynamics AX, specify a beginning balance, and then track the project information in only one place.

For more information, see About project beginning balances.

Track project revenue from a free text invoice

Revenue that is billed by using a free text invoice can now be tracked to a project.

For more information, see About transaction types.

Enhancements to adjustments

Adjustment capabilities have been enhanced as follows:

  • Transactions that have been invoiced and estimated can be adjusted. Previously, only transactions that were not invoiced or calculated in an estimate could be adjusted.

  • The adjustment date can be used as the project date for transactions, instead of the original transaction date.

  • The relationship between an original transaction, its reversal, and a new replacement transaction can be traced. The information that is traced can include the user who made each adjustment.

  • If an item transaction that is created from a purchase order is adjusted to a new project before the vendor is paid, you can use the new Adjustment cash flow trace feature to report “Expected” and “Paid” from the new project.

For more information, see the following topics:

Support for progress billing, estimates, and revenue recognition when you migrate data from other Enterprise Resource Planning (ERP) systems

When you migrate data from one ERP system to another, one challenge is to bring existing data into the estimation system, so that revenue can continue to be recognized for Fixed-price projects that have already started. Because revenue recognition is based on a completed percentage, the data must be migrated so that both the percentage of work that is already completed (actual cost) and the amount of work that remains on the project (estimated cost to complete) are reflected in the correct accounts.

Because some Fixed-price projects can span multiple years, the actual cost to date can also be derived from several years of transactions. Therefore, the key challenge in an ERP migration is to post a lump sum transaction in the beginning balance journal and connect it correctly to the estimate system.

To address these data migration issues, the new beginning balance and progress billing features integrate with the existing estimation system to support revenue recognition for Fixed-price projects.

For more information, see About migrating project data from other ERP systems.

Miscellaneous updates for Project management and accounting features

A series of minor feature changes have been implemented for Project management and accounting:

  • The Worker ID, formerly Employee ID, field is no longer required for hourly transactions in Project management and accounting. Therefore, route operations can be assigned to work center groups, not just to individual work centers.

  • Several references to period tables in Project management and accounting have been replaced with fiscal calendar objects, relations, and methods.

    For more information, see About fiscal calendars, fiscal years, and periods.

  • You can copy a project ID to a purchase order when the purchase order is made from an item requirement has been restored. This functionality is required, so that users can view a full list of the purchase orders that are related to a project.

Funding sources for project ledger posting

If you use multiple funding sources together with project contracts, you can configure ledger posting based on funding source by project, project group, category, category group, or all these options. For each posting type, you can associate projects and funding sources with specific accounts.

For more information, see Set up a ledger posting account for projects.

What’s new in Microsoft Dynamics AX 2012 R2

What’s new

Description

Designate a project cost price as an effective labor rate

AX 2012 R2 introduces support for specifying a worker's hourly cost price on projects as an effective labor rate. The effective labor rate defines the hourly cost if the worker works all the hours in a work week. The cost price of the effective labor rate for a period is calculated by using the following formula:

Effective labor rate price per hour * (Number of hours in the work week according to the worker's calendar / Number of hours registered in the week)

The Project setup form now includes a Use effective labor rate check box. If this check box is selected, you can mark a worker's hourly price in the Cost price - hour form as an effective labor rate.

For more information, see Project setup (form).

Select a value model for estimate eliminations

For investment projects, in the Estimate form, you can now select the value model that is applied when the value from an estimate project is eliminated to a fixed asset.

For more information, see About maintaining estimates and Estimate (form).

Enhancements to project invoice proposals and printing project documents

View all invoice proposals on a new list page for project invoice proposals. Distribute project funding amounts to multiple funding sources. Set up invoice forecasting on a bi-weekly basis. Set up printing for all types of projects, project contracts, project quotations, invoice proposals, and project invoices. Print comments on project documents that you send to customers.

For more information, see the following topics:

Improved support for project estimates and revenue recognition

In earlier versions of Microsoft Dynamics AX, a project manager who wanted an estimate project to be created to support a Fixed-price project or an Investment project had to remember to select the New estimate project check box in the Create project form. Otherwise, use of the estimate system to recognize revenue was not fully supported.

In AX 2012 R2, an estimate project is created automatically when the project manager creates a Fixed-price project or Investment project. As part of this change, cost templates and period codes no longer have to be assigned to each project individually, but can be assigned to project groups instead. This change supports the more common practice of using the same cost template and estimate period for most or all Fixed-price projects and Investment projects. This change also reflects the fact that other accrual and revenue recognition options are set up in project groups.

For more information, see Create an estimate project.

Intercompany resource scheduling and UX improvements

Major enhancements have been made to the resource scheduling feature in the Project Management and Accounting Add-in (Project III).

A new intercompany resource scheduling feature makes it easy for a worker in one legal entity to be assigned to a project in a related legal entity.

Support for staffing a project and viewing the status of project staffing is improved. Therefore, project managers can now more easily perform several tasks:

  • Discover the scheduling status of a project.

  • Find the best resources for projects and activities.

  • Assign resources to projects and activities. Resources can also be automatically assigned to projects.

Project managers can also easily view a list of resources that are assigned to a project, release resources from all assignments in a project, and view the assignment details for resources that are assigned to a project.

Soft-booking support has been updated, so that a worker’s soft-booked hours do not count against the worker’s overall availability.

When a project is closed, all of a worker’s bookings that are made for the project are released automatically.

Resources that are assigned to a project no longer have to be manually added to a validation group for the project. This validation, which lets a worker enter timesheet lines for the project, is set up automatically when a worker is assigned to a project.

For more information, see the white paper Microsoft Dynamics AX 2012 R2 White Paper: Resource Scheduling for Projects.

Expanded support for project budget checks when document lines are saved

In the Project management and accounting parameters form, the Check budget on document line save option previously applied only to financial budget documents, such as purchase requisitions and purchase orders, not to journals that are related to project budget. In AX 2012 R2, budget checks are now performed when changes are made to hour journals, expense journals, fee journals, and item journals. Budget checks are triggered when changes are made to any of the following fields:

  • Project ID

  • Activity number

  • Category

  • Date of transaction

  • Cost price

  • Sales price

  • Sales currency

For more information, see Configure project budget control.

Consumption of project items on product receipt, even if there is no item requirement

In AX 2012, if an item was added to the purchase order for a project but was not preceded by an item requirement, the item could not be consumed and invoiced to the project contract's funding source until the related vendor invoice was posted. In AX 2012 R2, project items can be immediately consumed and invoiced to the project’s contract funding source, before the vendor invoice for the purchase order is posted, even if an item requirement does not precede the purchase order.

For more information, see Consume item requirements in a project.

Reservation of funds in a project contract

The funding limits in the project contract can now be used to track revenue that has not yet been posted as commitments. This functionality allows for more realistic limit checks, because the commitments are considered while the remaining available funds in a limit are computed. This tracking of commitments on a limit is available to all the source documents that have project functionality.

For more information, see Examples: Project contract funding and Set up funding limits for funding sources in a project contract.

What’s new in cumulative update 6 for Microsoft Dynamics AX 2012 R2

What’s new

Description

Reverse an hour transaction for a project

You can set up a reversing entry for hours that are posted to a project, and you can also specify the date on which the reversing entry is automatically posted. Previously, you could post a reversing entry only on the date on which you created the reversing entry.

For more information, see Journal lines for hours (form).

Generate project budget revenue amounts from budget cost amounts for a project

After you enter cost amounts in a project budget, you can automatically generate the related revenue amounts in the project budget. One revenue line is added for each cost line.

For more information, see Create and submit an original project budget.

New Integration Solution for Microsoft Dynamics AX projects and Microsoft Dynamics CRM

The Integration Solution for Microsoft Dynamics AX projects and Microsoft Dynamics CRM is built on Connector for Microsoft Dynamics. This solution enables the integration and synchronization of project quotations and projects between Microsoft Dynamics AX and Microsoft Dynamics CRM.

For more information, see About synchronizing project information between Microsoft Dynamics AX and Microsoft Dynamics CRM.

What’s new in cumulative update 7 for Microsoft Dynamics AX 2012 R2

What’s new

Description

Use Microsoft Project to create or update a Microsoft Dynamics AX project plan, and integrate with an Office 365 SharePoint project site.

You can use Microsoft Project and AX 2012 to manage a project that was created in either program, and changes can be synchronized between the two programs. This integration lets you assign workers from AX 2012 to tasks in Microsoft Project, and to associate tasks in Microsoft Project with project categories in AX 2012.

This integration with Microsoft Project also lets you use features of Office 365 SharePoint project sites. You can now perform the following tasks:

  • Create and modify a AX 2012 project in an Office 365 SharePoint project site.

  • Publish a project from Microsoft Project to an Office 365 SharePoint project site.

  • Store a linked MPP file in an on-premises SharePoint site without having to generate a task list.

  • Use collaboration workspace functionality for AX 2012 projects together with Microsoft SharePoint 2013 Products, even SharePoint online.

For more information, see Create or update a project by using Microsoft Project.

Use Microsoft Project to create or update the work breakdown structure (WBS) for a Microsoft Dynamics AX project quotation

You can now use the Microsoft Project client to create and update the WBS of a project quotation from AX 2012. You can also save the WBS for the quotation, in a Microsoft Project MPP file, in a SharePoint site.

For more information, see Create or update a project by using Microsoft Project.

Create a WBS template for Microsoft Dynamics AX by using Microsoft Project

You can create a WBS template in Microsoft Project that can be used in AX 2012. This template can be made available to selected companies in AX 2012, and can be used for both quotations and projects. In addition, because the template is based on a linked MPP file, information types that are used in Microsoft Project but not in AX 2012, such as types of resources that are required (material, work, and so on), are retained and maintained in Microsoft Project.

For more information, see Create or update a project by using Microsoft Project.

Expanded support for working with project teams, defining project role types, and managing projects

Project managers can now perform the following tasks:

  • Define project role types, and define the role competencies that are required for a project.

  • Create a project team by reserving workers for specific roles.

  • Assign both workers that have been added to a project team and other workers to project activities.

  • Identify the number of workers that is required for an activity.

  • View a list of workers who meet the requirements of project roles in the following order: skills match, previous project roles, and availability.

  • View a graphical representation of available workers who can satisfy the resource requirements for the project team.

  • Authorize project team members to report time and expense in a project.

For more information, see About resource management for projects and Identify and assign qualified workers to projects.

Expanded support for managing worker assignments and capacity in projects

Updates in cumulative update 7 provide worker resource managers and project managers with several additional capabilities:

  • Use a graphical representation of worker availability to see how many days, weeks, or months workers are available in a specific time range. The information that is displayed includes the worker’s available capacity in hours. From this graphical representation, you can also access a list of projects that the worker can be assigned to. In addition, you can view a graphical representation of the activities that workers are already assigned to.

  • Filter the display of workers in the graphical representation, based on the workers’ skill sets, cost price, name, and legal entity.

  • Reserve workers in bulk from project teams.

  • View projects that have requirements that match the competencies of a particular worker, and then assign the worker to one or more of those projects.

  • Assign resources to projects for weeks or months at a time, not just day by day.

  • See at a glance which workers are currently overbooked.

  • Contact workers by email, IM, or telephone, directly from a Gantt chart display.

  • View a list of workers that have a work calendar and work for a particular legal entity.

  • Select several workers at the same time, and assign them to a project for a specific period, such as a week or month.

  • Access a view of workers that are hired by other legal entities but lent to the legal entity that is managing the project.

For more information, see About resource management for projects.

Enable audit trails on timesheet entry and reporting

You can enable parameters to track any changes or updates that are made to timesheet entries. You can also offer an option or require workers to provide a reason for any changes that are made to a timesheet. For example, if a worker enters the wrong date for a project and then has to correct the mistake, you can require that the worker note the reason for the change.

You can also block workers from entering any future time except an upcoming absence.

Improved management of project tasks in a WBS

The WBS has been redesigned to let you plan the schedule, skills, resources, costs, and revenue for tasks in a project in one form. You can view and automatically correct discrepancies in task schedules as you enter task information. You can also specify whether the start of a task depends on the completion of previous tasks.

For more information, see Create a work breakdown structure of tasks for a project.

Improvements for creating WBS templates for project tasks

There are new methods for creating a WBS template. You can copy some or all tasks from another template, and also from a WBS for a specific project.

For more information, see Create a work breakdown structure template for projects.

Improved budget control for projects

You can automatically enter revenue budget amounts that are related to project cost amounts. You can also enforce budget limits for costs by project category.

For more information, see Create and submit an original project budget.

Intercompany pro forma invoices for project costs

You can create an intercompany pro forma invoice for items and services that are sent from one legal entity to another legal entity in your organization. You can specify the value and currency to use for the transferred costs.

For more information, see Create an intercompany project invoice.

What’s new in Microsoft Dynamics AX 2012 R3

What’s new

Description

Billing rules for project milestones

You can create an on-account billing rule for projects. You can then automatically create customer invoices that are based on the project milestones that you specify. When work on the project reaches a specified milestone, you can set the status of the milestone as complete and then generate an on-account invoice for the milestone. For more information, see Create billing rules.

Modify project transactions in an invoice proposal.

In AX 2012, a preliminary invoice is known as an invoice proposal. After you create an invoice proposal for project transactions, you can modify the sales price for the project transactions in the invoice proposal. You can also create and add a fee transaction to the invoice proposal. For more information, see About billing rules.

Access additional views of project budget balances.

In the Project budget balances form, you can view summaries of project budget balances according to the following criteria:

  • Transaction type

  • Category group

  • Cost template

  • Category

For more information, see Project budget balances (form).

Enhancements to tools for scheduling worker resources

AX 2012 R3 builds on the system for managing worker resource assignments that was introduced in cumulative update 7 for Microsoft Dynamics AX 2012 R2. Project managers now have additional options in AX 2012 R3:

  • You can view text descriptions of worker availability in resource scheduling grids, such as Partially available and Booked. These text descriptions are used in addition to the colors that were introduced in cumulative update 7 for Microsoft Dynamics AX 2012 R2 to identify worker availability.

  • You can schedule workers on an activity for a specific number of hours.

  • You can convert selected soft-booked hours to hard-booked hours directly from the project team.

  • The concept of reserving workers has been renamed booking workers.

For more information, see View booking details (form) and Key tasks: Create a schedule based on a project in AX 2012 R3 or AX 2012 R2 CU7.

Enhanced support for integrating projects between Microsoft Dynamics AX and Microsoft Project

AX 2012 R3 builds on the support for integration with projects in Microsoft Project that was introduced in cumulative update 7 for Microsoft Dynamics AX 2012 R2. Project managers now have additional options in AX 2012 R3:

  • You can use Microsoft Project to open a project in Microsoft Dynamics AX.

  • You can create and update projects that are maintained in the Microsoft Dynamics AX system by using only Microsoft Project and the Microsoft Dynamics AX Add-in for Microsoft Project. In cumulative update 7 for Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX also had to be installed on your computer.

  • You can create a project contract for a project in Microsoft Dynamics AX when you first integrate a project that was created in Microsoft Project.

For more information, see Create or update a project by using Microsoft Project.

What's new in cumulative update 8 for Microsoft Dynamics AX 2012 R3

What’s new

Description

Enhanced performance when calculating and posting fixed price revenue recognition

In this release of Microsoft Dynamics AX, the revenue recognition performance is enhanced to enable you to:

  • Set up recurring revenue recognition for fixed price projects

  • Recognize revenue on a straight line basis for fixed-price projects.

  • Calculate and post the percent complete revenue recognition on a fixed-price project more quickly.