Suppose a saved search needs to fetch the quantity billed and quantity received in a purchase order. Additionally, the corresponding bill number associated with the items should also be included in the search.
There is a possibility that item lines may be excluded if the quantity billed is zero when using applied transaction join fields. To address this, you can include the related bill number directly from the “Billing Transaction” field. Additionally, include the Bill Line ID by using the join field of Billing Transaction.
By adopting this approach, you ensure that all item lines in the purchase order are included in the saved search, even if the quantity billed is zero.
