I'm stumped. Recently upgraded a client from 4.3 to 2013. There procedure has been to take sales orders, ship what's available, and create a PO to the vendor every afternoon for insufficient quantities, taking previously issued POs into account.
Now when the client prints Auto Generate (POs) from Sales Order Listing specifying a single vendor, the report shows 26 items with a total quantity of 521. They then print the same Auto Generate from Sales Order Listing without specifying any vendor. This time the vendor initially selected now shows 28 items with a total quantity of 532. We located the two missing items and traced them back to two separate sales orders. Both orders were created today, both were partially shipped and invoiced today - but so were dozens of others, and they aren't ""missing"" from the report.
In both cases, the items could not be shipped due to insufficient quantity on hand, but other lines on the order were shipped and invoiced, leaving both of these orders in a back order status. Strangely, the first item is one of three back ordered items on a single order - and the other two lines appear on both reports fine. In the second case, one item was shipped and invoiced but the ""missing"" item was back ordered.
Most of the items showing on the Auto Generate from Sales Order are back ordered from a partial shipment. So why are these two items missing and why are they the only ones missing?
We confirmed that the primary vendor was the one specified and the same for all items, that the item is not drop shipped on the Sales Order, that the reorder methods are the same, that the max on hands have not been exceeded, and that insufficient stock exists including what's on previously issued purchase orders. I'm baffled. I can't find anything by looking at CI_Item or the IM_WarehouseDetail that makes these two items unique. What am I missing?