How can I prevent opportunities from closing in Salesforce when an account record hasn’t completed s
Best Answer
-
You can use cross object validation rules to do this.
1. Create a custom field on the account object that will hold the status of the screening case and make sure it is populated using a flow or custom code. There is an example of how to do this in the Tutorials section of the developer portal, however the method you chose will depend on your data model/architecture.
2. Create a cross object validation rule on the opportunity object that references the custom field you created e.g. Risk_Screening_Status__c and then define the status values that you want to trigger the rule under e.g.
AND(
OR(CONTAINS(Account.Risk_Screening_Status__c, "Completed - do not proceed"),
CONTAINS(Account.Risk_Screening_Status__c, "Pending compliance review"),
CONTAINS(Account.Risk_Screening_Status__c, "Not started"),
CONTAINS(Account.Risk_Screening_Status__c, "Screening in progress"),
CONTAINS(Account.Risk_Screening_Status__c, "Risk Identified - Do not Proceed"))
,ISPICKVAL(StageName, 'Closed Won'))Obviously tweak the formula so that it works for the status values you have defined for your organisation. The above should work with the example referenced on the dev portal.
0
Answers
-
Hey everyone,
Just wanted to jump in with my thoughts on this topic. I totally understand the frustration of dealing with opportunities closing prematurely in Salesforce due to the screening case not being completed. It can really impact your workflow and cause missed opportunities.
DevTrev, you're definitely not alone in facing this challenge. What has worked for me in similar situations is using cross-object validation rules. It's a powerful way to ensure that opportunities don't close until the necessary criteria are met.
Creating a custom field on the account object to track the screening case status is a great idea. You can then set up a cross-object validation rule on the opportunity object that checks this custom field before allowing an opportunity to be closed.
@hannah.quinn01, your provided solution seems solid. The formula you've shared seems to cover the scenarios where the screening case is still in progress or not yet completed, preventing the opportunity from closing prematurely.
In terms of advice, I'd recommend thoroughly testing this setup in a sandbox environment before implementing it in your production org. Make sure all possible cases are accounted for and that the validation rule doesn't inadvertently block legitimate closures.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛