web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Project budget Consumption based on Inventory Physical value. is it possible ?

(0) ShareShare
ReportReport
Posted on by

Hi,

We have some issue regarding how the project is consumed. To explain this I will need to explain how this happen, because I don't think it's a common issue. This is the story :

We have a project that sell our inventory to a customer. Therefore we create a Project and an Item requirement related to it. also we allocated some Project Budget to it based on the value of that inventory. After that, we proceed to execute the project, and everything goes smoothly.

Then the issue began when we are about to close the project. The PM required to submit a report of Project Statement. And turns out the cost of the inventory is not reflected there. After some investigation turns out this is the history of the transaction :

1. October 1st. We received the items from PO. We haven't received the invoicing from Vendor

2. October 6th. We ship the items to Customer (from SO). At the same day we issue an Invoice Proposal to Customer

3. October 15th. We received an Invoice from Vendor and register it into DAX.

4. October 25th. the PM must close the project, therefore he generated Project Statement report

From that history it is clear that the cost is not reflected because of the shipping inventory before PO invoicing. Therefore I told them to do Inventory recalculation. and it works as intended. now the cost is reflected as it should be.

Next the PM is required to generate the project budget report (using cost control). and this is where My issue is. The budget is not consumed as it should be, I assume this happen because of the same reason as above (shipping inventory before PO invoicing). 

My query is :

Is there any way to fix it ? if not the is there a way for Project budget to use Physical value when it consume the Project budget ?

Very sorry for the long post. I hope this doesn't confuse you.

BR,

Satria WS

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Satria WS,

    Can you let us know where and how you track your Budget?

    Do you use the forecast forms and the reducing forecast functionaltiy to track your budget?

    Do you track your budget in the project budget form?

    Do you track your budget in the budgeting module only?

    How are your budget parameters setup at the project level?

    Can you possibly provide some screenprints and numbers that illustrate the issue?

    Can you also let us know your exact AX Version (AX2012 R2/3 CU7/8/9...)?

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    Thx for the reply. I will answer one by one :

    Q : Can you let us know where and how you track your Budget?

    A : We use the functionality of Project quotation transferred into forecast. then forecast into project budget. As for tracking. we use total budget control. maybe this picture will help u much better :

    2605.Capture.PNG

    Q : Do you use the forecast forms and the reducing forecast functionality to track your budget?

    A : We only use forecast for a bridge though. we don't really allocate it monthly or use a forecast reduction feature

    Q : Do you track your budget in the project budget form?

    A : Yes we did as previously I explained on the first answer of your question

    Q : Do you track your budget in the budgeting module only?

    A : unsure about this. do you mean to ask if we use the project budget transfer to ledger budget functionality ? if so then the answer is no. We didn't transfer the project budget to ledger budget

    Q : How are your budget parameters setup at the project level?

    A : Again. we are unsure about this. Are you asking about the budget control parameter ? if so please refer to the picture in first question answer

    Q : Can you possibly provide some screenprints and numbers that illustrate the issue?

    A : We don't think it will be possible because we have signed an NDA  agreement regarding sensitive data. please make do with our example.

    Q : Can you also let us know your exact AX Version (AX2012 R2/3 CU7/8/9...)?

    A : Of course. ours is AX 2012 R2 CU7

    I hope this answer you questions.

    BR,

    Satria Ws

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Satria Ws,

    Based on what you write I would say that your setup looks ok.

    I can imagine that your system behavior is caused by a bug.

    Can you check LCS for available Hotfixes, especially the following ones:

    KB 3038043The "Consumed budget" value is calculated incorrectly in the project budget balance form

    KB 2929176Incorrect project budget control after project purchase order partial deliver...

    KB 3091042Budget control statistics does not restrict the allowed parameters based on the selected budget cycle and active budget control configuration

    KB 2870312Budget Control by Project displays incorrect information for various project Transactions

    Please note that there are more Hotfixes available on LCS but the ones listed seem to come close to what you describe.

    Would be great if you could check those and let us know whether they resolved your issue.

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    sorry for the long delay. I wll try those. but may not be able to took care of this issue in the next month. maybe in february. because of anoher issue and preparation in AX for 2017

    BR,

    Satria

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Satira,

    No worries. Would be great if you could keep us updated here. Many thanks, Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    This just comes to my mind. But in the example I mentioned above. how should the system works ? because if u ask me, I don't think the system (AX) done anything wrong here. it's just not perfect. but it makes sense to me.

    BR,

    Satria WS

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans