If you come across a scenario where you want to restrict purchase order for the product which has an expiry date then Sage X3 provides a standard functionality called “Product end-of-life date”.
Product end-of-life date: when this date is exceeded, it is not possible to enter orders to the supplier.
To set up this functionality:
Navigation: Common data – Products – Products – Identification Tab.
Now purchase order can only be created for products which have Product end-of-life date greater than PO date.