Discussions
Work Order Item Summary with the Earliest PO Vendor Confirmed Date
Good morning! I have a Saved transaction search that shows Parts not issued to work orders based by sales order. What I would like to see is the earliest purchase order per part with the vendor confirmation date and the quantity on order. Is this possible? this is how my search is currently set up:
Transaction search
Main line: is False
Type: is a work order
Status: Is any of Work order: in process, Work Ordered: Planned, Work Order:Released
Formula (numeric): Is greater than 0 {Quantity}-{quantityshiprecv}
Item: Is all
Memo(main) Contains
Item: Type: Is non of Assembly/Bill Of Materials, Non-inventory Item