web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Project committed cost remains open after the timesheet transaction was posted

(0) ShareShare
ReportReport
Posted on by 15

Apparently two project committed cost records were created when the timesheet transaction was generated.

When the timesheet was posted, one of the records was reversed. But the other one remained open.

image011.png

Do someone know why two records were created with the same transaction ID for one timesheet line?

Thanks!

I have the same question (0)
  • Rafael Arrieta Profile Picture
    15 on at
    RE: Project committed cost remains open after the timesheet transaction was posted

    Hi Mark,

    Thank you for your help.

  • Suggested answer
    MarkB45 Profile Picture
    755 on at
    RE: Project committed cost remains open after the timesheet transaction was posted

    Hi Rafael,

    The system should auto clear the committed costs when the cost is finally posted and has hit the GL. This is the order of committed costs for timesheets.

    Timesheet approved - Committed cost created.

    Post timesheet - Committed cost reversed,  new line created for the timesheet  journal posting

    Journal posted in GL - Committed cost reversed and closed.

    Is it possible here that the timesheet has posted but the voucher behind it has not? 

    Please can you check General ledger -> Periodic tasks -> Subledger journal entries not yet transferred to see if the voucher is definitely posted. Or try and view the voucher from the transaction under Project -> Manage -> Posted Transactions.  

    If the timesheet has a voucher posted in the GL also then there is a error and yes the committed cost needs to cleared. In AX2012 when we had AOT access we could do this by removing the "open" flag against the line on the DB table which you can potentially still do if this is not a Production environment.

    If this is a Prod env. without access to the AOT/data you may need to log the issue with MS support and get them to clear it. 

    Another alternative would be to run the consistency checker in Sys Admin for the project module this might just pick up stranded cost commitments but I have never tried it.

    Hope this helps.

    KR

    Mark

  • Rafael Arrieta Profile Picture
    15 on at
    RE: Project committed cost remains open after the timesheet transaction was posted

    Hi Mark, thank you for your reply.

    The timesheet transaction has been fully posted. Another committed cost should have not created. This open committed cost does not allow the project cost recognition. Can I delete this committed cost? Would there be any impact in the project?

    Thanks!!

  • Suggested answer
    MarkB45 Profile Picture
    755 on at
    RE: Project committed cost remains open after the timesheet transaction was posted

    Hi Rafael,

    The committed cost functionality tracks a transaction as it moves through the posting process. Each stage the system reverses the current committed cost and replaces it with the new committed cost after the transaction is completed.

    In your case the top line is the cost being created, it is then reversed out (middle line) and the bottom line is created which is the current "open" committed cost as it has a tick in the "open" field.

    Has the timesheet been fully posted and the costs are showing under "posted transactions" at the point of taking the screenshot? If so then the committed cost should have been settled. If not there is still another process to do to clear the  committed cost.

    KR

    Mark

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,206

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 847 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 596 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans