Hi,
We created a Work Order Saved Search to monitor its related item quantities. The quantity fields are working as expected; however, we noticed that the Assembly Item and Components are displayed in the same column.
For Assembly Item, regardless if Main Line is removed or not in the Criteria, the Assembly field in the Results becomes blank. We used a formula to display the Assembly Item, but it only populates on one row. We would like it to populate on all related rows.
For Components, we would like to remove the row that represents the Assembly Item and display only the component lines.
Criteria:
Results:
Result:
Thank you!