Hi,

I am having issues with submitting records for approval.

From the log below (entry criteria, values and result (false)), the record satisfies the criteria but I can't figure out why the code rejects it.

Can anyone take a look at it and tell me what I am missing?

Thanks in advance.

Bao-Long

01:07:20.115 (115729000)|WF_FORMULA|Formula:(
    (
        (
            ISPICKVAL(Pricing_Source__c, 'Direct (Advertiser)')
            ||
            ISPICKVAL(Pricing_Source__c, 'Indirect (Remnant)')
            ||
            ISPICKVAL(Pricing_Source__c, 'Indirect (Partner)')
        )
        && Advertiser__c <> null 
        && Advertiser__r.Inactive__c = false 
        && ISPICKVAL(Advertiser__r.Credit_Status__c, 'Approved')
    )
    ||
    (
        ISPICKVAL(Pricing_Source__c, 'Agency')
        && Agency__c <> null 
        && Agency__r.Inactive__c = false 
        && ISPICKVAL(Agency__r.Credit_Status__c, 'Approved')
    )
    ||
    (
        ISPICKVAL(Pricing_Source__c, 'FS Rep Firm') && ISPICKVAL(Country__c, 'Canada')
        &&
        (
            Agency__c = null
            ||
            (
                Agency__r.Inactive__c = false 
                && ISPICKVAL(Agency__r.Credit_Status__c, 'Approved')
            )
        )
    )
)
&& ( ISPICKVAL(Status__c, 'In Progress') || ISPICKVAL(Status__c, 'Rejected') )
&& ( Is_Latest_Version__c = true )
&& ( Total_Remaining_Price__c >= 0 )
&& ( Total_Internal_Price__c > 0 )
&& ( Total_Internal_Price__c <= Total_Adjusted_External_Price__c )
&& ( Total_Invalid_PLIs__c = 0) 
&&
(
    NOT(ISPICKVAL(Country__c, 'Canada'))
    ||
    (
        ISPICKVAL(Country__c, 'Canada')
        &&
        (
            Agency__c = null
            || ISPICKVAL(Agency__r.Country__c, 'Canada')
        )
    )
)
&&
(
    NOT(ISPICKVAL(Country__c, 'United States'))
    ||
    (
        ISPICKVAL(Country__c, 'United States') && Agency__c = null
        ||
        (
            ISPICKVAL(Country__c, 'United States') && Agency__c <> null
            && ISPICKVAL(Agency__r.Country__c, 'United States')
        )
    )
)
&&
(
    (
        ISPICKVAL(Region__c, 'Canada')
        ||
        ISPICKVAL(Region__c, 'BizDev')
        ||
        ISPICKVAL(Region__c, 'Self Serve')
    )
    ||
    (
        Proposal_Number__r.Opportunity_Numbers_Count__c > 0
    )
)
&&
NOT(ISPICKVAL(Country__c, 'Germany'))

Values:

Agency__c=null
Agency__r.Inactive__c=null
Agency__r.Credit_Status__c=null
Agency__r.Country__c=null

Advertiser__c=0014000000aeGXA
Advertiser__r.Inactive__c=0
Advertiser__r.Credit_Status__c=Approved

Proposal_Number__r.Opportunity_Numbers_Count__c=1

Pricing_Source__c=Direct (Advertiser)

Is_Latest_Version__c=1
Status__c=In Progress
Country__c=Canada
Region__c=Canada

Total_Invalid_PLIs__c=0
Total_Internal_Price__c=7000.00
Total_Remaining_Price__c=0.00
Total_Adjusted_External_Price__c=7000.00

01:07:20.115 (115769000)|WF_EVAL_ENTRY_CRITERIA|OMS Proposal Approval|00X40000001235i|false