Require logic to fetch month end exchange rate while generating revenue in Projects Billing Module

Summary: Urgent!!!!!!

Client requires the Revenue in Projects Billing to have month end exchange rate even if the Event Completion date is mid month. Example, event was created with date as 15 Feb 2026. But when Revenue is generated in Projects Billing Module and then transferred to GL, it should fetch month end exchange rate which is 28th Feb 2026.

Content (please ensure you mask any confidential information):

Client requires the Revenue in Projects Billing to have month end exchange rate even if the Event Completion date is mid month. Example, event was created with date as 15 Feb 2026. But when Revenue is generated in Projects Billing Module and then transferred to GL, it should fetch month end exchange rate which is 28th Feb 2026.