Intercompany Timesheets Management in Microsoft Dynamics AX 2012

Hi All,

I had been very busy with several things on my plate at work. Work keeps all of us busy.

It feels bad for not being able to spend time on my blog and finally decided to take out some time and write here.

In today’s post, we will explore and discuss about one of the important functionality in the Project Management area which is “Intercompany timesheets functionality”.

In every mid sized to a large-sized professional service industry, it is a common practice that employees/workers of the organization keep working on the projects of different legal entities where as they will be employed in only one legal entity.

The loaning and borrowing activity of employees between the legal entities is essential to make efficient utilization and putting right people if the right job possible. When working on the projects of legal entities other than their employing legal entity, Microsoft Dynamics AX 2012 make it simple for the employees to register their times/hours directly on the projects of the contracting company/resource borrowing company, without having the need for the employee to enter times at multiple places and multiple times.

NOTE : Intercompany Timesheets Management functionality will be available only if the AX 2012 feature pack is installed.

In the subsequent steps and paragraphs of this post, we will explore the various setups and the overall intercompany timesheets operation in AX2012.

Let us refer the two legal entities which exchange the employees as the Loaning entity/Resourcing and the Borrowing/Contracting entity.

The following setups needs to be completed in AX 2012 in the Loaning legal entity.

1. Enable the intercompany timesheets management in the project parameters screen.

2. Setup pricing details for the employees who are to be loaned. This includes setting up the cost price and the transfer price. The cost price however is ideally setup for all employees weather they will be loaned or not. The transfer price represents the price which the loaning legal entity charges to the borrowing legal entity.

Transfer price setup:

Cost price setup:

3. Setup the ledger accounts for the inter company cost and revenue.

4. Make sure that the debit and credit accounts for the intercompany transactions are setup.

This completes the setup required in the loaning/resourcing company.

Now, let us complete the setup needed to be done in AX 2012 in the borrowing legal entity.

1. Setup sales prices for the borrowed resources which the the actual selling price in the project.

2. Setup the debit and the credit accounts for the legal entity the worker will be borrowed from.

3. Further additional setups can be done, like assigning projects and categories to the borrowed worker if the validation functionality is implemented.

Now that we are done with the minimum setups required for the intercompany timesheet functionality to be operational, let us take a look at the steps/process by which the borrowed employee can submit this timesheets in the borrowing/contracting company.

• Employee logs into AX 2012 enterprise portal and navigates to the new timesheets screen.
• Notice the new Legal entity field in the timesheet line which gets enabled when we enable the intercompany timesheets in AX2012.

• Also notice that the loaning and the borrowing/contracting companies are displayed in the look up of the legal entity field. The worker will select CEE as the legal entity and enter their times in.

So the employee will be able to submit his/her times in the project of the other legal entity without having to be an employee of that legal entity.

The back end accounting is then done automatically based on the setups done.

For any queries regarding the inter company timesheets functionality, please do not hesitate to contact me.

Till next time !!!