AnsweredAssumed Answered

Track Timesheet Posting to Financial Posting

Question asked by Liz_Williamson on Jun 28, 2012
Latest reply on Jun 29, 2012 by another_martink
Is there a way to tie the timesheet posted record to posted financials? I want to make sure all timesheet transactions are being posted and I want to identify which items have not financially posted. It used to be that all the records (financial hold, close) would show in invalid transactions and related table, but now (v13 and I think in some versions of v12) they don't show in invalid transactions.

I can't seem to find any internal mapping. I am using the prj_blb_slice table to retrieve the timesheet entries and the ppa.wip table to retrieve the posted financials. I am able to tie records by hours/date/resource/task, but sometimes the hours don't match because of adjusted timesheets.

Is there something else?

Thanks,
Liz

Outcomes