x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 76 subscribers
  • Views 563 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Jamie Bates

Validation on New Opportunity

Posted By

Hello,

We have a custom field named "Type of Customer" on the Company Entity, however, we would like it so that it is not possible to create new opportunities for companies with a specific type of customer. I have used the existing validation in place to stop Opportunities getting created where Company Type is Supplier, however, this isn't working and we can still make opportunities regardless of the Type of Customer.

Please see the validation below:

var company = eWare.FindRecord('Company', 'comp_primaryaccountid='+Values('oppo_primaryaccountid'));
if(company.comp_c_typeofcustomer=='Type A')
{
Valid = false;
ErrorStr="You cannot create an opportunity for a company with Type A";
};

This has been added to the 'Validate Script' for the oppo_primarycompanyid. I'm not sure on what I may be doing wrong as to why it isn't working, please does anyone have any suggestions?

CRM Version: Sage 200 CRM 2018 R3.3

Kind Regards,

Jamie

Parents
  • 0

    A simple method could be to go to Administration - Adv. Customisation - System Menus - New and under 'Opportunity' in the SQL field put in U:0

    This would remove the New Opportunity option from the New Menu

    Then on Companies suppress the Opportunity tab on certain record types. Users could still go to My/Team CRM and create new opportunities from there, but with training they could be guided to always go to the company first.... then create Opportunities from there.

    Also in your script you could change it to the following (JavaScript is my not strong point)

    var company = eWare.FindRecord('Company', 'comp_companyid='+Values('oppo_primarycompanyid'));

Reply
  • 0

    A simple method could be to go to Administration - Adv. Customisation - System Menus - New and under 'Opportunity' in the SQL field put in U:0

    This would remove the New Opportunity option from the New Menu

    Then on Companies suppress the Opportunity tab on certain record types. Users could still go to My/Team CRM and create new opportunities from there, but with training they could be guided to always go to the company first.... then create Opportunities from there.

    Also in your script you could change it to the following (JavaScript is my not strong point)

    var company = eWare.FindRecord('Company', 'comp_companyid='+Values('oppo_primarycompanyid'));

Children
No Data

*Community Hub is the new name for Sage City