Ah, got it to work! MainLine cannot be a Criteria ...
# inventory
s
Ah, got it to work! MainLine cannot be a Criteria field. This ensures all the items (including the Assembly and the components) are listed in the results. In the Results, you have to pick: Item, Serial/Lot Numbers, Item Numbers: Expiration Date. Sort by: Document Number (1st), ItemType(2nd), Item Number: Item (3rd). Then Highlight using these conditions: itemType = Assembly AND Line Sequence Number = 0.