• Home /
• VACCTG-I-199 /
• New Suggestion

10 Vote

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

Vista Apps / PR - Payroll

Company	Viewpoint
Job Title / Role	Application Support Specialist
I need it...	1 month

• Comments (1)
• Votes (10)

• Attach files

  Enter a subject
• 
  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

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Log in / Sign up

Identify yourself with your email address

Email address

Subscribe

You won't be notified about changes to this idea.

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.