Taking advantage of the On hold funding sources in Project Contracts in Microsoft Dynamics AX 2012

Hi,

Hope everyone is doing well and having great times in this festive season.

In today’s post I will discuss a very small and useful functionality which is introduced in the project management and accounting module of AX 2012. This is the new “On hold funding source type” for project contracts.                                                                       

When you use the funding limits on the project contracts, the “On hold” funding source can prove to be very useful in allocating any transaction amounts which exceeds the specified funding limits for the other funding sources present in the project contract. The on hold funding source is referred to one of the internal organizations of AX 2012, which are the business units setup in the company.

Let me now elaborate this with an example.

Let us say there is a project contract with one customer as funding source and one on hold funding source. Also there is a funding limit of $2000 for the customer which is the funding source for the project contract. Take a look at the screen below for such a project contract.

image

Now, let us post few transactions on the project belonging to this project contract, such that the amount exceeds $ 2000 and see how the on hold funding works. The below screenshot shows an hour journal posted on this project such that the total sales amount exceeds $2000, the funding limit for the customer.

image

If we go to the project posted transactions and take a look at the funding allocation, this will show how the exceeded amount of $100 is allocated to the On hold internal funding source and the allowable $2000 is allocated to the customer funding source.

image

image

Now that the exceeded amounts are allocated to the On hold funding source, you can use adjustment function later to allocate these amounts back to the funding source when funding limit changes after agreement with the customer. The advantage of having the On hold funding source is that, it will allow posting of transactions even if the sales amount exceed the specified funding limits for the funding customers in the project contract.

Let us now change the funding limit to $3000 as the customer has agreed upon the same and then run adjustment for the transaction to see how the amount which was allocated to the On hold funding source, gets allocated back to the customer.

Funding limit change is shown in screen below.

image

After you change the funding limit for the customer in the project contract, adjust the transaction to see the impact how the transaction gets allocated back to the funding source.

Select the adjusted transaction and verify the transaction to see that the amount $2100 is now allocated to the funding source which is Forest wholesale.

image

image

Powerfully Simple. Microsoft Dynamics AX 2012.

image

Feel free to ask any queries about this.

Thanks

Sandeep

2 thoughts on “Taking advantage of the On hold funding sources in Project Contracts in Microsoft Dynamics AX 2012

  1. Excellent post Sandeep – really useful
    I am however having a slight problem that maybe you could help with?

    I set up the on hold funding source as you demonstrated, and this works perfectly with posting hour journals – however if I post hour transactions through the portal using timesheets – I don’t get the expected results – if a timesheet exceeds the funding limit – the whole of the hours on the timesheet go to the on hold funding source instead of being split – any idea why that might be? I’m on AX2012 r2.

    Thanks for time..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s