SYMPTOMS
I am trying to delete a user within PDK and received a message indicating this user still had an unprocessed Timesheet or expense. Unfortunately, the message did not tell me in which time period the unprocessed transaction was present.
Is there a way to generate a listing or report of all unprocessed timesheets and expenses throughout all periods?
CAUSE
An unprocessed timesheet or expense exists.
RESOLUTION
You can run the following script in Query Analyzer against the company database. You will need to fill in the Employee ID of the user you are trying to delete.
Select * from PDK10000
Where PDK_Document_Status < 8 and EMPLOYID = 'enteremployeehere'
Go
Select * from PDK10500
Where PDK_Document_Status < 8 and EMPLOYID = 'enteremployeehere'
Go
This will provide a list of timesheets and expensesthat need to be deleted or processed.
This article was TechKnowledge Document ID:33867
I am trying to delete a user within PDK and received a message indicating this user still had an unprocessed Timesheet or expense. Unfortunately, the message did not tell me in which time period the unprocessed transaction was present.
Is there a way to generate a listing or report of all unprocessed timesheets and expenses throughout all periods?
CAUSE
An unprocessed timesheet or expense exists.
RESOLUTION
You can run the following script in Query Analyzer against the company database. You will need to fill in the Employee ID of the user you are trying to delete.
Select * from PDK10000
Where PDK_Document_Status < 8 and EMPLOYID = 'enteremployeehere'
Go
Select * from PDK10500
Where PDK_Document_Status < 8 and EMPLOYID = 'enteremployeehere'
Go
This will provide a list of timesheets and expensesthat need to be deleted or processed.
This article was TechKnowledge Document ID:33867