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.