This method will also be prone to an issue where you have 3 orders for 7 units. When compared to the Location Available of 10 units, then each order will show that it can be fulfilled You'll need to filter for that.

Thanks for the suggestions, the MAXes in the criteria didn't work but the other ones worked. Putting that line without the MAXes in the criteria worked though and it looks correct in the results

Ok good news. Enjoy