Hello - Several features around PR workflows generate timecard lines for employees (ex: auto overtime and auto earnings). When these lines are created they have a NULL approval status. My update request would be to have the status default to as 'Approved'. WHY?...when running audits these auto generated lines look like timecards are not being fully approved by reviewers putting the accuracy of timecards in question (especially around auto overtime lines where it looks like OT was not approved)
Erik Zimmer
| Company | LEI Companies, Inc. |
| I need it... | 6 months |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2024 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
To go a little further we are running two notifiers like this so 1) reviewers can see what time they missed from the last PR End Date and 2) management can see all weekly timelines that were not approved.
FROM bPRTH b (Nolock)
JOIN bHRRM d (Nolock) ON b.PRCo = d.HRCo AND b.Employee = d.HRRef
LEFT JOIN bJCJM f (Nolock) ON b.Job = f.Job AND b.PRCo = f.JCCo
WHERE b.PRCo = '1'
AND (b.udApprovalStatus <> 'Approved')
AND (b.udJobApprovalStatus <> 'Approved')
AND b.PREndDate <= GetDate()
AND b.PREndDate > (GetDate() - 6)
ORDER BY
d.LastName,
d.FirstName,
b.PostDate;