Public Profile
  • Timesheet Submission Improviements

    We have employees that utilize timesheet templates. The employee may only utilize just a few of the lines on the template on a given week. What I am finding in tracing the SQL and Dex code is that GP is processing each day for each line regardless if any time has been entered thus causing the submission process to be slower than it needs to be. Two stored procedures could be modified to only process the lines where time has actually been entered on. The first stored procedure is zDP_PTE10001L_1 by adding an additional AND clause "and pte_quantity<>0 " which will remove the lines that do not have time on them from being considered. The second stored procedure is a temporary stored procedure that gets generated in the dex code. In this particular instance, the stored procedure is ##zDP_2113547F_1. When executing that stored procedure , you get results which includes all the lines regardless if any time has been entered for them… If you modify the stored procedure to include a where clause to exclude results from the pte_qty_week_x columns that equal 0 you receive significantly less results. By making the changes, GP will only process the projects that have time applied to them. You can further optimize the process by only processing the actual day if pte_qty_week_1 through 7 is greater than zero. In a sample dex trace, GP calls a lot of stored procedures for each day that scan a lot of PA tables even if no time has been entered for it. For example,it will will loop through each call 7 times for the one line that the employee has a pay code on even though he did not even use it.