Mumha
Member
Hi All
I'm not sure if it is possible but I'll ask the question anyway !
The request is, for every F4801 WO, read all corresponding F3111 Parts List records and if any of those records don't have enough available qty, then summarize as "Inventory Short". So the output would be one row per WO with "Inventory Short" or "Inventory Ready for Production" in an availability column. Is that possible ? If it was a UBE, obviously this wouldn't be a problem as it would be put on a Level Break, but a Stored Procedure is essentially one SQL statement.
Any advice gratefully accepted.
I'm not sure if it is possible but I'll ask the question anyway !
The request is, for every F4801 WO, read all corresponding F3111 Parts List records and if any of those records don't have enough available qty, then summarize as "Inventory Short". So the output would be one row per WO with "Inventory Short" or "Inventory Ready for Production" in an availability column. Is that possible ? If it was a UBE, obviously this wouldn't be a problem as it would be put on a Level Break, but a Stored Procedure is essentially one SQL statement.
Any advice gratefully accepted.