Enhance Safety Stock Rules with Relational Operators (Eg: '>', '<') for extended attributes

Problem:

Currently, in case of extended attributes, safety stock rules only permit the use of the equality operator (=) for setting rule conditions. This limitation restricts the flexibility and granularity of safety stock management, particularly in scenarios where thresholds or ranges need to be defined.

Proposed Solution:

Introduce support for relational operators, such as greater than (>) and less than (<), within safety stock rule conditions. This enhancement would allow for more precise and dynamic safety stock calculations based on various factors, including:

• Threshold-based rules: Set safety stock levels based on predefined thresholds (e.g., "If inventory was received more than 100 days before the current date, set the safety safety stock by 10000").
• Range-based rules: Establish safety stock levels within specific ranges (e.g., "If inventory is between 50 and 100 units, maintain a safety stock of 15").

Benefits:

• Improved inventory management: More accurate and responsive safety stock calculations can help optimize inventory exposure.
• Enhanced flexibility
• Enhanced decision-making

Request:

Please consider implementing support for relational operators (>, <, >=, <=, between) for extended\custom attributes within safety stock rules to enhance the functionality and effectiveness of inventory management.