Restrict Back Dated Transactions for Line Managers

Summary:

Hello,

We have a requirement to restrict back-dated transactions for line managers by using auto-complete rules.

Requirement Example: Employee is having below transactions in the system.

If the manager is trying to initiate any transaction before the latest transaction start date it should throw an error.

In the above example, the manager should not initiate the transaction before Sep 07, 2023.

If any one now how can we create auto-complete rule with object validation type or how to fetch latest transaction start date/action date, please let me know.