Query to identify stale cycle count reservations
Via MSCA, a user will perform PickNone exception against a pick. This creates a Cycle count against the sub inv/locator/item/lot.
Cycle count taken. Adjustment processed. At times, the Cycle Count reservation as seen in Reservations form remains as a stale reservation. Demand Source = Cycle Count. You can look up the count entry / approval and see that the count was approved. Usually when the cycle count entry is approved the reservation clears. But sometimes, these reservations remain and hold product.
Anyone know how to link a cycle count entry to the stale reservation? Goal is to have a query that can return these stale reservations.