CODEWITHSUNDEEP
netsuite
Vince Luk
Vince Luk

Reputation: 1

Create a saved search with sales orders containing only two types of items

I am trying to create a saved search to show only the sales orders that have BOTH types of items on them.

Let's say I have:

ITEM TYPE A ITEM TYPE B

These are checkboxes on the Item Record. An item can only be checked once.. either TYPE A or TYPE B.

I'd like a search that shows me all sales orders that how items on it that contain both ITEM TYPE A and ITEM TYPE B on it.

Right now I have a search with the following criteria (image attached). However, what it yields is only Sales Orders with items, where the the item's record has BOTH checkboxes checked on them.

How to make it to show what I need? Many thanks.

saved search criteria

Upvotes: 0

Views: 2044

Answers (1)

Nathan Sutherland
Nathan Sutherland

Reputation: 1270

You need to use grouping and summary criteria (or SuiteScript). Try Summary Criteria: Minimum formulanumeric MAX(DECODE({type_a_field},'T',1,0))+MAX(DECODE({type_b_field},'T',1,0)) equalto 2 and group the transaction. If you need to see each line item, use NS_CONCAT in a Minimum formulatext (or SuiteScript)

Upvotes: 0

Related Questions