Project Remaining Budget Calculation- Wrong Values.

(0) Share

Report

Posted on by Community Member

Total Budget Awarded to Project Category "A"= 200,000.

A Purchase Order of 2,500 was created, confirmed, received and invoiced. Later the Item Requirement was posted fully. Now the Budget form shoes the following values:

Approved Budget= 200,000

Commitment= 2,500.

Consumption= 2,500

Remaining Budget= 195,000. (Which is wrong, as only the consumption should be accounted for and once the commitment is converted into consumption, it should no longer show up on the Project Budget Balances form.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Jill,

Have all PO lines been posted or is there still something open?

Why did you post the item requirement fully?

Didn't AX post the expense at the time you invoice the PO?

Can you double check the posted cost amounts in the posted transactions form? Can you see $5000 or $2500 posted?

What is your AX System Version (kernel+appl Version)?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi Ludwig,

All the PO lines have been posted.

The Item requirement was posted fully to consume the received items.

By 'post the expense', I'm assuming you mean consume the Project Budget. Invoicing the PO did not consume the Budget.

[ I had to run the Generate Committed Cost for the invoice to create a commitment on the budget. Strangely, confirmation of the P.O did not create commitment even though my parameters are set-up for creating commitment for both PO and Vendor Invoice]

Posted Transaction form states an amount of 2,500.

Kernel Version: 6.3.3000.1086

App Version: 6.3.3000.111

Best Regards,

Jill

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Jill,

Can you check whether this hotfix, that has been released with CU11 (you run CU10) helps?

KB 3167226Wrong committed cost generated for a purchase order linked to item requirement

Here is the problem description from the hotifx:

When you consume the item requirement on the project by making an actual cost, the vendor invoice amount incorrectly displays under the committed cost. The system is generating double committed cost by getting wrong project cost control.

There are a couple of additional Hotfixes available that also relate to committed costs, item requirement, etc. which have just recently be issued. Maybe also take a look at them through LCS.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig, Let me attempt that.

Best Regards.

Was this reply helpful? Yes No
Suggested answer

Nour Desoki 555 on at

Like (1)

Report
Copy link

Link copied!

Hello Jill ,

what is your setup in Commitment cost in project management & accounting parameters module ?

what is your setup in project purchase order consumption in parameters ?

Please post a screen shot for screen if possible ?

Please check if there is any item journal isn't posted??

the system behavio

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Noureldeen Desoki

I agree with you my friend.

Was this reply helpful? Yes No