Attendance Transaction entry

[DBan13]

We encountered an error with the attendance transaction entry form. The form appeared locked because the transaction numbers were out of sequence. This was caused by user error. We would like to delete all of the current entries and start from scratch. We have a spreadsheet that records time taken and time accrued per pay period, so it would just be a matter of inputting the time taken and accruing the vacation.

I deleted all of the records in the TATX1030 table and this did work to fix the Attendance Transaction entry form. However, I discovered a few problems:

• I did some double-checking and realized that there is another table TATM2030 that appears to have YTD totals. So when I add new attendance transactions, it adds to these totals. I discovered this by running various reports and then working backwards to see where these totals came from.

• Another issue is that it does not appear to accrue the vacation anymore. I went to the screen where it lists each pay period and deselected the accrued check box. I then ran the accrual again from 1/1/2006 to 3/31/2006, but it did not enter the transactions. I'm sure there is probably something still set that says the accrual was done for these pay periods, but I do not know where to find it. I double-checked and the accrual schedule appears to be set up correctly.

• Also, when are the transactions posted to the payroll side? I'm not sure I understand exactly how this works and this may be part of the problem. Many transactions had already been posted.

Thanks for your help!

 

[BobSchleicher]

Try running check links to see if it will clean up the totals.

BobSchleicher

 

[DBan13]

I figured this out and got it to work, but it was not easy. Here is what I had to do:

* Delete all of the transactions from TATX1030 table
* Zero out the VACAVLBL field in the UPR00100 table
* In the TATM2030 table I had to set the HOURSAVAILABLE_I field to 0 where the TIMECODE_I field = 'VAC'
* In the TATM1030 table I had to set the NEXTACCRUALDATE_I field to 1/1/2006 for all employees hired on or before 1/1/2006 and set the NEXTACCRUALDATE_I field to the SENIORITYDATE_I field for those employees hired after wherever the TIMECODE_I = 'VAC'.

We were then able to accrue the vacation thru the current pay period and manually enter the time taken thus far. We ran all of the reports and checked individuals records and everything appears to be correct.