Prevent Deal Creation for Blocked Account

Prevent Deal Creation for Blocked Account

Hi,

I'm trying to figure out a way to create a validation rule that would prevent the creation of a new Deal to an Account that, for any defined reason, is blocked (normally because of delayed payment issues), thus preventing users to create new Deals for an Account that already has payment issues.

The idea would be to have a custom boolean field in the Account module (let's call it "Blocked"), that if selected, would prevent the user from selecting this Account while in Deal creation or editing. So if the Account had the "Blocked" field selected, the user would not be able to create the Deal. Otherwise, it would proceed as normal.

My first try was to create a validation rule based on the Account Name field, but this field is not available in Validation Rules.
I then thought I could solve this by creating a deluge script to validate the field. Even though I have not tried, I think that this won't work also because there's no way I can select the Account Name field for validation in the Deal form.

Any suggestions?

Regards,
Bruno

            Zoho DataPrep Resources


                Zoho CRM Plus Resources

                  Zoho Books Resources


                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources


                          Zoho Sprints Resources


                            Zoho Orchestly Resources


                              Zoho Creator Resources


                                Zoho WorkDrive Resources




                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                  Design. Discuss. Deliver.

                                                  Create visually engaging stories with Zoho Show.

                                                  Get Started Now




                                                      Zoho Writer Writer

                                                      Get Started. Write Away!

                                                      Writer is a powerful online word processor, designed for collaborative work.