Is there a way to have a saved search for a custom...
# general
k
Is there a way to have a saved search for a custom field on the Item Fulfilment show me the total qty for all items on that Item Fulfilment? Currently the saved search I have now works perfectly for Item Fulfilments created from a Sales Order, but it does not work for Item Fulfilments created from Transfer Orders. The qty doubles for Transfer Orders. How do I fix this doubling?
c
Transfer Orders create both ship and receive lines in the fulfillment, doubling your count. Add criteria "Shipping : Internal ID is not empty" to only count the shipping side, or use CASE WHEN logic to exclude receive lines based on the TO relationship.