Rule 5 - Bulk/Pick face Optimized

This rule will perform the following in order and is designed to use up old stock first, then take from bulk without breaking pallet and finally from pick face but not depleting the pick face fully.
Reserve from any bulk pallet that will expire in the next 3 months
Reserve any full pallets where the quantity <= the requirement, this will be a loop that will continue until there are no pallet with a quantity <= requirement or the requirement is satisfied.
Reserve the remaining requirement from pickface provided the quantity required is within 40% of the minimum of the pickface, if not get from bulk.
The system will always exclude expired stock and if a stock items has an expiry of 0000-00-00 it will NEVER be reserved