Recreate in Saved Search the Quantity in Transit for Inbound Shipment with In Transit Status

In purchase order record, Quantity on Shipment column does not have ability to filter the Inbound Shipment Status to show. Workaround could be recreation of the report via Saved Inbound Shipment Search.

Solution

1. Navigate to Lists > Search > Saved Searches > New
2. Click Inbound Shipment
3. Search Title: Enter Title
4. Click Criteria
5. Click Standard
6. Filter:

• Select Item Fields…

1. Item Filter: Select Location External Quantity In Transit
2. Location External Quantity In Transit: Select Not Empty
3. Click Set

• Select Status

1. Status: Select In Transit
2. Click Set
3. Click Results
4. Click Columns
5. Field:
6. Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.

• Select Shipment Number
• Select Status
• Select Purchase Order Fields…
• Purchase Order Field: Select Document Number
• Select Items – Quantity Expected
• Select Expected Delivery Date

1. Click Save & Run