function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Abhijeet Purohit01Abhijeet Purohit01 

Problem in a Workflow

There are 3 objects BOQ(BOM__c), BOQ Item(BOM_Item__c), Quote Line Item.

There is a Master_Detail relationship between BOQ and BOQ Item. BOQ being Master.

There is a LookUp relationship between BOQ and Quote Line Item.

There are two fields, among other fields, in the BOQ Item: Record_Type__c is a picklist field with the values "Bought-Out Item" and "Processed Item"; and BOQ_Quantity__c which is a number field.

There is a picklist field called Rate_Basis__c in Quote Line Item with the values "Per Kg" and "Per Unit".

 

Requirement: I was asked to create a workflow on BOQ Item object to update the BOQ_Quantity__c field by some value iff

Record_Type__c = "Bought-Out Item" and Rate_Basis__c = "Per Kg"

and iff

Record_Type__c = "Bought-Out Item" and Rate_Basis__c = "Per Unit"

then BOQ_Quantity__c = some other value.

 

I created 2 WorkFlows as below:

 

Workflow 1: Rule Name   BOQ Quantity: PER KG

 

              Rule Criteria   AND( ISPICKVAL( Record_Type__c , "Bought-Out Item"), 
ISPICKVAL( BOM__r.Quote_Lookup__r.Rate_Basis__c, "Per Kg") )

 

              Evaluation Criteria  Evaluate the rule when a record is created, and any time it’s edited to subsequently meet criteria

 

               Immediate Workflow Actions

               Field Update
                            BOQ_Quantity__c = Some value1.

 

Workflow 2: Rule Name   BOQ Quantity: PER UNIT

 

              Rule Criteria   AND( ISPICKVAL( Record_Type__c , "Bought-Out Item"), 
ISPICKVAL( BOM__r.Quote_Lookup__r.Rate_Basis__c, "Per Unit") )

              Evaluation Criteria  Evaluate the rule when a record is created, and any time it’s edited to subsequently meet criteria

 

               Immediate Workflow Actions

               Field Update
                            BOQ_Quantity__c = Some value2.

***********************************************************************************************************************************

Its not working. The Workflows are not triggering any values. What to do?

 

phiberoptikphiberoptik

If the Rate_Basis__c field is on the BOQ Item object, why does your workflow formula contain BOM__r.Quote_Lookup__r.Rate_Basis__c? That is attempting to pull a value from a field two object relationships away, neither of which you mentioned in your post.

 

Also, what object is the workflow rule based on? BOQ or BOQ Item?

Abhijeet Purohit01Abhijeet Purohit01
Sorry. I have made the necessary changes. Pls provide your valuable inputs.
And YES both the workflows are on BOQ Item. Also, Rate_Basis__c is a picklist field in QuoteLineItem object. This QuoteLineItem object is in a LookUp relationship with BOQ object.
phiberoptikphiberoptik

Are both rules Activated?

 

What action are you taking to make the workflow rules fire? Are you creating a new record or editing one? If so, what is the record and what is the edit you are doing?