AX 2012 Committed Costs not Relieved upon Receipt

(0) Share

Report

Posted on by Liz Herrington

265

Hello. We are working in the Project management and accounting module within AX. When we create a PO, a committed cost is created for the project, but when the item is received, the committed costs remain on the project rather than being relieved. Does anyone know how to fix this?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

Hello Liz.

what you are requesting can't be fixed with std. AX. The "problem" is the way AX looks at costs and revenue. transactions won't be relieved from commited costs before they are fully financially updated (invoiced), the reason for this's that the system dosn't know the actual cost before this point.

When you think about it, the logic is actually quite fair. how can it be anything else than commited when you haven't paid for it?? :-)

Was this reply helpful? Yes No
Liz Herrington 265 on at

Like (0)

Report

Jesper,

Thanks for your reply. That does make sense. We are seeing committed costs staying on POs that have been cancelled as well. With committed costs still on the project via cancelled POs, we are unable to close the projects.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Liz.

You're welcome.

If you reconfirm / finalize the PO after cancellation, the cost commitment should be removed from the project.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jesper,

I hope this finds you well,

We have an issue related to the Committed cost in AX 2012 R2 CU7, some of the lines in the committed cost are related to "Vendor invoice" transaction origin, but these invoices are already posted!

My first question; is it acceptable to have a value in the committed cost for these already posted invoices, if yes, what does it mean to have it in the committed cost report.

My second question; there are lines for these invoices in the

VendInvoiceInfoLine_Project table, if we deleted the lines from

this table there will be no committed cost for them in the next

generation! should this table be cleaned for these invoices ?

Can you help on this please ?

Was this reply helpful? Yes No
Suggested answer

David Massey on at

Like (0)

Report

Do not delete the VendInvoiceInfoLine_Project records. This will not solve correctly the issue. There are two types of commitment tracking within project management and accounting. You haven't indicated where you are looking. I'm assuming you are looking at the commitment from the project level and not on a contract funding limit.

This information is tracked in the table CostControlTransCommitedCost. The table should contain the original commitment and a reversing entry (Reverse field is set).

Yes, you can have committed costs after a Vendor Invoice is posted when there is only a partial receipt or price variances from a purchase order. In this case you need to Finalize the purchase order to relieve the commitment variance. If there is no backing purchase order for the vendor invoice, there should be no commitment after posting.

Was this reply helpful? Yes No

Community site session details

AX 2012 Committed Costs not Relieved upon Receipt

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

AX 2012 Committed Costs not Relieved upon Receipt

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates