[Terry Horn]

We upgraded from GP 2013R2 to GP 2016R2 over the weekend.

We use GP Project Accounting and now must use the Project Time Entry versus PDK/BP in GP 2013.

When we run the missing timesheet report, inactive employees are showing on the report.  The employees are marked inactive in both Payroll and Human Resources.

Any ideas on how to get these employees off the missing timesheet report?

Thanks in advance for your help.

——————————
Terry Horn
IT Manager
Owensboro Municipal Utilities
Owensboro KY
——————————

[Guillaume Simard]

I don’t have GP2016 available to confirm but I think that you will need to review the following stored procedure : PTE_FillTimesheetWFStatusData

You will have to filter inactive employees in the underlying query.

Regards

——————————
Guillaume Simard
Negotium Technologies Inc.
Montréal QC
——————————
——————————————-

[Beat Bucher]

Hi Terry,
From where do you run this ‘missing timesheet’ report in GP 2016 ?
I use my own missing TS reports from SQL server, but we’re still on 2013R2.. haven’t switched to 2016 because of the PTE change & lack of proper BP replacement..

The code is pretty primitive as it looks for missing entries in the PDK TS header table vs. the last period entries.. I think the code could easily be adjusted for PTE, as the table structure has remained the same.. this works fine, except if you have a new employee or one that left.. 🙂

SELECT T1.EMPLOYID

, (left(UPRT1.LASTNAME,4)) + (left(UPRT1.FRSTNAME,1)) as username

, UPRT1.LASTNAME

, UPRT1.FRSTNAME

FROM PDK10000 T1

INNER JOIN UPR00100 AS UPRT1 ON T1.EMPLOYID = UPRT1.EMPLOYID

WHERE NOT EXISTS

(

SELECT T2.EMPLOYID

, T2.PDK_TS_No

, T2.PDK_Document_Status

FROM PDK10000 T2

WHERE T2.PDK_TS_No LIKE ‘%-TS-042917-%’ –> TS from this week

AND PDK_Document_Status<>9 –> unposted TS

AND T1.EMPLOYID=T2.EMPLOYID

)

AND T1.PDK_TS_No LIKE ‘%-TS-042217-%’ –> TS from Last week

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Terry Horn]

Project panel
Reports panel
PTE Timesheet Status –> select Missing in the status dropdown box

——————————
Terry Horn
IT Manager
Owensboro Municipal Utilities
Owensboro KY
——————————
——————————————-