Only Return Work Order Numbers After Amount Is Distributed
Good Day, I am only wanting to return workorders where we didn't have enough quantityonhand to cover the order. In the example below quantityonhand in IM_ItemWarehouse is 139. I need quantityonhand to be distributed to the QtyCommitted amount in WO2_WorkOrderMaterialDetail in order of earliest to latest WODueDates, this would cover WorkOrder 0082975 leaving 29 left. Then the next earliest date is WorkOrder 0082966 with 108 – leaving me 79 short so I would need to return this (0082966) workorder. The next few WorkOrders have 0 committed so they are not in the report, then it shows WorkOrders 0083655 & 0083646 being short 50 & 42 because there is no qty left to cover it. So what I would need returned are WorkOrders 0082966, 0083655 & 0083646 with their quantity short amounts. Does anyone know how I can accomplish this? IM_ItemWarehouse WO2_WorkOrderMaterialDetail Expected outcome Anonymous Thanks so much, Lydia
