Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

Error message should occur during validation, not during posting of PR Ledger Update

Error message: The INSERT statement conflict with the FOREIGN KEY constraint "FK_bEMCD_bEMWI_WOItem". The occurred in database "Viewpoint", table "dbo.bEMWI". The statement has been terminated.

Occurs during Posting of PR Ledger Update.  Suggest the error be part of the validation process, and also list the employee for which the EM Work Order Item is missing.

  • Darrell Robinson
  • Dec 21 2016
PR - Payroll
Company Viewpoint
Job Title / Role Application Support Specialist
I need it... 1 month
  • Attach files
  • Nathan Sutherland commented
    May 02, 2017 23:19

    I agree. Sadly, the entire batch process and so many of the triggers from table-to-table use loops, so outside of simulating the entire posting process, there is little hope of them being able to catch every conceivable error during validation.

    Although simulating the entire posting process might not be a bad idea, if they can speed it up.....

    Attachments Open full size

Related Suggestion

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.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 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.