REQUIREMENT

When creating a dataset for sales orders, you may want to include line items. If a line item contains an assembly item, NetSuite automatically adds both the assembly item and its component items to the dataset. This may give discrepancies as you find totals for certain fields.

SOLUTION

In order to handle the requirement you will need to apply a criteria.

Navigate to Transaction Line and drag the Assembly Components field to criteria to set it to False so that only Assembly item will be shown in the dataset