filter - How to use a saved search formula to validate item line {custom_department.subsidiary} contains item line {custom_subsi

I want to filter items in an invoice saved search based on the subsidiary associated with the department on the item line. Specifically, for each item line, I need to check whether the subsidiary selected in the line "custom-subsidiary" field is present in the multi-select subsidiary fields of the line {custom_department}

I’m attempting to use the following formula in the saved search filter, but it’s throwing an error:

CASE WHEN {custcol_alloc_department.subsidiary} contains {item.linesubsidiary}

Please advice!

I want to filter items in an invoice saved search based on the subsidiary associated with the department on the item line. Specifically, for each item line, I need to check whether the subsidiary selected in the line "custom-subsidiary" field is present in the multi-select subsidiary fields of the line {custom_department}

I’m attempting to use the following formula in the saved search filter, but it’s throwing an error:

CASE WHEN {custcol_alloc_department.subsidiary} contains {item.linesubsidiary}

Please advice!

• search
• filter
• netsuite
• suitescript2.0
• saved-searches

Share Improve this question Follow edited Jan 5 at 6:35 Maira S asked Jan 4 at 16:01 Maira SMaira S 4766 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Can you add the full formula used? To check what is happening I need to check the full formula.

From what I see in the part of the formula shown, 'CASE WHEN {custcol_alloc_department.subsidiary} contains {item.linesubsidiary}' looks quite strange. They are using 'contains,' but 'contains' is a function that cannot be used on just any field as it requires a specific index.

Best ERPSof