What's new: Intercompany timesheet entry in projects
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
In Microsoft Dynamics AX 2012 Feature Pack, an organization can allow a worker in one legal entity to enter hours that are worked for a project that is managed in a different legal entity, without requiring that the worker switch company data sets.
Overview
Item |
Description |
|---|---|
Required |
No |
Feature areas affected |
Project management and accounting Human resources Home (Timesheets) |
Stakeholders |
Business decision makers Technical decision makers Implementation team members Independent software vendors (ISVs)/developers Partners |
New functionality
After AX 2012 Feature Pack is installed, a legal entity can perform the following tasks:
In the Project management and accounting parameters form, enable the functionality for intercompany timesheets.
In the Transfer price (hour) form, specify the hourly prices that the legal entity charges related legal entities for loaned workers.
In the Sales price (hour) form, specify the hourly prices that the legal entity charges customers for borrowed workers.
In the Worker/project validation groups and Worker/category validation groups forms, add workers from other legal entities to the legal entity’s validation setup.
By enabling the Intercompany timesheets feature, you add the following functionality:
Loaned workers can submit timesheet hours for project work that they perform for the legal entity that borrows them.
Project managers can review and approve timesheet submissions from borrowed workers. The loaning legal entity can track the amounts that are due from the borrowing legal entity.
Additionally, the Intercompany timesheets feature adds the following two new posting types:
Intercompany revenue – The account that records intercompany revenue is used by the loaning legal entity to record revenue that it receives from the loan of resources to a borrowing legal entity.
Intercompany cost – The account that records intercompany costs is used by the loaning legal entity to record the true cost that the legal entity incurs by loaning resources. An intercompany timesheet for a loaning legal entity is posted to an intercompany cost account that is offset by a payroll allocation account. By default, the financial dimensions from the worker’s profile are added to the posting entry.
Special considerations
The invoice for intercompany time that the loaning legal entity creates cannot be sent to the borrowing legal entity through the regular accounts payable process. (In this case, the borrowing legal entity’s account is handled in the same manner as any other vendor account). Instead, the due-to and due-from amounts are recorded in ledger accounts. Based on this information, the borrowing legal entity can determine how much to pay the loaning legal entity. After the loaning legal entity settles those payments against the ledger entries, the loaning legal entity can determine which hours have been paid for.
Because of the introduction of the Intercompany timesheets feature in AX 2012 Feature Pack, the posting of timesheets is handled by the accounting framework that was introduced in AX 2012. Therefore, hour journals are no longer used to summarize subledger entries or any subsequent project transactions are that are related to timesheets. Additionally, the Default posting level attribute that was specific to Project management and accounting has been deprecated. If any customized solutions have been built on the timesheet functionality in AX 2012, you might have to update these solutions for AX 2012 to account for this change, even if you do not intend to take advantage of the Intercompany timesheets feature.
Comparison with Microsoft Dynamics AX 2009
Intercompany timesheet functionality is new in AX 2012 and has changes to the following areas:
Hourly transfer prices and sales prices
Validation groups
Timesheet submission and approval
Recording of revenue and costs
Hourly transfer prices and sales prices
What can you do? |
AX 2009 |
AX 2012 |
Why is this important? |
|---|---|---|---|
Specify hourly prices for workers who are loaned to a related legal entity. |
Not available |
Project management and accounting supports the hourly transfer process. Project management and accounting stores transfer prices for workers who work on projects that are run by related legal entities. You can create transfer prices for any combination of effective date, worker, project, category, and borrowing legal entity. |
Borrowing legal entities are charged the correct amount for the hours that a worker from another legal entity contributes to a project. |
Specify hourly sales prices for borrowed workers who are assigned to a customer project. |
Not available |
Hourly sales prices can be assigned for workers in your own legal entity and related legal entities. |
Sales prices for borrowed workers can be specified in your legal entity’s records in Microsoft Dynamics AX. |
Validation groups
What can you do? |
AX 2009 |
AX 2012 |
Why is this important? |
|---|---|---|---|
Control which projects and categories a worker can be associated with. |
Transactions cannot be entered into hour journals for projects and categories that a worker has not been validated for. Hour transactions can be entered only for projects in the worker’s legal entity. |
Workers can enter hours in timesheets, and can enter these hours not only in journals, but also for projects and categories that the workers have been validated for. You can add workers who are borrowed from another legal entity to validation groups in your legal entity’s records. |
Workers can select projects that are managed in their own legal entity, and also in other legal entities for which they have been validated for work. |
Timesheet submission and approval
What can you do? |
AX 2009 |
AX 2012 |
Why is this important? |
|---|---|---|---|
Workers can submit timesheets, and project managers can review and approve timesheets |
Not available |
Workers can submit hours for project work in their own legal entity. Additionally, workers can submit hours for work that they did for legal entities that borrowed them. Project managers can review timesheet submissions for work that was done by workers in their own legal entity and by workers that were borrowed from related legal entities. |
A worker who is employed by one legal entity can enter timesheet hours for work that was performed on projects in a different legal entity, without having to be employed by the legal entity that is managing the project. Project managers do not have to log on to multiple company accounts in Microsoft Dynamics AX to submit and review timesheet hours for intercompany project work. |
Recording of revenue and costs
What can you do? |
AX 2009 |
AX 2012 |
Why is this important? |
|---|---|---|---|
Specify the account in which to record revenue that is received from the loan of a worker to another legal entity. |
Not available |
The new Intercompany revenue posting type is available in the Project groups form. |
A loaning legal entity can easily track the revenue that it receives from the loan of a worker to a project in another legal entity. |
Specify the account in which to record the true costs that are incurred from the loan of a worker to another legal entity. |
Not available |
The new Intercompany cost posting type is available in the Project groups form. |
A loaning legal entity can easily track the costs that it incurs by loaning a worker to a project in another legal entity. |
More information
For more information about intercompany timesheets, see About intercompany timesheets.