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?
thanks in advance. Oliver