Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

Posted on by Microsoft Employee

Hello,

I was wondering if anyone has experience the following...

We had a Project set up in AX Dyanmics which incurred a lot of cost in error due to a PO set up. We had to transfer the costs from the wrong project to the correct project. We transferred the cost by doing the following:

-Using the Adjustment transaction for current month items

-Using a $0 AP invoice for older items through Subcontractor and Materials

-Using a $0 Hrs Journal for Labor

Now the old/wrong job has the correct total of Posted Project Transactions (PPT) associated with it. The problem is that when we create the Estimates the Total Cost of the wrong project is not correct and does not tie to the PPT. It shows that we transferred too much to the correct project resulting in a negative total cost.

We unfortunately do not have anyone on our team who has experienced this or knows how to resolve. Is there maybe a hold up in the backend of the system that we just need to clear a cache or is there a report we can run that might show the detail of the Estimates Total Cost?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

    Hi RyannHofhine,

    Doing some corrections in the 'background' by a developer can be a risky thing especially when it comes to inventory transactions and projects.

    What might help is having a developer who helps you debugging things in order to identify why the adjustment is not picked up.

    This should be done first before thinking about making a correction by code, which can only be a means of last resort.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

    Hello Ludwig,

    Yes to both and the re-run didn't work.

    I think for some reasons unknown the original posted transaction is not being picked up by the estimate calculation. Someone at my company suggested having the AX Developer go in the background for those posted transactions and have them change the code to 7 so that they will be picked up in the following monthly estimates. Does that sound correct? Still unsure why they weren't picked up to begin with.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

    Hello RyannHofhine,

    I assume that you refer to the project estimate process, right?

    Have you tried to cancel and re-run the estimate?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

    Hi Ludwig,

    Thank you for your response. I actually was able to narrow down the root of the cause for the variance (thanks to your posts). I unfortunately don't know how to fix or why this happened. Maybe you could shed some light or point me in a certain direction?

    I found that the cause of the variance was due to current period adjustments made through the Adjust Transaction. While the Adjust Transaction corrected the total in the Posted Project Transactions for the Project it caused a variance in the Estimate Total Cost. I used the Edit function to identify the items and it seems that when I did the Adjustment it only reflected the adjusting entry in the Estimate Total Cost (meaning I only see the Credit to remove the cost) I don't see the original posting of the cost thus the credit is the balance in the Estimate Total Cost (as opposed to netting to zero). Have you ever seen this before?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Variance Between the PMA Estimates Total Cost on A Project and the Posted Project Transactions

    Hi RyannHofhine,

    Have you done the corrections already in your productive environment or in a demo/test system first?

    I hope for the latter.

    About your issues:

    #1 In general the adjustment functionality is the right one to use to get things corrected.

    #2 I would not have done this because (a) it messes up your inventory prices if you use a current valuation model such as FIFO, LIFO, etc. and (b) You cannot directly influence the cost price that is used and posted to your project if you use a current valuation model (FIFO, LIFO, etc.) When you use such valuation models, inventory recalculations/closures will result in adjustments that might end up in a situation where you have to do subsequent corrections.

    #3 Did you record your labor costs in an hour journal or how did you realize that?

    Without having more details, it sounds that the corrections made things probably worse and as a result, you would have to go through each and every transaction and correction recorded to see what is the correct and wrong amount posted.

    If you have not done this before, I would recommend that you get some help probably from external consultants.

    Otherwise, you run the risk that things get even more complex and difficult to correct.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans