I created a report in Synoptix that shows the part number, warehouse ID, QTY on hand, safety stock, the difference between the two, and the QTY on order. Pretty simple, or so I thought. I've discovered that any PO that has not been fully received still shows that it's on order, even if the PO has been cancelled, even if it has been partially fulfilled and we decided that we didn't want the remainder, even if we check the box to "Close Short" in Purchase Receipt Entry.
Why is this so, and are there any settings that I can change in the system that indicates that the part is no longer on order once the PO has been closed or cancelled? For audit reasons I don't want to delete the line or alter the ordered quantity. Also, we create thousands of PO's a year and there are at least a couple hundred closed or cancelled PO's, it would be a menacing task to go into each of those individually and update them.