Created a query to generate all the items that has negative allocated quantities. Validated the output vs. total created transfers with allocated and picked status. Performed corrective update setting negative quantities to zero for all the items which has no pending orders .