Hi,
I am trying to create a saved search that would allow me see items on a sales order that are backordered as well as see if there is a special/dropship or Special WO created for that backordered item/s. It is also supposed to display if there are no related PO or WO as well.
So essentially say item 123 is backordered will have a column say called "With PO/WO" and the logic is:
With PO = display PO#
With WO = display WO#
With PO/WO = blank
This is my transaction saved search so far:
Criteria
I tried adding the Applying Transaction but the problem is it would also show like an IF or Invoice if the SO is partially fulfilled/invoiced.
But if I add the criteria for Applying Transaction Type to exclude IF, Invoice, etc. then it eliminates those backordered items with partial fulfillment.
Your inputs SMEs are highly appreciated.