The "Miscellaneous" earning is listed under the pay type, but the actual amount—retrieved from the SQL table [PR_CHECK_HISTORY_MC], specifically the Earnings_Amount_List11 field—is missing from the cube. As a result, the total earnings and individual earning components do not reconcile correctly due to this missing data.
This is my guess that data is coming from that table and I do not have knowledge. If not then equailivant data is required and should be in the table that makes payroll history cube.
This discrepancy is currently preventing me from completing the dataset. At this point, I’ve only identified this one missing earning, but there may be others. I’ll continue investigating and will report any additional gaps as they surface.
Raj Dhillon
| Company | Ocean Park Mechanical |
| 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.
© 2023 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.