Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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
0