The sales team would like a report to show the following. I built a transaction search, but can't seem to get the On Hand and Amount Open On PO's in the search. Appreciate any advice.
Open order qty from supplier + Total Inventory on hand – Back order qty – committed qty = Total available to sell