What is the workaround for translating the Income Statement a/c at "Average Rate" for the YTD rule?

Summary: As per our client’s requirement, they expect the monthly ending balances for Revenue and Expense accounts to be translated using the provided average rate. However, we have observed that this is not achievable when the translation rule is set to PTD (period-to-date), since translation in this case is performed on a period-by-period basis.

We attempted to use the YTD (year-to-date) translation rule instead, expecting that it would allow translation of the ending balance at the average rate for the entire year. However, it appears that when YTD is selected, the system still translates using the end rate instead of the average rate, or the combination of YTD + Average Rate is not functionally accepted by the application.