In the GL_Detail_MC table you have information fields available to you that are not used.
There is a field Operator_Id and Tran_Date that are left empty or not entered correctly. It would be nice to know the Operator's 3 digit code for every GL transaction for information, audit trails or legal action. Also your date fields (which includes a time stamp) in many areas of you program you just use 12AM for everything. Why not use the actual time stamp of the transaction instead of creating other fields for the time (this condition of not using the time stamp is in most of your tables).
This would be helpful to those of us that lookup raw data in SQL or create Crystal Reports, I know this suggestion may not be for everyone, but it might even make it easier on your coders and development team to have that information in one place since you already have the fields in the table and are just not using them.
Les Papp
| Company | RI Construction Management |
| Job Title / Role | IT Consultant |
| I need it... | 12 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.
© 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.