x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 74 subscribers
  • Views 249 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
David Forshaw

Create New Opportunity Validation Errors

Posted By

I am using Sage 200 CRM 7.3 SP1.3 . When I create a new opportunity from the green plus button (system action 261) and try and save it, I get the error "Validation Errors - Please correct the highlighted entries" but there are no entries highlighted. When I create a new opportunity from the company screen (system action 1190), the same opportunity saves without issue. I have already run the script to create accounts for companies that don't have them.

Please can you advise me what I need to do to resolve the issue.

Many Thanks

  • 0

    David

    You need to investigate where the Validation rule is set.

    The SQL Query below will list all the fields (and their screens) which have a Validation rule.

    select seap_searchboxname, seap_colname, SeaP_ValidateScript from custom_screens where SeaP_ValidateScript is not null and Seap_DeviceID is null

    The Screens involved in the CRM interface are

    OpportunityWebPicker

    OpportunityDetailBox

    OpportunityStatusBox (This is actually defined against the table OpportunityProgress)

    OETotalsBox

    BUT

    The Validation may be coming from a Workflow Action so you need to check there too.

*Community Hub is the new name for Sage City