How to use period average rate for fx curr trx for entries created in multiperiod accounting in AHCS
For Ex:
AHCS transaction (foreign currency) created on 21-Nov-2024
Accounting Date: 21-Nov-2024
Conversion Date: 21-Nov-2024
Multiperiod Start Date: 01-Dec-2024
Multiperiod End Date: 31-Mar-2024
Business requirement is to account the multiperiod entries on 31-Dec-2024, 31-Jan-2024, 28-Feb-2025 and 31-Mar-2025.
As this is a foreign currency transaction, Business requires the conversion rate to be used for multiperiod entries be the average period for the month.
for multiperiod entries posted on 31-Dec-2024, the conversion rate should be the average rate for Dec-2024.
for multiperiod entries posted on 31-Jan-2024, the conversion rate should be the average rate for Jan-2024.
Could you please help in achieving the above scenario?