RE: Combining multiple transactions in one search (Purchase orders & Sales orders)
I am trying to combine a sales recap search with the ability to see the next purchase order coming in for that item. It’s a transactional search that searches sales orders for the ordered quantity, uses the fulfilled quantity, subtracts the two for OUTS. But then I want to search for any (the next incoming) purchase orders on the transaction line item too.
Thank you for the help… this would solve sooooo many issues if i could combine purchase order due dates, quantities on order, with current customer orders and their quantities on order.