Question:

How do you trace a row posted into PPA_WIP from a resource timesheet back to the original timesheet record in PRTimeSheet?

Answer:

When a Timesheet Entry has been exported into the Financial Module for processing, the entry record will have the following field set to true

prtimeentry.prrmexported = 1

The prtimeentry.prid record contains segmented entries for the cells in the timesheet. Therefore, one record in the PRTimeEntry table can represent more than one record in the financial PPA_WIP table.

Once the time entries have been exported into the financial module, the transactions are processed and posted into WIP. Once the transactions are in WIP, you can then compare the timesheet posted hours versus the financial posted hours.

The PPA_WIP record has fields that help identify if it came from a timesheet entry record:

ppa_wip.sourcemodule = 51** Note: The 51 is an indicator that this came from posted timesheets.

ppa_wip.externalbatchid = prtimeentry.prtimesheetid** Note: this is the link for the financial transaction to the Timesheet Record ID

ppa_wip.external_id = prtimeentry.prid** Note: this is the link for the financial transaction to the Timesheet Entry (row) record ID

To compare actual hours on a posted timesheet to the posted financial transactions, you can sum up the financial transactions and the timesheet entries and group by Timesheet for that resource.