PTE Missing Timesheet

  • PTE Missing Timesheet

    Posted by DSC Communities on May 3, 2017 at 8:13 pm
    • Terry Horn

      Member

      May 3, 2017 at 8:13 PM

      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

      Member

      May 4, 2017 at 9:53 AM

      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

      Member

      May 5, 2017 at 10:23 AM

      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

      Member

      May 5, 2017 at 10:45 AM

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

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

    DSC Communities replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘PTE Missing Timesheet’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!