Ask Search:
Ray BrownRay Brown 

If account field:Customer VAT No. is blank then Object:Quotes Field: VAT% = no override

Hi All,
I am in need of your expert advice!! 
I have a field in the account object called "Customer VAT No." and would like if this is blank for the "VAT%" field in the Quotes object to be uneditable.  So no overriding.  If the Account field has anything in it, then to allow the vAT% to be amended. 

Is this possible and if so, can someone help me with the formula and how to put it in where??

So,
If account field:Customer VAT No. is blank then Object:Quotes Field: VAT% = no override

Thank You in advance 
Best Answer chosen by Ray Brown
Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj
You can use Validation Rules to accomplish this. Create the Validation Rule on the Quote Object

Try this
AND(
ISBLANK(API Name of Customer VAT No field),
ISCHANGED(API Name of VAT% field)
)

Use the "Insert Field" button to use the right API names of the fields
User-added image

All Answers

Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj
You can use Validation Rules to accomplish this. Create the Validation Rule on the Quote Object

Try this
AND(
ISBLANK(API Name of Customer VAT No field),
ISCHANGED(API Name of VAT% field)
)

Use the "Insert Field" button to use the right API names of the fields
User-added image
This was selected as the best answer
Ray BrownRay Brown
Hi., Thank you for this.  I get this error message, but I think it is because I need the account object address as the field is not in this object.  Do you know where i find it if this is the problem?

Error: Field Customer_VAT_No__c does not exist. Check spelling.
Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj
How is the Quote related to the Account?
Through the Opportunity?
Ray BrownRay Brown
Yes, we add the products within opportunity and then create quote from the opportunity products
Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj
- Click on the Insert Field button
- In the second Column/list, navigate to Opportunity >
- Navigate to Account >
- Find the Customer Vat No field and click Insert
Ray BrownRay Brown
Superb!!  A*
Thank you all done.  I didnt realise I could get to the Account object from "insert field".  
Jeffrey Jonathan JeyarajJeffrey Jonathan Jeyaraj
Awesome !

Please mark the appropriate response as "Best Answer" by clicking the Best Answer button