There are quite a few steps for a transaction to be processed to the WIP, how are the timestamps for each action recorded in the Clarity tables?
The following example illustrates how timestamps get recorded into the date fields for each transaction through the financial workflow up to and through the PPA_WIP tables, excluding Chargebacks tables.
Timesheet is saved at 8:42:10 AM then approved at 8:56:20 AM
Timesheet is posted at 9:09:03 AM
Note: If the transaction was created by XOG rather than a timesheet, the transaction would first arrive at imp_transactionimport with importdate being the time when XOG was completed for the transaction.
Post Transactions to Financial job is run at 9:27:38 AM
Note: If the transaction was created by a voucher rather than a timesheet or XOG, the transaction would arrive at ppa_transcontrol with entrydate and lastupdatedate being the time when the 'Submit' button is clicked on the Transaction Entry Detail page. This transaction then can be posted to WIP. There is no need to run Post Transactions to Financial job for vouchers.
Do Post to WIP at 9:45 AM
Create a WIP adjustment/transfer/reverse, etc
NOTE: It is not recommended to perform a WIP Adjustment on transactions that originated from Timesheets to change dates or quantities or to transfer the transaction as this will cause a discrepancy between financial transaction quantities and Timesheet quantities. The 'Import Financial Actuals' job does NOT adjust any data on Timesheets. Other WIP Adjustments can be made to Timesheet financial transactions such as changing rates and costs or chargeable status.
CLRT-63673 has been logged for the fact that the timestamp for Post to WIP isn't recorded into the ppa_wip.lastupdatedate, details as follow:
Issue
The field ppa_wip.lastupdatedate does not record the time when a transaction is posted to WIP. When a transaction is posted to WIP the lastupdatedate actually keeps the time when Post Transactions to Financial job is run. This could lead to incorrect reporting that uses the field to pull records from a certain period.
Steps to Reproduce
Expected Result : ppa_wip.lastupdatedate reflects the time when Post to WIP was done
Actual Result : ppa_wip.lastupdatedate still reflects the time when the Post Transactions to Financial job was run. It is unchanged from step 3
Status
This issue has been reviewed by Development and Product Management. At this time there are no plans to make any changes to this area of the product. For more details please review the Customer Reported Defect Resolution Policy