Project Expense - Budget Issue

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Andreas311,

Have you already checked the available hotfixes on LCS?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Andreas,

What AX2012 version do you operate?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Ludwig,

We are using AX2012 R3 CU11 version.

Regards

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mav on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TestBot 958 on at

Like (0)

Report
Copy link

Link copied!

Hi Can you share the code , please.

i'm also facing the same issue.

Was this reply helpful? Yes No