Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Project Expense - Budg...
Microsoft Dynamics AX (Archived)

Project Expense - Budget Issue

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

We are having some issue regarding the project budget for expense transaction.

Lets say I have project budget of $500. Then I posted a journal to this project $200, which makes the remaining project budget is $300.

Then I want to cancel that project transaction by posting a journal with reverse amount (-$200) to that project, which make the remaining project budget back to $500.

Now when I try to post a new journal to this project with amount $250, an error "The Entry for Category A, Activity B-XX on Project cannot be posted/approved because it would cause the cost budget to exceeded by 150.00" occurs. After we trace the error, we found that in table ProjBudgetAllocationLine, the total reduction amount somehow become become 400.00 (200 + 200) instead of 0.00 (200 - 200).

Is it a bug? How can I fix this?

*This post is locked for comments

  • Shaik146 Profile Picture
    Shaik146 932 on at
    Project Expense - Budget Issue
    Hi Can you share the code , please.
    i'm also facing the same issue.
  • Mav Profile Picture
    Mav on at
    RE: Project Expense - Budget Issue

    I am facing somewhat same issue , can you share the code which you think can solve the issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Ludwig,

    I did use budgeting module but not project forecast form.

    Temporarily, this issue is solved by customizing some codes in method of project increase budget, where the cost amount will be absolute first before calculated into reduction amount field in ProjBudgetAllocationLine. Still I am not really convinced with this type of solution.

    Regards,

    Andreas

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hi Andreas311,

    Do you make use of any additional budget controls, such as the one in the budget module and/or the project forecast form?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Ludwig,

    Thank you for response. The budget control of project is already set to cost only.

    Maybe is there another way to reverse project invoice rather than posting the negative amount?

    Regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hi Andreas311,

    I replicated your steps in a cu11 demo machine but did not run into the error you describe.

    Can you check whether your budget control is set up for costs or for costs and revenues?

    If it is set to costs and revenues can you change that parameter setting to costs only and try once again to post the invoice?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Ludwig,

    We are using AX2012 R3 CU11 version.

    Regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Andreas,

    What AX2012 version do you operate?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Ludwig,

    I haven't checked the LCS yet. Can you help me to provide the hotfix?

    Or have you experience that problem before?

    Regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Project Expense - Budget Issue

    Hello Andreas311,

    Have you already checked the available hotfixes on LCS?

    Best regards,

    Ludwig

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans