(Automation/Sequence/Rule) Trigger needed for Open Order Next Charge Date for renewal reminders

(Submitting this feature request on behalf of a client)

We sell multiple products with annual subscriptions. It is possible for a customer to subscribe to more than one subscription-based product. We need a way to automate upcoming recharge notifications and other pre-recharge conditions without creating and managing multiple surrogate "product expiration date" fields in the contact record. The current surrogate field approach gets even more difficult to manage for less common modalities like quarterly or bi-annually.

Concrete Example: Assume Product A is sold as an annual subscription on Feb 1, 2026. We need to be able to trigger a "renewal reminder" email message on Jan 1, 2027.

Thanks for your consideration.