We would like expenses coded to Equipment to route to the reviewer or reviewer group set up in the respective EM Department.
Lauren Spalinger
| Company | Shaw Construction |
| Job Title / Role | Controller |
| I need it... | Yesterday...Come on already |
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.
Below is the code that I've been using for EM Department approvers based on the reviewer group. This can be tested as a starting point.
Kevin Halme | Constructive Tech Solutions
INSERT ExpenseApproval
(
ExpenseItemID
, Reviewer
, ReviewerSeq
,RevSource
)
SELECT ExpenseItems.ExpenseItemID
, kHQRD.Reviewer
, kHQRD.ApprovalSeq
,'E' --E for Equipment
FROM ExpenseItems
INNER JOIN kEMEM ON ExpenseItems.EMCo = kEMEM.EMCo
AND ExpenseItems.Equip = kEMEM.Equipment
INNER JOIN kEMDM ON kEMEM.EMCo = kEMDM.EMCo
AND kEMEM.Department = kEMDM.Department
INNER JOIN kHQRD ON kEMDM.ReviewerGroup = kHQRD.ReviewerGroup
INNER JOIN kDynamicHQRV ON kHQRD.Reviewer = kDynamicHQRV.Reviewer
LEFT OUTER JOIN @SubmitterReviewer SubmitterReviewer ON kDynamicHQRV.Reviewer = SubmitterReviewer.Reviewer
WHERE ExpenseHeaderID = @ExpenseHeaderID
AND kDynamicHQRV.Active = 'Y'
AND kHQRD.Active = 'Y'
AND ( kHQRD.ThresholdAmount < ExpenseItems.Amount
OR ThresholdAmount IS NULL)
AND ExpenseItems.Equip IS NOT NULL
AND @ReviewerOnSubmit = 0
AND 1 = CASE WHEN @ExpenseAllowSelfApproval = 0 AND SubmitterReviewer.Reviewer IS NOT NULL
THEN 0
ELSE 1
END