Replacement Timesheet Upload File Workaround

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.