Implement Audit Year and Finding Reference Validation Rule

[sambodeme]

Description:

A user recently reported a data quality issue to the helpdesk team. According to the user, the audit year was incorrectly generated (e.g., 2022 instead of 2023), and the associated finding references were also incorrect. Specifically:

• An audit for the year 2022 should have finding references starting with 2022 (e.g., 2022-###).

To address this, a validation rule should be implemented to ensure:

1. The audit year is correctly generated.
2. The finding reference year matches the corresponding audit year.