Hi, i need to do a Saved Search that show me Sales Order that have Items fullfilled but havent got billed yet. Example:

| Item | Quantity | FullFilled | Billed |

| A | 2 | 2 | 0 |

The current Search brings me all the ítems that fullfill the criteria, but i only want the transaction that they belong to, to simplify the view. Any way to do this?

I believe using the Main Line true in the filter area would help here. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4459563851.html#bridgehead_4459570097

Hi!, using the main line = true will show me the wrong results, as the main line doenst have values in fullfilled and billed items. What im trying currently is to group the results by the transaction name, the cliente name, and the date of creation of the transaction

Thanks @battk for the info, i solved it by grouping by, it gives me the correct results.

could you just filter for sales order statuses with 'pending billing'?

Hi David, correct me if im wrong, but the SO only changes to pending billing when all the items have been fulfilled. What im looking, is the items that have been fulfilled but not billed yet, even if it was just 1 from 200

looks to be SO is status "pending billing/partially fulfilled" as soon as any qty is fulfilled