Customer specific rules for Expiry Dates

We sell to supermarkets with a 45-day shelf life and use multiple 3PLs to dispatch orders.  It would be great if we could generate customer-specific rules around expiry dates when picking and packing orders to utilise the Auto pick and pack function and have the correct stock allocated for the packing slip without having to intervene manually, this could also flag an error message or something when that customer's rule can not be met. When we sell to the large supermarket distribution centres they have rules like it must be greater than 32 Days, but if we are dealing directly with a store, they will accept 14 days. 

Also a column in the availability report showing days to expire would be amazing and the ability to colour code and set those rules like the image example attached.