Hi! Anyone created a report/saved search with this info on a line per item (not per transaction):
- Quantity sold in a period range to be set
- Current QTY on Order (pulls form open Purchase orders)
- Current QTY on Hand
- Current Qty on Backorder (to populate from ON BO from Open Sales Orders)
- Current QTY Ordered for each item (populating from Open Sales Orders)
They look at open PO and SO info on the Item360 tab of the item record, if someone did it and can provide guidance or can say if its best to go for a workbook that would be great, thanks!