Currency exchange rate in GL Allocation

Summary:

Hi, I have requirement to create allocation to move the entered currency balances to different offset account. I created a formula based allocation rule and it works fine to move balances for ledger currency balances, however I am having issues with moving balances to Non ledger currency as it' s taking corporate exchange rate of the last day of the accounting period to record allocation journal Is there a way to provide exchange rate in GL Allocation ?

I have attached an example of outcome I am expecting for better understanding

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):