Replacement Timesheet Upload File Workaround
ISSUE: When a timesheet is imported under Hourly and Daily Timesheet Import > Update and a correction is needed, imported data is deleted/removed and the File is updated and Re-Imported.
Upon data being re-imported, it is expected a new Batch should be created for the new import set. It is not.
Data goes into Batch. Batch was Posted > Reversed and then data is deleted under Daily Rate Timesheet.
Steps to Replicate
PAYROLL > PAY INPUTS > TIMESHEET > HOURLY & DAILY TIMESHEET IMPORT
ATE Daily + Approved > Trial and then Update > Submit
**Batch is created**
PAYROLL > PAY INPUTS > TIMESHEETS > BATCH POST AND REVERSE
**Batch is Posted**
At this point issues are found with the data.
PAYROLL > PAY INPUTS > TIMESHEETS > BATCH POST AND REVERSE
**Batch is Unposted**
PAYROLL > PAY INPUTS > TIMESHEETS > DAILY RATE
**Choose Delete All Entries From This Batch**
At this point customer should be able to simply re-import Timesheet File > See new Batch Number > Post > Continue onward as normal
PAYROLL > PAY INPUTS > TIMESHEET > HOURLY & DAILY TIMESHEET IMPORT
ATE Daily + Approved > Trial and then Update > Submit
**SAME Batch is created**
REPLICATED: New Batch is not created. Data stays tied to incorrect batch number and therefore does not show under Web Transaction Approval and Query.
FIX: To be scheduled and fixed by development. Daily Rate > Delete should allow for a new Import to create new Batch and be process and posted accordingly.
Workaround
Coordinate with client so that IT can run the below script in the Production Environment.
STEP 1: This script will change the Status to Approved and change the Pay Number and Batch No to NULL.
select * from EC_WEB_TS_TRANS
where EMP_GROUP_CODE = 'EMP_GROUP'
and BATCH_NO = 'BATCHNAME'
**Here we want to confirm the Number of Rows with client to confirm correct amount**
update EC_WEB_TS_TRANS
set TRANSACTION_STATUS = 'A', PAY_NUMBER = NULL, BATCH_NO = NULL
where EMP_GROUP_CODE = 'EMP_GROUP'
and BATCH_NO = 'BATCHNAME'
**Confirm the same number of rows returned above are affected**
STEP 2: Re-run 'Hourly & Daily Timesheet Import Process' with the corrected Import File
STEP 3: They will use the 'WEB Transaction Approval by Group' Screen to submit the process.
STEP 4: Post the batch using 'Batch Post and Reverse' screen.