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!
Display Sales order number of back ordered/presold items
Hi everyone
I have a saved search that looks up open Purchase orders
it shows line by line the items.
I want to be able to analyse each item and if it is an open sales order then display the SO number.
I already have a column which works out if an item is presold by calculating the number backordered minus the amount on hand.
I want to go a step further and actually display any open sales orders with that product in them.
So if product x appears in open sales order display sales order number.
is this possible?
Tagged:
0