Scenario
User is creating a Transaction Saved Search for Work Orders and needs to show the values in the Built field (Main Line) and Used In Build column (Item Line). While there is already a Built field available in Transaction Saved Searches, there is still no Used in Build field.
Solution
You can pull both the Built Qty and the Used in Build Qty by using the Quantity Fulfilled/Received field.
In the Main Line, the Quantity Fulfilled/Received will pull the Built Qty, while on the Item Line, it will show the Used in Build Qty.
For example:
Aside from using the Quantity Fulfilled/Received field, here are other ways to get the Built Qty:
- Use the available Built field
- Use a Formula (Numeric) field with formula = {built}.
-----
If you find this information useful, let us know by reacting or commenting on this post!