Inventory & Sales Order
All our sales orders are special orders or drop ships. As such there is a one-one correlation to an item in the inventory to an item on the sales order.
We are in need of a report that provides the following for each item in the inventory data.
Item, Location, Quantity, $Amount, SO#, Customer Name, SO Expected Ship Date
where the SO# is the corresponding SO that lead to creation of the PO and hence the item in the inventory.
Any pointer would be greatly appreciated.
Thanks in advance.