You’re offline. This is a read only version of the page.
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
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
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
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
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
Hello Ludwig,
We are using AX2012 R3 CU11 version.
Regards
Hello Andreas,
What AX2012 version do you operate?
Best regards,
Ludwig
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
Hello Andreas311,
Have you already checked the available hotfixes on LCS?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (